Programming Books C Java PHP Python Learn more Browse Programming Books
Buy New
$85.45
Qty:1
  • List Price: $89.95
  • Save: $4.50 (5%)
Only 9 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $24.93
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Information Modeling and Relational Databases, Second Edition (The Morgan Kaufmann Series in Data Management Systems) Hardcover – March 17, 2008

ISBN-13: 978-0123735683 ISBN-10: 0123735688 Edition: 2nd

Buy New
Price: $85.45
28 New from $63.17 19 Used from $42.15
Rent from Amazon Price New from Used from
eTextbook
"Please retry"
$21.56
Hardcover
"Please retry"
$85.45
$63.17 $42.15

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



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: $124.16

One of these items ships sooner than the other.

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

NO_CONTENT_IN_FEATURE
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

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: 1.8 x 7.7 x 9.1 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: #731,463 in Books (See Top 100 in Books)

Editorial Reviews

Review

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.


More About the Authors

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

Customer Reviews

4.9 out of 5 stars
5 star
7
4 star
1
3 star
0
2 star
0
1 star
0
See all 8 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

18 of 19 people found the following review helpful By Bill MacLean on May 5, 2008
Format: Hardcover
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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Andrew Carver on April 17, 2008
Format: Hardcover
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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Henry Carvajal on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Artyom Shalkhakov on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Search