Database Answers Map of Windsor Park, outside London, England
You are not logged in: login | why register ?
Home Ask a Question Best Practice Communities Contact us Data Models Search Site Map
 
  Stage 3 - Data Marts in the Best Practice Road Map
 

  Stages in the Best Practice Road Map for Enterprise Data Management
Overview
A good starting-point is the Wikipedia Entry on Data Marts 

Question : What are Data Mart Templates ?
Data Marts have a common design of Dimension fields and Facts.

Templates are important because they represent a tremendous Kick-Start approach to the design of Data Marts for a specific business area.
They are produced by exploiting the common design of Dimensions and Facts.

A range of Data Mart diagrams is available in the Case Studies on the Database Answers Web Site.
You can Email us for more information.

Question : How do I improve the performance of my Data Mart ?
Every DBMS produces what is called an Execution Plan for every SELECT statement.

The steps to improving the performance involve checking this Execution Plan against the Indexes that exist, and 
making sure that the Query Optimizer has used the appropriate Indexes to obtain the best performance.

This is a specialized area where DBA’s spend a lot of their time when they are looking after production databases 
where speed is a mission-critical factor.

Data Marts are always created to support Business Intelligence, which includes Performance Reports, Balanced Scorecards, 
Dashboards, Key Performance Indicators and so on.

Best practice always requires user involvement and a generic design to support a flexible approach to meeting changing requirements.
Users will always want changes to their first specifications of their requirements.

The insight that they obtain from the first Reports helps them identify more precisely what their long-term requirements will be.

Therefore flexibility is important.

A well-designed Data Mart will anticipate the areas where flexibility is required.
The design process should always follow two steps :-
•	Production of generic design for the Data Mart
•	Implementation of the design with a specific Data Mart software product.


  • Click to go back.
     
  •  


    © Database Answers Ltd. 2009

    Home Ask a Question Best Practice Communities Contact us Data Models Search Site Map
    Click for details of Data Governance Click for details of BI + Performance Rpts Click for details of Data Marts Click for details of Data Integration Click for details of Data Sources