Hybrid Database Table Stored as Both Row and Column Store
First Claim
1. A computer-implemented method comprising:
- providing in a non-transitory computer readable storage medium, a database created in an application level language and comprising row partitioned store and column partitioned store;
causing a row engine to insert records into the row partitioned store;
performing an optimization based upon additional information to check for a uniqueness violation only if there are uniqueness constraints; and
selectively moving data from the row partitioned store to the column partitioned store when one or more criteria according to a data movement policy are met.
2 Assignments
0 Petitions
Accused Products
Abstract
A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.
-
Citations
21 Claims
-
1. A computer-implemented method comprising:
-
providing in a non-transitory computer readable storage medium, a database created in an application level language and comprising row partitioned store and column partitioned store; causing a row engine to insert records into the row partitioned store; performing an optimization based upon additional information to check for a uniqueness violation only if there are uniqueness constraints; and selectively moving data from the row partitioned store to the column partitioned store when one or more criteria according to a data movement policy are met. - View Dependent Claims (2, 3, 4, 5, 6, 19, 20, 21)
-
-
7. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
-
receiving records to be inserted into a database created in an application level language in a non-transitory storage medium and comprising row partitioned store and column partitioned store; causing a row engine to insert the records into the row partitioned store; performing an optimization based upon additional information to check for a uniqueness violation only if there are uniqueness constraints; and selectively moving data from the row partitioned store to the column partitioned store when one or more criteria according to a data movement policy are met. receiving a query on the database; accessing the row partitioned store and the column partitioned store; and producing a result of processing the query using data accessed from the row partitioned store and data accessed from the column partitioned store. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A computer system comprising:
-
one or more processors; a software program, executable on said computer system, the software program configured to; receive records to be inserted into a database created in an application level language in a non-transitory storage medium and comprising row partitioned store and column partitioned store; cause a row engine to insert the records into the row partitioned store; perform an optimization based upon additional information to check for a uniqueness violation only if there are uniqueness constraints; and selectively move data from the row partitioned store to the column partitioned store when one or more criteria according to a data movement policy are met. receive a query on the database; access the row partitioned store and the column partitioned store; and produce a result of processing the query using data accessed from the row partitioned store and data accessed from the column partitioned store. - View Dependent Claims (14, 15, 16, 17)
-
-
18. (canceled)
Specification