Hybrid database table stored as both row and column store

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 consideration such as frequency of access, or underlying business logic. In another technique, querying of a 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.

Description

technical field [0001] The present invention relates to the storage of data in databases, and more particularly to the storage of database information in a hybrid tabular format. Background technique [0002] Unless otherwise indicated, the approaches described in this section are not prior art to the claims in this application and are not admitted to be prior art by incorporation in this section. [0003] A database is an electronic filing system that stores data in a structured manner. The primary storage structure in a database is the table. A database can contain multiple tables, and each table can hold a specific type of information. Database tables store and organize data in horizontal rows and vertical columns. A row usually corresponds to a real-world entity or relationship, which represents a single record in a table. Columns can indicate specific attributes of these entities or relationships, such as "name", "address", or "telephone number". For example, Compa...

AI Technical Summary

Problems solved by technology

[0013] Despite the various advantages of various database table types, traditionally

Images