
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer—no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera, scan the code below and download the Kindle app.
Follow the authors
OK
Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design Hardcover – 10 April 2008
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.
- ISBN-100123735688
- ISBN-13978-0123735683
- Edition2nd
- PublisherMorgan Kaufmann
- Publication date10 April 2008
- LanguageEnglish
- Dimensions19.05 x 3.81 x 24.13 cm
- Print length976 pages
There is a newer edition of this item:
Product description
Review
About the Author
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.
Product details
- Publisher : Morgan Kaufmann; 2nd edition (10 April 2008)
- Language : English
- Hardcover : 976 pages
- ISBN-10 : 0123735688
- ISBN-13 : 978-0123735683
- Dimensions : 19.05 x 3.81 x 24.13 cm
- Best Sellers Rank: 317,952 in Books (See Top 100 in Books)
- Customer Reviews:
About the authors
Terry Halpin, BSc, DipEd, BA, MLitStud, PhD, is a Principal Scientist at LogicBlox (headquartered in Atlanta), and a Professor in computer science at INTI International University, Malaysia. He has held senior faculty positions at Australian and American universities, and worked on data modeling technology for several companies including Microsoft Corporation. He has authored over 160 technical publications and six books, is a regular columnist for the Business Rules Journal, and is a recipient of the DAMA International Achievement Award for Education and the IFIP Outstanding Service Award. His personal interests include martial arts, body surfing, philosophy, and fantasy novels.
Discover more of the author’s books, see similar authors, read book recommendations and more.
Customer reviews
Top reviews from Australia
There was a problem filtering reviews. Please reload the page.
- Reviewed in Australia on 3 March 2023Verified PurchaseBook for university, great textbook
Top reviews from other countries
- J G HarrisReviewed in the United Kingdom on 12 July 2017
5.0 out of 5 stars An excellent description of an excellant design method
Verified PurchaseThe Kindle version of this book suffers from the usual problem : On
a Fire HDX every diagram is so small that it has to be zoomed to
read it. The good news is that when zoomed the text is only slightly
blurred.
The book has more typos than I would like, but no more than most
modern textbooks.
As for the content, I first met this database design method on an
MSc course. At the time it struck me as being sensible, effective,
and the right way to do the job. 25 years later, I still think it's
the right way to design a database.
The book describes clearly how to design a database and, just as
important, why it is done that way. For the most part it is very
straightforward and simple. There are programs, some free, that do
the final more complicated step of turning the design into a set of
relational database tables. These are guaranteed to be in 5th normal
form (highly desirable).
- Artyom ShalkhakovReviewed in the United States on 30 July 2012
5.0 out of 5 stars For the curious reader
Verified PurchaseThis 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.
- Luke BlanchfordReviewed in the United States on 23 February 2017
5.0 out of 5 stars This is a great book if you want to get a higher level perspective on what data modeling is all about
Verified PurchaseI work in data modeling and data architecture, for a large bank. Most people think modeling is something simple, like adding columns to a table -- and that is certainly one approach. However, Terry Halpin gets it, that modeling is about semantics. It's up to the reader if he wants a simple book about relational table development -- or a higher level conceptual perspective. For me, to define and solve a modeling problem you have to know different ways on how to frame the problem, how to express a design and a solution. And this book very elegantly captures a number of design perspectives beyond the traditional SQL, to get at big picture -- which is meaning creation and knowledge semantics. I use this book when I want to think about modeling problems from alternate perspectives, as well as when I feel I am getting lost in too literal a notation. I also refer this book to members on my team, as well as to colleagues who ask me for good books on how I approach models..
- ScottReviewed in the United States on 10 July 2015
3.0 out of 5 stars Limited Professional Application - dated content
Verified PurchaseBe careful in trusting the 5-star reviews! If you click on the user names you will see they have all reviewed only 1 thing at Amazon ever- this book. They may not all be from the publisher/author-- but if they were I would not be shocked.
I feel like I have been warped back to 1989 when reading this book. Although there are some theoretical benefits to the approaches taken in the book, industry has largely chosen to not use many of the topics preached within. In the forwards it was mentioned that common industry modeling techniques were contrasted fairly (e.g. UML/ER) -- but I did not find this to be true. The book reads like a desperate attempt to make a lesser used modeling technique relevant. I was hopeful when picking up this book it would be a fair comparison and add a powerful tool I could use in my daily work data-modeling.
As a text-book for first-time data modelers this book does provide some value. Unfortunately, the explanations are dry, patronizing on simple topics and skip detail on complex ones. A typical explanation in the book reads: "For brevity, relational style assumes that variables in the rule head are universally quantified and that variables introduced in the body are existentially quantified." The examples are too simplistic to actually fully explain concepts - and frustratingly seem to avoid all real-world pitfalls we typically encounter as data modelers. On the positive side, if you have no background in modeling at all - you will learn something from this book.
For everyone else, this book is only useful if you are looking for a history lesson on alternative modeling approaches or need a different perspective than is offered in books focused on UML.
In the end, I think there are better choices for learning.