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.