Skip to main content
View Cart

Information Modeling and Relational Databases

  • 3rd Edition - July 9, 2024
  • Latest edition
  • Authors: Terry Halpin, Tony Morgan
  • Language: English

Information Modeling and Relational Databases, Third Edition, provides thorough coverage of information modeling approaches, including object-role modeling (ORM), entity-re… Read more

Early spring sale

Nurture your knowledge

Grow your expertise with up to 25% off trusted resources.

Shop now

Description

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.

Key features

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

Readership

Computer Science researchers, data science researchers, and software engineers working in academia and industry, including data modelers, database designers, information architects, and practitioners in data management, Graduate students and senior undergraduate students in Computer Science, data science, information systems, and software engineering

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

Review quotes

"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

Product details

  • Edition: 3
  • Latest edition
  • Published: July 11, 2024
  • Language: English

About the authors

TH

Terry Halpin

Dr. Terry Halpin, is a Principal Scientist at LogicBlox, headquartered in Atlanta, USA, and a Professor at INTI International University, Malaysia. After many years in academia, he worked on data modeling technology at Asymetrix Corporation, InfoModelers Inc., Visio Corporation, and Microsoft Corporation, before returning to academia as Distinguished Professor at Neumont University (Utah, USA), and then once again returning to industry at LogicBlox and also taking a professorship at INTI. His research focuses on conceptual modeling and conceptual query technology. Dr. Halpin is the recipient of the DAMA International Academic Achievement Award and the IFIP Outstanding Service Award. He is a member of IFIP WG 8.1 (Design and Evaluation of Information Systems), is an editor or reviewer for several academic journals and international program committees, has co-chaired several international workshops on modeling, and has presented at dozens of international conferences in both industry and academia. For many years, his research has focused on conceptual modeling and conceptual query technology for information systems, using a business rules approach. His doctoral thesis formalized Object-Role Modeling (ORM/NIAM), and his publications include over 160 technical papers, and six books, including Information Modeling and Relational Databases, Second Edition, Elsevier/Morgan Kaufmann.
Affiliations and expertise
Professor of Computer Science, INTI International University, Malaysia

TM

Tony Morgan

Dr. Tony Morgan is a British computer scientist, data modeling consultant, and Professor in Computer Science at INTI International University, Malaysia. Dr. Morgan obtained his BA in Earth Sciences from The Open University, his BSc in Computer Systems Engineering from Coventry University, where in 1984 he also obtained his MSc in Control Engineering. In 1988 he obtained his PhD in Computer Science from University of Cambridge with a thesis on automated decision-making using qualitative reasoning. Dr. Morgan has done extensive work in industry with companies such as Unisys, EDS, and other corporations across transport, aerospace, government, and financial services, including the UK’s National Computing Centre in Manchester. Dr. Morgan has published several articles on AI and simulation. In 2003 he was appointed Professor of Computer Science and Vice President of Enterprise Informatics at Neumont University, Utah, USA. His research interests focus on business rules and business processes and the rapid development of high-quality information systems. Along with Dr. Halpin, he is the co-author of Information Modeling and Relational Databases, Second Edition, Elsevier/Morgan Kaufmann.
Affiliations and expertise
Professor in Computer Science, INTI International University, Malaysia

View book on ScienceDirect

Read Information Modeling and Relational Databases on ScienceDirect