Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)

3.48 avg rating
( 23 ratings by Goodreads )
 
9780126853520: Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)

Database Modeling and Design, Fourth Edition, the extensively revised edition of the classic logical database design reference, explains how you can model and design your database application in consideration of new technology or new business needs. It is an ideal text for a stand-alone data management course focused on logical database design, or a supplement to an introductory text for introductory database management.

This book features clear explanations, lots of terrific examples and an illustrative case, and practical advice, with design rules that are applicable to any SQL-based system. The common examples are based on real-life experiences and have been thoroughly class-tested. The text takes 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 - complemented with examples for both approaches. It also discusses the use of data modeling concepts in logical database design; the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; and the major issues in business intelligence such as data warehousing, OLAP for decision support systems, and data mining. There are examples for how to use the most popular CASE tools to handle complex data modeling problems, along with exercises that test understanding of all material, plus solutions for many exercises. Lecture notes and a solutions manual are also available.

This edition will appeal to professional data modelers and database design professionals, including database application designers, and database administrators (DBAs); new/novice data management professionals, such as those working on object oriented database design; and students in second courses in database focusing on design.



+ 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.

"synopsis" may belong to another edition of this title.

Book Description:

Extensively revised edition of the classic logical database design reference.

From the Back Cover:

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.

About the Authors

Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor, and his current research focuses on database design and performance of computing systems. Sam S. Lightstone is the cofounder and leader of DB2's autonomic computing R&D effort, and has been with IBM since 1991. His current research includes automatic physical database design, adaptive self-tuning resources, automatic administration, benchmarking methodologies, and system control. Mr. Lightstone is an IBM Master Inventor. Thomas P. Nadeau is a senior technical staff member of Ubiquiti Inc. and works in the area of data and text mining. His technical interests include data warehousing, OLAP, data mining and machine learning.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Toby J. Teorey; Sam S. Lightstone; Tom Nadeau; H.V. Jagadish
Published by Morgan Kaufmann (2005)
ISBN 10: 0126853525 ISBN 13: 9780126853520
New Paperback Quantity Available: 1
Seller:
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2005. Paperback. Book Condition: New. book. Bookseller Inventory # M0126853525

More Information About This Seller | Ask Bookseller a Question

Buy New
15.75
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

2.

Toby J. Teorey , Sam S. Lightstone , Tom Nadeau , H.V. Jagadish
ISBN 10: 0126853525 ISBN 13: 9780126853520
New Paperback Quantity Available: 5
International Edition
Seller:
PRIORITY BOOKS
(Springfield, VA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. Softcover Book, New Condition, Fast Shipping. Ready in Stock. 4th Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 296 Pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Bookseller Inventory # 354429

More Information About This Seller | Ask Bookseller a Question

Buy New
16.12
Convert Currency

Add to Basket

Shipping: 3.01
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

Toby J. Teorey , Sam S. Lightstone , Tom Nadeau , H.V. Jagadish
ISBN 10: 0126853525 ISBN 13: 9780126853520
New Paperback Quantity Available: 1
International Edition
Seller:
Nick Book House
(Fresno, CA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. New, Softcover International Edition, Printed in Black and White, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Bookseller Inventory # 19811

More Information About This Seller | Ask Bookseller a Question

Buy New
16.15
Convert Currency

Add to Basket

Shipping: 3.01
Within U.S.A.
Destination, Rates & Speeds

4.

Teorey, Toby J., Lightstone, Sam S., Nad
Published by Morgan Kaufmann (2005)
ISBN 10: 0126853525 ISBN 13: 9780126853520
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2005. Paperback. Book Condition: New. Never used!. Bookseller Inventory # P110126853525

More Information About This Seller | Ask Bookseller a Question

Buy New
27.47
Convert Currency

Add to Basket

Shipping: 1.50
Within U.S.A.
Destination, Rates & Speeds

5.

Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
Published by Morgan Kaufmann (2005)
ISBN 10: 0126853525 ISBN 13: 9780126853520
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2005. Paperback. Book Condition: New. 4. Bookseller Inventory # DADAX0126853525

More Information About This Seller | Ask Bookseller a Question

Buy New
36.77
Convert Currency

Add to Basket

Shipping: 3.01
Within U.S.A.
Destination, Rates & Speeds