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

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