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:
a computer storing a database on a non-transitory computer readable storage medium, the database comprising a row-oriented portion comprising data stored using a row-oriented storage model and a column-oriented portion comprising data stored using s column-oriented storage model; the computer receiving a query on the database; the computer making a first search on the row-oriented portion of the database using the received query; and the computer selectively making a second search on the column-oriented portion of the database depending on an outcome of the first search, wherein the computer makes the second search on the column-oriented portion of the database in response to a first outcome of the first search, wherein the computer does not make the second search column-oriented portion of the database in response to a second outcome of the first search.