Answer Upon
#1 in Business Subscribe Email Print

You are here: Home > Business > Management > Components of a Data Warehouse Architecture - Part 4, Kimball vs Inmon

Tags

  • linked
  • approachk
  • operators manual
  • operational systemsi
  • schemasi development

  • Links

  • The Proliferation of Terrorism
  • Two Enter Internet Battle
  • Credit Cards - Finding The Right One May Be A Challenge
  • Answer Upon - Components of a Data Warehouse Architecture - Part 4, Kimball vs Inmon

    The Misconceptions of the Value Of Disclosures in Franchising
    Disclosure laws in franchising are suppose to help the consumer. They don’t. The FTC, which over sees franchising has in fact created a rule, which makes 5 lb. Disclosure documents for franchise buyers, which is so huge that no one ever reads it. I know when I personally meet a franchise buyer whose application form is approved and hand them a UFOC, Uniform Franchise Offering Circular with attachments
    dependent datamart).

    K: Data marts are linked to each other, based on conformed dimensions.

    I: Data marts are not linked to each other.

    K: A data mart maintains all available historical data.

    I: A data mart maintains limited history, since history is kept in the Enterprise Datawarehouse.

    Phased development approach K: phased development of datamarts on selected business processes, which are linked on conformed dimensions, forming the It's Like A Jigsaw Puzzle
    A business, no matter whether a one person company or a multi-national conglomerate, is a complex assemblage of people, tasks, products, services, inventory, and equipment with many components or departments that together create a combined whole. The departments do not stand alone. Each is dependant upon the others for their form and their relationship to the whole. As an example, think of the Accou

    In parts 2 & 3 of this article series, we described the data warehouse architecture according to the Kimball and the Inmon approach. In the present article we shall describe the main differences between the two approaches and their common points. The two approaches have the following common points:
    • The proposed use of a staging area, when the volume of data and the extraction-transformation-loading (ETL) complexity is high
    • The implementation of automated ETL processes
    • The use of multidimensional structures and analysis at the data mart level, based on the dimensional model and on-line analytical processing (OLAP) tools
    • The use of an iterative development approach, which is however based on different design and development methodologies.
    The main differences are identified at the following points (K for Kimball, I for Inmon): Data warehouse development philosophyK: Based on the prioritized selection of specific business processes. I: Based on the Enterprise ‘data model’ as it is defined by this approach.

    K: Direct development of data marts on the selected business processes. Exclusive use of denormalized dimensional models (star schemas).

    I: Development of the Enterprise Datawarehouse (EDW) based on a normalized database schema. The development of data marts, is based on data retrieved from the EDW.

    Data mart definition K: A data mart maintains data of the lowest level of detail (atomic data), which relate to a business process. Data marts are developed based on the popular dimensional modelling methodology.

    I: A data mart maintains aggregate data which relate to a Business Unit. They are built to monitor predefined KPIs (key performance indicators).

    K: A data mart is built by extracting data directly from operational systems.

    I: A data mart is built by extracting data from the Enterprise Datawarehouse (also called dependent datamart).

    K: Data marts are linked to each other, based on conformed dimensions.

    I: Data marts are not linked to each other.

    K: A data mart maintains all available historical data.

    I: A data mart maintains limited history, since history is kept in the Enterprise Datawarehouse.

    Phased development approach K: phased development of datamarts on selected business processes, which are linked on conformed dimensions, forming the A SMART Way to Turn Your Business Wishes into Reality
    Have you ever wondered why New Years resolutions typically don’t work? It’s worth exploring, because it’s the same reason why most business leaders miss their performance objectives more often than they’d like.We commonly accept New Years resolutions as being personal in nature -- we want to exercise more, get organized, quit smoking, etc. But, whether we realize it or not, as business leaderses

  • The use of multidimensional structures and analysis at the data mart level, based on the dimensional model and on-line analytical processing (OLAP) tools
  • The use of an iterative development approach, which is however based on different design and development methodologies.
  • The main differences are identified at the following points (K for Kimball, I for Inmon): Data warehouse development philosophyK: Based on the prioritized selection of specific business processes. I: Based on the Enterprise ‘data model’ as it is defined by this approach.

    K: Direct development of data marts on the selected business processes. Exclusive use of denormalized dimensional models (star schemas).

    I: Development of the Enterprise Datawarehouse (EDW) based on a normalized database schema. The development of data marts, is based on data retrieved from the EDW.

    Data mart definition K: A data mart maintains data of the lowest level of detail (atomic data), which relate to a business process. Data marts are developed based on the popular dimensional modelling methodology.

    I: A data mart maintains aggregate data which relate to a Business Unit. They are built to monitor predefined KPIs (key performance indicators).

    K: A data mart is built by extracting data directly from operational systems.

    I: A data mart is built by extracting data from the Enterprise Datawarehouse (also called dependent datamart).

    K: Data marts are linked to each other, based on conformed dimensions.

    I: Data marts are not linked to each other.

    K: A data mart maintains all available historical data.

    I: A data mart maintains limited history, since history is kept in the Enterprise Datawarehouse.

    Phased development approach K: phased development of datamarts on selected business processes, which are linked on conformed dimensions, forming the Franchise Business - What is an Operators Manual?
    Every Franchise Opportunity comes with an Operators manual. This is the cornerstone of every franchise business. A well written and properly set out manual can easily make the difference between having a successful franchisee or a failure. Many franchisors do not dedicate as much time and effort in their operators manual as they should.I believe that a franchise business operator’s manual has toecific business processes. I: Based on the Enterprise ‘data model’ as it is defined by this approach.

    K: Direct development of data marts on the selected business processes. Exclusive use of denormalized dimensional models (star schemas).

    I: Development of the Enterprise Datawarehouse (EDW) based on a normalized database schema. The development of data marts, is based on data retrieved from the EDW.

    Data mart definition K: A data mart maintains data of the lowest level of detail (atomic data), which relate to a business process. Data marts are developed based on the popular dimensional modelling methodology.

    I: A data mart maintains aggregate data which relate to a Business Unit. They are built to monitor predefined KPIs (key performance indicators).

    K: A data mart is built by extracting data directly from operational systems.

    I: A data mart is built by extracting data from the Enterprise Datawarehouse (also called dependent datamart).

    K: Data marts are linked to each other, based on conformed dimensions.

    I: Data marts are not linked to each other.

    K: A data mart maintains all available historical data.

    I: A data mart maintains limited history, since history is kept in the Enterprise Datawarehouse.

    Phased development approach K: phased development of datamarts on selected business processes, which are linked on conformed dimensions, forming the Car Wash Industry Needs a New Water Strategy for the Future
    The Car Wash Industry has been under considerable stress lately with their public relations; this time it is over the hiring of illegal aliens and illegal immigrants. Early on the car wash industry tried to attempt to justify the hiring of illegal aliens stating; There Is Just No Way for Us to Know If Someone Is a US Citizen or Not.Of course we all know this was a cop-out and they know that theyf the lowest level of detail (atomic data), which relate to a business process. Data marts are developed based on the popular dimensional modelling methodology.

    I: A data mart maintains aggregate data which relate to a Business Unit. They are built to monitor predefined KPIs (key performance indicators).

    K: A data mart is built by extracting data directly from operational systems.

    I: A data mart is built by extracting data from the Enterprise Datawarehouse (also called dependent datamart).

    K: Data marts are linked to each other, based on conformed dimensions.

    I: Data marts are not linked to each other.

    K: A data mart maintains all available historical data.

    I: A data mart maintains limited history, since history is kept in the Enterprise Datawarehouse.

    Phased development approach K: phased development of datamarts on selected business processes, which are linked on conformed dimensions, forming the Lessons in Leadership: The Business of Busy-ness
    Did you know that the word "business" actually comes from the word "busy"?Business is something we do to keep ourselves BUSY -- to fill our days with something that pays our bills at the very least -- perhaps amuses us -- and ideally, give our lives meaning.Business offers us several ways of keeping busy. In fact, three types of activities fill everyone's days -- those which are income G dependent datamart).

    K: Data marts are linked to each other, based on conformed dimensions.

    I: Data marts are not linked to each other.

    K: A data mart maintains all available historical data.

    I: A data mart maintains limited history, since history is kept in the Enterprise Datawarehouse.

    Phased development approach K: phased development of datamarts on selected business processes, which are linked on conformed dimensions, forming the datawarehouse Bus architecture. I: design of the whole Enterprise Datawarehouse based on the Enterprise ‘data model’. Phased implementation of subject areas, according to priorities set.

    International experience records difficulties in the successful implementation of the Inmon approach. On the other hand, enterprises which have developed independent, incompatible and uncoupled data marts without central coordination, are facing the challenge to consolidate them, in order to yield combined data analysis value. Consolidation requires redesign of a major part of the existing infrastructures. The Kimball approach, which receives increasing attention, does not propose implementation of uncoupled data marts.

    Copyright 2006 – Kostis Panayotakis

    HTTP = HTML link (for blogs, profiles,phorums):
    <a href="http://www.hubyou.info/article/21639/hubyou-Components-of-a-Data-Warehouse-Architecture--Part-4-Kimball-vs-Inmon.html">Components of a Data Warehouse Architecture - Part 4, Kimball vs Inmon</a>

    BB link (for phorums):
    [url=http://www.hubyou.info/article/21639/hubyou-Components-of-a-Data-Warehouse-Architecture--Part-4-Kimball-vs-Inmon.html]Components of a Data Warehouse Architecture - Part 4, Kimball vs Inmon[/url]

    Related Articles:

    Picasso Did Not Work By The Hour!

    Eight Signs That You Should Change Jobs

    How To Generate Unique Business Ideas That Make Money?

    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