|
Add You - Components of a Data Warehouse Architecture - Part 2, The Kimball Presentation Area
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 ChecksWe 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 PortfolioAre 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 MortgageThe 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 JulyThe 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 LoyaltyAs 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
One of the most important decisions that you will have to make while starting or operating your small business is that of which accounting software to use. It could certainly be a nightmare if you make the wrong choice.
Unethical Interview Questions: How Should You Handle Them?
What is an unethical interview question and how should you handle it?
Good Customer Service - Simple, But Not Easy
Perseverance is the key to winning long-term customer support. To ensure customer satisfaction, and to keep them coming back, is simple, but it is not easy. When the right environment is in place, and the right processes are in order, and the environment and processes are predictable and repetitive, customers will return again and again.
|