Add You
#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

  • produce
  • different
  • career
  • corporate information
  • major approaches
  • globally acceptable

  • Links

  • Website Design Can Help or Hinder Your Business
  • Windows Vista: Wow Or Not Now?
  • Swimming Safely - Tips From the American Red Cross
  • Add You - Components of a Data Warehouse Architecture - Part 2, The Kimball Presentation Area

    Michelle Obama Delivers Address on Community Relations at Best Bosses Conference
    The culmination of the 2006 Best Bosses Conference & Celebration, held September 27, 2006 in Chicago, was a Plenary Address delivered by Michelle Obama. Obama is Vice President for Community and External Affairs at the University of Chicago Hospitals. Her topic was “Creating Relationships Betw
    ther, 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 directl
      Instant Background Checks
      We live in a 'fast-food generation' information-age, technology-driven society and time, where prompt access and consistency of information is gradually becoming more complex and difficult. An instant background check provides important information to help an individual or company make informe
      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 understood by business users, who can access and use it directly
        5 Things You Must Have in Your Career Portfolio
        Are you at the end of your rope and considering exploring other career opportunities? If so, I'd like to share with you what I feel are the five most critical things to have in your Portable Career Portfolio before you jump ship. With things in the corporate sector moving at breakneck speed, c
        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 understood by business users, who can access and use it directl
          Improve Your Home by Refinancing Your Mortgage
          The possibilities involved in refinancing are overwhelming. If you have considered using a refinanced mortgage to do some remodeling you should consider cash-out refinancing. With a cash-out refinance home loan you can refinance your current mortgage for a higher loan amount than your outstand
          ) 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 understood by business users, who can access and use it directl
            US Job Market Bullish in July
            The job market will likely have another strong month in July 2006 with an estimated 58 percent of employers in the manufacturing and service sectors planning on increased hiring, according to the findings of a recent study released last July 27.The leading Indicator of National Employme
            easurements 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 understood by business users, who can access and use it directl
            Three Steps To Customer Loyalty
            As a prime source for repeat business and referrals, your relationships with customers have to be given top priority. After the sale is made is when you can really strengthen the connectivity with your client. This is the time where you can develop unshakable customer loyalty.Loyalty is
            ther, 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.addyou.info/article/21649/addyou-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.addyou.info/article/21649/addyou-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:

    Discover The Best Accounting Software

    Unethical Interview Questions: How Should You Handle Them?

    Good Customer Service - Simple, But Not Easy

    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