Atricle Dump
#1 in Business Subscribe Email Print

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

Tags

  • efficient
  • first
  • warehouse
  • different business
  • takes places
  • periodic snapshot

  • Links

  • Secured Loans - Wise or Willy?
  • Samsung D900 - Slim, Slender and Powerful
  • Email Marketing 101 - 5 Time-Tested Tips For Writing Powerful Emails!
  • Atricle Dump - Prevalent Data Warehouse Development Approaches

    Part 1 - The Evolution of Business
    Here today, I am going to share about how Business has evolved.In summary, what you will read today will be on how trade began from the time people start to exchange, to buying and selling. Brick-and-Mortar Business will be the next phase which business will go though and finally, Internet Business.As you all know, business began a long time ago. It all bega
    ing 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 t
      Conversation
      It has been said that one of the greatest fears people hold is speaking in front of a group of people, yet we seem to have no shortage of public speakers. There is a kind of speaking that inspires greater fear. This is the fear of having a real conversation.Conversation is when two or more people talk openly and honestly, listen deeply to each other, and reach a com
      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 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
        Residential Construction Estimating Software For Contractors
        Operating construction jobs is a great deal of work, not just in terms of using a level or nail gun. Managing those construction duties is just as time consuming and sometimes aggravating. Small and medium sized contractors have a need for the most help, which will definitely benefit the use of construction estimating software. While there are many software packages used f
        imensional 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 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 t
          Grants Are Ideal For Capital Raising!
          Raising capital can be a harrowing affair for most of us, but particularly so for small struggling businesses, disadvantaged groups and those belonging to the rural sector. Often many of these people have done the rounds of the banks and traditional lending institutions only to be turned away because they have not been able to meet their very strict lending criteria. Unfor
          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 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 t
            Could Your Company Survive a Disaster?
            In the wake of most catastrophes, the media often concentrates on tragic personal stories: lost life, lost homes, lost belongings, lost pets. But what about lost businesses? Medical facilities, law offices, corporate and government organizations—none are immune to the costly effects of flood, fires or hurricanes. Patient histories, client, vendor and employee files, fina
            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 t
              NFL Players, Coaches And Celebrities Enjoy A Day Of Sport Fishing Off Of South Florida
              The population count for Miami has about doubled for Super Bowl weekend. The historic Art Deco streets of South Beach have been shut down only allowing for the flood of pedestrians walking the sidewalks to overflow onto the streets.Some of the NFL Superstars and other Celebrities in town for this weekend chose to escape the organized chaos and relax by heading offsh
              ing 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.articledump.net/article/2639/articledump-Prevalent-Data-Warehouse-Development-Approaches.html">Prevalent Data Warehouse Development Approaches</a>

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

    Related Articles:

    Requirement of a Credit Card Processing Service in Business

    Discover the Real Cancer of Our Western Culture

    Use Your Hobbies to Gain Business

    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