Casual Articles
#1 in Business Subscribe Email Print

You are here: Home > Business > Management > Components of a Data Warehouse Architecture - Part 2, The Kimball Presentation Area

Tags

  • point
  • corporate information
  • structure which
  • kimball parlor

  • Links

  • Drop Shipping Is Your Perfect Home Based Business Solution
  • The New World Of Mobile Telephony
  • College Grants And The Approval Process
  • Casual Articles - Components of a Data Warehouse Architecture - Part 2, The Kimball Presentation Area

    Beat the Bully
    Bullying has come into the spotlight this week, with a record number of complaints made about Celebrity Big Brother (UK). Whilst Jade Goody is bearing the brunt of the criticism, she was not alone in her appalling behaviour and was joined by 2 other housemates, who thought it was fair game to
    lled a data mart. Star schemas are linked to each other, based on conformed dimension tables (according to the Kimball parlor, this is called a bus architecture). The major advantage of the dimensional data structure is derived from the symmetry and simplicity of the star schema, which:
    • is easily
      Value Stream Mapping And Six Sigma
      Business processes are similar to a river flowing in a natural direction and carrying information from point A to point B. Value Stream Mapping (VSM) is one of the techniques used in Lean Six Sigma for identifying areas of waste that need to be avoided in both manufacturing as well as office
      In part 1 of this article series, we described the staging area and the ETL process of a data warehouse architecture. In the present and following article we shall describe the presentation area of the data warehouse. The term presentation is used to denote the fact that this is the area, where data are presented to its Customers (the business analysts). There is no globally acceptable standard on the development of the data warehouse presentation area. Two major approaches have prevailed:· the dimensional datawarehouse approach (proposed by R. Kimball)· the corporate information factory (CIF) approach (proposed by B. Inmon) Kimball approach According to the Kimball approach, the presentation area is made of a number of dimensional data structures, called star schemas. A star schema is a relational data structure which involves the following:
      • a fact table which stores all the measurements used to produce performance analytics and is linked to
      • a set of tables which capture the dimensional information, related to the above mentioned measurements.
      A set of linked star schemas which focus on a single business process, are called a data mart. Star schemas are linked to each other, based on conformed dimension tables (according to the Kimball parlor, this is called a bus architecture). The major advantage of the dimensional data structure is derived from the symmetry and simplicity of the star schema, which:
      • is easily
        Emerging Role of the Business Analyst
        Software application development has only been around since the late 1970s. Compared to other industries and professions the software industry is still very young. Ever since organizations began to use computers to support their business tasks, the people who create and maintain those “systems
        presented to its Customers (the business analysts). There is no globally acceptable standard on the development of the data warehouse presentation area. Two major approaches have prevailed:· the dimensional datawarehouse approach (proposed by R. Kimball)· the corporate information factory (CIF) approach (proposed by B. Inmon) Kimball approach According to the Kimball approach, the presentation area is made of a number of dimensional data structures, called star schemas. A star schema is a relational data structure which involves the following:
        • a fact table which stores all the measurements used to produce performance analytics and is linked to
        • a set of tables which capture the dimensional information, related to the above mentioned measurements.
        A set of linked star schemas which focus on a single business process, are called a data mart. Star schemas are linked to each other, based on conformed dimension tables (according to the Kimball parlor, this is called a bus architecture). The major advantage of the dimensional data structure is derived from the symmetry and simplicity of the star schema, which:
        • is easily
          Get Out of Your Comfort Zone in the Job Search
          Most everyone these days knows what a comfort zone is. My definition is the place, environment and tasks that we have learned to do and feel comfortable with--a comfort zone.Lots of people feel devastated when they have lost a job as their comfort zone no longer exists. In other words,
          e information factory (CIF) approach (proposed by B. Inmon) Kimball approach According to the Kimball approach, the presentation area is made of a number of dimensional data structures, called star schemas. A star schema is a relational data structure which involves the following:
          • a fact table which stores all the measurements used to produce performance analytics and is linked to
          • a set of tables which capture the dimensional information, related to the above mentioned measurements.
          A set of linked star schemas which focus on a single business process, are called a data mart. Star schemas are linked to each other, based on conformed dimension tables (according to the Kimball parlor, this is called a bus architecture). The major advantage of the dimensional data structure is derived from the symmetry and simplicity of the star schema, which:
          • is easily
            Are You Suited for Self-employment?
            A recent poll conducted by Yahoo! Small Business showed that nearly 3 out of 4 Americans have considered starting their own business. In fact, of more than 2,200 adults surveyed, over half (51 percent) said they would like to launch their small business within the next 5 years.Clea
            li>a fact table which stores all the measurements used to produce performance analytics and is linked to
          • a set of tables which capture the dimensional information, related to the above mentioned measurements.
          A set of linked star schemas which focus on a single business process, are called a data mart. Star schemas are linked to each other, based on conformed dimension tables (according to the Kimball parlor, this is called a bus architecture). The major advantage of the dimensional data structure is derived from the symmetry and simplicity of the star schema, which:
          • is easily
            5 Big Questions to Ask Yourself: Do I Need Career Change?
            Enthused with your daily routine of work? Since “what we do” is wrapped up so compactly with “who we are” it is a natural starting point to look at our vocations for hints on what we need to address in our lives. When you answer these 5 simple questions for yourself, you can determine if you
            lled a data mart. Star schemas are linked to each other, based on conformed dimension tables (according to the Kimball parlor, this is called a bus architecture). The major advantage of the dimensional data structure is derived from the symmetry and simplicity of the star schema, which:
            • is easily understood by business users, who can access and use it directly without database manipulation skills
            • performs better in the execution of complex queries, than complex normalized data structures (used commonly in operational systems)
            The Kimball approach is criticized on the following points:
            • how feasible it is to connect data marts which capture information at a different level of detail. Linking of data marts is very important, since it allows the combined analysis of data from different marts (a practice known as drill across).
            • normalized database structures reflect better complex entity type relationships, compared to the denormalised dimensional model. The Kimball approach proposes the exclusive use of denormalised structures.
            Copyright 2006 – Kostis Panayotakis

    HTTP = HTML link (for blogs, profiles,phorums):
    <a href="http://www.casualarticles.com/article/21649/casualarticles-Components-of-a-Data-Warehouse-Architecture--Part-2-The-Kimball-Presentation-Area.html">Components of a Data Warehouse Architecture - Part 2, The Kimball Presentation Area</a>

    BB link (for phorums):
    [url=http://www.casualarticles.com/article/21649/casualarticles-Components-of-a-Data-Warehouse-Architecture--Part-2-The-Kimball-Presentation-Area.html]Components of a Data Warehouse Architecture - Part 2, The Kimball Presentation Area[/url]

    Related Articles:

    Establishing A Budget For Advertising

    The Electrician's Guide to Effective Yellow Page Advertising

    LED Moving Message Displays

    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