Range-clustered tables in a database management system

Details Range-clustered tables in a database management system Range-clustered tables in a database management system

2006-09-05

2006-09-05

Gaffin, Jeffrey (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07103588

ABSTRACT:
A method, apparatus and article of manufacture, implementing the method, accesses rows in a range-clustered table in a database management system. A table stores data that is organized into rows and columns. At least one column is designated as a key column. A particular row in the table is accessed based on a relationship between a specified key value and a predetermined range of key values associated with the key column. The table has slots for storing rows, and the slots are organized in accordance with the values of the predetermined range.

REFERENCES:
patent: 5253361 (1993-10-01), Thurman et al.
patent: 5408652 (1995-04-01), Hayashi et al.
patent: 5440732 (1995-08-01), Lomet et al.
patent: 5517641 (1996-05-01), Barry et al.
patent: 5594899 (1997-01-01), Knudsen et al.
patent: 5664172 (1997-09-01), Antoshenkov
patent: 5687361 (1997-11-01), Sarkar
patent: 5727196 (1998-03-01), Strauss et al.
patent: 5794228 (1998-08-01), French et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5950210 (1999-09-01), Nelson
patent: 6125370 (2000-09-01), Courter et al.
patent: 6163775 (2000-12-01), Wlaschin et al.
patent: 6240428 (2001-05-01), Yeung et al.
patent: 6289336 (2001-09-01), Melton et al.
patent: 6298338 (2001-10-01), Melton et al.
patent: 6338056 (2002-01-01), Dessloch et al.
patent: 6457000 (2002-09-01), Witkowski et al.
patent: 6526435 (2003-02-01), Lippert
patent: 6546394 (2003-04-01), Chong et al.
patent: 6859808 (2005-02-01), Chong et al.
patent: 6931390 (2005-08-01), Zait et al.
Kulkami, Uday, et al., “Using Semantic Knowledge in Partitioning and Allocation of Data in Distributed Databases,” 1991, IEEE.
Chang, et al., “A Dynamic Clustering Technique for Physical Database Design” 1980, ACM.
Managing Index-Organized Tables, Oracle8i Application Developer's Guide—Fundamentals, Release 8.1.5, A68003-01 [online] Copyright 1999 [Retrieved on Jan. 24, 2006] Retrieved from the Internet: <URL: http://www.csee.umbc.edu/help/oracle8/server.815/a68003/01—07iot.htm> 15 pages.
Oracle9i Index-Organized Tables, Technical Whitepaper [online] Sep. 2001 [Retrieved on Jan. 23, 2006] Retrieved from the Internet:<http://www.oracle.com/technology/products/oracle9i/pdf/iot—twp.pdf> 11 pages.
“TPC Benchmark™ C Full Disclosure Report”, Silicon Graphics and Informix Software, Inc. ( © 1997), 72 pps.

Affiliated with

Also associated with

Rating

Range-clustered tables in a database management 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 Range-clustered tables in a database management system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Range-clustered tables in a database management system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3606742