Part 2: Data Model

Advanced Data Modeling and Architecture --  Table of Content


Part 1: Data Modeling Overview



2.1 : Definition of a Data Model

•Model

         Representation of a set of business requirements in a standard structured framework understood by the users

•Data Model
 A collection of concepts that can be used to describe the structure of a database

         Most data models include a set of basic operations for query and updates on the database

         It is becoming more common to include concepts in the data model to specify the dynamic aspect or behavior defined operations

Data Model Instances

   Conceptual Model

   Logical Model

   Physical Model

2.2 : Data Model Types

Database Model

  A database model is a theory or specification describing how a  database is structured and used. Several such models have been suggested. Common models include

–  Flat model

–  Hierarchical model

–  Network model

–  Relational model:

–  Object-relational model

–  Dimensional Model

2.3 Data Modeling Stages & Deliverables

2.4: Main Phases of Database Design

2.5: Data Modeling In DWH Environment

2.6: Data Modeling Approaches

2.7: Data Modeling Life Cycle

2.8: Data Models & Zachman Framework