No Bits Left Behind
Name
Madden_No bits.pdf
Size
572.54 KB
Format
Adobe PDF
Checksum (MD5)
909be5c9f90aafd44d49f614a3d9291b
Author(s)
Wu, Eugene
Curino, Carlo
Madden, Samuel R.
Date Issued
January 2011
Journal
Conference on Innovative Systems Research (CIDR)
Publisher
CIDR Conference
Citation
Wu, Eugene, Carlo Curino, Samuel Madden. "No Bits Left Behind." 5th Biennial Conference on Innovative Data Systems Research, Jan. 9-12, 2011. [Papers] pp. 187-190.
Version
Author's final manuscript
Abstract
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×).
MIT Department
Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory
Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science
Terms of Use
Creative Commons Attribution-Noncommercial-Share Alike 3.0
Persistent DSpace Link
DOI of Published Version
http://www.cidrdb.org/cidr2011/Papers/CIDR11_Paper23.pdf
