Partitioned database system
View Patent ↗Implementations of a partitioned database system and a method of using a database system are disclosed. One system implementation includes storage facilities. Each storage facility includes data from database table rows. The database table rows in each storage facility that correspond to a specific database table are logically ordered according to a row identifier (row ID). The row ID includes a first value that is based on one or more columns of the table. The row ID also includes a second value that is based on one or more columns of the table, which may be different from or the same as those on which the first value is based. The first value of the row ID is predominate in determining the order of the rows in the storage facilities. The second value determines the order of those rows with identical first values.
1. A partitioned database system comprising:
a plurality of storage facilities, each storage facility including data representing a plurality of table rows;
wherein table rows in each storage facility that correspond to a specific table are logically ordered according to a row identifier (row ID);
the row ID comprises a first value based on one or more columns of the table and a second value based on one or more columns of the table;
the first value of the row ID is predominate in determining the order of the rows in the storage facilities and the second value determines the order of those rows with identical first values, the second value being the result of applying a hash function to a value in at least one specified column; and
table rows are distributed among the plurality of storage facilities based on the second value.
2. The partitioned database system of claim 1 , wherein:
the row ID further comprises a third value and the third value determines the order of rows with identical first and second values.
3. The partitioned database system of claim 1 , wherein:
the first value of the row ID corresponds to ranges of values in a column.