Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-07-18
2006-07-18
Wong, Leslie (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C711S153000
Reexamination Certificate
active
07080072
ABSTRACT:
A database system for selecting rows from a partitioned database table is disclosed. The partitioned database table includes rows and columns and is divided into partitions with at least one of the partitions in the table being populated by one or more rows. The system includes one or more nodes, each of the one or more nodes providing access to one or more CPUs. Each of the one or more CPUs provides access to one or more virtual processes. Each process is configured to manage data, including the partitioned database table, stored in one of a plurality of data-storage facilities. The system also includes a partitioned table access component configured to select rows from the table by creating a file context, which stores at least location data for a row and a first value associated with the row, for each populated partition, determining the lowest first value stored by the file contexts, and identifying rows with a particular first value by reading the file contexts.
REFERENCES:
patent: 5121494 (1992-06-01), Dias et al.
patent: 5537475 (1996-07-01), Micali
patent: 5721907 (1998-02-01), Pyne
patent: 5765146 (1998-06-01), Wolf et al.
patent: 5787411 (1998-07-01), Groff et al.
patent: 5794229 (1998-08-01), French et al.
patent: 5802357 (1998-09-01), Li et al.
patent: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5860070 (1999-01-01), Tow et al.
patent: 5960086 (1999-09-01), Atalla
patent: 6073129 (2000-06-01), Levine et al.
patent: 6081801 (2000-06-01), Cochrane et al.
patent: 6092061 (2000-07-01), Choy
patent: 6105026 (2000-08-01), Kruglikov et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6115705 (2000-09-01), Larson
patent: 6216125 (2001-04-01), Johnson
patent: 6223182 (2001-04-01), Agarwal et al.
patent: 6240428 (2001-05-01), Yeung et al.
patent: 6263331 (2001-07-01), Liu et al.
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6349310 (2002-02-01), Klein et al.
patent: 6366902 (2002-04-01), Lyle et al.
patent: 6366911 (2002-04-01), Christy
patent: 6370529 (2002-04-01), Kruglikov et al.
patent: 6401098 (2002-06-01), Moulin
patent: 6421662 (2002-07-01), Karten
patent: 6493699 (2002-12-01), Colby et al.
patent: 6496817 (2002-12-01), Whang et al.
patent: 6505188 (2003-01-01), Ghazal et al.
patent: 6567802 (2003-05-01), Popa et al.
patent: 6594659 (2003-07-01), Lin et al.
patent: 6609131 (2003-08-01), Zait et al.
patent: 6662175 (2003-12-01), Ghazal et al.
patent: 6678701 (2004-01-01), Garth et al.
patent: 6772163 (2004-08-01), Sinclair et al.
patent: 2002/0016922 (2002-02-01), Richards et al.
patent: 2002/0065815 (2002-05-01), Layden
patent: 2002/0099691 (2002-07-01), Lore et al.
patent: 2002/0165727 (2002-11-01), Greene et al.
patent: 2002/0194157 (2002-12-01), Zait et al.
Goetz Graefe; “Query Evaluation Techniques for Large Databases” ACM Computing Surveys, vol. 25, No. 2, Jun. 1993; Portland State University, Computer Science Department, P. O. Box 751, Portland, Oregon 97207-0751.
Baker & Botts
Cowart John D.
NCR Corp.
Rayyan Susan
Wong Leslie
LandOfFree
Row hash match scan in a partitioned database system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Row hash match scan in a partitioned database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Row hash match scan in a partitioned database system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3583725