Now in its seventh edition. Silberschatz, Korth, and Sudarshan's Database System Concepts is one of the cornerstone texts of database education. It presents the fundamental concepts of database management in an intuitive manner. Chapters 1 to 11 cover concepts and techniques needed to use databases, and to design and build applications. Chapters 12 to 23 cover concepts and techniques related to database internals. while Chapters 24 to 26 cover advanced material. Concepts are presented in a general setting that is not tied to one particular database system. but are annotated with details needed to enable hands-on exercises on specific database systems. Familiarity with basic data structures, computer organization, and a high-level programming language are the only prerequisites.
The overall style of the prior editions has been retained, while the content and organization continues to evolve to reflect the major changes that have occurred In recent years.
New to the Seventh Edition
Extensive coverage of Big Data systems. from the user perspective (Chapter 10), as well as from an internal perspective (Chapters 20 - 23).
Updates to all the internal chapters to reflect current-generation technology, such as solid-state disks, main-memory databases, multi-core systems, and parallel and distributed databases.
Additional coverage of semi-structured data management using JSON, RDF, and SPARQL.
Updated coverage of temporal data, data analytics. and advanced indexing techniques such as write-optimized indices.
Reorganization and update of chapters to better support courses with a significant hands-on component, including use of current-generation application development tools and Big Data systems such as Apache Hadoop and Spark.
New chapter on Blockchain Databases (Chapter 26) that introduces blockchain technology and its growing role in enterprise applications.
Table of Contents Chapter 1: Introduction
Part 1: Relational Languages
Chapter 2: Introduction to the Relational Model
Chapter 3: Introduction to SQL
Chapter 4: Intermediate SQL
Chapter 5: Advanced SQL
Part II: Database Design
Chapter 6: Database Design Using the E-R Model
Chapter 7: Relational Database Design
Part III: Application Design and Development
Chapter 8: Complex Data Types
Chapter 9: Application Development
Part IV: Big Data Analytics
Chapter 10: Big Data
Chapter 11: Data Analytics
Part V: Storage Management and Indexing
Chapter 12: Physical Storage Systems
Chapter 13: Data Storage Structures
Chapter 14: Indexing
Part VI: Query Processing and Optimization
Chapter 15: Query Processing
Chapter 16: Query Optimization
Part VII: Transaction Management
Chapter 17: Transactions
Chapter 18: Concurrency Control
Chapter 19: Recovery System
Part VIII: Parallel and Distributed Databases
Chapter 20: Database-System Architectures
Chapter 21: Parallel and Distributed Storage
Chapter 22: Parallel and Distributed Query Processing
Chapter 23: Parallel and Distributed Transaction Processing
Part IX: Advanced Topics
Chapter 24: Advanced Indexing Techniques
Chapter 25: Advanced Application Development
Chapter 26: Blockchain Databases
Part X: Appendix A
Appendix A: Detailed University Schema
Part XI: Online Chapters
Chapter 27: Formal Relational Query Languages
Chapter 28: Advanced Relational Database Design
Chapter 29: Object-Based Databases
Chapter 30: XML
Chapter 31: Information Retrieval
Chapter 32: PostgreSQL
Abraham (Avi) Silberschatz is the Sidney J. Weinberg Professor of Computer Science at Yale University. Prior to coming to Yale in 2003, he was the vice president of the Information Sciences Research Center at Bell Labs. He previously held an endowed professorship at the University of Texas at Austin, where he taught until 1993. Silberschatz is a fellow of the ACM, a fellow of the IEEE, and a member of the Connecticut Academy of Science and Engineering. He received the 2002 IEEE Taylor L. Booth Education Award, the 1998 ACM Karl V. Karlstrom Outstanding Educator Award, and the 1997 ACM SIGMOD Contribution Award. Silberschatz was awarded the Bell Laboratories President’s Award three times, in 1998, 1999 and 2004. His writings have appeared in numerous journals, conferences, workshops, and book chapters. He has obtained over 48 patents and over 24 grants. He is an author of the textbook Operating System Concepts.
Henry F. (Hank) Korth is a Professor of Computer Science and Engineering and co-director of the Computer Science and Business program at Lehigh University. Prior to joining Lehigh, he was director of Database Principles Research at Bell Labs, a vice president of Panasonic Technologies, an associate professor at the University of Texas at Austin, and a research staff member at IBM Research. Korth is a fellow of the ACM and of the IEEE and a winner of the 10-Year Award at the VLDB Conference. His numerous research publications span a wide range of aspects of database systems, including transaction management in parallel and distributed systems, real-time systems, query processing, and the influence on these areas from modern computing architectures. Most recently, his research has addressed issues in the application of blockchains in enterprise databases.
S. Sudarshan is currently the Subrao M. Nilekani Chair Professor at the Indian Institute of Technology, Bombay. He received his Ph.D. at the University of Wisconsin in 1992, and he was a member of the technical staff at Bell Labs before joining IIT Bombay. Sudarshan is a fellow of the ACM. His research spans several areas of database systems, with a focus on query processing and query optimization. His paper on keyword search in databases published in 2002 won the IEEE ICDEMost Influential Paper Award in 2012, and his work on main-memory databases received the Bell Laboratories President’s Award in 1999. His current research areas include testing and grading of SQL queries, optimization of database applications by rewriting of imperative code, and query optimization for parallel databases. He has published over 100 papers and obtained 15 patents.