Database System Concepts, Sixth Edition



Database System Concepts, Sixth Edition

Database System Concepts, Sixth Edition

  • Title: Database System Concepts, Sixth Edition
  • By: Avi Silberschatz, Henry F. Korth, S. Sudarshan
  • ISBN: 0-07-352332-1, 978-0-07-352332-3
  • Format: eBook, 1376 pages
  • Edition: 6th

 

Description

Database System Concepts by Silberschatz, Korth and Sudarshan 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.

The text 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.

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

Part VIII: Advanced Topics

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

New Features

  • Revised Coverage of SQL: The coverage of SQL is earlier and more complete, with greater attention to the variants of SQL that exist in actual systems.
  • New Running Example of a University Organization: A new database schema based on university data is used as a running example throughout the book.
  • Revised and Expanded Coverage of Database Design: An updated chapter on ER modeling makes good use of the new running example of the university database.
  • Updated Chapter on Relational Design: The Relational Design chapter has been updated with a more readable style, providing more intuition about normalization before covering fuctional dependency theory.
  • Expanded and Updated Applications: The material on application security has been significantly expanded and emphasis is on practical issues over abstract concepts. Additionally, new material on application development has been included, mirroring rapid changes in the field and early coverage of OLAP is featured.
  • Transaction Management: Coverage has been moved earlier in the book, with chapter 14 providing basics for an introductory course and details following in Chapters 15 and 16. The new edition also features coverage of snapshot isolation including coverage of potential hazards when using it.
  • Expanded Coverage of Distributed Data Storage Systems: Also known as cloud data storage, distributed data storage systems are increasingly used for storing Web scale data and are more and more significant for today’s computer professionals.
  • Object Database and XML Chapters Postponed to Later in the Book: Although object-oriented languages and XML are widely used outside of databases, their support and use in databases is limited, making them appropriate for more advanced courses. Placing this material later in the book allows it to be more easily skipped.
  • Upgraded Chapter on Web Applications and Their Relationship to Databases: The updated material on Web Applications answers the increasing need for web-related expertise in the computing field.

About the Authors

Abraham Silberschatz (Ph.D. the State University of New York at Stony Brook) is the Sidney J. Weinberg Professor of Computer Science and the Chair of the Computer Science Department 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, storage systems, network management, and distributed systems. Prof. Silberschatz is an ACM Fellow and an IEEE Fellow. He is 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, 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 in 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 database algorithms designed for modern computing architectures (multicore, multithread, multilevel cache) , large Web-based data repositories, real-time database systems, and parallel systems. Before joining Bell Laboratories, Prof. Korth was a Vice President of Panasonic Technologies, an Associate Professor in the Department of Computer Sciences at the University of Texas at Austin, and a Research Staff Member at IBM Research. Prof. Korth is an ACM Fellow, an IEEE Fellow, and a winner of the VLDB 10-year Award.

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 75 papers in different areas of database systems, and holds 13 patents. His current research interests include query processing and optimization, keyword querying of relational and graph-structured data, and tools for building and testing database applications. In addition to being the architect of several software systems dealing with database internals and keyword querying, he has also been responsible for building and maintaining a variety of database applications used in IIT Bombay.

Download

To download an eBook version Database System Concepts, Sixth Edition in PDF format for free please click the download link provided below.

Like or share to get the download link

[l2g facebook="true" twitter="true" gplusone="true"]

Download

[/l2g]

Note:¬†Instructor’s Solution Manual also included.

Like this book! You may buy a copy of Database System Concepts, Sixth Edition from Amazon to enrich your library collection.

Your rating:
1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 4.38 out of 5)

Loading ... Loading …





 

Speak Your Mind

*