Information modeling and relational databases
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 s...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Burlington, MA :
Elsevier/Morgan Kaufman Publishers
c2008.
|
| Edición: | 2nd ed |
| Colección: | Morgan Kaufmann series in data management systems.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627813906719 |
Tabla de Contenidos:
- 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
