Will You Add?
#1 in Business Subscribe Email Print

You are here: Home > Business > Business > Prevalent Data Warehouse Development Approaches

Tags

  • types
  • processes
  • relational
  • models simple
  • movado watches
  • complex normalized

  • Links

  • Do You Need An SEO Company For Your Traffic Campaign?
  • Are You An Organized Manager?
  • Why Use Beeswax Candles? Beeswax Candles vs Paraffin
  • Will You Add? - Prevalent Data Warehouse Development Approaches

    India To The Rescue With Accounting Solutions
    Source: Business-Standard.comWhen Control Solutions, one of USA’s biggest accounting firms dealing with Sarbanes-Oxley (SOX) accounting compliance procedures, wanted to recruit accountants for its expanding practice, it looked at Enabilizer, a New Delhi-based accounting outsourcing firm. That look has led to the two signing a joint venture agreement that allows Con
    2 Ralph Kimball and Margy Ross
    1. Corporate Information Factory – CIF (introduced by Bill Inmon)
    According to this approach, the first step involves the design of a comprehensive abstract data model for the Enterprise (a model mapping the way the Enterprise exploits information). Based on this abstract model, the central DWH da
    The Fundamentals of Motivation
    Have you ever wondered why the people in your team don’t seem as motivated as you do? Or why some people do their jobs with enthusiasm and vigor, and others barely get through the day without taking the frown off their faces?You are not alone. The topic of human motivation has been studied for hundreds of years. So it’s a topic we know a lot about. Unfortunately it’
    There are two prevalent approaches to the development of Datawarehouse Architectures:

    1. Data Warehouse (DWH) bus architecture (introduced by Ralph Kimball)
    According to this approach the DWH is developed in phases. Each phase includes the development of a set of dimensional models which are linked together via conformed dimensions, thus forming a virtual ‘bus architecture’. Therefore, according to this approach, at the core of the DWH resides a denormalised dimensional data model, which handles data at the atomic level.The major advantages of this approach are inherited from the use of the dimensional model combined with the ‘conformed dimensions’ principle. This model’s simple and symmetric structure is easily understood by Business Analysts (easier than complex normalized data models). Moreover the so called ‘star schema’ allows the efficient execution of queries (less relational joins). The ‘conformed dimensions’ principle allows for the gradual development of a Data Warehouse, in which all information is linked efficiently and analytics spanning different business processes or subject areas are feasible. Each ‘star schema’ involves a fact table linked to a number of dimensions in a star.Three fundamental types of fact tables: transaction, periodic snapshot, and accumulating snapshot have been defined. In order to define a DWH development roadmap, Kimball introduced the concept of the DWH bus matrix. The ‘bible’ on this approach is: ‘ The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling’, John Wiley & Sons, 2002 Ralph Kimball and Margy Ross
    1. Corporate Information Factory – CIF (introduced by Bill Inmon)
    According to this approach, the first step involves the design of a comprehensive abstract data model for the Enterprise (a model mapping the way the Enterprise exploits information). Based on this abstract model, the central DWH da
    Business Plan Basics - Part 1
    Online or offline, when you want to start a business you need a business plan. Writing a business plan helps when pursuing investment capital, but it also helps you set some clear goals. A business plan is a living document, so you can first create it as an outline and develop it later, as your business grows.Executive Summary:This is the most important sec
    med dimensions, thus forming a virtual ‘bus architecture’. Therefore, according to this approach, at the core of the DWH resides a denormalised dimensional data model, which handles data at the atomic level.The major advantages of this approach are inherited from the use of the dimensional model combined with the ‘conformed dimensions’ principle. This model’s simple and symmetric structure is easily understood by Business Analysts (easier than complex normalized data models). Moreover the so called ‘star schema’ allows the efficient execution of queries (less relational joins). The ‘conformed dimensions’ principle allows for the gradual development of a Data Warehouse, in which all information is linked efficiently and analytics spanning different business processes or subject areas are feasible. Each ‘star schema’ involves a fact table linked to a number of dimensions in a star.Three fundamental types of fact tables: transaction, periodic snapshot, and accumulating snapshot have been defined. In order to define a DWH development roadmap, Kimball introduced the concept of the DWH bus matrix. The ‘bible’ on this approach is: ‘ The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling’, John Wiley & Sons, 2002 Ralph Kimball and Margy Ross
    1. Corporate Information Factory – CIF (introduced by Bill Inmon)
    According to this approach, the first step involves the design of a comprehensive abstract data model for the Enterprise (a model mapping the way the Enterprise exploits information). Based on this abstract model, the central DWH da
    Binding Machine Buying Tips
    Whenever you are asked to prepare an annual report or a technical paper, you want it to look as professional as it can be. The same thing is true with client presentations. And aside from making your document look professional, you would also want to protect it with covers so that I can be used for a longer time. There are many applications that can enhance the appearance
    Business Analysts (easier than complex normalized data models). Moreover the so called ‘star schema’ allows the efficient execution of queries (less relational joins). The ‘conformed dimensions’ principle allows for the gradual development of a Data Warehouse, in which all information is linked efficiently and analytics spanning different business processes or subject areas are feasible. Each ‘star schema’ involves a fact table linked to a number of dimensions in a star.Three fundamental types of fact tables: transaction, periodic snapshot, and accumulating snapshot have been defined. In order to define a DWH development roadmap, Kimball introduced the concept of the DWH bus matrix. The ‘bible’ on this approach is: ‘ The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling’, John Wiley & Sons, 2002 Ralph Kimball and Margy Ross
    1. Corporate Information Factory – CIF (introduced by Bill Inmon)
    According to this approach, the first step involves the design of a comprehensive abstract data model for the Enterprise (a model mapping the way the Enterprise exploits information). Based on this abstract model, the central DWH da
    Are Movado Watches Worth The Price?
    There is no question whether or not movado watches have won over society with its brilliant artistic features and display for time. However, the movado price is perhaps a little too much for a watch. By raising their prices to what they are, it ultimately narrows its target market down significantly. So the question is, are movado watches worth the price?The answ
    ves a fact table linked to a number of dimensions in a star.Three fundamental types of fact tables: transaction, periodic snapshot, and accumulating snapshot have been defined. In order to define a DWH development roadmap, Kimball introduced the concept of the DWH bus matrix. The ‘bible’ on this approach is: ‘ The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling’, John Wiley & Sons, 2002 Ralph Kimball and Margy Ross
    1. Corporate Information Factory – CIF (introduced by Bill Inmon)
    According to this approach, the first step involves the design of a comprehensive abstract data model for the Enterprise (a model mapping the way the Enterprise exploits information). Based on this abstract model, the central DWH da
    Medical Billing - XA0 Record Fields 18 Through 23
    Trailer records are a subtle animal. They don't seem to do much, but in the world of medical billing and the electronic transmission of claims, trailer records can mean the difference between a whole claim file going through or being rejected like a bad virus. In this installment of our series on medical billing and electronic claims submission, we'll be continuing our r
    2 Ralph Kimball and Margy Ross
    1. Corporate Information Factory – CIF (introduced by Bill Inmon)
    According to this approach, the first step involves the design of a comprehensive abstract data model for the Enterprise (a model mapping the way the Enterprise exploits information). Based on this abstract model, the central DWH data model is developed following a normalized design approach (3NF), which handles data at the atomic level.According to the Inmon approach, dimensional models embedding aggregated facts are built by querying this central atomic DWH data model and serve departmental needs (this is one of the major disagreements between the two thought leaders – read Kimball’s open letter to the data warehousing community).Both development approaches agree to the following points:
    • Phased-iterative implementation is the way to proceed, by prioritizing on business processes or subject areas.
    • The use of a separate staging area in which extraction-transformation-cleansing of source data takes places in order to be loaded to the DWH (known as ETL operations).
    • The power of information resides in the atomic data, which embed all available information dimensionality.
    Copyright 2006 – Kostis Panayotakis

    HTTP = HTML link (for blogs, profiles,phorums):
    <a href="http://www.atriclecheck.com/article/2639/atriclecheck-Prevalent-Data-Warehouse-Development-Approaches.html">Prevalent Data Warehouse Development Approaches</a>

    BB link (for phorums):
    [url=http://www.atriclecheck.com/article/2639/atriclecheck-Prevalent-Data-Warehouse-Development-Approaches.html]Prevalent Data Warehouse Development Approaches[/url]

    Related Articles:

    Security Cameras in Nursing Homes - Useful or Wasteful?

    Attract Renters With Technological Appeal

    Watch Out for MLM Business Opportunities

    Bookmark it: del.icio.us digg.com reddit.com netvouz.com google.com yahoo.com technorati.com furl.net bloglines.com socialdust.com ma.gnolia.com newsvine.com slashdot.org simpy.com shadows.com blinklist.com