Cover image for Information modeling and relational databases : from conceptual analysis to logical design
Information modeling and relational databases : from conceptual analysis to logical design
Halpin, T. A.
Personal Author:
Publication Information:
San Francisco : Morgan Kaufman Publishers, 2001.
Physical Description:
xxviii, 763 pages : illustrations ; 24 cm.
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D26 H355 2001 Adult Non-Fiction Central Closed Stacks

On Order



Information Modeling and Relational Database is devoted entirely to information modeling - the process by which an expert understanding of an aspect of the real world is transformed into a conceptual model. A sound approach to modeling is key to developing a database that makes useful information, and not mere facts, available to its users. Author Terry Haplin is a noted authority in the field. He introduces readers to the most powerful and versatile standard - Object Role Modeling (ORM). Information Modeling and Relational Database is an important resource for anyone with a stake in the accuracy and efficacy of databases.

Author Notes

Dr. Terry Halpin is a professor at Northface University. He has led database research teams at several companies including Visio Corporation and Microsoft Corporation, where he worked on the conceptual and logical database modeling technology in Microsoft Visio for Enterprise Architects. His publications include over 100 technical papers and five books.

Reviews 1

Library Journal Review

The information revolution is in motion, and sound database design will drive the ease of data handling and, in turn, improve the results of business practices. A timely topic, then, is Object-Role Modeling (ORM), a way to design and query databases via an application written in lay terms. Halpin expertly explains ORM as well as other solid database design practices so that even seasoned pros will learn something new. Designers, programmers, systems analysts, and managers will discover everything they need to know about database design. Complete with a companion web site, this is highly recommended for libraries serving techies. (c) Copyright 2010. Library Journals LLC, a wholly owned subsidiary of Media Source, Inc. No redistribution permitted.

Table of Contents

Industrial foreword
Academic foreword
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 Relational mapping
11 Relational languages
12 Schema transformations
13 Other modeling aspects and trends
ORM glossary
ER glossary
UML glossary