CS614 - Data Warehousing Assignment No. 2 Solution Fall 2018 Due Date: January 22, 2018 

Assignment No. 2

(Graded)

Semester Fall 2018
Data Warehousing– CS614

Total Marks: 20

 

Due Date:

22-01-2019

 

Objective:

This assignment has been designed to develop your ability to learn and apply different Indexing Techniques.

Instructions:

Please read the following instructions carefully before solving & submitting the  assignment:

 

1.       The assignment will not beaccepted after due date.

2.       Zero marks will be awarded to the assignment that does not open or the file is corrupt.

3.       The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.

4.       Zero marks will be awardedto the assignment if copied (from other student or copied from handouts or internet).

 

 

For any query about the assignment, contact only at CS614@vu.edu.pk

 

Please do not post queries related to assignment on MDB.

 

 

Note: The assignment covers lectures 26-27.

 

 

 

Consider the following table (Data File):

BookID

BookTitle

ISBN

Author

Publisher

1

Modern Operating Systems

978-0133591620

 Tanenbaum,A

Prentice Hall

2

Building the Data Warehouse

0-471-14161-5

W. H. Inmon

John Wiley & Sons Inc., NY.

3

Data Warehousing Fundamentals

0-471-41254-6

PaulrajPonniah

John Wiley & Sons Inc., NY.

4


Operating System Concepts

 

978-0470128725


Silberschatz,A, Galvin,P, Greg,g

 

John Wiley & Sons

5

Database Management Systems

978-0072465631

Raghu Ramakrishnan, Johannes Gehrke

McGraw-Hill

6

Modern Database Management


978-0805360547

 


Fred McFadden, Jeffrey Hoffer, Mary B. Prescott

 

Pearson Education

7

Database Management

978-0805360400

Fred R. McFadden, Jeffrey A. Hoffer

Benjamin Cummings Publishing Company

 

8


C++ How To Program:Dietel and Dietel

 

0131857576

Harvey & Paul

Prentice Hall

9

Object-Oriented Software Engineering

0201544350


Jacobson,Christerson,Jonsson

 

Addison Wesley

10


The C++ Programming Language

 

0201889544

Bjarne Stroustrup


Addison - Wesley

 

 

Question 1:

Part (a):Create Dense Index oncolumnBookID. Data file should be divided according to block size=2KB where 1KB is storing one record/data row. Index file block size should also be 2KB where 1KB is storing 1 index entry.In last step,create pointers from Index file to Data file.

Part (b):Create Sparse Index on column BookID. Data file should be divided according to block size=2KB where 1KB is storing one record/data row. Index file block size should also be 2KB where 1KB is storing 1 index entry.In last step,create pointers from Index file to Data file.

 

 

Question 2:

Create Cluster Index on columnBookTitle.

 

Note: Your solution should clearly show all steps of index creation.


 

 

Note: Deadline for assignment submission is22nd January 2019.

 

Wish you best of Luck!

 

Tags: -, 2, 2018, 22, Assignment, CS614, Data, Date:, Due, Fall, More…January, No., Solution, Warehousing

Views: 34

Attachments:

SPONSORED LINKS

Top Discussions 

SPONSORED LINKS

© 2019   Created by Irfan Khan MSCS.   Powered by

Badges  |  Report an Issue  |  Terms of Service