Usage-driven database design : from logical data modeling through physical schema definition /: from logical data modeling through physical schema definition. ([2017])

• Record Type: Book
• Further Information: Note: George Tillmann.
• Authors: Tillmann, George
• Contents: At a Glance; Contents; About the Author; Preface; Part I: Introduction; Chapter 1: Introduction to Usage-Driven Database Design; Database Design Principle 1: Separation Principle; Database Design Principle 2: Distinction Principle; The Difference Between Separation and Distinction; Database Design Principle 3: Convergence Principle; The Separation, Distinction, and Convergence Principles; Database Design Principle 4: Minimal Regression Principle; Usage-Driven Database Design; Logical Data Modeling; Physical Schema Definition; The Terminology Trap; Notes. Part II: Logical Data ModelingChapter 2: The E-R Approach; A Little Data Modeling History; Some Important Definitions; Logical Data Modeling Objects; Entities; Type-Instance Distinction; Relationships; Attributes; Notes; Chapter 3: More About the E-R Approach; More About Relationships; Membership Class; Cardinality; Modality; Degree; Binary Relationship; N-ary Relationships; Unary or Recursive Relationships; Relationship Constraints; Inclusion; Exclusion; Conjunction; Simple Conjunction; Conditional Conjunction; Recursive Modality Constraints; More About Entities; Attributive Entity. Associative EntitiesSupertype and Subtype Entities (Generalization and Specialization); More About Attributes; Attribute Domain; Attribute Source: Primitive and Derived; Attribute Descriptor and Unique Identifier; Compound or Concatenated Unique Identifiers; Attribute Complexity: Simple and Group; Attribute Valuation: Single Value and Multivalue; Attribute Complexity and Valuation; Chapter 4: Building the Logical Data Model; The Interview Process; Gather Information and Review; 1. Identify the Users Who Are Authorities or Experts on the Subject. 2. Meet and Interview the Experts and Identify the Subject (Application) EntitiesPreparation; The First Interview; 3. Identify Relationships Between the Entities; 4. Identify the Properties or Attributes of the Entities and Relationships; Analyze Information; Construct Model; Repeat as Necessary; Making Sense of the Interview; Modeling Rules; Verifying What You Have Heard; Immediate Interview Feedback; Formal Walk-Throughs; Increasing E-R Diagram Comprehension; Subject Areas; Entity Fragments; Neighborhood Diagrams; Relationship Bridges and Stubs; Some Model Building Best Practices. Getting StartedDon't Lose Control of the Project to Users; Don't Lose Control of the Project to Technical Staff; Don't Become Dependent on Tools or Techniques; Don't Get Bogged Down in Endless Analysis; The Players ... and the Rules of Engagement; Deliverables; Examples of Deliverables; Sample Data Dictionary, Data Object Definitions; Notes; Chapter 5: LDM Best Practices; Abbreviations; Almost Unique Identifiers; Clarity; Compound Unique Identifiers; Conceptual Integrity; Conjunctive Relationships; Duplicate Super-Subtypes "Type" Data; Exclusive and Nonexclusive Generalization.
• Publisher Details: New York : Apress
• Publication Date: 2017
• Copyright Date: 2017
• Extent: 1 online resource
• Subjects: 005.74; Computer science; Database design; COMPUTERS -- Databases -- General; Database design; Computer Science; Database Management; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484227220; 1484227220
• Related ISBNs: 9781484227213; 1484227212
• Notes: Note: Vendor-supplied metadata.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.