StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Rating Dimensional Data Warehouse by Ralph Kimball - Article Example

Cite this document
Summary
The article “Rating Dimensional Data Warehouse by Ralph Kimball” 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…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER98% of users find it useful
Rating Dimensional Data Warehouse by Ralph Kimball
Read Text Preview

Extract of sample "Rating Dimensional Data Warehouse by Ralph Kimball"

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 the 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 the 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 presentation. Kimball succeeds in giving concise yet clear definitions of each of the 12 criteria he as addressed. Considering that this was the first of a two-part series, it is assumed that the remaining criteria would be covered in the concluding article. Moreover, given that Data Warehouse metrics is a technical subject, the author manages to give the gist of the underlying mathematics and statistics without employing esoteric language or complex formulae.

Toward the end of the article, Kimball notes that the criteria were deliberately set too high standards and that it is unreasonable for an enterprise to meet all expectations. In other words, the 12 (20) criteria serve as an ideal template with which enterprise Data Warehouse systems can be rated for the extent of their dimensions. The article is an overall success, in that it accomplishes its limited and clearly stated objectives with scholarly excellence and professional presentation.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Rating Dimensional Data Warehouse by Ralph Kimball Article, n.d.)
Rating Dimensional Data Warehouse by Ralph Kimball Article. Retrieved from https://studentshare.org/statistics/1579767-rating-your-dimensional-data-warehouse
(Rating Dimensional Data Warehouse by Ralph Kimball Article)
Rating Dimensional Data Warehouse by Ralph Kimball Article. https://studentshare.org/statistics/1579767-rating-your-dimensional-data-warehouse.
“Rating Dimensional Data Warehouse by Ralph Kimball Article”, n.d. https://studentshare.org/statistics/1579767-rating-your-dimensional-data-warehouse.
  • Cited: 0 times

CHECK THESE SAMPLES OF Rating Dimensional Data Warehouse by Ralph Kimball

Data Warehouse and Formal OLAP Tool

The paper "data warehouse" tells us about the data mart provided in Microsoft Access format.... A manager needs to be able to pull down and across the dimensions of a data warehouse to analyze the data from different perspectives and get the best results.... Though this is a logically true relationship, the fact that this is one of the findings from the data in the warehouse makes it an analysis of the data from the data mart.... Though it is not possible to perform comprehensive data mining on the data using Excel tools, the data was converted to a customer versus product pivot table displaying total sales amount and total sales quantity....
7 Pages (1750 words) Essay

Data warehouse presentation evaluation

Generally a data warehouse is a trace of an enterprise's past transactional and operational information that is stored in a specially designed database with appropriate facilities for data analysis and reporting. There is one common idea in the basis of data warehousing design: first data should be integrated from distributed and differently structured databases and then it should be picked out for purposes of reporting, decision support, analysis or control.... Generally a data warehouse is a trace of an enterprise's past transactional and operational information that is stored in a specially designed database with appropriate facilities for data analysis and reporting....
2 Pages (500 words) Essay

Benefits Of Data Warehouse

hellip; The data warehouse has been a principal means of storage of data without the capability of utilizing it.... he main objective will be establishing the benefits accrued by multinational businesses when they carry out data mining in their data warehouse.... he data warehouse is a collection of data which helps management in decision making.... The data warehouse ability of integration with modern analysis tools like OLAP is an advantage to corporate....
5 Pages (1250 words) Research Paper

DW - Components of Data Warehouses

According to Kimball and Ross (2002), data sources refer to electronic repository that generates data that are directed towards the data warehouse either on a regular interval or on a real-time basis for transaction by transaction.... This component cleans, consolidate, standardize, reconcile, augment, and enrich data Components of a data warehouse s Components of a data warehouse Data sources According to Kimball and Ross (2002), data sources refer to electronic repository that generates data that are directed towards the data warehouse either on a regular interval or on a real-time basis for transaction by transaction....
1 Pages (250 words) Assignment

Rationale Databases and Data Warehouse

The paper "Rationale Databases and data warehouse" highlights that the data is moved from the operational data store in the data warehouse database and right here the data are kept in a hierarchical manner and this modification is generally referred to as dimensions, specifics/total specifics.... The functional systems, for example, marketing, Enterprise Resource Planning (ERP), and so on, supply data the warehouse and making use of the Extract, Transform and Load (ETL) approach the data is retrieved from the data warehouse (Rizzi, Abello, Lectenborger and Trujilo, 2006)....
5 Pages (1250 words) Essay

The Use of a Data Warehouse

This is due to the fact that a data warehouse will provide data from different sources, therefore managers and executives will no longer need to make business decisions based on limited… Secondly, since all the data will be stored on a central point, business users and analysts will not waste their precious time retrieving data from multiple sources, they will simply access it from the central location. Thirdly, there will be Data from different sources are converted into a common format in the data warehouse, therefore, each department will produce results that are in line with all the others....
3 Pages (750 words) Assignment

The Critical Success Factor of Data Warehousing Implementation: Key Challenges for a Company Like Offco

hellip; There are 2 well-known approaches of building data warehouse developed separately by Inmon and Kimball.... An empirical study by Ariyachandra and Watson (2008) where 454 companies were asked to respond to the surveys regarding the effectiveness of the particular data warehouse which was used by these companies, surprisingly, found no significant differences in preferences for enterprise data warehouse approach or data mart approach and both were thus found to be evenly efficient and effective....
15 Pages (3750 words) Research Paper

Data Warehouses, OLAP, and Data Mining

One such option is a data warehouse.... One such option is a data warehouse.... The nature of the data warehouse is such that it is a repository of data that lies at the heart of a data management system.... The data warehouse is explored in detail in the following sections.... undamental CharacteristicThe fundamental characteristics of a data warehouse pertain to the inherent nature of the data warehouse which depicts the data warehouse to be subject-oriented, including time variance, while being nonvolatile a providing for the integration of data....
8 Pages (2000 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us