Description
For courses in database systems and computer science.
This text goes beyond the relational coverage of a typical first course in databases.
Dietrich and Urban include object-oriented conceptual data modeling, object oriented databases, and databases and the Web.
Topic coverage is in-depth and accessible to undergraduates as well as graduate CS students. Teachers can select the topics that best fit their course.
Features and Benefits
Chapter-opening synopses of material to be covered*Includes a list of assumed knowledge and available implementation examples on the authors* Web site.
Checkpoint Sections in strategic locations throughout the chapters*Provide a summary of critical concepts covered, plus exercises for student self-assessment.
Detailed Coverage of UML class diagrams*Includes 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 models*Provides 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 interface*Illustrates 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 exchange*Establishes 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 Standard*Provides a strong foundation for object-relational concepts.
Detailed coverage of advanced relational features of SQL*Establishes 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 illustrations*Include 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.
Table Of Contents
List Of Figures
List Of Tables
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
Instructor Supplements
Instructor's Website, 1/e
Suzanne Dietrich
©2005 / ISBN: 0131489860