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

Product Details

• Amazon Sales Rank: #1343470 in Books
• Published on: 2004-11-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 320 pages

From the Back Cover

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.

About the Author

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.

Excerpt. © Reprinted by permission. All rights reserved.

This book goes beyond the relational database coverage of atypical first course in databases. The topics covered include object-oriented conceptual data modeling, object-oriented databases, object-relational databases, and databases and the Web. Designed for a second database course for undergraduates, the book provides both depth of coverage and a wealth of examples to illustrate the concepts. The book can also be easily adapted for use at the graduate level, assuming an introductory database course on relational databases. Research papers can supplement the text coverage with the latest research topics. The target audience of the book also includes the professional engineer who understands relational database technology. The book can help guide the engineer through the latest technological advances in object databases and Web access to databases.

We assume a familiarity with relational databases, the SQL industry-standard query language, and fundamental object-oriented programming language concepts. These assumptions are consistent with the targeted audience of the book. Where needed, the book is self-contained by providing a review of the relational features of the SQL standard.

Organization

Chapters 1 and 2 provide coverage of object-oriented conceptual data models that graphically describe the data stored in a database. This text bridges the gap between the established Enhanced Entity Relationship (EER) diagrams from the database community and the Unified Modeling Language (UML) conceptual class diagrams used by software engineers in industry. Both of these conceptual data models provide advanced semantic modeling features that address class inheritance, constraints on subclass memberships, and class relationships.

Before offering a detailed approach to mapping the conceptual data models to the relational data model, Chapter 3 covers the relational features of the SQL standard, reviewing the basics of the SQL data definition and manipulation language, as well as introducing advanced relational features such as integrity constraints, triggers, and SQL-invoked routines. Chapter 4 uses side-by-side illustrations to show the mapping of the various EER and UML features to the relational data model, including a detailed discussion of how to maintain the inherent constraints given by the EER or UML diagrams.

The next part of the book focuses on recent developments associated with the interaction between databases and the Web. Specifically, Chapter 5 provides detailed coverage of the JDBC API as a sample call-level interface to relational databases. Chapter 6 covers the Extensible Markup Language (XML), which has become a de facto standard for data exchange. Most relational database products are XML enabled, providing the capability to transfer data between XML documents and the data structures of the database itself. Most database products use either Document Type Definitions or XML Schema for specifying the structure of an XML document. Both specifications are included in the chapter, which also illustrates the exchange of data through the use of XML.

Chapters 7 and 8 examine object data management in the context of object-oriented databases and object extensions to relational databases. Chapter 7 provides in-depth coverage of the ODMG standard for object-oriented databases, including a description of the Object Definition Language (ODL), an approach to mapping the object-oriented conceptual data models to ODL, and the Object Query Language (OQL). Chapter 8 covers the object-relational features of the SQL standard, including abstract data types, object tables, object references, and collections. Techniques are presented for mapping EER and UML schemas to the SQL object-relational data model and for maintaining the constraints of the conceptual design. Chapter 9 discusses sample implementations of a database enterprise on various database products, including implementations in 'a relational database, an object-oriented database, and an object-relational database.

The organization of the chapters allows the application of conceptual data modeling to the design of an enterprise, followed by its mapping to the relational data model. The JDBC API and XML representation of data can then be explored in the context of a relational implementation. Object data management concepts are introduced, covering first the foundations of object-oriented databases and then object extensions to relational databases. The three implementation case studies summarize the application of the mapping of the conceptual data models to the relational, object-relational, and object-oriented data models, providing a basis for a comparative analysis of these three different database paradigms with respect to data design, constraint enforcement, and data access.

Each chapter includes checkpoint sections at strategic locations in the presentation of the material. Each checkpoint summarizes critical concepts covered, as well as exercises for assessing progress with understanding the material at that point in the chapter. The authors' Web site, http://www.eas.asu.edu/~advdb provides implementation examples that support the relational database mapping material in Chapter 4, the JDBC coverage in Chapter 5, the XML coverage in Chapter 6, the object-oriented database concepts in Chapter 7, and the relational, object-relational, and object-oriented case studies in Chapter 9. The Web site also provides links to useful references and database tools.

Customer Reviews

Excellent book for Relational, OR and OO databases
This is an excellent book for beginners to understand the important concepts in relational, object relational and oo databases. ER,UML and XML are introduced and used at an appropriate level, as well as SQL and ODMG standard. A rich set of examples are given and they are easy to understand. I especially like the case study chapter which gives very detailed application design on relational and or using oracle, and oo using Objectivity. The book website is great source for example details and other sources related to the topic. Overall, it's a great book on relational, or and oo databases with detailed examples to assit gaining hands-on experiences.

Great book for beginners!
Before I read this book, I only know something about relational db and ER modeling. This book tells me a lot beyond that including UML modeling, XML, Object-oriented db, and some advanced SQL features etc. Compared with other similar books, this book presents these techniques very clearly and it provides a lot of figures and examples, so it's very easy to follow.

This is one of the worst books I have ever read!
I honestly don't know how they can seriously think this book is worth the asking price, I wouldn't waste the time on it if it were free. The only reason I bought it was because it was a requirement for a course I was taking, that is most likely the only way they will ever sell many copies. It is inconsistent in many places, none of the examples (what few there are) flow together in a consistent manner. Many topics are barely touched on, with no real detail and many with no examples that make sense. I have never reviewed a book before, but felt compelled to do so in this case. This is absolutely the worst experience I have ever had with a book. For the life of me, I can't figure out how any school/professor that even glanced through this book would select it as a required text. Perhaps they get kickbacks? ;-)