Range-clustered tables in a database management system
First Claim
1. A method of operating a database management system having a table for storing data, the data being organized into rows and columns, at least one column being designated as an at least one key column, comprising:
- accessing a particular row in the table based on a relationship between a specified key value and a predetermined range of key values associated with the at least one key column, wherein the table has slots for storing rows, the slots being organized in accordance with the values of the predetermined range.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
20 Claims
-
1. A method of operating a database management system having a table for storing data, the data being organized into rows and columns, at least one column being designated as an at least one key column, comprising:
accessing a particular row in the table based on a relationship between a specified key value and a predetermined range of key values associated with the at least one key column, wherein the table has slots for storing rows, the slots being organized in accordance with the values of the predetermined range. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
9. An apparatus for operating a database management system, comprising:
-
a computer having a data storage device connected thereto, wherein the data storage device stores a table for storing data, the data being organized into rows and columns, at least one column being designated as an at least one key column;
one or more computer programs, executed by the computer, for accessing a particular row in the table based on a relationship between a specified key value and a predetermined range of key values associated with the at least one key column, wherein the table has slots for storing rows, the slots being organized in accordance with the values of the predetermined range. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform a method of operating a database management system having a table for storing data, the data being organized into rows and columns, at least one column being designated as an at least one key column, the method comprising:
accessing a particular row in the table based on a relationship between a specified key value and a predetermined range of key values associated with the at least one key column, wherein the table has slots for storing rows, the slots being organized in accordance with the values of the predetermined range. - View Dependent Claims (16, 17, 18)
-
19. The article of manufacture of claim 19, wherein the table comprises an overflow area, and the method further comprises:
accessing the overflow area when the specified key column value is outside the specified range. - View Dependent Claims (20)
Specification