Running Type: DATA WAREHOUSING1Ross and Kimball ApproachesNameInstitutionCourse CodePart OneThe Ross approach employs a top-down method that is made valid by developing thecentral element of the data warehouse's analytical environment. Next, the summary anddelivery from the primary data warehouse to a single or numerous data marts are dependent.On the other hand, the Kimball approach employs a different method of data warehousing.An organization should start by developing distinct data marts and then developing the datawarehouse, which will offer one global view inside the organization. This methodology aimsto develop the data warehouse after combining and merging all the distinct data marts.The methodologies proposed by both Kimball and Ross have their differences inarchitecture and design. However, Drewek (2005) states that the two approaches are similarin that the requirements for timely and accurate data cannot be fulfilled just by independentor separate data warehouses or data marts. Moreover, as Kimball and Ross (2013) stated, forusers to easily access the data warehouse on a corporate or enterprise-scale, numerousconditions have to be satisfied in both approaches.The differences in the two designs are also quite evident. In Ross' top-downmethodology, the data warehouse is a data storage in a normalized enterprise level. However,in Kimball's approach, it is well acknowledged that the data marts that have conformeddimensions consolidate to form ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here











Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.