Foundations and Trends® in Databases > Vol 1 > Issue 2

Architecture of a Database System

By Joseph M. Hellerstein, University of California, USA, hellerstein@cs.berkeley.edu | Michael Stonebraker, Massachusetts Institute of Technology, USA | James Hamilton, Microsoft Research, USA

 
Suggested Citation
Joseph M. Hellerstein, Michael Stonebraker and James Hamilton (2007), "Architecture of a Database System", Foundations and TrendsĀ® in Databases: Vol. 1: No. 2, pp 141-259. http://dx.doi.org/10.1561/1900000002

Publication Date: 07 Nov 2007
© 2007 J. M. Hellerstein, M. Stonebraker
 
Subjects
Database Design and Tuning
 

Free Preview:

Download extract

Share

Download article
In this article:
1. Introduction 
2. Process Models 
3. Parallel Architecture: Processes and Memory Coordination 
4. Relational Query Processor 
5. Storage Management 
6. Transactions: Concurrency Control and Recovery 
7. Shared Components 
8. Conclusion 
Acknowledgments 
References 

Abstract

Database Management Systems (DBMSs) are a ubiquitous and critical component of modern computing, and the result of decades of research and development in both academia and industry. Historically, DBMSs were among the earliest multi-user server systems to be developed, and thus pioneered many systems design techniques for scalability and reliability now in use in many other contexts. While many of the algorithms and abstractions used by a DBMS are textbook material, there has been relatively sparse coverage in the literature of the systems design issues that make a DBMS work. This paper presents an architectural discussion of DBMS design principles, including process models, parallel architecture, storage system design, transaction system implementation, query processor and optimizer architectures, and typical shared components and utilities. Successful commercial and open-source systems are used as points of reference, particularly when multiple alternative designs have been adopted by different groups.

DOI:10.1561/1900000002
ISBN: 978-1-60198-078-6
128 pp. $85.00
Buy book (pb)
 
ISBN: 978-1-60198-079-3
128 pp. $100.00
Buy E-book (.pdf)
Table of contents:
1. Introduction
2. Process Models
3. Parallel Architecture: Processes and Memory Coordination
4. Relational Query Processor
5: Spatial Control
6. Transactions: Concurrency Control and Recovery
7. Shared Components
8. Conclusion
Acknowledgments
References

Architecture of a Database System

Database Management Systems (DBMSs) are a ubiquitous and critical component of modern computing, and the result of decades of research and development in both academia and industry. Architecture of a Database System presents an architectural discussion of DBMS design principles, including process models, parallel architecture, storage system design, transaction system implementation, query processor and optimizer architectures, and typical shared components and utilities. Successful commercial and open-source systems are used as points of reference, particularly when multiple alternative designs have been adopted by different groups. Historically, DBMSs were among the earliest multi-user server systems to be developed, and thus pioneered many systems design techniques for scalability and reliability now in use in many other contexts. While many of the algorithms and abstractions used by a DBMS are textbook material, Architecture of a Database System addresses the systems design issues that make a DBMS work.

Architecture of a Database System is an invaluable reference for database researchers and practitioners and for those in other areas of computing interested in the systems design techniques for scalability and reliability that originated in DBMS research and development.

 
DBS-002