Database modeling & design
著者
書誌事項
Database modeling & design
(The Morgan Kaufmann series in data management systems)
M. Kaufmann, c1999
3rd ed
- : pbk
- タイトル別名
-
Database modeling and design
並立書誌 全1件
-
-
Database modeling & design / Toby J. Teorey
BA40923436
-
Database modeling & design / Toby J. Teorey
大学図書館所蔵 件 / 全8件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes bibliographical references and index
内容説明・目次
内容説明
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.
目次
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
「Nielsen BookData」 より