No Bits Left Behind

One of the key tenets of database system design is making efficient use of storage and memory resources. However, existing database system implementations are actually extremely wasteful of such resources; for example, most systems leave a great deal of empty space in tuples, index pages, and data p...

Full description

Bibliographic Details
Main Authors: Wu, Eugene (Contributor), Curino, Carlo (Contributor), Madden, Samuel R. (Contributor)
Other Authors: Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory (Contributor), Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science (Contributor)
Format: Article
Language:English
Published: CIDR Conference, 2011-04-22T18:49:48Z.
Subjects:
Online Access:Get fulltext
LEADER 01755 am a22002413u 4500
001 62302
042 |a dc 
100 1 0 |a Wu, Eugene  |e author 
100 1 0 |a Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory  |e contributor 
100 1 0 |a Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science  |e contributor 
100 1 0 |a Madden, Samuel R.  |e contributor 
100 1 0 |a Wu, Eugene  |e contributor 
100 1 0 |a Curino, Carlo  |e contributor 
100 1 0 |a Madden, Samuel R.  |e contributor 
700 1 0 |a Curino, Carlo  |e author 
700 1 0 |a Madden, Samuel R.  |e author 
245 0 0 |a No Bits Left Behind 
260 |b CIDR Conference,   |c 2011-04-22T18:49:48Z. 
856 |z Get fulltext  |u http://hdl.handle.net/1721.1/62302 
520 |a One of the key tenets of database system design is making efficient use of storage and memory resources. However, existing database system implementations are actually extremely wasteful of such resources; for example, most systems leave a great deal of empty space in tuples, index pages, and data pages, and spend many CPU cycles reading cold records from disk that are never used. In this paper, we identify a number of such sources of waste, and present a series of techniques that limit this waste (e.g., forcing better memory locality for hot data and using empty space in index pages to cache popular tuples) without substantially complicating interfaces or system design. We show that these techniques effectively reduce memory requirements for real scenarios from the Wikipedia database (by up to 17.8×) while increasing query performance (by up to 8×). 
546 |a en_US 
655 7 |a Article 
773 |t Conference on Innovative Systems Research (CIDR)