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
Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations m

What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

What is recovery management component? Ensuring durability is the responsibility of a software component of the base system known as the recovery management component.

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

Express types of information available in MySQL? Information as regards the result of queries:  This includes number of records affected by any SELECT or UPDATE or DELETE st

Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea