Friday, September 21, 2012

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