Written by well-known computer scientists, this accessible and succinct introduction to database systems focuses on database design and use. It provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. KEY TOPICS: The authors provide an overview of important programming systems (e.g., SQL, JDBC, PSM, CLI, PHP, XQuery, etc.) and the intellectual framework to put them into context. MARKET: For software engineers, database engineers, and programmers.
1. The Worlds of Database Systems.
2. Introduction to the Relational Model.
3. Relational Database Schema Design.
4. Higher-Level Models for Relational Design.
PART II: RELATIONAL DATABASE PROGRAMMING.
5. Algebraic and Logical Query Languages.
6. The Database Language SQL.
7. SQL Constraints and Triggers.
8. SQL Indexes and Views.
9. SQL in a Service Environment.
10. Advanced Topics in SQL.
Web Appendix A. More About Datalog.
PART III: MODELING AND PROGRAMMING IN SEMISTRUCTURED-DATA MODELS.
11. Semistructured Data Models.
12. Query Languages for Semistructured Data.