Computer Science

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.

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

Database Systems: Advanced Topics  (Computer Science)

SUZANNE W. DIETRICH is an associate professor in the Department of Computer Science and Engineering at Arizona State University. Her current research focuses on the application of active, declarative and object-oriented database technology to designing event-based enterprise applications by integrating distributed components using rules. Dr. Dietrich's research has been supported by grants from the National Science Foundation, including the investigation of active rule processing and the development of novel approaches to undergraduate database education. She has numerous publications and is the author of Understanding Relational Database Query Languages (Prentice Hall 2001).

SUSAN D. URBAN is a professor in the Department of Computer Science and Engineering at Arizona State University. Her research interests include object-oriented data modeling as well as event, rule, and transaction processing for enterprise application integration. Dr. Urban has been the recipient of several research grants from the National Science Foundation for her research on constraints, active rule processing, the use of databases in engineering design, and the development of innovative teaching concepts for database instruction. She has published numerous refereed papers and book chapters on the results of her research.

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.

SUGNIFICANT FEATURES

• 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.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.