Database Systems: The Complete Book

0.0

For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems. The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer.It covers the latest database standards SQL: 1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques. Key Features Many real-world examples. Extensive treatment of database modeling—Includes detailed and separate explanations of how to use E/R and ODL to design databases. Excellent, up-to-date and detailed coverage of SQL—Includes coverage of object-relational systems and many aspects of the new SQL:1999 standard. Discussion of the technologies used to connect database programming with C or Java code—Includes discussions of SQL/PSM, SQL/CLI, and JDBC. Coverage of advanced issues important to database designers and users. Discussions of how to successfully plan a database application before building it. Coverage of topics such as designing storage structures and implementing a variety of indexing schemes. Extensive coverage of query processing andoptimization. Comprehensive coverage of transaction processing mechanisms for concurrency control and recovery, including distributed and long-duration transactions. Coverage of information integration, including data warehousing, mediation, OLAP, data-cube systems, and data mining. Extensive exercises—In almost every section. Table of contents 1. The Worlds of Database Systems. 2. The Entity-Relationship Data Model. 3. The Relational Data Model. 4. Other Data Models. 5. Relational Algebra. 6. The Database Language SQL. 7. Constraints and Triggers. 8. System Aspects of SQL. 9. Object-Orientation in Query Languages. 10. Logical Query Languages. 11. Data Storage. 12. Representing Data Elements. 13. Index Structures. 14. Multidimensional Indexes. 15. Query Execution. 16. The Query Compiler. 17. Coping with System Failures. 18. Concurrency Control. 19. More about Transaction Management. 20. Information Integration.