NoSQL and SQL data modeling: bringing together data, semantics, and software

✍ Scribed by Hills, Ted

• Publisher: Technics Publications, LLC
• Year: 2016;2019
• Tongue: English
• Leaves: 217
• Category: Library

✦ Synopsis

The Concept and Object Modeling Notation (COMN) is able to cover the full spectrum of analysis and design. This book will teach you:
��the simple and familiar graphical notation of COMN with its three basic shapes and four line styles
��how to think about objects, concepts, types, and classes in the real world, using the ordinary meanings of English words that aren't tangled with confused techno-speak
��how to express logical data designs that are freer from implementation considerations than is possible in any other notation
��how to understand key-value, document, columnar, and table-oriented database designs in logical and physical terms
��how to use COMN to specify physical database implementations in any NoSQL or SQL database with the precision necessary for model-driven development

✦ Table of Contents

Acknowledgements......Page 13
Introduction......Page 15
Taking Care of Data......Page 17
Where did the Savings Come From?......Page 18
Why Model?......Page 21
Book Outline......Page 23
SQL Database Developer......Page 24
Ontologist......Page 25
Part I Real Words in the Real World......Page 26
Chapter 1 It’s All about the Words......Page 27
References......Page 28
Chapter 2 Things: Entities, Objects, and Concepts......Page 29
Chapter Glossary......Page 33
Containment......Page 34
Composition......Page 35
Chapter Glossary......Page 37
Collections of Objects......Page 38
Sets of Concepts......Page 39
Types and Classes......Page 40
Types Designate Sets......Page 41
Three Aspects of Types and Classes......Page 42
Chapter Glossary......Page 43
Part II The Tyranny of Confusion......Page 44
Logical E-R Data Models......Page 45
Multiple Levels of Abstraction......Page 48
Limitations of E-R Modeling Notation......Page 49
Lack of Reusable Composite Types......Page 50
Representing Individual Entities......Page 53
Entity......Page 54
E-R Terms Mapped to COMN Terms......Page 55
References......Page 56
Class Diagrams......Page 57
Lack of Keys......Page 58
Lack of Concept......Page 59
Type and Implementation Class......Page 60
UML Terms Mapped to COMN Terms......Page 61
References......Page 62
Facts and Relationships......Page 63
Incompleteness......Page 66
Terminology......Page 67
References......Page 69
Predicates and RDF Statements......Page 70
Doubles and Quadruples......Page 72
Terminology......Page 73
Classes, Objects, Types, and Variables......Page 75
Terminology......Page 76
Part III Freedom in Meaning......Page 79
Material Objects......Page 80
Objects with States......Page 81
Meaning of States......Page 82
Objects with More States......Page 83
Methods......Page 84
Material Objects in Computers......Page 85
Summary......Page 86
Composing Objects......Page 87
Chapter Glossary......Page 92
Types in Programming and Databases......Page 94
Classes in Object-Oriented Software......Page 95
Separating Type and Class......Page 96
Simple Types......Page 99
Chapter Glossary......Page 104
Composite Types as Logical Record Types......Page 105
Types Representing Things in the Real World: Identification......Page 106
Stepwise Refinement and Completeness......Page 109
Types Representing Other Types......Page 110
Measures as Composite Types......Page 112
Nested Types......Page 115
Modeling Documents......Page 117
Arrays......Page 119
References......Page 120
Subtypes......Page 121
Subclasses......Page 128
Subtypes and Extensions: Perfect Together......Page 131
Using Subtype Variables and Values......Page 135
Projection: The Inverse of Extension......Page 136
Chapter Glossary......Page 137
Information......Page 138
Is Information Always True?......Page 139
From Information to Data......Page 140
Variable Names......Page 141
It’s Just Data......Page 142
“Unstructured Data” and “Semi-Structured Data”......Page 143
Chapter Glossary......Page 145
Arrivals and Departures......Page 147
Labeling Relationship Lines......Page 150
Cleaning Up the Model......Page 151
Roles, Predicates, and Relationships......Page 153
Chapter Glossary......Page 154
The Order of Rows......Page 155
The Uniqueness of Rows......Page 157
The Significance of Columns......Page 158
Technical Relational Terminology......Page 159
Tuple and Relation Schemes......Page 161
Data Attribute Versus Attribute......Page 162
Composite Data Attributes......Page 163
Relational Operations......Page 166
SQL Versus the Relational Model......Page 167
Terminology......Page 168
Chapter Glossary......Page 169
What’s Different about NoSQL?......Page 170
ACID......Page 171
BASE and CAP......Page 172
Key/Value DBMS......Page 174
Graph DBMS......Page 175
Document DBMS......Page 177
Columnar DBMS......Page 178
Tabular DBMS......Page 179
References......Page 183
Part IV Case Study......Page 184
Analysis: Documenting Real-World Entities......Page 185
Logical Data Modeling: Designing the Data......Page 190
Physical Data Modeling: Designing the Implementation......Page 195
APPENDIX COMN Quick Reference......Page 201
Glossary......Page 206
Photo and Illustration Credits......Page 209
Index......Page 210