The Resource Information modeling and relational databases : from conceptual analysis to logical design, Terry Halpin, (electronic resource)

Information modeling and relational databases : from conceptual analysis to logical design, Terry Halpin, (electronic resource)

Label
Information modeling and relational databases : from conceptual analysis to logical design
Title
Information modeling and relational databases
Title remainder
from conceptual analysis to logical design
Statement of responsibility
Terry Halpin
Creator
Subject
Genre
Language
  • eng
  • eng
Summary
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
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Halpin, T. A
Dewey number
005.756
Illustrations
illustrations
Index
index present
Language note
English
LC call number
QA76.9.D26
LC item number
H355 2001
Literary form
non fiction
Nature of contents
  • dictionaries
  • bibliography
Series statement
Morgan Kaufmann series in data management systems
http://library.link/vocab/subjectName
  • Database design
  • Relational databases
Label
Information modeling and relational databases : from conceptual analysis to logical design, Terry Halpin, (electronic resource)
Instantiates
Publication
Note
Description based upon print version of record
Bibliography note
Includes bibliographical references and index
Carrier category
online resource
Carrier category code
  • cr
Content category
text
Content type code
  • txt
Contents
  • 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
  • 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
  • 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
Dimensions
unknown
Extent
1 online resource (792 p.)
Form of item
online
Isbn
9781281024527
Media category
computer
Media type code
  • c
Specific material designation
remote
System control number
  • (EBL)298493
  • (OCoLC)191035141
  • (SSID)ssj0000179046
  • (PQKBManifestationID)11165705
  • (PQKBTitleCode)TC0000179046
  • (PQKBWorkID)10230344
  • (PQKB)10783714
  • (MiAaPQ)EBC298493
  • (EXLCZ)99111086906316350
Label
Information modeling and relational databases : from conceptual analysis to logical design, Terry Halpin, (electronic resource)
Publication
Note
Description based upon print version of record
Bibliography note
Includes bibliographical references and index
Carrier category
online resource
Carrier category code
  • cr
Content category
text
Content type code
  • txt
Contents
  • 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
  • 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
  • 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
Dimensions
unknown
Extent
1 online resource (792 p.)
Form of item
online
Isbn
9781281024527
Media category
computer
Media type code
  • c
Specific material designation
remote
System control number
  • (EBL)298493
  • (OCoLC)191035141
  • (SSID)ssj0000179046
  • (PQKBManifestationID)11165705
  • (PQKBTitleCode)TC0000179046
  • (PQKBWorkID)10230344
  • (PQKB)10783714
  • (MiAaPQ)EBC298493
  • (EXLCZ)99111086906316350

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...