Database modeling & design

Author(s)

• Teorey, Toby J.

Bibliographic Information

Database modeling & design

Toby J. Teorey

（The Morgan Kaufmann series in data management systems）

M. Kaufmann, c1999

3rd ed

• : pbk

Other Title

Database modeling and design

Note

Includes bibliographical references and index

Description and Table of Contents

Description

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.

Table of Contents

1 Introduction 2 The ER Model: Basic Concepts 3 ER Modeling in Logical Database Design 4 Transformation of the ER Model to SQL 5 Normalization 6 Access Methods 7 An Example of Relational Database Design 8 Distributed Data Allocation 9 Data Warehousing, OLAP, and Data Mining 10 Advanced Database Technologies

by "Nielsen BookData"

Details

• NCID: BA41860852
• ISBN:
  • 1558605002
• LCCN: 98042150
• Country Code: us
• Title Language Code: eng
• Text Language Code: eng
• Place of Publication: San Francisco
• Pages/Volumes: vii, 366 p.
• Size: 24 cm
• Classification:
  • LCC : QA76.9.D26
  • DC21 : 005.75/6
• Subject Headings:
  • LCSH : Relational databases
  • LCSH : Database design
• Parent Bibliography ID:
  • BA07715704