There are several ways of measuring a data model’s quality, and all require a standard for comparison. One method that will be used to provide an example of data model …
Data Modeling – Deliverables
The Deliverables of the Data Modeling Process include: Diagram: A data model contains one or more diagrams. The diagram is the visual that captures the requirements in a precise form. …
Normalization
Normalization is a Systematic Approach, which is used to design a Relational Database table up to higher normal form. The basic goal of normalization is to keep each attribute in …
Data Modeling – De-Normalization and Canonical Model
De-Normalization is the deliberate transformation of normalized logical data model entities into physical tables with redundant or duplicate data structures. In other words, de-normalization intentionally puts one attribute in multiple …
Content Management – Terms Management
As per DAMA, Lists of terms are just that: lists. They do not describe relationships between the terms. Pick lists, web pull-down lists, and lists of menu choices in information …
Data Modeling – Identifiers / Keys
Key or Identifier, is a set of one or more attributes that uniquely defines an instance of an entity. Keys by Construction-Type Surrogate Key is a unique identifier for a …
Content Modeling – Controlled Vocabularies and Format
Controlled Vocabularies The primary purpose of Vocabulary Control is to achieve consistency in the description of content objects and to facilitate retrieval. A Controlled Vocabulary is a pre-defined, established and …
Data Modeling – Arity of Relationships
Arity of RelationshipsThe number of entities in a relationship is the Arity of the relationship. The most common Arities are unary, binary, and ternary relationships. Unary (Recursive) Relationship: A unary …
Data Masking – Data Subsetting
Data Masking is the process to replace, truncate, scramble, or encrypt sensitive data with fictitious yet realistic looking. Data Masking limits sensitive data proliferation by anonymizing sensitive production data. Data …