Information modeling and relational databases / Terry Halpin, Tony Morgan.

Format:

Book

Author/Creator:

Halpin, T. A.

Contributor:

Morgan, A. J. (Antony J.)

Series:

Morgan Kaufmann series in data management systems.

Morgan Kaufmann series in data management systems

Language:

English

Subjects (All):

Database design.

Relational databases.

Physical Description:

1 online resource (970 p.)

Edition:

2nd ed.

Place of Publication:

Burlington, MA : Elsevier/Morgan Kaufman Publishers, c2008.

Language Note:

English

System Details:

text file

Summary:

Information Modeling and Relational Databases, second edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and programmers. Terry Halpin, a pioneer in the development of ORM, blends conceptual information with

Contents:

Front Cover; Information Modeling and Relational Databases; Copyright Page; Contents; Foreword by John Zachman; Foreword by Sjir Nijssen; Foreword by Gordon Everest; Preface; Chapter 1 Introduction; 1.1 Information Modeling; 1.2 Modeling Approaches; 1.3 Some Historical Background; 1.4 The Relevant Skills; 1.5 Summary; Chapter 2 Information Levels and Frameworks; 2.1 Four Information Levels; 2.2 The Conceptual Level; 2.3 Database Design Example; 2.4 Development Frameworks; 2.5 Summary; Chapter 3 Conceptual Modeling: First Steps; 3.1 Conceptual Modeling Language Criteria

3.2 Conceptual Schema Design Procedure3.3 CSDP Step 1: From Examples to Elementary Facts; 3.4 CSDP Step 2: Draw Fact Types and Populate; 3.5 CSDP Step 3: Trim Schema; Note Basic Derivations; 3.6 Summary; Chapter 4 Uniqueness Constraints; 4.1 Introduction to CSDP Step 4; 4.2 Uniqueness Constraints on Unaries and Binaries; 4.3 Uniqueness Constraints on Longer Fact Types; 4.4 External Uniqueness Constraints; 4.5 Key Length Check; 4.6 Projections and Joins; 4.7 Summary; Chapter 5 Mandatory Roles; 5.1 Introduction to CSDP Step 5; 5.2 Mandatory and Optional Roles; 5.3 Reference Schemes

5.4 Case Study: A Compact Disc Retailer5.5 Logical Derivation Check; 5.6 Summary; Chapter 6 Value, Set-Comparison, and Subtype Constraints; 6.1 Introduction to CSDP Step 6; 6.2 Basic Set Theory; 6.3 Value Constraints and Independent Types; 6.4 Subset, Equality, and Exclusion Constraints; 6.5 Subtyping; 6.6 Generalization of Object Types; 6.7 Summary; Chapter 7 Other Constraints and Final Checks; 7.1 Introduction to CSDP Step 7; 7.2 Occurrence Frequencies; 7.3 Ring Constraints; 7.4 Other Constraints and Rules; 7.5 Final Checks; 7.6 Summary; Chapter 8 Entity Relationship Modeling

8.1 Overview of ER8.2 Barker notation; 8.3 Information Engineering notation; 8.4 IDEF1X; 8.5 Mapping from ORM to ER; 8.6 Summary; Chapter 9 Data Modeling in UML; 9.1 Introduction; 9.2 Object-Orientation; 9.3 Attributes; 9.4 Associations; 9.5 Set-Comparison Constraints; 9.6 Subtyping; 9.7 Other Constraints and Derivation Rules; 9.8 Mapping from ORM to UML; 9.9 Summary; Chapter 10 Advanced Modeling Issues; 10.1 Join Constraints; 10.2 Deontic Rules; 10.3 Temporality; 10.4 Collection Types; 10.5 Nominalization and Objectification; 10.6 Open/Closed World Semantics; 10.7 Higher-Order Types

10.8 SummaryChapter 11 Relational Mapping; 11.1 Implementing a Conceptual Schema; 11.2 Relational Schemas; 11.3 Relational Mapping Procedure; 11.4 Advanced Mapping Aspects; 11.5 Summary; Chapter 12 Data Manipulation with Relational Languages; 12.1 Relational Algebra; 12.2 Relational Database Systems; 12.3 SQL: Historical and Structural Overview; 12.4 SQL: Identifiers and Data Types; 12.5 SQL: Choosing Columns, Rows, and Order; 12.6 SQL: Joins; 12.7 SQL: In, Between, Like, and Null Operators; 12.8 SQL: Union and Simple Subqueries; 12.9 SQL: Scalar Operators and Bag Functions

12.10 SQL: Grouping

Notes:

Description based upon print version of record.

Includes bibliographical references, useful Web sites (p. 911-924) and index.

ISBN:

9786611749347

9781281749345

1281749346

9780080568737

0080568734

OCLC:

437245571