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 …
Content Modeling and Delivery Methods
Content Modeling is the process of converting logical content concepts into content types, attributes, and data types with relationships. It documents all the different types of contents associated with a …
Organization / Enterprise Ontology and Taxonomy
With the growing amount of information created every day, effective Data Management is a key business requirement for Data-Driven Organization as a part of a well implemented strategy. Both Ontology …
Data Modeling – Conceptual, Logical and Physical Model – CDM, LDM and PDM
Data Modeling is the process of creating an illustrative and visual representation of either a whole information/database system or parts of it to show the relationships among data types, the …