Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-09-26
2006-09-26
Metjahic, Safet (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07113957
ABSTRACT:
A method, computer system, and computer program are claimed for selecting rows from first and second tables each having rows containing values in columns. In at least the first table, the rows are divided into partitions at least one of which is populated by one or more rows. The method, computer system, and computer program include creating a plurality of partition contexts, each partition context corresponding to a populated partition and storing at least a first value associated with a row. The lowest first value stored by the partition context is determined. Rows with a particular first value are identified by reading the partition contexts, creating a temporary file context corresponding to one of the partition contexts, the temporary file context including location data for a data block of rows in memory, and reading rows in memory.
REFERENCES:
patent: 5794229 (1998-08-01), French et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 6073129 (2000-06-01), Levine et al.
patent: 6366911 (2002-04-01), Christy
patent: 6523036 (2003-02-01), Hickman et al.
patent: 6772163 (2004-08-01), Sinclair et al.
Cohen Steven B.
Sinclair Paul L.
Al-Hashemi Sana
Baker & Botts LLP
Cowart John D.
Metjahic Safet
NCR Corporation
LandOfFree
Row hash match scan join using summary contexts for 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 Row hash match scan join using summary contexts for a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Row hash match scan join using summary contexts for a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3610427