Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-11-05
2008-08-05
Mahmoudi, Tony (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07409385
ABSTRACT:
Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. The data processing system implemented method directs the data processing system to process a query against data objects. The data objects are operatively coupled to the data processing system. The query includes a parent operator. The parent operator references a union operator. The union operator references sub-queries. The sub-queries reference the data objects. The data processing system implemented method includes noting a set of partitionings for the union operator, the noted set of partitionings being based on the sub-queries and being based on the data objects reference by the sub-queries, and executing the query having the union operator, the execution of the query being based on the noted set of partitionings and the parent operator.
REFERENCES:
patent: 6032143 (2000-02-01), Leung et al.
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6161105 (2000-12-01), Keighan et al.
patent: 6356887 (2002-03-01), Berenson et al.
patent: 7120623 (2006-10-01), Ganesan et al.
patent: WO 02/061622 (2002-08-01), None
Calisto Zuzarte et al.: “Partitioning in DB2 Using the UNION ALL View,” © Copyright International Business Machines Corporation 2002.
Ning An et al.: “Toward an Accurate Analysis of Range Queries on Spatial Data,” IEEE Transactions on Knowledge and Data Engineering, vol. 15, No. 2, Mar./Apr. 2003.
Disclosed anonymously: “Improving the Performance of Correlated Subqueries in SQL,”, Research Disclosure No. 310117, Kenneth Mason Publications Ltd., England, ISSN 0374-4353, Feb. 17, 1990.
Jin Deog Kim et al.: “Estimation Methods of Selectivity for Spatial Query Optimization,” Journal of KISS(B): Software and Applications, ISSN 1226-2285, vol. 25, No. 7, Jul. 1998.
Cesar A. Galindo-Legaria et al.: “Orthogonal Optimization of Subqueries and Aggregation,” ACM SIGMOD, May 21-24, 2001, Santa Barbar, CA, USA.
Lindsay Bruce Gilbert
Liu Linqi
Neugebauer Robert Paul
Pirahesh Mir Hamid
Sharpe David C.
Gofman Alex
International Business Machines - Corporation
Mahmoudi Tony
Sughrue & Mion, PLLC
LandOfFree
Method, system and program for executing a query having a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system and program for executing a query having a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system and program for executing a query having a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4001919