Data Modeling

Description

A data model is part of the foundation for a sustainable Corporate Information Factory (CIF). Intelligent Solutions, Inc. (ISI) offers consulting and education services to help companies develop any of the required data models for this environment. The models being addressed by these services are:

  • Subject Area Model, which describes the high-level groupings of data, and their relationships,
  • Business Data Model, which describes the information used in an enterprise from a business perspective,
  • Data Warehouse Model, which describes the structure of the data warehouse,
  • Operational Data Store Model, which describes the structure of the operational data store,
    Mart Model, which describes the structure of the various data marts and oper marts, and

  • Database Schema, which describes the physical database structure for each CIF component needed for optimal performance.

For each of the models, ISI can provide three types of services:

  • Development Services, in which ISI’s consultants actively work on the models, while transferring knowledge to the client’s participating team members,
  • Mentoring Services, in which ISI’s role is primarily one of providing advice and support, and
  • Quality Assurance Services, in which ISI reviews the model developed by the client.

Schedule

Subject Area Model – The subject area model is typically time-boxed into a three-day period that consists of two half-day facilitated sessions, separated by a day for work between the sessions.

Business Data Model, Data Warehouse Model, Operational Data Store Model – Development of the business, data warehouse, and operational data store data model should be time-boxed into two to four week periods for each iteration whenever possible.

Data Mart and Oper Mart Model Development – The matrix that relates the business questions to the required marts is developed in a 2 – 5 day period. Each model required for this environment requires about a day to develop.

Database Schema Development and Tuning – Transformation of the model into the physical database schema typically requires 3 – 5 days. Tuning activities transpire during the first few months of use.

Deliverables

The modeling effort has two major deliverables:

  • The major tangible deliverable is the data model. Included in this deliverable are the appropriate diagrams, definitions, and a list of outstanding issues. (In the case of a quality assurance service, the major tangible deliverable is a quality assurance review report that identifies potential data model problems and recommends solutions.
  • The second deliverable is intangible, and is attained through the interaction of the ISI consultant and the company’s personnel. In addition to soliciting information, the consultant provides informal education and training in relevant concepts and knowledge transfer to client personnel.