|
Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems) | 
 enlarge | Author: Toby J. Teorey
Publisher: Morgan Kaufmann
Category: Book
List Price: $57.95
Buy New: $44.93
You Save: $13.02 (22%)
New (20) Used (8) from $37.66
Avg. Customer Rating:  6 reviews
Sales Rank: 256479
Media: Paperback
Edition: 4
Number Of Items: 1
Pages: 296
Shipping Weight (lbs): 1.2
Dimensions (in): 9.2 x 7.5 x 0.8
ISBN: 0126853525
Dewey Decimal Number: 005.756
EAN: 9780126853520
ASIN: 0126853525
Publication Date: September 6, 2005
Availability: Usually ships in 1-2 business days
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
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 fourth 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.
+ a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches!
+ the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax;
+ the fundamentals of database normalization through the fifth normal form;
+ practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining;
+ examples for how to use the most popular CASE tools to handle complex data modeling problems.
+ Exercises that test understanding of all material, plus solutions for many exercises.
|
| Customer Reviews: Read 1 more reviews...
Comprehensive clear logical and conceptual data modeling May 5, 2008
The authors have done an exceptional job of making the process of data modeling from requirements analysis to conceptual to logical very, very clear. Even their coverage of seeminingly simple concepts like nomenclature explanations and expecially UML were very helpful. The sections on transformation, 3NF, and BI (including data warehouse, OLAP adn mining) were clear, and a great "how to". Given the state of BPM, SOA and BPEL this is a must have reference for anyone who is responsible for enterprise information and data.
Superb March 18, 2007
3 out of 3 found this review helpful
This book is clear, concise, and to the point. The language is in such a way as to pack the maximum information into the minimum space and yet remain fully intelligible.
The techniques and methods described are top rate. If your desire is to not simply learn database design and implementation but to "understand" it, this is the book for you.
Just enough DB design without being complicated June 14, 2006
9 out of 9 found this review helpful
This book is now next to my desk as a reference text. It does a good job at explaining the basics of relational database models and how they fit into a modern business architecture. The authors obviously have a methodology that works for them and the chapters seem to be organized according to their methodology. They start with UML, analyze the model in UML for potential problems, then move into SQL, normalization at the SQL stage, and end with an example. It's nicely written and concise.
-Frank Cohen
http://www.xquerynow.com
http://www.pushtotest.com
Excellent introduction to data modeling January 23, 2006
18 out of 18 found this review helpful
I also am a reviewer of the book and an interested colleague. I've used this book since its first edition as my main reference on basic data modeling, and I have been happy to comment on its newer editions. This 4th edition improves on earlier ones by including the Unified Modeling Language (UML), my own first choice for a design language for data modeling. The chapter on the UML includes everything you need, but it keeps it as simple and straightforward as possible, making the material very accessible. The real contribution of the book is in the normalization chapter and in the excellent description and examples of n-ary relationships and the consequences of their multiplicities, a very-hard-to-understand corner of the data modeling world. The inclusion in this edition of material on OLAP and data warehousing is also welcome, though very limited in scope. Finally, moving the physical design material into a separate book makes this book much more cohesive and useful as a reference for data modeling.
Excellent book for Data Modelers, etc. January 23, 2006
4 out of 7 found this review helpful
For those in Data Modeling, Data Architecture, and similar disciplines, I highly recommend this book ! An excellent discussion of database design and modeling, practices and techniques.
|
|
|
Copyright 2008 - RailroadBookstore.com
| |
