Business Intelligence/Data Mart Data Model

  • Purpose:
  • Input: List of KPI's, Dimensions and Budgets
  • Activities: Create an ERD for the frame's data mart
  • Outputs: ERD and Relational data model
  • Documentation: ERD and Relational data model diagrams

Data Model Defined

A data model is a collection of concepts used to describe the structure of a database. This means the data types, relationships and constraints that should hold for the data. Data models are categories as (Elmasri and Navathe 2005):

  • Conceptual: provide concepts that are related to the way users understand the data
  • Physical: provide concepts that describe how the data is stored in the computer
  • Representational/Implementation: Concepts understood by end users but that are not too far removed from the way data is organized within the computer

This chapter focuses on creating a conceptual data model. Conceptual data models use concepts such as entities, attributes and relationships. Chen proposed the entity-relationship data model in 1976.

Entity: Real-world object or concept Relationship: Property of interest that further describes an entity Attribute: An associated among two or more entities

Representation data models include the widely used relationship data model.