Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Architecture-Conscious Database System

  • John Cieslewicz
  • Kenneth A. Ross
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_659

Synonyms

Architecture-aware database system; Architecture-sensitive database system; Hardware-conscious database system

Definition

Database systems designed with awareness of and a sensitivity to the underlying computer hardware are “architecture-conscious.” In an architecture-conscious database system implementation, the performance characteristics of computer hardware guide algorithm and system design.

Historical Background

Database system implementation has been, in varying ways, architecture conscious from the advent of the relational database. For instance, System R [2], an early relational database system prototype included the number of I/Os as a cost metric in its optimizer. At a very high level, the implementers of System R included the characteristics of the underlying hardware in their analysis. This trend has continued with growing attention paid by the database research community to the effects of hardware technology on database performance. Architecture-conscious design...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Ailamaki A, DeWitt DJ, Hill MD, Wood DA. DBMSs on a modern processor: where does time go? In: Proceedings of the 25th International Conference on Very Large Data Bases; 1999. p. 266–77.Google Scholar
  2. 2.
    Chamberlin DD, Astrahan MM, Blasgen MW, Gray JN, King WF, Lindsay BG, Lorie R, Mehl JW, Price TG, Putzolu F, Selinger PG, Schkolnick M, Slutz DR, Traiger IL, Wade BW, Yost RA. A history and evaluation of system R. Commun ACM. 1981;24(10):632–46.CrossRefGoogle Scholar
  3. 3.
    Chen S, Ailamaki A, Gibbons PB, Mowry TC. Improving hash join performance through prefetching. ACM Trans Database Syst. 2007;32(3):17.CrossRefGoogle Scholar
  4. 4.
    Chen S, Gibbons PB, Mowry TC, Valentin G. Fractal prefetching B+ trees: optimizing both cache and disk performance. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2002. p. 157–68.Google Scholar
  5. 5.
    Cieslewicz J, Ross KA. Adaptive aggregation on chip multiprocessors. In: Proceedings of the 33rd International Conference on Very Large Data Bases; 2007. p. 339–50.Google Scholar
  6. 6.
    Cieslewicz J, Ross KA. Database optimizations for modern hardware. Proc IEEE. 2008;96(5):863–78.CrossRefGoogle Scholar
  7. 7.
    Graefe G. The five-minute rule twenty years later, and how flash memory changes the rules. In: Proceedings of the Workshop on Data Management on New Hardware; 2007.Google Scholar
  8. 8.
    Hardavellas N, Pandis I, Johnson R, Mancheril N, Ailamaki A, Falsafi B. Database servers on chip multiprocessors: limitations and opportunities. In: Proceedings of the 3rd Biennial Conference on Innovative Data Systems Research; 2007. p. 79–87.Google Scholar
  9. 9.
    Héman S, Nes N, Zukowski M, Boncz P. Vectorized data processing on the cell broadband engine. In: Proceedings of the 3rd Workshop on Data Management on New Hardware; 2007.Google Scholar
  10. 10.
    Johnson R, Hardavellas N, Pandis I, Mancheril N, Harizopoulos S, Sabirli K, Ailamaki A, Falsafi B. To share or not to share? In: Proceedings of the 33rd International Conference on Very Large Data Bases; 2007. p. 351–62.Google Scholar
  11. 11.
    Lee SW, Moon B. Design of flash-based DBMS: an in-page logging approach. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2007. p. 55–66.Google Scholar
  12. 12.
    Ross KA. Selection conditions in main memory. ACM Trans Database Syst. 2004(1);29:132–61.CrossRefGoogle Scholar
  13. 13.
    Zhou J, Cieslewicz J, Ross KA, Shah M. Improving database performance on simultaneous multithreading processors. In: Proceedings of the 31st International Conference on Very Large Data Bases; 2005. p. 49–60.Google Scholar
  14. 14.
    Zhou J, Ross KA. Implementing database operations using SIMD instructions. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2002. p. 145–56.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Google Inc.Mountain ViewUSA
  2. 2.Columbia UniversityNew YorkUSA

Section editors and affiliations

  • Anastasia Ailamaki
    • 1
  1. 1.Informatique et CommunicationsEcole Polytechnique Fédérale de LausanneLausanneSwitzerland