Assignment, Database Management System

Birla Institute of Technology & Science, Pilani
Work-Integrated Learning Programmes Division
Second Semester 2012-2013

EC-1 Assignment 2 (7.5% of the grade)

Course No. : SS ZG515
Course Title : DATA WAREHOUSING
Due Date : 31st March, 2013
************************************************************************

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictorial form so that it is easy to understand.
a. Finance cube (3 hours to build)
b. Warranty cube (4 hours to build)
c. Order cube (2 hours to build)
d. Customer master data (30 min run time)
e. Vendor master data (60 min run time)
f. Product master data (60 min run time)
g. Other Master data (2 hour run time)
Finance and Order cubes cannot run together.


2) Above cubes are used by NA and EU users, NA users will only use NA data and EU users will use only EU data but Master data is common for both NA and EU. The requirement of availability stays same for NA (6AM CST) and for EU reports/cubes should be available by 6am CET.

What changes you need to make to the job scheduling proposal of Question 1 to meet the requirement of Question 2?

CST – NA Central Standard Time.
CET - EU Central European Time.
Posted Date: 4/2/2013 6:43:55 AM | Location : Anonymous Proxy







Related Discussions:- Assignment, Assignment Help, Ask Question on Assignment, Get Answer, Expert's Help, Assignment Discussions

Write discussion on Assignment
Your posts are moderated
Related Questions
Question: (a) What do you meant by content management and briefly describe four major components of a Content Management System? (b) Explain key benefits of a Content Manage

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip


Explain the difference between the three storage types - volatile, non volatile and stable.             Ans: Volatile storage: if storage media loses data while power goes off,

am looking for assignment helper for dbms

When is a transaction rolled back? Any changes that the aborted transaction made to the database must be uncompleted. While the changes caused by an aborted transaction have be

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for

State as Location within a Program In this traditional approach, location of control inside a program totally defines the program state. Any finite state machine may be implem

(a) Differentiate between information and data . (b) List and briefly explain five potential benefits of the database approach compared to conventional file systems. (c) Diff