Information Modeling and Relational Databases, Third Edition, provides thorough coverage of information modeling approaches, including object-role modeling (ORM), entity-relationship (ER) modeling, and the unified modeling language (UML). It shows how to map models developed with those approaches to a variety of relational and nonrelational database systems, including document databases, column-oriented databases, graph databases, and deductive databases. Process and state modeling, ontological modeling, and metamodeling are also covered. For this new edition, the coverage of ORM, ER, UML, SQL, OWL, and BPMN has been thoroughly updated to include their latest versions. A significant amount of new material has been added. Various data file formats such as CSV, XML, JSON, YAML, and some other markup languages are now covered, and a more thorough treatment is provided for nonrelational databases, especially NoSQL. One of the major features of the book is its large number of exercises, which have been thoroughly class-tested. This book is intended for anyone with a stake in the accuracy and efficacy of databases such as systems analysts, information modelers, database designers and administrators, and programmers.

Presents the most in-depth coverage of object-role modeling, including a thorough update of the book for the latest versions of ORM, ER, UML, OWL, and BPMN modeling.
Includes clear coverage of relational database concepts as well as the latest developments in SQL, XML, information modeling, data exchange, and schema transformation.
Case studies and a large number of class-tested exercises are provided for many topics.
Includes all-new chapters on data file formats and NoSQL databases.

"This book is an excellent introduction to both information modeling in ORM and relational databases. The book is very clearly written in a step-by-step manner and contains an abundance of well-chosen examples illuminating practice and theory in information modeling. I strongly recommend this book to anyone interested in conceptual modeling and databases." --Dr. Herman Balsters, Director of the Faculty of Industrial Engineering, University of Groningen, The Netherlands

Table of Contents:

1. Introduction 2. Information Levels and Frameworks 3. Conceptual Modeling: First Steps 4. Uniqueness Constraints 5. Mandatory Roles 6. Value, Set-Comparison, and Subtype Constraints 7. Other Constraints and Final Checks 8. Entity Relationship Modeling 9. Data Modeling in UML 10. Advanced Modeling Issues 11. Relational Mapping 12. Data Manipulation with Relational Languages 13. Using Other Database Objects 14. Schema Transformations 15. Process and State Modeling 16. Data Interchange 17. NoSQL Databases 18. Other Modeling Aspects and Trends