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: 53

Attachments:

SPONSORED LINKS

Latest Activities on Virtialians Social Network

Irfan Khan MSCS and Cinderella are now friends
4 hours ago
aisha and Muhammad Mursleen are now friends
12 hours ago
aisha and Shoaib Khan are now friends
yesterday
Wasi Zawar and Izzah Malik are now friends
yesterday
Sid commented on AaBeerα (MBA 2nd sems)admin's blog post ****Jumma Mubarak****
Friday
Sid liked AaBeerα (MBA 2nd sems)admin's blog post ****Jumma Mubarak****
Friday
AaBeerα (MBA 2nd sems)admin posted a blog post
Friday
Irfan Khan MSCS liked kashif Rfaique's discussion Admission
Friday
kashif Rfaique added a discussion to the group M.Sc. in Organizational Psychology
Friday
Farwa Sahar is now a member of Virtualians Social Network
Friday
AaBeerα (MBA 2nd sems)admin replied to AaBeerα (MBA 2nd sems)admin's discussion Issuance of First Voucher to continuing students (Spring, 2019)
Thursday
ٹمبکٹو posted a blog post
Thursday
AaBeerα (MBA 2nd sems)admin liked Zain Ali's discussion Allah behtar Tadbir aor chahat krny wala hai
Thursday
AaBeerα (MBA 2nd sems)admin liked Cinderella's blog post ouqt
Thursday
Zain Ali added a discussion to the group Islam
Thursday
Cinderella posted blog posts
Thursday
BSCS *Admin added a discussion to the group Spring 2019 Semester
Thursday
BSCS *Admin posted a discussion
Thursday
Younas Khan (MBA 02 Year) liked Irfan Khan MSCS's discussion Virtual University of Pakistan (VUP) Semester Spring 2019 Mid-Term Exam From Saturday June 22, 2019
Wednesday
Arooj un nisa liked AaBeerα (MBA 2nd sems)admin's discussion Virtual University opening doors to future jobs
Wednesday

SPONSORED LINKS

© 2019   Created by Irfan Khan MSCS.   Powered by

Badges  |  Report an Issue  |  Terms of Service