Database Answers  
You are not logged in: login | why register ?
Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us
Data Governance
BI+Performance Rpts
Data Marts
Data Integration
Data Sources
Info Catalogue


Architecture
 
    If you have a Question that is not addressed here, please feel free to email us your Question.
    
    Question 1: How do we measure progress with Data Marts ?
    
    • Check the level of Users understanding.
    • Check for existence of Templates.
    Question 2: 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 3: 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.
 

© Database Answers Ltd. 2010

Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us