Advanced Course in Database Systems, An: Beyond Relational Databases

About

Features

Chapter-opening synopses of material to be coveredIncludes a list of assumed knowledge and available implementation examples on the authors Web site.

Checkpoint Sections in strategic locations throughout the chaptersProvide a summary of critical concepts covered, plus exercises for student self-assessment.

Detailed Coverage of UML class diagramsIncludes a comparative analysis with EER diagrams; bridges the gap between database modeling using EER diagrams and industry modeling using UML diagrams.

In-depth coverage of the object-relational features of the SQL standard.

Mapping of UML and EER diagrams to the relational, object-oriented and object-relational data modelsProvides side-by-side illustrations of similar concepts from EER and UML diagrams that form the basis of the detailed mapping discussion of each model.

Detailed coverage of JDBC as an example call level interfaceIllustrates how the recognized JDBC API can dynamically access information from a relational database using a Web application.

Coverage of XML and databases, including DTDs, SML Schema and data exchangeEstablishes the importance of the relationship between XML and databases, including a detailed example of data exchange using XML.

In-depth coverage of the Object Data StandardProvides a strong foundation for object-relational concepts.

Detailed coverage of advanced relational features of SQLEstablishes the background for the case-study relational implementation that enforces integrity constraints using triggers and routines.

Case Study Implementations of the same database enterprise in relational (Oracle), object-relational (Oracle), and object-oriented (objectivity/DB) databases.

Over 100 illustrationsInclude side-by-side illustrations of similar concepts from EER and UML diagrams that form the basis of the detailed mapping discussion to each data model.

Description

An Advanced Course in Database Systems goes beyond the relational database coverage of a typical first course and offers readers a carefully researched set of topics specifically designed for a second course in database systems: object-oriented conceptual data modeling, object-oriented databases, object-relational databases, arid databases and the Web, The target audience of the book is anyone who understands relational database technology, including both undergraduate and graduate students, as well as the database professional. The book bridges the gap between the UML and EER abject-oriented conceptual data models, guiding the reader through the latest technological advances ire object databases and the integration of databases and the World-Wide Web.

• Provides detailed coverage of UML class diagrams including a comparative analysis with EER diagrams.
• Establishes the foundation far object-oriented and object-relational concepts by offering in-depth coverage of the Object Data Standard.
• Gives comprehensive coverage of advanced relational and object-relational features of the SQL standard.
• Includes mapping of UML and EER diagrams to the relational, object-oriented and object-relational data models.
• Presents in-depth coverage of JDBC as an example call-level interface to SQL databases.
• Covers XML and databases, including DTDs, XML Schema and data exchange.
• Provides case study implementations of the same database enterprise in relational (Oracle). object-relational (Oracle) and object-oriented (Objectivity/DB) databases.

Sample Content

Table of Contents

List Of Figures

Preface

1. Enhanced Entity Relationship Modeling

2. The Unified Modeling Language Conceptual Class Diagrams

3. The SQL Standard: Advanced Relational Features

4. Mapping Object-Oriented Conceptual Models To The Relational Data Model

5. Web Access To Relational Databases Using JDBC

6. XML And Databases

7. Object-Oriented Databases And The ODMG Standard

8. The SQL Standard: Object-Relational Features

9. Case Studies: Relational, Object-Relational, And Object-Oriented Database Implementations

Bibliography

Updates

Submit Errata