New Brain and Whole Body Tissue Clearing|Register Now
»
Database Modeling and Design
 
 

Database Modeling and Design, 5th Edition

Logical Design

 
Database Modeling and Design, 5th Edition,Toby Teorey,Sam Lightstone,Tom Nadeau,H.V. Jagadish,ISBN9780123820204
 
 
 

  &      &      &      

Morgan Kaufmann

9780123820204

9780123820211

352

235 X 191

The database professional’s only complete business intelligence guide to data modeling concepts and logical database design.

Print Book + eBook

USD 77.94
USD 129.90

Buy both together and save 40%

Print Book

Paperback

In Stock

Estimated Delivery Time
USD 64.95

eBook
eBook Overview

ePUB format

PDF format

VST format

USD 64.95
Add to Cart
 
 

Key Features

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

Description

Database Modeling and Design focuses on techniques for database design in relational database systems. The book discusses the entity-relationship approach and the unified modeling language approach; both are used throughout the book when it refers to logical database design for the specification of data requirements and conceptual modeling. The book starts with a description of the life cycle of databases, and it goes on to discuss the entity-relationship model and unified modeling languages. It demonstrates how data modeling concepts are used in the process of database design. The book covers database normalization, including information about equivalence on the function of the entity-relationship and unified modeling language conceptual models, and the relational model of the Boyce Codd normal form. The book explores the difference between object-oriented database systems and relational database systems. It includes a description on handling the impedance mismatch problem by the extensions made to relational systems. Web technologies, including an overview and specific database design issues on XML, are also covered in this book. Lastly, IBMs Rational Data Architect, Computer Associates AllFusion ERwin Data Modeler, and Sysbases PowerDesigner are discussed, and their uses for handling complex data modeling problems are demonstrated. This book will serve as a guide for both novice and experienced professional database practitioners.

Readership

This book is intended for data management professionals with job titles/functions that include data analyst, data modeler; data architect; database designer; database application developer, application architect, database programmer, programmer/analyst, database administrator.

 

Toby Teorey

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.

Affiliations and Expertise

University of Michigan, Ann Arbor, USA

View additional works by Toby J. Teorey

Sam Lightstone

Sam Lightstone is a Senior Technical Staff Member and Development Manager with IBM’s DB2 product development team. His work includes numerous topics in autonomic computing and relational database management systems. He is cofounder and leader of DB2’s autonomic computing R&D effort. He is Chair of the IEEE Data Engineering Workgroup on Self Managing Database Systems and a member of the IEEE Computer Society Task Force on Autonomous and Autonomic Computing. In 2003 he was elected to the Canadian Technical Excellence Council, the Canadian affiliate of the IBM Academy of Technology. He is an IBM Master Inventor with over 25 patents and patents pending; he has published widely on autonomic computing for relational database systems. He has been with IBM since 1991.

Affiliations and Expertise

IBM, Toronto, Canada

View additional works by Sam S. Lightstone

Tom Nadeau

Tom Nadeau is the founder of Aladdin Software (aladdinsoftware.com) and works in the area of data and text mining. He received his B.S. degree in computer science and M.S. and Ph.D. degrees in electrical engineering and computer science from the University of Michigan, Ann Arbor. His technical interests include data warehousing, OLAP, data mining and machine learning. He won the best paper award at the 2001 IBM CASCON Conference.

Affiliations and Expertise

Ubiquiti Inc., Ann Arbor, MI

View additional works by Tom Nadeau

H.V. Jagadish

H.V. Jagadish is a professor in EE and CS at the University of Michigan, Ann Arbor, where he is part of the database group affiliated with the bioinformatics program and the Center for Computational Medicine and Bioinformatics. Prior to joining the Michigan faculty, he spent over a decade at AT&T Bell Laboratories as a research scientist where he became head of the Database division.

Affiliations and Expertise

Univ of Mich, Ann Arbor (EE/CS dept)

Database Modeling and Design, 5th Edition

Preface About the Authors Chapter 1 Introduction Chapter 2 The Entity-Relationship Model Chapter 3 The Unified Modeling Language Chapter 4 Requirements Analysis and Conceptual Data Modeling Chapter 5 Transforming the Conceptual Data Model to SQL Chapter 6 Normalization Chapter 7 An Example of Logical Database Design Chapter 8 Object-Relational Design Chapter 9 XML and Web Databases Chapter 10 Business Intelligence Chapter 11 CASE Tools for Logical Database Design Appendix: The Basics of SQL References Exercises Solutions to Selected Exercises Glossary Index Chapter 3: Query Optimization and Plan Selection Appendix A: A Simple Performance Model for Databases

Quotes and reviews

"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

“The book is not only good for beginners, but it also provides greater insight for experienced learners. Perhaps this is why it has evolved into its fifth edition. The book is generally well organized. It starts with the first step in the database life cycle, and progresses in a chronological order to more advanced concepts such as object relational design, Extensible Markup Language (XML), and Web databases. The writing style of the book is simple and straightforward, and the use of database terminology is very concise…In my opinion, the book could be used as a course text, with some help from other sources to cover SQL query-related concepts. However, I would have liked a chapter on SQL that covered simple and complex query design, as well as optimization."-- Computing Reviews

 
 

Shop with Confidence

Free Shipping around the world
▪ Broad range of products
▪ 30 days return policy
FAQ

Contact Us