Table of Contents for

NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software

Index

abstraction, 6, 61, 73, 89, 98, 123

multiple levels of, 48–50

ACID, 198, 199

aggregation, 31, 32, 33, 63, 100, 114, 129, 235

agile software development, 6

American Standard Code for Information Interchange. See ASCII

analytics, 161, 166, 235

array, 50, 51, 86, 132–34, 135, 149, 189, 235

ASCII, 123, 124

assembly, 32, 34, 100, 118, 235

association, 60, 63

associative entity, 48, 174

atom, 24

atomic, 200

attribute, 59, 186, 194, 235

Barker-Ellis, 45

BASE, 202

base class, 144, 152, 154, 236

base type, 146, 154, 236

bit, 96

Blaha, Michael, 61

blending, 30, 31, 33, 218, 235

byte, 96

C++, 83, 101

cake, 30, 31

CAP theorem, 199, 201, 202

cardinality, 133

carton, 29, 30, 33, 236

change request, 4

Chen, Peter, 45

class, 39–41, 41, 59, 60, 64, 84, 101, 102, 107, 116, 235

class diagram, 59–60

classification, 39, 107, 116, 137

collection, 35–36, 35, 36, 41, 42, 235

columnar, 198, 203, 207, 208, 212

COMN, 46, 63, 79, 211

goals of, 11–12, 84

completeness principle, 122

component, 26, 28, 32, 100, 235

composite, 26, 28, 235

composite data attribute, 187, 189

composite key, 222

composite type, 52, 116, 117–18, 235

composition, 31–32, 100

computer object, 97–102, 104, 235

concept, 23, 26, 27, 28, 36, 42, 62, 89, 235

Concept and Object Modeling Notation. See COMN

conceptual, 57, 236

conceptual data model, 48, 49, 57

conceptual entity, 27

conceptual thing, 24

consistency, 200

container, 29, 33, 236

containment, 29–30, 30

contents, 29, 33, 236

CRM, 10

crow’s feet, 47

customer relationship management. See CRM

data, 155, 157–61, 165, 166, 236

data architect, 7

data attribute, 45, 57, 64, 117, 174, 185, 194, 236

data attribute value, 182, 194, 236

data independence, 180, 194, 195, 236

data model, 8–11

data modeler, 7, 8, 11, 14, 51, 54, 85, 115

data modeling tool, 6, 8, 115

data object, 165

database, 6

database administrator, 7

database developer, 7

Database Management System. See DBMS

datum, 159, 166, 186, 236

DBMS, 9, 49, 106, 108, 114, 160, 201

document database, 120, 191, 203, 213, 226

Document Type Definition. See DTD

domain, 51

DTD, 131

durability, 201

edge, 205

egg, 29, 30

electron, 24

element, 130, 132

element number, 132

elementary particle, 24, 25, 27

elephant, 38, 41, 137

encapsulate, 102, 104, 236

encapsulation, 59, 118

entity, 23, 27, 28, 45, 46, 72, 89, 236

entity-relationship model, 45

enumeration, 40, 41, 42, 113, 143

extending class, 146, 152, 154, 236

extending type, 150, 152

eXtensible Markup Language. See XML

extension, 145, 146, 154, 236, 237

fact, 155, 157, 166, 236

fact type, 67

fact-based model, 70

fact-based modeling, 67

limitations of, 70–71

terminology of, 71–72

FCO-IM, 67

FK, 46, 169

flight schedule, 167, 169

flip-flop, 94

foreign key. See FK

foreign key constraint, 169

forward engineering, 6

Fully Communication-Oriented Information Modeling. See FCO-IM

generalization, 45, 63

graph, 203

graph DBMS, 205

hardware object, 98, 104, 236

Humpty-Dumpty problem, 19

IDEF1X, 45

identification, 119

identifier, 119, 135, 236

IE, 45, 61

implementation class, 64

inclusion relationship, 140, 154, 236

index, 132

induction, 24

information, 155–57, 160, 165, 166, 236

Information Engineering. See IE

Information Technology. See IT

inheritance, 144, 151–52

insight, 166, 237

Integration DEFinition for Information Modeling. See IDEF1X

isolation, 200

IT, 50

JavaScript Object Notation. See JSON

JSON, 10, 129, 131, 189

juxtaposition, 32, 33, 100, 149, 237

key/value, 191, 203, 204, 212

kind, 39, 42

location, 40, 42

logical data model, 48, 49, 53, 54, 55, 57, 189, 220, 226

logical E-R data model, 45–48

limitations of, 50–56

terminology of, 56–57

logical predicate, 77, 81, 158, 166, 167, 174, 237

logical record type, 45, 135, 237

main memory, 95

markup language, 132

material object, 90–97, 103

matryoshka doll, 30

matter, 24, 25

measure, 72, 125, 135, 237

member, 37

method, 59, 84, 90, 94, 101, 104, 237

Microsoft Visio, 9, 45

Microsoft Visual Studio, 67

model-driven development, 6

molecule, 24

Monet, 35, 36, 37

multiple inheritance, 142

multiplicity, 133

naming, 40

National Insurance Number. See NINO

natural language, 20, 21, 67, 69, 75, 76, 90, 92, 155, 157

Natural-language Information Analysis Methodology. See NIAM

nested type, 128–30

neutron, 24

Newman, Robert, 93

NIAM, 67

Nijssen, Sjir, 67

NINO, 117

node, 205

NORMA, 67, 69, 71, 74

normalization, 68

NoSQL, 50, 51, 120, 170, 192, 197

NoSQL Database Developer, 13

object, 23, 25, 27, 28, 29, 42, 59, 60, 71, 89, 131, 237

Object Role Modeling. See ORM

object type, 68, 70, 71, 72

objective thing, 24

object-oriented language, 107

object-oriented modeling, 83

terminology for, 85–86

object-oriented software, 8, 10, 20, 59, 101

Old North Church, 92, 93, 94, 103

ontologist, 15

operations, 59

ORM, 67

OWL, 15, 75, 79, 81

OWL class, 77

PK, 46, 51

predicate, 75, 77, 158, 161, 166, 237

primary key. See PK

projection, 153, 237

proposition, 156, 160, 166, 237

proton, 24

quark, 24

RDF, 75, 76, 81

RDF statement, 76

real world, 49

record collection, 120

redundancy, 52

relation, 178–82, 194, 237

relation scheme, 185, 195, 237

relation value, 195, 237

relation variable, 185, 195, 237

relational database, 185

relational operation, 178–82

relationship, 63, 170, 174, 175, 176, 237

relationship line labels, 170–74

relationship type, 176, 237

RELAX NG. See RNG

Renoir, 35

Resource Description Framework. See RDF

restriction relationship, 138, 154, 238

reverse engineering, 6, 8

RNG, 131

round-trip engineering, 6

scale horizontally, 201

scale vertically, 201

schema-less, 9, 10

selection, 40

semantic modeling, 75

semi-structured data, 166, 238

set, 37–38, 107

set notation, 37

simple hardware object, 99

simple key, 222

simple type, 52, 112–15, 116, 238

Simula, 83, 116

slot, 60, 61, 64

SmallTalk, 83

Social Security Number, 119

software developer, 7, 14

software object, 98, 104, 238

specialization, 45

SQL, 6, 49, 192

SQL Database Developer, 14

state, 29, 90, 91, 104, 238

stateful, 91–94, 103, 104, 235, 238

stateful mechanism, 97

stateless, 91, 96, 104, 238

stepwise refinement, 6, 123, 134

stereotype, 60, 64

structured data, 163, 166, 238

Structured Query Language. See SQL

subclass, 63, 144–46

subroutine, 52

subset, 138

subtype, 63, 137–44, 138, 152, 154, 238

superclass, 62

supertype, 62, 138, 152, 154, 238

Supreme Court, 55, 70

tag, 130

taxonomy, 137, 138

thing, 23

tuple, 183, 194, 238

tuple scheme, 185, 194, 238

tuple value, 183, 194, 238

tuple variable, 195, 238

type, 39–41, 41, 64, 77, 83, 84, 105, 116, 238

type checking, 106

UML, 31, 59, 62, 129

limitations of, 61–63

terminology of, 63–65

Unified Modeling Language. See UML

union type, 140

Universal Product Code. See UPC

universal type of the tuple scheme, 186

unstructured data, 163, 166, 238

UPC, 225

value, 104, 238

value type, 68, 71, 86

Vehicle Identification Number. See VIN

VIN, 119

Web Ontology Language. See OWL

XML, 10, 76, 129, 130, 184, 189