Other Added
#1 in Business Subscribe Email Print

You are here: Home > Business > Management > Components of a Data Warehouse Architecture - Part 3, The Inmon approach

Tags

  • covers
  • extracted
  • assure
  • approach given
  • moreover implementation
  • further enforced

  • Links

  • Just a Bit about Ballistic Stretches and How to Use it Without Injuring Yourself
  • Easy to Use Tips to Save Money On Your Homeowners Insurance
  • Bathroom Vanities Information and Reviews
  • Other Added - Components of a Data Warehouse Architecture - Part 3, The Inmon approach

    RFID Benefits
    Radio frequency identification (RFID) technology can be applied at several levels, and it ensures improved communication and efficiency. It can be used to identify, follow, and spot known objects or people and can be utilized in catalog management, asset tracking, security and loss prevention, preservation, rental equipment, and operations.RFID technology does not necessitate reading line-of-sight access. An RFID t
    difficult to design such a model which can reflect successfully the reality for a long term period. The argument is further enforced by the fact that the business environment is rapidly changing in many markets.
  • one-off development of the information model does not follow the general principle for phased-iterative development supported by post implementation review of each phase.
  • it is a high risk approach, since it requires high investment in money and time for the design of the data model and the development of the Enterprise Data warehouse-EDW) which covers all the needs of the Enterprise. This argument is countered by
    Saying Thank You With Corporate Gifts
    Everyone loves to be appreciated, and when that thanks is expressed with a gift, you’ll make extra points with the gift recipient. Corporate gifts are often thought of as expensive, one-of-a-kind executive style gifts that your company sends out at holidays, but there’s another level of corporate gift-giving that can mark you and your firm as a thoughtful, appreciative company with whom to do business.The wonderful
    In parts 1 & 2 of this article series, we described the staging area of a data warehouse architecture and the presentation area according to the Kimball approach. In the present article we shall describe the presentation area of the data warehouse, according to the Inmon approach.

    The Inmon approach (marketed as Corporate Information Factory) involves the holistic view of the Enterprise and its informational needs. First implementation step, according to this approach, is the design of the Enterprise data model, supporting all its activities with completeness and sufficient detail ((‘atomic data model’). This is not any existing database model, but an abstract model of the information, actually used by the Enterprise. The data model of the so called ‘Enterprise Data warehouse’ is designed based on this abstract model. Data are extracted from all operational systems and other sources and the unique ‘Enterprise Data warehouse’ is updated through an ETL process (as described in Part 1). Moreover, implementation of an integrated operational database, covering all the Enterprise, is proposed if operational systems are not integrated. This is known as an Operational Data Store (ODS), and has a dual role:

    · Serving operational processes

    · Support operational reporting & decision making. If an ODS is developed, it becomes the primary source of the Enterprise Datawarehouse. In that way, the implementation of ETL (extraction-transformation-loading) streams from multiple data sources is avoided.

    According to the Inmon approach, data marts should be ‘fed’ exclusively from the ‘Enterprise Data warehouse’, in order to assure the single version of truth. This approach is known in the literature as ‘dependent data mart’ approach, given that the data marts depend on the ‘Enterprise Data warehouse’. According to Inmon, the development of independent data marts (which are fed directly from operational systems) creates information silos which are uncoupled, do not assure the single version of truth and do not allow the combined information analysis. Moreover, Inmon asserts that the existence of many independent data marts increases the staging area complexity (this assertion assumes that datamarts are unconnected).

    The Inmon approach has received criticism focused on the following:

    • The design method of the abstract Enterprise ‘data model’ is not clarified, given that in most cases information use is not standardised nor documented. The concept of the Enterprise ‘data model’ is abstract and unclear, therefore it is difficult to design such a model which can reflect successfully the reality for a long term period. The argument is further enforced by the fact that the business environment is rapidly changing in many markets.
    • one-off development of the information model does not follow the general principle for phased-iterative development supported by post implementation review of each phase.
    • it is a high risk approach, since it requires high investment in money and time for the design of the data model and the development of the Enterprise Data warehouse-EDW) which covers all the needs of the Enterprise. This argument is countered by s
      Buy A Business With A Broker And You Could End Up Dead Broke, Wondering What The Heck Happened
      I will be honest with you: I don't like business brokers. In fact, I've only known a small handful during my entire 50 years of buying businesses I would deal with. That I trust. That didn't try to purposely screw me over. Now again, that doesn't mean they're all crooked. Just the ones I've dealt with. And so, if you can find a decent broker to work with, that’s fine. You're lucky. But don't count on
      ase model, but an abstract model of the information, actually used by the Enterprise. The data model of the so called ‘Enterprise Data warehouse’ is designed based on this abstract model. Data are extracted from all operational systems and other sources and the unique ‘Enterprise Data warehouse’ is updated through an ETL process (as described in Part 1). Moreover, implementation of an integrated operational database, covering all the Enterprise, is proposed if operational systems are not integrated. This is known as an Operational Data Store (ODS), and has a dual role:

      · Serving operational processes

      · Support operational reporting & decision making. If an ODS is developed, it becomes the primary source of the Enterprise Datawarehouse. In that way, the implementation of ETL (extraction-transformation-loading) streams from multiple data sources is avoided.

      According to the Inmon approach, data marts should be ‘fed’ exclusively from the ‘Enterprise Data warehouse’, in order to assure the single version of truth. This approach is known in the literature as ‘dependent data mart’ approach, given that the data marts depend on the ‘Enterprise Data warehouse’. According to Inmon, the development of independent data marts (which are fed directly from operational systems) creates information silos which are uncoupled, do not assure the single version of truth and do not allow the combined information analysis. Moreover, Inmon asserts that the existence of many independent data marts increases the staging area complexity (this assertion assumes that datamarts are unconnected).

      The Inmon approach has received criticism focused on the following:

      • The design method of the abstract Enterprise ‘data model’ is not clarified, given that in most cases information use is not standardised nor documented. The concept of the Enterprise ‘data model’ is abstract and unclear, therefore it is difficult to design such a model which can reflect successfully the reality for a long term period. The argument is further enforced by the fact that the business environment is rapidly changing in many markets.
      • one-off development of the information model does not follow the general principle for phased-iterative development supported by post implementation review of each phase.
      • it is a high risk approach, since it requires high investment in money and time for the design of the data model and the development of the Enterprise Data warehouse-EDW) which covers all the needs of the Enterprise. This argument is countered by
        How To Get Your Complementary Therapy Business Off To A Flying Start
        Well done! You've passed the exams, received the certificate, taken out your insurance and you're ready to open the doors in your new complementary therapy business. You are your own boss, possibly for the first time - and here's where the learning starts all over again.There are two common traps that newly qualified practitioners fall into - the first is neglecting the rest of your life. Family, your own health, f
        ational reporting & decision making. If an ODS is developed, it becomes the primary source of the Enterprise Datawarehouse. In that way, the implementation of ETL (extraction-transformation-loading) streams from multiple data sources is avoided.

        According to the Inmon approach, data marts should be ‘fed’ exclusively from the ‘Enterprise Data warehouse’, in order to assure the single version of truth. This approach is known in the literature as ‘dependent data mart’ approach, given that the data marts depend on the ‘Enterprise Data warehouse’. According to Inmon, the development of independent data marts (which are fed directly from operational systems) creates information silos which are uncoupled, do not assure the single version of truth and do not allow the combined information analysis. Moreover, Inmon asserts that the existence of many independent data marts increases the staging area complexity (this assertion assumes that datamarts are unconnected).

        The Inmon approach has received criticism focused on the following:

        • The design method of the abstract Enterprise ‘data model’ is not clarified, given that in most cases information use is not standardised nor documented. The concept of the Enterprise ‘data model’ is abstract and unclear, therefore it is difficult to design such a model which can reflect successfully the reality for a long term period. The argument is further enforced by the fact that the business environment is rapidly changing in many markets.
        • one-off development of the information model does not follow the general principle for phased-iterative development supported by post implementation review of each phase.
        • it is a high risk approach, since it requires high investment in money and time for the design of the data model and the development of the Enterprise Data warehouse-EDW) which covers all the needs of the Enterprise. This argument is countered by
          The Fundamentals of Direct Response Radio Advertising
          Direct response radio advertising, at its core, works in the same way regardless of what type of business you are in. Whether you own a direct-to-consumer model business, a retail business, a web business, or some combination thereof, direct response radio advertising can help you grow. And grow profitably. The fundamentals of direct response radio, then, must start with a discussion of how radio advertising works within
          operational systems) creates information silos which are uncoupled, do not assure the single version of truth and do not allow the combined information analysis. Moreover, Inmon asserts that the existence of many independent data marts increases the staging area complexity (this assertion assumes that datamarts are unconnected).

          The Inmon approach has received criticism focused on the following:

          • The design method of the abstract Enterprise ‘data model’ is not clarified, given that in most cases information use is not standardised nor documented. The concept of the Enterprise ‘data model’ is abstract and unclear, therefore it is difficult to design such a model which can reflect successfully the reality for a long term period. The argument is further enforced by the fact that the business environment is rapidly changing in many markets.
          • one-off development of the information model does not follow the general principle for phased-iterative development supported by post implementation review of each phase.
          • it is a high risk approach, since it requires high investment in money and time for the design of the data model and the development of the Enterprise Data warehouse-EDW) which covers all the needs of the Enterprise. This argument is countered by
            Consider Working from Mexico
            With modern technology, Mexico can be an attractive base of operations for many people who operate their business over the Internet. With a little planning Mexico can offer a safe but exciting place to work from.There are several advantages to working from Mexico. The cost of living is lower particularly in the cost of housing. Homes that would cost millions of dollars in the U.S. often rent for less than $900 per
            difficult to design such a model which can reflect successfully the reality for a long term period. The argument is further enforced by the fact that the business environment is rapidly changing in many markets.
          • one-off development of the information model does not follow the general principle for phased-iterative development supported by post implementation review of each phase.
          • it is a high risk approach, since it requires high investment in money and time for the design of the data model and the development of the Enterprise Data warehouse-EDW) which covers all the needs of the Enterprise. This argument is countered by suggesting a phased implementation of the EDW, dealing in each phase with one or few enterprise subject areas.
          Copyright 2006 – Kostis Panayotakis

  • HTTP = HTML link (for blogs, profiles,phorums):
    <a href="http://www.otheradded.com/article/21646/otheradded-Components-of-a-Data-Warehouse-Architecture--Part-3-The-Inmon-approach.html">Components of a Data Warehouse Architecture - Part 3, The Inmon approach</a>

    BB link (for phorums):
    [url=http://www.otheradded.com/article/21646/otheradded-Components-of-a-Data-Warehouse-Architecture--Part-3-The-Inmon-approach.html]Components of a Data Warehouse Architecture - Part 3, The Inmon approach[/url]

    Related Articles:

    Loans For Nevada LLCs

    Build Company Value By Buidling a Brand

    Corporate Flight Attendant Career: Getting Hired

    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