Tags |
|
|
Links |
|
|
Casual Articles - Components of a Data Warehouse Architecture - Part 3, The Inmon approach
As a self-proclaimed industry analyst spanning many sub-sectors of our economy I always find it fascinating to study Industry Surveys although I never seem to quite trust the data. Why you ask? Because it always seems that I will read one research paper or survey, which says one thing and another, which says something different.Occasionally, I will find that all the surveys say the same thing and at that point gene
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 ‘E
Before you open the doors of your cleaning business you not only need equipment and supplies, you need a name for your business. The name of your company will be the first thing prospective clients see - whether that is in the phone book, on your company car, in an ad, or on a website. The name symbolizes what your cleaning business represents. So it is important to spend some time on choosing a name that not only fits
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 ‘En
In the midst of the bustle and shuffle of the collaborative whirlwind of documents, drafts, e-mails, and electronic documents that is 21st century business, it is important to evaluate the best collaborative software suites available on the market today. FileNet packages have stepped up to the plate to seek to provide helpful tools for organizing the enterprise content that exists in the modern-day corporation: e-mails an
· 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 ‘E
Journal1. Is the book of prime entry.2. As soon as transaction originates it is recorded in journal3. Transactions are recorded in order of occurrence i.e. strictly in order of dates.4. Narration (brief description) is written for each entry.5. Ledger folio is written6. Relevant information cannot be ascertained readily e.g. cash in hand can't be found out easily.
· 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 ‘E
No, you can’t control how the interview will be conducted, nor can you control the outcome. But you can influence it greatly by the way you present your personality and your skills.Part of acing an interview, is preparation. Do your homework on the company you’re applying to. Read their stock performance if they’re listed. Surf for their web site, and be sure to read the About Us page as well as any news or press r
· 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 ‘E
Business negotiation in China can be very a frustrating exercise for western business executives. The Chinese business culture and deliberate style of negotiation is vastly different from the more direct western approach.It is easy to lose perspective and patience and ultimately fail in reaching the desired agreement.European and American business men and women are accustomed to a straight-forward style of negotiat
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 suggesting a phased implementation of the EDW, de
HTTP = HTML link (for blogs, profiles,phorums):
<a href="http://www.casualarticles.com/article/21646/casualarticles-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.casualarticles.com/article/21646/casualarticles-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:
Background Checks - Quintessential In Today's World Of Employment
Location of Errors through Trial Balance
Bookmark it:
|