| 摘要 |
A system, method and a computer-readable medium for reducing a contentious access of data in memory system storage by simulating an online transaction processing business lifecycle, are provided. The memory storage system determines a type of data, where the type of data corresponds to access frequency of data. The data is stored in a row-based format in a row-based storage, a page-based format in a page-based storage and a compressed format in a compressed storage based on the determined type of data. The data is also transferred between the row-based storage, the page-based storage and the compressed storage according to predefined criteria. |
| 主权项 |
1. An integrated relational database management system (RDBMS), comprising:
a data row cache comprising rows that store a first type of data of a table in a row-based format, wherein the data row cache is configured to allow access to rows to a plurality of clients at the same time; a buffer cache comprising a plurality of pages that store a second type of data of the table in a page-based format, wherein the buffer cache is configured to allow access to a page in the plurality of pages to one of the plurality of clients at a time; a disk storage that stores a third type of data of the table in a compressed page-based format, wherein the third type of data in the disk storage is moved to the buffer cache before one of the plurality of clients access the third type of data; and a processor coupled to the data row cache, the buffer cache, and the disk storage, and configured to:
determine a type of data, wherein the type of data corresponds to access frequency of data and is the first type of data, the second type of data or the third type of data and is associated with a life-cycle of the data; andstore the data in the data row cache, the buffer cache, or the disk storage based on the determined type of data. |
