ISE Database System Concepts

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.

• Chapter 1: IntroductionPart 1: Relational LanguagesChapter 2: Introduction to the Relational ModelChapter 3: Introduction to SQLChapter 4: Intermediate SQLChapter 5: Advanced SQLPart II: Database DesignChapter 6: Database Design Using the E-R ModelChapter 7: Relational Database DesignPart III: Application Design and DevelopmentChapter 8: Complex Data TypesChapter 9: Application DevelopmentPart IV: Big Data AnalyticsChapter 10: Big DataChapter 11: Data AnalyticsPart V: Storage Management and IndexingChapter 12: Physical Storage SystemsChapter 13: Data Storage StructuresChapter 14: IndexingPart VI: Query Processing and OptimizationChapter 15: Query ProcessingChapter 16: Query OptimizationPart VII: Transaction ManagementChapter 17: TransactionsChapter 18: Concurrency ControlChapter 19: Recovery SystemPart VIII: Parallel and Distributed DatabasesChapter 20: Database-System ArchitecturesChapter 21: Parallel and Distributed StorageChapter 22: Parallel and Distributed Query ProcessingChapter 23: Parallel and Distributed Transaction ProcessingPart IX: Advanced TopicsChapter 24: Advanced Indexing TechniquesChapter 25: Advanced Application DevelopmentChapter 26: Blockchain DatabasesPart X: Appendix AAppendix A: Detailed University SchemaPart XI: Online ChaptersChapter 27: Formal Relational Query LanguagesChapter 28: Advanced Relational Database DesignChapter 29: Object-Based DatabasesChapter 30: XMLChapter 31: Information RetrievalChapter 32: PostgreSQL