Method and apparatus for accelerating data access operations in a database system
First Claim
1. A method for accelerating data access operations in a database system, the method comprising the steps of:
- causing at least a first portion of data associated with the database system to be stored in a memory cache;
organizing at least a second portion of the data associated with the database system into an organized manner designed to increase the likelihood that sections of the second portion of data will be able to be retrieved from a disk cache using continuous disk read operations, and causing the at least a second portion of the data to be stored on the disk cache; and
in response to receipt of a read command, reading data associated with the read command from at least one of the memory cache and the fast disk cache if the data associated with the read command is available in the at least one of the memory cache and the fast disk cache.
0 Assignments
0 Petitions
Accused Products
Abstract
Data access operations in a database system may be accelerated by allowing the memory cache to be supplemented with a disk cache. The disk cache can store data that isn'"'"'t able to fit in the memory cache and, since it doesn'"'"'t contain the primary copy of the data for the database, may organize the data in such a way that the data is able to be streamed from the disks in response to data read operations. The reduced number of read data operations allows the data to be read from the disk cache faster than it could be served from the primary storage facilities, which might not allow the data to be organized in the same manner. The cache hit ratio may be increased by compressing data prior to storing it in the cache. Additionally, where a particular portion of data stored on the disk cache is being used heavily, that portion may be pulled into memory cache to accelerate access to that portion of data.
117 Citations
9 Claims
-
1. A method for accelerating data access operations in a database system, the method comprising the steps of:
-
causing at least a first portion of data associated with the database system to be stored in a memory cache;
organizing at least a second portion of the data associated with the database system into an organized manner designed to increase the likelihood that sections of the second portion of data will be able to be retrieved from a disk cache using continuous disk read operations, and causing the at least a second portion of the data to be stored on the disk cache; and
in response to receipt of a read command, reading data associated with the read command from at least one of the memory cache and the fast disk cache if the data associated with the read command is available in the at least one of the memory cache and the fast disk cache. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
Specification