Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $11.31 Gift Card
Trade in
Kindle Edition
Read instantly on your iPad, PC, Mac, Android tablet or Kindle Fire
Buy Price: $69.56
Rent From: $21.56
More Buying Choices
Have one to sell? Sell yours here

Information Modeling and Relational Databases, Second Edition (The Morgan Kaufmann Series in Data Management Systems) [Hardcover]

by Terry Halpin, Tony Morgan
4.9 out of 5 stars  See all reviews (8 customer reviews)

Buy New
$73.55 & FREE Shipping. Details
Only 13 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
In Stock.
Rented by RentU and Fulfilled by Amazon.
Want it Monday, April 28? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition
Rent from
Hardcover $73.55  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

March 17, 2008 0123735688 978-0123735683 2
Information Modeling and Relational Databases, second edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and programmers.

Terry Halpin, a pioneer in the development of ORM, blends conceptual information with practical instruction that will let you begin using ORM effectively as soon as possible. Supported by examples, exercises, and useful background information, his step-by-step approach teaches you to develop a natural-language-based ORM model, and then, where needed, abstract ER and UML models from it. This book will quickly make you proficient in the modeling technique that is proving vital to the development of accurate and efficient databases that best meet real business objectives.

*Presents the most indepth coverage of Object-Role Modeling available anywhere, including a thorough update of the book for ORM2, as well as UML2 and E-R (Entity-Relationship) modeling.

*Includes clear coverage of relational database concepts, and the latest developments in SQL and XML, including a new chapter on the impact of XML on information modeling, exchange and transformation.

* New and improved case studies and exercises are provided for many topics.

* The book's associated web site provides answers to exercises, appendices, advanced SQL queries, and links to downloadable ORM tools.

Frequently Bought Together

Information Modeling and Relational Databases, Second Edition (The Morgan Kaufmann Series in Data Management Systems) + Thinking in Java (4th Edition)
Price for both: $110.42

Buy the selected items together
  • Thinking in Java (4th Edition) $36.87

Editorial Reviews


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

About the Author

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.

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Hardcover: 976 pages
  • Publisher: Morgan Kaufmann; 2 edition (March 17, 2008)
  • Language: English
  • ISBN-10: 0123735688
  • ISBN-13: 978-0123735683
  • Product Dimensions: 9.3 x 7.8 x 1.8 inches
  • Shipping Weight: 3.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.9 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #476,616 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.9 out of 5 stars
4.9 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
18 of 19 people found the following review helpful
5.0 out of 5 stars Fantastic Book May 5, 2008
Everyone needs this book. Read more to find out why:

If you intend to create genuinely useful business applications without first creating an accurate conceptual data model and deriving the database schema from the model, then I hope your projects have very large budgets and flexible deadlines, because you'll need both. Accurate conceptual data models are not an academic curiousity, they are a practical necessity. Well designed databases are the heart of every business application, and accurate conceptual data models are the foundation of every well designed database.

This book presents a method for data modeling called Object Role Modeling (ORM). If you've never created a data model before, you might as well learn the best method from the start. If you've used E-R (Entity Relationship) modeling before, this is your chance to learn a method that overcomes the limitations of E-R, while building on the knowledge you already have.

ORM is based on facts (assertions about the business sphere you are modeling), not entities and attributes. Business users understand facts much better than they understand data modeling abstractions. By using ORM facts, you create your data model in a language that business users can understand and validate. Poor communication with business users and inadequate understanding of requirements are major causes of design deficiencies. ORM solves these issues through its fact based approach.

ORM is also much more expressive than any other popular data modeling notation, ncluding UML and all major flavors of E-R. Many business rules should be expressed as data constraints, but traditional data modeling languages don't do well at capturing these constraints.
Read more ›
Comment | 
Was this review helpful to you?
9 of 9 people found the following review helpful
5.0 out of 5 stars The best book on database design April 17, 2008
This new edition of Information Modeling and Relational Databases maintains its predecessor's achievement of being the best, most complete book out there on design of information systems, and particularly of database schemas -- and of seeming a few decades ahead of the rest of the pack! The relational database theory world seems to move at a rather glacier-like pace -- with the result that some of the schema design methods still in common use have stayed well past their "obsolete by" date. But as a reviewer of the first edition said, this book presents MATURE database design technology; and it can only be hoped that the database design world will sooner, rather than later, realize the immense, and immensely practical, value of the mature theory and design procedure that this book presents. Do you want to be able to arrive at the correct schema the first time? or even to know whether you've reached it or not? This is the book that shows you how, and gives you a rich, formal modeling notation that has very significant and improving tool support. Terry and Tony have both added very valuable new chapters to the book, and expanded and updated the other chapters, so that this is a very much improved book -- as amazing as that may seem to those (like me) who loved the first edition. This book will, in my opinion, be setting the standard for books on information system design for many years to come.
Comment | 
Was this review helpful to you?
5 of 5 people found the following review helpful
5.0 out of 5 stars Get to a higher level when modeling data: concept models September 11, 2009
Format:Hardcover|Verified Purchase
Before knowing about Dr. Helpin's CSDP, I often struggled to find the appropiate data model for the project at hand. Model validation with users was not straight-forward: users do not think of the world in terms of entities and relationships of the ER model - They think about facts and concepts. Now, I do not try to fight with a data model, I build the ORM model and let the procedure to build the ER one.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars For the curious reader July 30, 2012
Format:Hardcover|Verified Purchase
This book covers in great detail the database design process, and can help the astute reader to bridge the seemingly disparate theory of (relational as well as deductive) databases with industrial practice.

Back in the University, when taught UML and ER diagrams, I was always a bit skeptic about all of them, as I could never really fit them into one big picture. This book was a great aid to me in this regard: not only does it cover fact-oriented information modeling (rooted in logic -- and so, making sense!), but it also shows the path to implementation (which most certainly will make use of relational databases available on the market), thereby bridging the disconnect mentioned above.

With this book, one can learn:
- an approach to systematically modelling "the real world" (that is, finding out which facts a given business is interested in, and finding how these facts are related to each other) with an eye towards implementation
- how some of the existing information modeling methods (e.g., UML, ER, IDEFx, ORM) can express same concepts, with a comparative analysis of the benefits and drawbacks of each method (personally, this is something I enjoy very much)

There are no necessary prerequites to reading (the book starts lightly), however I think it would be best to become familiar with basic formal logic concepts beforehand, so as to have some familiarity with certain technicalities (such as a brief discussion of consistency of universe of discourse), thus not having to take detours while reading.
Comment | 
Was this review helpful to you?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category