Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-12-05
2006-12-05
Gaffin, Jeffrey (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07146365
ABSTRACT:
Disclosed is a method, system, and program for database query execution. A range of data pages is assigned to each of multiple parallel tasks. For each of the multiple parallel tasks, the range of data pages is mapped to one or more physical partitions, and a data partitioned secondary index partition associated with each of the one or more physical partitions is identified. Each of the multiple parallel tasks is executed to process the database query against the assigned range of data pages using the one or more data partitioned secondary index partitions.
REFERENCES:
patent: 5093911 (1992-03-01), Parks et al.
patent: 5307484 (1994-04-01), Baker et al.
patent: 5515531 (1996-05-01), Fujiwara et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5692174 (1997-11-01), Bireley et al.
patent: 5813005 (1998-09-01), Tsuchida et al.
patent: 5918224 (1999-06-01), Bredenberg
patent: 5960194 (1999-09-01), Choy et al.
patent: 6101495 (2000-08-01), Tsuchida et al.
patent: 6192359 (2001-02-01), Tsuchida et al.
patent: 6266660 (2001-07-01), Liu et al.
patent: 6353820 (2002-03-01), Edwards et al.
patent: 6470331 (2002-10-01), Chen et al.
patent: 6598041 (2003-07-01), Bernal et al.
patent: 6609131 (2003-08-01), Zait et al.
patent: 6772163 (2004-08-01), Sinclair et al.
Leslie, Harry, et al.Efficient Search of Multidimensional B-Trees. Proceedings of the 21stInternational Conference on Very Large Data Bases, pp. 710-719. Zurich, Switzerland Sep. 11-15, 1995.
U.S. Appl. No. 10/440,333, filed on May 16, 2003, entitledMethod, System and Program for Managing Database Operations with Respect to a Database Table, by R.M. Croisettier et al.
Miller, Roger L. “DB2® for z/OS Technology Highlights,” IBM Silicon Valley Lab, DB2 for z/OS [online] [retrieved on Aug. 30, 2002].
“Partitioned Tables and Indexes.” Oracle9i Database Concepts, Release I (9.0.1), Part No. A88856-02, 1996-2001 [online] [retrieved on Aug. 30, 2002]. Retrieved from http:download-west.oracle.com.
Allen Terry Dennis
Desai Paramesh S.
Shibamiya Akira
Tie Hong Sang
Tsang Annie S.
Davda Janaki K.
Gaffin Jeffrey
International Business Machines - Corporation
Konrad Raynes & Victor LLP
Wu Yicun
LandOfFree
Method, system, and program for optimizing database query... 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 optimizing database query..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program for optimizing database query... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3720206