LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034

M.Sc. DEGREE EXAMINATION – COMPUTER SCIENCE

THIRD SEMESTER – NOVEMBER 2010

    CS 3812  – DATA WAREHOUSING

 

 

 

Date : 29-10-10                 Dept. No.                                        Max. : 100 Marks

Time : 9:00 – 12:00

Part A

Answer ALL questions                                                                                                10 x 2 = 20

 

1. List any two differences between the operational system and data warehouse.
2. Define the term facts in information package diagram.
3. What are the three major areas in the data warehouse?
4. Why Meta data is said to be a nerve centre of the data warehouse?
5. Define the term star index.
6. What is aggregate fact table?
7. Highlight any four services to be made available in the managed query environment.
8. What is data mining?
9. Define data clustering.
10. Why back up the data warehouse?

 

PART B

Answer ALL questions                                                                                             5 x 8 = 40

 

11. (a) Explain in detail the data staging component.

(OR)

(b) How do business requirements affect the choice of DBMS? Describe any three of the ways in which the selection of DBMS is affected.

 

12. (a) What are the four common methods for data movement within the data warehouse? Explain any two of these methods.

(OR)

(b) Briefly explain business Meta data.

 

 

 

13. (a) What are the three types of slowly changing dimensions? Compare and contrast Type 2 and Type 3.

(OR)

(b) Discuss any two forms of families of stars.

 

14. (a) How is the user classes named in a data warehouse? Explain any two in detail.

(OR)

(b) In detail, write about any three data mining techniques.

 

15. (a) Write short notes on Bit map index and B tree index.

(OR)

(b) List five common provisions to be found in a good security policy.

 

 

PART C

Answer any TWO questions                                                                                    2 x 20 = 40

 

16. (a) List the significant trends in data warehouse. Explain any four in detail.

(b)Discuss the technical architecture with neat diagram?

 

17. (a) A dimension table is wide; the fact table is deep. Explain with example.

(b) List the data capture techniques with its advantages and disadvantages.

 

18. (a) Write an essay about OLAP models.

(b)  List the types of pilot projects and explain any four in detail,

 

Go To Main page

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034

M.Sc. DEGREE EXAMINATION – COMPUTER SC.

THIRD SEMESTER – APRIL 2012

CS 3812 – DATA WAREHOUSING

 

 

Date : 21-04-2012             Dept. No.                                        Max. : 100 Marks

Time : 1:00 – 4:00

Part A

Answer ALL questions:                                                                                                             10 x 2 = 20

                                                                                                                                                                  

1. Compare Operational system with Informational system under two valuable tasks.

 

1. State any three factors that indicate the continued growth in data warehousing.

 

3. List out the three benefits of quality data in data warehouse.

 

4. Why Meta data is said to be nerve center?

 

5. What is mean by data granularity in data warehouse?

 

6. Illustrate the difference between destructive merge and constructive merge.

 

7. Give 2 reasons why naming standards are important in data warehouse

Environment.

 

8. Define data clustering.

 

9. Write notes on decision trees.

 

10. Give reasons why data warehouse must be backup.

 

Part B

Answer ALL questions:                                                                                                               5 x 8 = 40

                                                                                                    

11 a)  Why do data warehouses continue to grow in size, storing huge amounts of

data? Give any three reasons.

(OR)

1. b) Name 4 key issues to be considered while planning for a data warehouse.

 

 

12 a)   Why do you think Meta data is important in data warehouse environment?

.                   List four Meta data types in each area of data acquisition, data storage and

information delivery.

(OR)

b)List four major requirements that metadata must satisfy. Describe each of these

four requirements.

 

 

13  a)   Briefly explain multi dimensional analysis.

(OR)

1. b) Discuss star schema keys in detail.

 

 

14 a)    Identify the classes of users who will use information, in detail.

(OR)

1. b) What are hyper cubes? How do they apply in an OLAP system?

 

 

15 a)    Write notes on

( i ) Genetic algorithm

( ii ) Neural  networks.

(iii ) Drill-down and Roll-ups.

(OR)

1. b) List five common provisions to be found in a good security policy.

 

 

Part C

 

Answer any TWO questions:                                                                                                   2 x 20 = 40

 

16 a)  Discuss about  the components of data ware house in its three major areas.

1. b) Explain the 4 parallel server  List the benefits, features and limitations

of each.

 

17 a)  What are hyper cubes? How do they apply in OLAP system?

1. b) State any two underlying methods for information delivery to satisfy the

requirements of all types of users.

 

18  a)   Describe the physical design step activities.

1. b) Determine the major activities during data warehouse deployment.

 

 

Go To Main page

LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034

M.Sc. DEGREE EXAMINATION – COMPUTER SC.

THIRD SEMESTER – NOVEMBER 2012

CS 3812 – DATA WAREHOUSING

 

 

Date : 01/11/2012            Dept. No.                                        Max. : 100 Marks

Time : 9:00 – 12:00

 

 

Part A

Answer all the questions:                                                                                              10 x 2 = 20 Marks

 

1. Identify the relationship between Data Warehouse and Data Mart.
2. Specify the sources of Metadata.
3. What are the changes expected in dimensional tables?
4. List the characteristics of high quality data.
5. Differentiate Dimensional modules from ER modules.
6. What is surrogate key?
7. Name any four key capabilities of OLAP.
8. List any four criteria for evaluating data mining tools.
9. Notify the advantage of Clustered Index.
10. What is security policy?

 

Part B

Answer all the questions:                                                                                                5 x 8 = 40 Marks

 

1. a) Compare Data Warehouse with ERP and Knowledge Management.

(Or )

1. b) Elaborate the phases of Joint Application Development (JAD).

 

1. a) Write about the consideration in building technical metadata.

(Or )

1. b) Discuss & justify the influencing factors in selection of a DBMS.

 

1. a) Compare the characteristics of dimensional table & fact table.

(Or)

1. b) Stress the need for aggregates and describe the ways to construct aggregate fact

tables.

 

1. a) Review OLAP architectural options.

(Or)

1. b) Briefly describe the cluster detection technique.

 

1. a) Compare the significance of performance enhancement techniques.

(Or)

1. b) Discuss the principles of Indexing and explain Bit Mapped Index.

 

 

 

Part C

Answer any two questions:                                                                                           2 x 20 = 40 Marks

 

1. a) List and explain the components of Data Warehouse. (10 Marks)

 

1. b) Compare server hardware available for the Data Warehouse. (10 Marks)

 

1. a) Depict the design of star schema and explain star schema keys. (10 Marks)

 

1. b) With neat diagram, describe information delivery framework. (10 Marks)

 

1. a) Describe the types of pilot projects and discuss their merits. (10 Marks)

 

1. b) Explain how a genetic algorithm helps in increasing profit of the organization.

(10 Marks)

 

 

Go To Main page