MGM’s College of Engineering, Nanded.
Department of IT
Semester I (2016-17)
Class: BE(IT) Subject: DMDW Assignment I
Department of IT
Semester I (2016-17)
Class: BE(IT) Subject: DMDW Assignment I
1. Give comparison between Data warehouse and DBMs.
2. What are characteristics of data in data ware house? Explain.
2. What are characteristics of data in data ware house? Explain.
3. What is data cube? Explain with example.
4. A Weekly sales of year 2010 of a company is present in an OLAP, and Sales Manager is interested in Yearly sales of 2010, which OLAP operation is useful and why?
5. A Total Score of a Cricket Match is available in OLAP, the Team Manager wants to see the performance of each individual player, which OLAP operation is needed and why?
6. Suppose that a data warehouse consists of the three dimensions Time, Doctor, and Patient, and
the two measures count and Fee, where fee is charged by the Doctor for each OPD visit.
5. A Total Score of a Cricket Match is available in OLAP, the Team Manager wants to see the performance of each individual player, which OLAP operation is needed and why?
6. Suppose that a data warehouse consists of the three dimensions Time, Doctor, and Patient, and
the two measures count and Fee, where fee is charged by the Doctor for each OPD visit.
Draw a star and snowflake schema diagram for the above data warehouse.
7. Write DMQL statements for creating above star schema (Q No. 6).
8. Enlist the features of snowflake and fact constellation schema with appropriate examples.
9. Draw the block diagram of DW architecture. Explain various components of DW architecture.
9. Draw the block diagram of DW architecture. Explain various components of DW architecture.
10. Give SQL statements for star and snowflake scheme of Q No. 6.
11. What are the contents of metadata in DW? Enlist and explain.
12. Draw and explain ROLAP, MOLAP and HOLAP models of DW.
13. A company is using DW to provide monthly summary information about its products and branch sales to the company managers. How many different aggregates would be required to fill data cube on product, branches and dates if there are 20 products, 3 branches and 2 years of weekly data?
14. Draw starnet query model for above DW (Q. No.13) by considering Shipper, Supplier and Manager Dimensions.
15. What is bitmap indexing? What are the benefits of bitmap indexing? Create bitmap index for
Performance and Team for the following table:
Performance and Team for the following table:
TID
|
Performance
|
Team
|
T1
|
Good
|
India
|
T2
|
Average
|
South Africa
|
T3
|
Excellent
|
India
|
T5
|
Average
|
England
|
T6
|
Good
|
England
|
16. Suppose that a data warehouse of Online Education consists of the four dimensions, Date, Learners, Location, and Course, and the two measures, count and charge, where charge is the fees that a learner pays when learning a course on a given date. Learners may be of students, professionals, or seniors, with each category having its own charge rate.
(a) Draw a star schema diagram for the data warehouse.
(b) Starting with the base cuboid [Date, Learners, Location, and Course],
what specific OLAP operations should one perform in order to list
the total charge paid by professional learners at VIT Location in 2010?
(a) Draw a star schema diagram for the data warehouse.
(b) Starting with the base cuboid [Date, Learners, Location, and Course],
what specific OLAP operations should one perform in order to list
the total charge paid by professional learners at VIT Location in 2010?
Faculty Incharge: Hashmi S A
