Source: http://www.google.nl/patents/US6792420
Timestamp: 2013-05-23 06:57:25
Document Index: 426236012

Matched Legal Cases: ['art 2001', 'art 20036', 'art 2007', 'art 20075', 'art 200720', 'art 20075', 'art 200728', 'art 200717']

Patent US6792420 - Method, system, and program for optimizing the processing of queries ... - Google PatentenZoeken Afbeeldingen Maps Play YouTube Nieuws Gmail Drive Meer » Geavanceerd zoeken naar patenten | Webgeschiedenis | Inloggen Geavanceerd zoeken naar patenten PatentenProvided is a method, system, and program for processing a query including a query operation on a table derived from a set operation on two result tables. The query operation is performed on each result table separately to produce two intermediate result tables. The set operator is then applied to the...http://www.google.nl/patents/US6792420?utm_source=gb-gplus-sharePatent US6792420 - Method, system, and program for optimizing the processing of queries involving set operators PublicatienummerUS6792420 B2PublicatietypeVerlening Aanvraagnummer09/896,453 Publicatiedatum14 sept 2004 Aanvraagdatum29 juni 2001 Prioriteitsdatum29 juni 2001Ook gepubliceerd alsUS20030055814 UitvindersYao Ching Stephen ChenYumi Kimura TsujiYun WangGuogen Zhang Oorspronkelijke patenteigenaarInternational Business Machines Corporation Classificatie in de VS1/1707/999.3 Internationale classificatieG06F17/30 Co�peratieve classificatieG06F17/30495G06F17/30454 Europese classificatieG06F17/30S4P3T2G06F17/30S4P4P3ReferentiesPatentcitaties (4)Niet-patentcitaties (8) Verwijzingen naar dit patent (17)Externe linksUSPTO USPTO-toewijzing EspacenetMethod, system, and program for optimizing the processing of queries involving set operatorsUS 6792420 B2 Samenvatting Provided is a method, system, and program for processing a query including a query operation on a table derived from a set operation on two result tables. The query operation is performed on each result table separately to produce two intermediate result tables. The set operator is then applied to the two intermediate result tables to produce a final result table that is a same result table that would have been produced by performing the query operation on the table derived from the set operation performed on the two result tables.
Tekeningen(6) Claims
Patentcitaties Geciteerd patent Aanvraagdatum Publicatiedatum Aanvrager TitelUS595670713 feb 199721 sept 1999Chu; Wesley W.Database system with query relaxation using type abstraction hierarchy (TAH) as query condition relaxation structureUS620545122 mei 199820 maart 2001Oracle CorporationMethod and apparatus for incremental refresh of summary tables in a database systemUS628933431 jan 199711 sept 2001Sun Microsystems, Inc.Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing systemUS63275875 okt 19984 dec 2001Digital Archaeology, Inc.Caching optimization with disk and/or memory cache managementNiet-patentcitatiesReferentie1Hellerstein, Joseph M., Predicate Migration: Optimizing Queries with Expensive Predicates, Dec. 3, 1992, Computer Science Division, EECS Department, University of California, Berkeley, CA 94720.2International Business Machines Corporaton, IBM DB2 Universal Database, SQL Getting Started, Version 7, 1993, 2000.3Lars et al., "Incremental computation of Nested relational query expressions", ACM transaction on database systems, vol. 20, No. 2, Jun. 1995, pp. 111-148.*4Mishra, Prite, et al., Join Processing in Relational Databases, ACM Computing Surveys, vol. 24, No. 1, Mar. 1992.5Pirahesh, Hamid, et al., Extensible/Rule Based Query Rewrite Optimization in Starburst, (C) 1992, IBM Almaden Research Center, San Jose, CA 94720.6Pirahesh, Hamid, et al., Extensible/Rule Based Query Rewrite Optimization in Starburst, � 1992, IBM Almaden Research Center, San Jose, CA 94720.7Weihrauch, Maryela, "DB2 for OS/390: Version 5 Versus Version 6 Outer Join Performance". The IDUG Solutions Journal, vol. 7, No. 3, Winter 2000. [Retrieved on Jun. 10, 2001]. Retrieved from the Internet at <URL: http://www.idug.org/member/journal/winter00/article108.cfm>.8Yevich, Richard. "Technical Talk Outer Joins: No More Worries". The IDUG Solutions Journal: Technical Talk, vol. 6, No. 3 Fall 1999. [Retrieved on Jun. 10, 2001]. Retrieved from the Internet at <URL:http://www.idug.org/member/journal/nov99/technical.cfm>. Verwijzingen naar dit patent Citerend patent Aanvraagdatum Publicatiedatum Aanvrager TitelUS71881075 maart 20036 maart 2007Infoglide Software CorporationSystem and method for classification of documentsUS72130118 april 20021 mei 2007Oracle International CorporationEfficient processing of multi-column and function-based in-list predicatesUS73180556 april 20058 jan 2008Metatomix, Inc.Methods and apparatus for querying a relational data store using schema-less queriesUS743055120 jan 200530 sept 2008International Business Machines CorporationMethod to enforce domain strong typingUS761718927 sept 200510 nov 2009Oracle International CorporationParallel query processing techniques for minus and intersect operatorsUS76440628 maart 20075 jan 2010Oracle International CorporationJoin factorization of union/union all queriesUS77026278 maart 200720 april 2010Oracle International CorporationEfficient interaction among cost-based transformationsUS779730421 aug 200614 sept 2010Microsoft CorporationExtensible query language with support for rich data typesUS78097138 maart 20075 okt 2010Oracle International CorporationEfficient search space analysis for join factorizationUS781404217 aug 200412 okt 2010Oracle International CorporationSelecting candidate queriesUS781409127 sept 200512 okt 2010Oracle International CorporationMulti-tiered query processing techniques for minus and intersect operatorsUS786089926 maart 200728 dec 2010Oracle International CorporationAutomatically determining a database representation for an abstract datatypeUS787737930 sept 200525 jan 2011Oracle International CorporationDelaying evaluation of expensive expressions in a queryUS79455628 maart 200717 mei 2011Oracle International CorporationJoin predicate push-down optimizationsUS795374715 aug 200831 mei 2011International Business Machines CorporationEnforcing domain strong typingUS820932221 aug 200726 juni 2012Oracle International CorporationTable elimination technique for group-by query optimizationWO2007108858A116 jan 200727 sept 2007Microsoft CorporationExtensible query language with support for rich data typesDraaienOriginele afbeeldingGoogle Startpagina - Sitemap - USPTO-bulkdownloads - Privacybeleid - Servicevoorwaarden - Over Google Patenten - Feedback verzendenGegevens geleverd door IFI CLAIMS Patent Services© 2012 Google