by Toby Teorey, Sam Lightstone, Tom Nadeau, and H.V. Jaqadish
Published Feb 24, 2011.
(Note that the amazon.com price is currently 40% off the regular price. Not sure how long this will be the case, so if you want the book, buy it soon!)
Yes, the 5th edition! A book only gets updated this often if it is REALLY good and REALLY popular. Have you read any of the editions yet? I’ve seen the book for sale at conferences, but haven’t read it yet.
A whole chapter devoted to XML and web databases. What you need to know to utilize XML rather than relational tables.
- In-depth detail and plenty of real-world, practical examples throughout
- Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system
- Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data.
A whole chapter describing Object Relational Design. Learn how to make a choice between what is in the database as a BLOB and what is outside in a separate file.
About the book:
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?
In the extensively revised fifth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems.
I copied a couple of reviews from amazon.com to give you an idea of the book’s value:
"Database Modeling and Design is one of the best books that I have seen for explaining how to build database applications. The book is informative, well-written, and concise."-Michael Blaha, DSc., Consultant, Modelsoft Consulting Corp
"This book book is by far the best book available on classic database design. Topics like normalization and many-to-many and n-ary association semantics are without peer in teaching you how to model real-world complexities. This latest edition extends the classic material with extensive discussion of modern tools and other aspects of logical database design. Every database architect should have this book at hand."-Bob Muller, Data Analyst, Poesys Associates
About the authors:
I only know author Sam Lightstone, so let me tell you a bit about him. He works in the IBM Toronto Lab and is a master inventor in the database area. Last year he published his first non-database book, called “Making it Big in Software”. The book is quite successful and is highly recommended if you are in the software business in any role.
Here are some previous blog entries about Sam & his Making it Big book: