Publisher Description

For Database Systems, Database Design and Application courses Written by well-known computer scientists, this accessible and succinct introduction to database systems focuses on database design and use. The authors provide in-depth coverage of databases from the point of view of the database designer, user, and application programmer, leaving implementation for later courses. It is the first database systems text to cover such topics as UML, algorithms for manipulating dependencies in relations, extended relational algebra, PHP, 3-tier architectures, data cubes, XML, XPATH, XQuery, XSLT.

Author Biography

Jeffrey D. Ullman is the Stanford W. Ascherman Professor of Computer Science (emeritus) at Stanford University. He is the author or co-author of 16 books, including Elements of ML Programming. His research interests include data mining, information integration, and electronic education. He is a member of the National Academy of Engineering, and recipient of a Guggenheim Fellowship, the Karl V. Karlstom Outstanding Educator Award, the SIGMOD Contributions and Edgar F. Codd Innovations Awards, and the Knuth Prize. Jennifer Widom is Professor of Computer Science and Electrical Engineering at Stanford University. Her research interests span many aspects of nontraditional data management. She is an ACM Fellow and a member of the National Academy of Engineering, she received the ACM SIGMOD Edgar F. Codd Innovations award in 2007 and was a Guggenheim Fellow in 2000, and she has served on a variety of program committees, advisory boards, and editorial boards.

Table of Contents

• 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

Long Description

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 accessible and succinct introduction to database systems focuses on database design and use. The authors provide in-depth coverage of databases from the point of view of the database designer, user, and application programmer, leaving implementation for later courses. It is the first database systems text to cover such topics as UML, algorithms for manipulating dependencies in relations, extended relational algebra, PHP, 3-tier architectures, data cubes, XML, XPATH, XQuery, XSLT. Supplements: Access Student and Instructor Resources at Author Website (Open Access)

Feature

Details A print text Free shipping

New Feature

* More emphasis on the variety of large-data systems (e.g., Web search) in Chapter 1. * Simplified functional dependencies material - Introduces X, Y, ... as attribute sets early, and simplifies lossless-join decomposition via project/join from Ch. 2. * More material on SQL indexes, including materialized views as a general kind of index. * New advanced topics in SQL added, such as star schemas, OLAP, data cubes, recursive SQL, and authorization. * A new Chapter 11 on Semistructured Data Models - Covers XML, DTD's and new material on XSchema. * A new Chapter 12 on Query Languages for Semistructured Data - Includes new material on XPath and XQuery.

Details