data modeling
Structuring information architecture
Data modeling is the process of creating a structured representation of how data elements relate to each other within a system.
In software development and database design, a data model defines what information will be stored, how it connects, and what constraints apply: The team spent weeks on data modeling before building the database.
Data models range from abstract conceptual diagrams to detailed physical schemas specifying exact table structures.
Things that exist
- attributesInherent characteristics or properties
- relationshipsLinks between individuals
- cardinalitySize of a set
- abstractionDistilling to essential qualities
ontology · semantics · domain · generalization · specialization · inheritance · aggregation · composition
Organized representational structure
- tablesFlat-topped furniture pieces
- normalizationAdjusting to a standard
- SQLDatabase manipulation language
- indexesAlphabetized reference guides
constraints · datatypes · records · views · joins · one-to-many · many-to-many · denormalization
System of written symbols
- crow's footWrinkle near outer eye
- blueprintDetailed technical drawing
- visualizationForming mental or graphical images
- boxesSix-sided containers
lines · connectors · legend
Study of existence's nature
- OWLSemantic web standard
- knowledge graphLinked entity-relationship database
- inferenceConclusion reached through reasoning
- reasoningDrawing logical conclusions
vocabulary · namespace · URI · semantic web · concept mapping · thesaurus · nodes · edges
Denormalized analytical database structure
- measuresQuantifies or evaluates
- cubeSix-squared-faced solid
- hierarchyRanked authority structure
- grainCereal plant's harvest unit
bridge table · aggregation · drill-down · slice and dice · Kimball · ETL · business intelligence
entities
Things that exist
- attributesInherent characteristics or properties
- relationshipsLinks between individuals
- cardinalitySize of a set
abstraction · ontology · semantics · domain · generalization · specialization · inheritance · aggregation · composition · taxonomy
schema
Organized representational structure
- tablesFlat-topped furniture pieces
- normalizationAdjusting to a standard
- SQLDatabase manipulation language
indexes · constraints · datatypes · records · views · joins · one-to-many · many-to-many · denormalization · tuple
notation
System of written symbols
- crow's footWrinkle near outer eye
- blueprintDetailed technical drawing
- visualizationForming mental or graphical images
boxes · lines · connectors · legend
ontology
Study of existence's nature
- OWLSemantic web standard
- knowledge graphLinked entity-relationship database
- inferenceConclusion reached through reasoning
reasoning · vocabulary · namespace · URI · semantic web · concept mapping · thesaurus · nodes · edges
star schema
Denormalized analytical database structure
grain · bridge table · aggregation · drill-down · slice and dice · Kimball · ETL · business intelligence
model, data, models, modeling, remodel, remodeling, modeled, modelling, modeler