Database Modeling and Design, Third Edition (The Morgan Kaufmann Series in Data Management Systems) [Paperback]

Toby J. Teorey (Author)

Book Description

ISBN-10: 1558605002 | ISBN-13: 978-1558605008 | Publication Date: October 23, 1998 | Edition: 3

This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP).

Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing.

Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise.

* Continued focus on relational model
* Integration of information about data warehouse and OLAP, plus other advanced database technologies, including object oriented, multimedia, and temporal database
* Discussion of basic principles is supplemented by examples based on real life cases

Editorial Reviews

From the Back Cover

This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP).

Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing.

Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise.

About the Author

Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor. He received his B.S. and M.S. degrees in electrical engineering from the University of Arizona, Tucson, and a Ph.D. in computer sciences from the University of Wisconsin, Madison. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. Professor Teorey's current research focuses on database design and data warehousing, OLAP, advanced database systems, and performance of computer networks. He is a member of the ACM and the IEEE Computer Society.

Product Details

• Paperback: 384 pages
• Publisher: Morgan Kaufmann; 3 edition (October 23, 1998)
• Language: English
• ISBN-10: 1558605002
• ISBN-13: 978-1558605008
• Product Dimensions: 9.1 x 7.3 x 0.8 inches
• Shipping Weight: 1.5 pounds
• Average Customer Review: 3.6 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #1,522,062 in Books (See Top 100 in Books)

More About the Author

Toby Teorey (1942- ) is currently Professor Emeritus of Electrical Engineering and Computer Science (EECS) at the University of Michigan, where he served as Associate Chair for Computer Science & Engineering (1994-1997). He received the BS (1964) and MS (1965) degrees in Electrical Engineering from the University of Arizona, Tucson, and a PhD in Computer Science (1972) from the University of Wisconsin, Madison. He served as an Electronic Data Processing Officer in the U.S. Air Force (1965-1969), including duty as a White House Social Aide for President Lyndon Johnson (1966-1968).

He conducted extensive research and developed software tools for the logical and physical design of relational databases, data warehouse and OLAP design, disk scheduling algorithms, and computer system and network (Ethernet) performance. He has published over 65 critically refereed technical papers and six books. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. His web page is http://www.eecs.umich.edu/~teorey.

Customer Reviews

Most Helpful Customer Reviews

29 of 30 people found the following review helpful:

5.0 out of 5 stars Theoretical Analysis, March 14, 2000

By 

Bucci - See all my reviews

This review is from: Database Modeling and Design, Third Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)

I have no formal schooling in programming, but find myself having developed one major database application and about to embark on another larger project. I bought the book because I wasn't sure if my intuitions about database design were the right intuitions.

Given what I was looking for, the book was excellent. It described (perhaps in dry language) the theoretical underpinnings of a well designed (or normalized) database.

Also, the book gave me the proper smybolic and linguistic tools to tackle the task of DB design in a more organized and effecient process.

In short, it turns out there are very strict rules about what makes a database a well designed database. Given that previously I was designing on intuition alone, I found this book an excellent developmental tool. There were a few things I was doing wrong that I won't do again!

By the way, there are 2 chapters in the book that most people won't use. Or rather, if you need these chapters you probably don't need the other chapters. These are the chapters on geographically distributed database applications and the chapter on how the physical implementation of the database in memory can relate to query optimization.

17 of 17 people found the following review helpful:

5.0 out of 5 stars Perfect Balance of Theory and Practice!, April 4, 1999

By A Customer

This review is from: Database Modeling and Design, Third Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)

This is one of the best books I have found for the intermediate-advanced DB designers out there. Most of the other books dwell too much on theory - one of my main gauges for checking out DB Modeling books has been a scan for descriptions on what First and more advanced Normal Forms mean and this book does a great job. It goes step-by-step with plenty of worthwhile examples on why you should attempt to normalize to higher degrees and even on why, as a final step, you may actually want to denormalize (yes, undo some of the work that you've done). This is not a beginner's book - go get SQL for Dummies or the like if you're just getting started. If, on the other hand, you've been creating tables, databases, and indexes for a while and can't quite figure out how to get around a pesky design problem, then this is the perfect book for you.

15 of 15 people found the following review helpful:

4.0 out of 5 stars A bit dry, but impressively thorough!, February 17, 2000

By 

Wilfredo R. Infante "Any sufficiently advance... (Florida, USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Database Modeling and Design, Third Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)

Ok, yes the book is rather dry. No cute anecdotes here. But, if you bring yourself to really focus on it you'll find DM&D to be a well written book. At a little over 300 pages it did a great job of conveying the major DM concepts concisely yet with enough examples so that the reader can achieve a good level understanding. Also, not having to wade through another 1500 page goliath yet getting the same return, in terms of knowledge acquired, saves me time, my most valuable resource right now. Undisciplined novices may not find it a good 'motivator' book because it does serve up a great deal of information per page mixing both basic information and advanced concepts, this generally leads to rereading a page several times to let a theory and it's implications sink in. All in all I really thought it was a very worthwhile read. It filled a good number of 'holes' in my knowledge of data modeling. I've been doing Oracle database administration for 5 years and hardcore modeling in the last 2. I was pretty good at my job, now I'm even better! Hope this helps!