KEMBAR78
Unit 2-Assignment-2-1 | PDF
Scribd
Upload
61 views1 page

Unit 2-Assignment-2-1

This document contains an assignment on data warehousing and online analytical processing (OLAP). It includes four questions: 1) Draw a snowflake schema diagram for a university data warehouse and describe OLAP operations to list average course grades for each student. 2) Explain additive and semi-additive measures with examples. 3) Define a "factless fact table". 4) Given dimensions and cells for a cube, calculate the total cube size, order for computing chunks with least space, and main memory required for 2-D planes.

Uploaded by

Snowflake
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views1 page

Unit 2-Assignment-2-1

This document contains an assignment on data warehousing and online analytical processing (OLAP). It includes four questions: 1) Draw a snowflake schema diagram for a university data warehouse and describe OLAP operations to list average course grades for each student. 2) Explain additive and semi-additive measures with examples. 3) Define a "factless fact table". 4) Given dimensions and cells for a cube, calculate the total cube size, order for computing chunks with least space, and main memory required for 2-D planes.

Uploaded by

Snowflake
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

DELHI TECHNICAL CAMPUS GREATER NOIDA

Paper Code: ETCS 413

SUBJECT: DATA MINING AND BUSINESS INTELLIGENCE

SEMESTER: 7th

Assignment-2 (Need to submit in Handwritten)


Q-1 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. When at the lowest
conceptual level (e.g., for a given student, course, semester, and instructor combination), the avg grade
measure stores the actual course grade of the student. At higher conceptual levels, avg grade stores the
average grade for the given combination.
(a) Draw a snowflake schema diagram for the data warehouse.
(b) Starting with the base cuboid [student, course, semester, instructor], what specific OLAP operations
(e.g., roll-up from semester to year) should one perform in order to list the average grade of CS courses
for each Big-University student.
(c) If each dimension has four levels (including all), such as “student < major < status < university <
all, how many cuboids will this cube contain (including the base and apex cuboids)?

Q-2 What are additive, semi-additive measures? Explain with examples.


Q-3 What is Fact Less Fact Table?
Q-4 Suppose that a base cuboid has three dimensions, A, B, C, with the following number of cells: |A|
= 1, 000, 000, |B| = 100, and |C| = 1000. Suppose that each dimension is evenly partitioned into 10
portions for chunking.
(a) Assuming each dimension has only one level, draw the complete lattice of the cube.
(b) If each cube cell stores one measure with 3 bytes, what is the total size of the computed cube if the
cube is dense?
(c) State the order for computing the chunks in the cube that requires the least amount of space, and
compute the total amount of main memory space required for computing the 2-D planes.

You might also like