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.