Table of Contents for
NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software

Version ebook / Retour

Cover image for bash Cookbook, 2nd Edition NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software by Ted Hills Published by Technics Publications, 2016
  1. cover
  2. NoSQL and SQL Data Modeling
  3. FrontMatter
  4. FrontMatter-1
  5. FrontMatter-2
  6. FrontMatter-3
  7. Acknowledgements
  8. Introduction
  9. Part I Real Words in the Real World
  10. Chapter 1 It’s All about the Words
  11. Chapter 2 Things: Entities, Objects, and Concepts
  12. Chapter 3 Containment and Composition
  13. Chapter 4 Types and Classes in the Real World
  14. Part II The Tyranny of Confusion
  15. Chapter 5 Entity-Relationship Modeling
  16. Chapter 6 The Unified Modeling Language
  17. Chapter 7 Fact-Based Modeling Notations
  18. Chapter 8 Semantic Notations
  19. Chapter 9 Object-Oriented Programming Languages
  20. Part III Freedom in Meaning
  21. Chapter 10 Objects and Classes
  22. Chapter 11 Types in Data and Software
  23. Chapter 12 Composite Types
  24. Chapter 13 Subtypes and Subclasses
  25. Chapter 14 Data and Information
  26. Chapter 15 Relationships and Roles
  27. Chapter 16 The Relational Theory of Data
  28. Chapter 17 NoSQL and SQL Physical Design
  29. Part IV Case Study
  30. Chapter 18 The Common Coffee Shop
  31. APPENDIX COMN Quick Reference
  32. Glossary
  33. Photo and Illustration Credits
  34. Index

Contents

  1. Acknowledgements
  2. Introduction
    1. Taking Care of Data
    2. Plant Change Control 2.0
    3. Where did the Savings Come From?
    4. Why Model?
    5. Why COMN?
    6. Book Outline
    7. Book Audience
      1. NoSQL Database Developer
      2. SQL Database Developer
      3. Data Modeler
      4. Software Developer
      5. Ontologist
  3. Part I Real Words in the Real World
  4. Chapter 1 It’s All about the Words
    1. References
  5. Chapter 2 Things: Entities, Objects, and Concepts
    1. Chapter Glossary
  6. Chapter 3 Containment and Composition
    1. Containment
    2. Composition
    3. Chapter Glossary
  7. Chapter 4 Types and Classes in the Real World
    1. Collections of Objects
    2. Sets of Concepts
    3. Sets of Objects
    4. Types and Classes
      1. Types Designate Sets
      2. Classes Describe Objects
      3. Three Aspects of Types and Classes
    5. Chapter Glossary
  8. Part II The Tyranny of Confusion
  9. Chapter 5 Entity-Relationship Modeling
    1. Logical E-R Data Models
    2. Multiple Levels of Abstraction
    3. Limitations of E-R Modeling Notation
      1. NoSQL Arrays and Nested Data Structures
      2. Lack of Reusable Composite Types
      3. Lack of Place
      4. Modeling the Real World
      5. Representing Individual Entities
      6. Mapping Between Models
      7. Data in Software
    4. Terminology
      1. Entity
      2. Conceptual
      3. E-R Terms Mapped to COMN Terms
    5. References
  10. Chapter 6 The Unified Modeling Language
    1. Class Diagrams
      1. Stereotyping
    2. Limitations of the UML
      1. Lack of Keys
      2. Middling Level of Abstraction
      3. Lack of Concept
      4. Subclassing versus Subtyping
    3. Terminology
      1. Relationship, Composition and Aggregation
      2. Type and Implementation Class
      3. UML Terms Mapped to COMN Terms
    4. References
  11. Chapter 7 Fact-Based Modeling Notations
    1. Facts and Relationships
    2. Limitations of Fact-Based Modeling
      1. Lack of Instances
      2. Incompleteness
      3. Difficulty
    3. Terminology
      1. Fact-Based Modeling Terms Mapped to COMN Terms
    4. References
  12. Chapter 8 Semantic Notations
    1. Predicates and RDF Statements
      1. Doubles and Quadruples
    2. OWL
    3. Graphical Notations for Semantics
    4. Terminology
  13. Chapter 9 Object-Oriented Programming Languages
    1. Classes, Objects, Types, and Variables
    2. Terminology
  14. Part III Freedom in Meaning
  15. Chapter 10 Objects and Classes
    1. Material Objects
      1. Objects with States
      2. Meaning of States
      3. Objects with More States
      4. Methods
      5. Material Objects in Computers
      6. Summary
    2. Computer Object Defined
      1. Composing Objects
    3. Summary
    4. Chapter Glossary
  16. Chapter 11 Types in Data and Software
    1. Types in Programming and Databases
      1. What Does a Type Tell Us?
    2. Classes in Object-Oriented Software
    3. Separating Type and Class
    4. Simple Types
    5. References
    6. Chapter Glossary
  17. Chapter 12 Composite Types
    1. Composite Types as Logical Record Types
    2. Types Representing Things in the Real World: Identification
      1. Stepwise Refinement and Completeness
    3. Types Representing Other Types
    4. Measures as Composite Types
    5. Nested Types
    6. Modeling Documents
    7. Arrays
    8. Chapter Glossary
    9. References
  18. Chapter 13 Subtypes and Subclasses
    1. Subtypes
      1. Restriction is Subtyping
    2. Subclasses
    3. Subtypes and Extensions: Perfect Together
    4. Inheritance
      1. Using Subtype Variables and Values
      2. Using Extending Types and Classes
    5. Projection: The Inverse of Extension
    6. Chapter Glossary
  19. Chapter 14 Data and Information
    1. Information
      1. Is Information Always True?
    2. From Information to Data
      1. Data en Masse
      2. Variable Names
      3. Summary
    3. Information and Data as Colloquialisms
      1. Information En Masse
      2. It’s Just Data
      3. Putting It All Together
      4. “Unstructured Data” and “Semi-Structured Data”
    4. Data Object
    5. Chapter Glossary
  20. Chapter 15 Relationships and Roles
    1. Arrivals and Departures
    2. Labeling Relationship Lines
      1. Cleaning Up the Model
    3. Roles, Predicates, and Relationships
    4. Chapter Glossary
  21. Chapter 16 The Relational Theory of Data
    1. What is a Relation?
      1. The Order of Rows
      2. The Uniqueness of Rows
      3. The Significance of Columns
      4. Summary
    2. Technical Relational Terminology
      1. Tuple and Relation Schemes
      2. Giving Data to the System
      3. Data Attribute Versus Attribute
      4. Relational Terminology Reprise
    3. Composite Data Attributes
    4. Relational Operations
    5. NoSQL Versus the Relational Model
    6. SQL Versus the Relational Model
    7. Terminology
    8. Chapter Glossary
  22. Chapter 17 NoSQL and SQL Physical Design
    1. What’s Different about NoSQL?
    2. Database Performance
    3. ACID versus BASE and Scalability
      1. ACID
      2. BASE and CAP
    4. NoSQL and SQL Data Organization
      1. Key/Value DBMS
      2. Graph DBMS
      3. Document DBMS
      4. Columnar DBMS
      5. Tabular DBMS
    5. Summary
    6. References
  23. Part IV Case Study
  24. Chapter 18 The Common Coffee Shop
    1. Analysis: Documenting Real-World Entities
    2. Logical Data Modeling: Designing the Data
    3. Physical Data Modeling: Designing the Implementation
  25. APPENDIX COMN Quick Reference
  26. Glossary
  27. Photo and Illustration Credits
  28. Index

Landmarks

  1. Cover
Back to top