MGM’s College of
Engineering, Nanded.Department of IT
Semester I (2015-16)
Class: BE(IT) Subject: DMDW Assignment I
1.
Define data warehouse. Explain the characteristics of DW.
2. Compare DBMs with DW.
3. Draw and explain star schema with an example.
4. Enlist the features of snowflake and fact constellation schema with appropriate
example.
5. What are the major components of data warehouse architecture? Explain with
block diagram.
6. Describe the OLAP operations with an appropriate example.
7. Draw and explain ROLAP, MOLAP and HOLAP models of DW.
8. Suppose that a data warehouse consists of the three dimensions Time,
Trainer, and Trainee, and the two measures count and Fee, where fee is
charged by the trainer for training.
Draw a star and snowflake schema diagram for the above data warehouse.
9. Why metadata is important for DW?
10. What back-end tools and utilities are used in DW? Why?
11. Enlist and explain the applications of DW.
12. A company is using DW to provide quarterly 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 50 products, 5 branches and 7 years of monthly data?
13. Draw starnet query model for above DW (Q. No.12) by considering additional
3 more dimensions.
14. What is bitmap indexing? What are the benefits of bitmap indexing? Create
bitmap index for rank and class for the following table:
2. Compare DBMs with DW.
3. Draw and explain star schema with an example.
4. Enlist the features of snowflake and fact constellation schema with appropriate
example.
5. What are the major components of data warehouse architecture? Explain with
block diagram.
6. Describe the OLAP operations with an appropriate example.
7. Draw and explain ROLAP, MOLAP and HOLAP models of DW.
8. Suppose that a data warehouse consists of the three dimensions Time,
Trainer, and Trainee, and the two measures count and Fee, where fee is
charged by the trainer for training.
Draw a star and snowflake schema diagram for the above data warehouse.
9. Why metadata is important for DW?
10. What back-end tools and utilities are used in DW? Why?
11. Enlist and explain the applications of DW.
12. A company is using DW to provide quarterly 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 50 products, 5 branches and 7 years of monthly data?
13. Draw starnet query model for above DW (Q. No.12) by considering additional
3 more dimensions.
14. What is bitmap indexing? What are the benefits of bitmap indexing? Create
bitmap index for rank and class for the following table:
|
TID
|
Rank
|
Class
|
|
T1
|
First
|
BE
|
|
T2
|
Second
|
ME
|
|
T3
|
Distinction
|
BE
|
|
T5
|
First
|
HSC
|
|
T6
|
Second
|
HSC
|
15. Suppose that a data warehouse for Big University consists of
the following
four dimensions: student, course, semester, and instructor, and two
measures count and avg grade. What issues are important in building this
DW?
four dimensions: student, course, semester, and instructor, and two
measures count and avg grade. What issues are important in building this
DW?
16. Suppose that a data warehouse consists of the four dimensions, date,
teams, location, and game, and the two measures, count and charge,
where charge is the fare that a team pays when playing a game on a
given date. Teams may be of students, adults, or seniors, with each
category having its own charge rate.
teams, location, and game, and the two measures, count and charge,
where charge is the fare that a team pays when playing a game on a
given date. Teams may be of students, adults, 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, teams, location, game],
what specific OLAP operations should one perform in order to list
the total charge paid by student teams at GM_Place in 2004?
(b) Starting with the base cuboid [date, teams, location, game],
what specific OLAP operations should one perform in order to list
the total charge paid by student teams at GM_Place in 2004?
Faculty
Incharge: Hashmi S A
