StudentShare solutions
Triangle menu

Rating Your Dimensional Data Warehouse - Article Example

Not dowloaded yet

Extract of sample
Rating Your Dimensional Data Warehouse

While a sum total score of 0 would indicate a system completely unsupportive of a dimensional approach, a score of 20 would indicate a system that is fully supportive of a dimensional approach.
The author outlays 12 of the 20 criteria in the article. Some of the criteria that pertain to the Architecture of the Data Warehouse are: Explicit Declaration, Conformed Dimensions and Facts, Dimensional Integrity, Open Aggregate Navigation, Dimensional Symmetry, Dimensional Scalability and Sparsity Tolerance, etc. Kimball explains Open Aggregate Navigation as follows:
“The system uses physically stored aggregates as a way to enhance performance of common queries. These aggregates, like indexes, are chosen silently by the database if they are physically present. End users and application developers do not need to know what aggregates are available at any point in time, and applications are not required to explicitly code the name of an aggregate. All query processes accessing the data, even those from different application vendors, realize the full benefit of aggregate navigation.” (Kimball, 2000)
Similarly, some of the criteria that fall under Administration category are: Graceful Modification, Dimensional Replication, Dimension Notification, Surrogate Key Administration, International Consistency, etc. Kimball explains Dimensinal Replication as follows:
“The system supports the explicit replication of a conformed dimension outward from a dimension authority to all the client data marts, in such a way that we can only perform drill-across queries on data marts if they have consistent versions of the dimensions. Aggregates that are affected by changes to the content of a dimension are automatically taken offline in each client data mart until we can make them consistent with the revised dimension and the base fact table.” (Kimball, 2000)
One of the impressive aspects of the article is its compact ...Show more

Summary

The article titled Rating Your Dimensional Data Warehouse is a concise piece of scholarship that outlines the key metrics in evaluating a Data Warehouse. Data Warehouse as a data storage concept and decision making aid has evolved a lot over the past two decades. Yet, no…
Author : wisozkkamille
Rating Your Dimensional Data Warehouse essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the article on your topic
"Rating Your Dimensional Data Warehouse"
with a personal 20% discount.
Grab the best paper

Related Essays

What Color Is Your English
What Color is Your English? Their research is restricted to the African immigrant women living, studying and working in the Canadian State. The study brings to light the effects biased opinion of the English language accent has on the various rights of these women.
4 pages (1000 words) Article
Becoming An Expert in Your Topic Area
Development of these interventions and techniques is based on research and systematic studies conducted to evaluate the effectiveness of some of these initiatives. In order to come up with a conclusive or concrete decision pertaining to the best version of remedy, evaluation must be conducted with regard to the proposed solutions and interventions.
7 pages (1750 words) Article
Systematic Measurement Error with State- Level Crime Data: Evidence From the More Guns Less Crime Debate
2 pages (500 words) Article
Choosing the Right Coach for Your Employees
Either way, the idea is to enhance the job skills of your employees so as to improve the company's bottom line. For this reason, it is vital that your coaching program succeeds. One of the ways of ensuring that you're the success of this program is to hire the right coach for the job.
3 pages (750 words) Article
Write your own critique
the maximum progress and recognizing them as Reward schools; this would encourage the functioning of the schools and thereby enhance their performance. Though I agree that the identification of the Challenge School and then helping them in specific ways is an innovative way to
2 pages (500 words) Article
Nteroperability in EHR implementations Analyze and communicate necessary data from EHR systems
Alert fatigue is caused as a result of frustration arising from warning after warning alerts that pop up before an order is accepted when one is using the EHR system (AHIMA 26). The alerts may have been put in place in an attempt at
2 pages (500 words) Article
Dont Expect Job Data Alone to Persuade Fed on Rates
As the author of the article puts it, Ben Bernanke, the Fed Chairman, has assumed that the high unemployment rate, above 6.5 percent, would continue at least until mid-2015. Besides, the unemployment rate for the month of December 2013 is estimated at 6.7 percent and it is quite likely that the targeted unemployment rate of 6.5 percent will be achieved soon.
2 pages (500 words) Article
Respect your elders
nd through the utilization of case study examples, Stein and Devaney show that small businesses still reap the rewards of higher levels of consumer responsiveness to direct mailing strategies, television and other print advertisements as promotional tools. The article asserts
2 pages (500 words) Article
Review on Data impediments to empirical work on health insurance markets paper
The article compares the levels of dataset in the market share volatility obtained by a superior investment bank and in a state level hospital. The article is aimed at
3 pages (750 words) Article
Please provide a 2-3 page critical evaluation of the LUMS Report on Data is the Next Frontier (Wong, 2012). This evaluation needs to take place from the perspective of a named technology organisation, of your choice. Criteria for evaluation should includ
Wong is the leader of the organizations and Business Models research streams. His other roles include organizational culture, cross-cultural management and relational analytics. David has served as a
4 pages (1000 words) Article
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT