First Course in Database Systems, A: Pearson New International Edition

Series
Pearson
Author
Jeffrey D. Ullman / Jennifer Widom  
Publisher
Pearson
Cover
Softcover
Edition
3
Language
English
Total pages
515
Pub.-date
August 2013
ISBN13
9781292025827
ISBN
1292025824
Related Titles


Product detail

Product Price CHF Available  
9781292025827
First Course in Database Systems, A: Pearson New International Edition
84.50 approx. 7-9 days

eBook

You'll find the eBook here.:

Free evaluation copy for lecturers


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:

 

 

Features

  • Large variety of real-world examples ensure the presentation is readable and engaging.
  • Extensive treatment of database modeling teaches about this important first step of the planning process.
  • Coverage of advanced issues important to database designers and users includes discussions of views, integrity constraints, assertions, triggers, transactions, authorization, and recursion in SQL: 1999.
  • Discussion of how to successfully plan a database application before building it reflects how these plans are developed in the real world.
  • Extensive exercises in almost every section provide students with the opportunity to practice and apply the concepts they've learned in each chapter.
  • GOAL--please note that GOAL is no longer available.

 

New to this Edition

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.

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.