Hybrid database table stored as both row and column store

摘要

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.

主权项

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 a first one-dimensional row partitioned store data structure including a row store index, the database further comprising a second one-dimensional column partitioned store data structure; receiving a new record for insertion into the database; inserting the new record into the row partitioned store according to the row store index; checking a uniqueness violation of the new record in the column partitioned store only where a scalable Bloom filter maintained for unique columns, returns a TRUE result; receiving a query from a user; searching the row partitioned store based upon a search condition of the query; searching the second one-dimensional column partitioned store data structure based upon the query; and returning to the user a search result based on the query, wherein the search result includes the new record and is formed by merging a search result of the row partitioned store with a search result of the column partitioned store.