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

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D26 H355 2001 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

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
Preface
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
Answers
Bibliography
ORM glossary
ER glossary
UML glossary
Index

Google Preview