Data modelling
https://knobit.org/id/competence/data-modelling
Also as Turtle · JSON-LD · RDF/XML
| consists of | Capture data requirements |
|---|---|
| consists of | Review the data model against the scorecard |
| consists of | Reverse-engineer a model from an existing database |
| consists of | Maintain and version data models |
| consists of | Build the conceptual model and taxonomies |
| consists of | Derive the logical data model |
| consists of | Design the physical data model |
| consists of | Generate and review DDL |
| consists of | Plan the modelling and set its standards |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/competence/data-modelling |
| rdfs:comment | Data modelling and design end to end (DAMA-DMBOK2 ch. 5) — plan the modelling and its standards, capture data requirements, derive conceptual, logical and physical data models, generate DDL for PostgreSQL, MySQL, Oracle, SQL Server, Snowflake, Databricks or ANSI, review the models with a data model scorecard, reverse-engineer an existing database, and maintain and version models through change, with validation and anomaly checklists gating every stage. Use it whenever the user mentions data requirements, a conceptual/logical/physical data model, entities and attributes, ERDs, normalisation or 3NF, star schemas, dimensional or Kimball modelling, Data Vault, data taxonomies, modelling standards, a model review or scorecard, reverse engineering a schema, model versioning, database schema design, or DDL/CREATE TABLE statements — or hands over a requirements document, a spreadsheet of attributes or an existing schema to turn into a proper data model. en |
| rdfs:label | Andmete modelleerimine et |
| rdfs:label | Data modelling en |
| related topic | Data modelling and design (DAMA-DMBOK2 chapter 5) |
Used by
| related learning outcome | data-modelling skill (SKILL.md) |
|---|---|
| related learning outcome | Stage checklists |
| related learning outcome | Conventions — naming and modelling styles |
| related learning outcome | Model file schemas |
| related learning outcome | Tests of the data-modelling skill |
| requires competence | Data modeller |