Abstract | ||
---|---|---|
In this paper we present a more efficient record based caching model than the conventional page (disk block) based scheme. In a record caching model, individual records are stored together in a section of shared memory to form the cache. Traditional relational database systems have individual pages that are stored together in shared memory to form the cache and records are then extracted from these pages on demand. The record cache model has better memory utilization than the page model and also helps reduce overheads like page fetches/writes, page locks and code path.In May 1996, Oracle Rdb announced a record breaking number of 14227 tpmC on a Digital AlphaServer 8400. At the time, this was the best TPC-C performance achieved on a single SMP machine. A total of 15 record caches, caching 19.5 million records, consuming almost 7 GB of memory, formed the bulk of the shared memory. |
Year | DOI | Venue |
---|---|---|
1998 | 10.1145/276304.276365 | SIGMOD Conference |
Keywords | Field | DocType |
oracle rdb,million record,caching model,better memory utilization,record cache model,shared memory,conventional page,record cache,efficient record,individual record,individual page,customer retention,relational database system | Uniform memory access,Shared memory,Computer science,Cache,Page cache,False sharing,Relational database management system,Cache coloring,Distributed shared memory,Database | Conference |
Volume | Issue | ISBN |
27 | 2 | 0-89791-995-5 |
Citations | PageRank | References |
1 | 0.36 | 1 |
Authors | ||
3 |
Name | Order | Citations | PageRank |
---|---|---|---|
Richard Anderson | 1 | 1 | 0.36 |
Gopalan Arun | 2 | 9 | 2.90 |
Richard Frank | 3 | 75 | 9.59 |