|About the book|
Database System Concepts by Silberschatz is now in its 6th edition and is one of the cornerstone texts of database education. It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible.
Silberschatz is designed for a first course in databases at the junior/senior undergraduate level or the first year graduate level. It also contains additional material that can be used as supplements or as introductory material for an advanced course. Because the authors present concepts as intuitive descriptions, a familiarity with basic data structures, computer organization, and a high-level programming language are the only prerequisites. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.
|About the author|
Abraham Silberschatz (Ph.D. the State University of New York at Stony Brook) is a Professor of Computer Science at Yale University. Prior to joining Yale, he was the Vice President of the Information Sciences Research Center at Bell Laboratories, Murray Hill, New Jersey. Prior to that, he held a chaired professorship in the Department of Computer Sciences at the University of Texas at Austin. His research interests include operating systems, database systems, real-time systems, storage systems, network management, and distributed systems. Prof. Silberschatz is an ACM Fellow and an IEEE Fellow. He received the 2002 IEEE Taylor L. Booth Education Award, the 1998 ACM Karl V. Karlstrom Outstanding Educator Award, the 1997 ACM SIGMOD Contribution Award, and the IEEE Computer Society Outstanding Paper award. He is an author of the textbook Operating System Concepts.
Henry F. Korth (Ph.D. Princeton University) is Weiseman Professor and Chair of the Department of Computer Science and Engineering at Lehigh University. Before joining Lehigh, he was Director of Database Principles Research at Bell Laboratories, Murray Hill, New Jersey. His research interests include XML data management, web-based data, main-memory database systems, real-time systems, parallel systems and other topics. Before joining Bell Laboratories, Prof. Korth was a Vice President of Panasonic Technologies and Director of the Matsushita Information Technology Laboratory. Prior to that, he was an Associate Professor in the Department of Computer Sciences at the University of Texas at Austin, and a Research Staff Member at the IBM T. J. Watson Research Center. Prof. Korth is an ACM Fellow and an IEEE Fellow.
S. Sudarshan (Ph.D. University of Wisconsin, Madison) is a Professor in the Department of Computer Science and Engineering at the Indian Institute of Technology, Bombay. Prior to joining IIT Bombay, he was a Member of Technical Staff in the Database Research Group at Bell Laboratories, Murray Hill, New Jersey. Prof. Sudarshan is an author of over 60 papers in different areas of database systems, and holds 13 patents. His current research interests include query processing and optimization, authorization, and keyword querying of databases. In addition to being the architect of several software systems dealing with database internals, he has also been responsible for building and maintaining a variety of database applications used in IIT Bombay.
|Table of contents|
Chapter 1: Introduction Part 1: Relational Databases Chapter 2: Introduction to the Relational Model Chapter 3: Introduction to SQL Chapter 4: Intermediate SQL Chapter 5: Advanced SQL Chapter 6: Formal Relational Query Languages
Part II: Database Design Chapter 7: Database Design and the E-R Model Chapter 8: Relational Database Design Chapter 9: Application Design and Development
Part III: Data Storage and Querying Chapter 10: Storage and File Structure Chapter 11: Indexing and Hashing Chapter 12: Query Processing Chapter 13: Query Optimization
Part IV: Transaction Management Chapter 14: Transactions Chapter 15: Concurrency Control Chapter 16: Recovery System
Part V: System Architecture Chapter 17: Database-System Architectures Chapter 18: Parallel Databases Chapter 19: Distributed Databases
Part VI: Data Mining and Information Retrieval Chapter 20: Data Mining Chapter 21: Information Retrieval
Part VII: Specialty Databases Chapter 22: Object-Based Databases Chapter 23: XML Chapter 24: Advanced Application Development Chapter 25: Advanced Data Types and New Applications Chapter 26: Advanced Transaction Processing
Part IX: Case Studies Chapter 27: PostgreSQL Chapter 28: Oracle Chapter 29: IBM DB2 Universal Database Chapter 30: Microsoft SQL Server
Part X: Appendices Appendix A: Detailed University Schema Appendix B: Other Relational Query Languages Appendix C: Advanced Relational Database Design Appendix D: Network Model Appendix E: Hierarchical Model