Tags |
|
|
Links |
|
|
Add You - Components of a Data Warehouse Architecture - Part 3, The Inmon approach
Residential Relocation: Is residential relocation on your mind? If yes, you need to plan for it well in advance as there are too many things to be taken care of. Choosing a professional residential moving company is the first and most important step in your relocation plan. Inexperienced household movers would not only add to your troubles but you also would have to pay a heavy price for it.Get the profe
Rejection. All of us have experienced it at some point in our lives. It never feels good. Call it what you want, but accept the fact that ultimately you lost. You were not selected. I particularly like the synonym “spurned.” That really makes you feel great, doesn't it? Got any rocks laying around that you can craw under?So you have been rejected. Now what? How can you turn this into something positive?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 sy
I know that diversity has been a big topic of conversation ever since the early 1990s when research supported the demographics that by the year 2000, 85% of the entering workforce would be female, African-American, Asian-American, Latino, or new immigrants. The fact that white males would be a minority entering the workplace was a wake up call for corporate America.How have we done sine then? I suggest that there h
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 sy
Accounts Receivable factoring is a process that enables a small business to sell off its invoices and other Account Receivables to a financing company. The financing company purchases these invoices at a discounted rate, gives the cash to the business and, when the due date of the invoice arrives, it collects the cash from the customer at the face value of the invoice. The company can collect the cash itself or outsource
Jim Cathcart developed and characterized “Relationship Selling” as a system to describe and teach the paramount importance of the interpersonal relationship in business and the conduct of business around the world. Mr. Cathcart has transformed the business world by instilling the values of simple human kindness and contact back into the conduct of the business day. Too bad Mr. Cathcart doesn’t teach disaster preparedness.
Compassion is one of five principles of the Skilled Facilitator approach. (It's also one of the four core values of the approach.) I have already written about the other four principles: curiosity, commitment, accountability, and transparency.Compassion means temporarily suspending judgment so that you can appreciate others' perspectives or situations when they are different from your own. To be compassionate you n
· 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
HTTP = HTML link (for blogs, profiles,phorums):
<a href="http://www.addyou.info/article/21646/addyou-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.addyou.info/article/21646/addyou-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:
Hot New Career for Nurses Taking the US by Storm
There is No Yellow Brick Road Dorothy!
Business Ethics - High Ethical Standards In Business 100% Of The Time - 5 Principals Of Success
Bookmark it:
|