This book bridges the gap between UML conceptual class diagrams used in industry and the EER diagrams used in databases. Dietrich and Urban include detailed coverage of the object-relational features of the SQL standard. Connects database modeling using EER and industry modeling using UML. Illustrates object features with in-depth coverage of SQL standards. Demonstrates side-by-side concepts of mapping UML and EER. Uses web application to dynamically access information from a relational database. Provides a strong foundation for object-relational concepts. Analyzes and compares three data models. Summarizes critical concepts. This book is designed for database architects and software architects.
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.