"Now fully updated to reflect the latest trends and technologies, this is a complete, accessible, and practical course in designing and programming modern databases." "Stanford's Jeffrey Ullman and Jennifer Widom introduce core DBMS concepts, theory, and modeling; then demonstrate how DBMSs can be queried and modified, both with abstract languages and SQL. After an extensive coverage of SQL, including embedded SQL programming and object-relational features, the book turns to systems using XML. Design languages including XML Schema are covered, as are query languages XPath and XQuery." "New in this edition: improved organization throughout; new coverage of UML database modeling; new introduction to algorithms for manipulating dependencies including the 3NF synthesis algorithm; more 3NF coverage, including the 3NF synthesis algorithm; expanded discussion of SQL triggers; new material on index selection and materialized views; new coverage of 3-tiered architecture; new coverage of PHP; introduction to OLAP and the SQL cube operator; and extensive XML coverage, including XML Schema, XPath, XQuery, and XSlT."--Jacket.