COLUMN SMART MECHANISM FOR COLUMN BASED DATABASE
First Claim
1. A method comprising:
- receiving a request for an online transactional processing (OLTP) transaction to access data in a column-based storage of a database;
if a cache includes column information for the OLTP transaction, processing the OLTP transaction with the column information in the cache; and
if the cache does not include the column information for the OLTP transaction, selecting columns from the column-based storage of the database.
2 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the present disclosure may provide a system and method for processing an online transactional processing (OLTP) transaction on a column-based storage of a database. The method may include receiving a request of the OLTP transaction to access data on the column-based storage. A determination may be made whether a cache associated with the database includes column information for the OLTP transaction. If the cache includes the column information for the OLTP transaction, the method may include processing the OLTP transaction with the column information in the cache. If the cache does not include the column information for the OLTP transaction, the method may include selecting columns from the column-based storage of the database.
40 Citations
20 Claims
-
1. A method comprising:
-
receiving a request for an online transactional processing (OLTP) transaction to access data in a column-based storage of a database; if a cache includes column information for the OLTP transaction, processing the OLTP transaction with the column information in the cache; and if the cache does not include the column information for the OLTP transaction, selecting columns from the column-based storage of the database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A non-transitory computer readable storage medium storing one or more programs configured to be executed by a processor, the one or more programs comprising instructions for:
-
receiving a request for an online transactional processing (OLTP) transaction to access data in a column-based storage of a database; determining whether a cache associated with the database includes column information for the OLTP transaction; if the cache includes the column information for the OLTP transaction, processing the OLTP transaction with the column information in the cache; and if the cache does not include the column information for the OLTP transaction, selecting columns from the column-based storage of the database. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A system, comprising:
-
one or more processors; and memory storing one or more programs for execution by the one or more processors, the one or more programs including instructions for; receiving a request for an online analytical processing (OLAP) transaction to access data in the column-based storage of the database; receiving a request for an online transactional processing (OLTP) transaction to access data in a column-based storage of a database; determining whether a cache associated with the database includes column information for the OLTP transaction; if the cache includes the column information for the OLTP transaction, processing the OLTP transaction with the column information in the cache; if the cache does not include the column information for the OLTP transaction, selecting columns from the column-based storage of the database; caching columns'"'"' names or indices of the columns selected from the column-based storage of the database; and after the columns'"'"' names or indices of the columns, processing the OLTP transaction with the column information in the cache.
-
Specification