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