Information Modeling and Relational Databases : From Conceptual Analysis to Logical Design
Terry. Halpin
Bok Engelsk 2001 · Electronic books.
| Annen tittel | |
|---|---|
| Utgitt | Burlington : : Elsevier Science, , 2001.
|
| Omfang | 1 online resource (792 p.)
|
| Opplysninger | Description based upon print version of record.. - Front Cover; Information Modeling and Relational Databases; Copyright Page; Contents; Foreword; Foreword; Foreword; 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 From External to Conceptual to Relational; 2.4 Development Frameworks; 2.5 Summary; Chapter 3. Conceptual Modeling: First Steps; 3.1 Conceptual Modeling Language Criteria; 3.2 ORM's Conceptual Schema Design Procedure. - 10.4 Advanced Mapping Aspects10.5 Summary; Chapter 11. Relational Languages; 11.1 Relational Algebra; 11.2 Relational Database Systems; 11.3 SQL: Historical and Structural Overview; 11.4 SQL: Identifiers and Data Types; 11.5 SQL: Choosing Columns, Rows, and Order; 11.6 SQL: Joins; 11.7 SQL: In, Between, Like, and Null Operators; 11.8 SQL: Union and Simple Subqueries; 11.9 SQL: Scalar Operators and Bag Functions; 11.10 SQL: Grouping; 11.11 SQL: Correlated and Existential Subqueries; 11.12 SQL: Data Definition; 11.13 SQL: Updating Table Populations; 11.14 SQL: Security and Meta-Data. - 11.15 Summary. - 3.3 CSDP Step 1: From Examples to Elementary Facts3.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 CSDP Step 4: Uniqueness Constraints; Arity Check; 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 Projection-Join Check; 4.7 Summary; Chapter 5. Mandatory Roles; 5.1 Introduction to CSDP Step 5; 5.2 Mandatory and Optional Roles; 5.3 Logical Derivation Check. - 5.4 Reference Schemes5.5 Case Study: A Compact Disc Retailer; 5.6 Summary; Chapter 6. Value, Set-Comparison, and Subtype Constraints; 6.1 CSDP Step 6: Value, Set, and Subtype Constraints; 6.2 Basic Set Theory; 6.3 Value Constraints and Independent Objects; 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 CSDP Step 7: Other Constraints; Final Checks; 7.2 Occurrence Frequencies; 7.3 Ring Constraints; 7.4 Other Constraints; 7.5 Final Checks; 7.6 Summary. - Chapter 8. Entity Relationship Modeling8.1 Overview of ER; 8.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 Reference and Single-Valued Attributes; 9.3 Multi-valued 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. Relational Mapping; 10.1 Implementing a Conceptual Schema; 10.2 Relational Schemas; 10.3 Relational Mapping. - Information Modeling and Relational Databases provides an introduction to ORM (Object Role Modeling)-and much more. In fact, it's 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. Inside, ORM authority Terry Halpin blends conceptual information with practical instruction that will let you begin using ORM effectively as soon as possible. Supported by examples, exercises, and useful background information, his step-by-step approach teaches you to
|
| Emner | |
| Sjanger | |
| Dewey | |
| ISBN | 1558606726
|
