|First Course in Database Systems, A||
First Course in Database Systems, A
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.
• 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.