Data Warehouse Design-When large volumes of information are created daily

Question # 00728273 Posted By: mac123 Updated on: 06/22/2019 04:10 PM Due on: 06/22/2019
Subject Computer Science Topic Algorithms Tutorials:
Dot Image

Data Warehouse Design

When large volumes of information are created daily, a company needs a sound infrastructure and systems in place that are capable of storing and analyzing the massive amounts of data. A data warehouse becomes increasingly critical to this kind of business as the scope and customer base expand. 

A star schema is a type of data warehouse design that optimizes multidimensional query performance (Poolet, 2007). The first step in designing an information system is to construct a data model. The data model you use is a star schema.

To complete this Assignment:

  1. Write a 500-word summary that defines, compares, and contrasts the Ross and Kimball approaches to data warehousing. Please include the characteristics of the data warehouses as output of each approach. Provide five references within the paper and cite at least two within your writing. (40 points) 
  2. Design a star schema to organize the sales information to meet the marketing department’s needs. Identify the grain, the dimensions, the attributes of those dimensions, the fact table, and the attributes of the fact table. Provide an ERD or UML of the dimensional model. (60 points) 

Submit your Assignment by Day 7.

Dot Image
Tutorials for this Question
  1. Tutorial # 00728762 Posted By: mac123 Posted on: 06/22/2019 04:10 PM
    Puchased By: 2
    Tutorial Preview
    The solution of week 7 homework...
    Attachments (122 KB)

Great! We have found the solution of this question!

Whatsapp Lisa