Other Bachelor Degree- DATA WAREHOUSING(Karunya University, Coimbatore-2012)
Saturday, 24 August 2013 10:25anudouglas
Karunya University
(Karunya Institute of Technology and Sciences)
(Declared as Deemed to be University under Sec.3 of the UGC Act, 1956)
Supplementary Examination – June 2012
Subject Title: DATA WAREHOUSING Time: 3 hours
Subject Code: 09IT227 Maximum Marks: 100
Answer ALL questions
PART – A (10 x 1 = 10 MARKS)1. What are the problems with the naturally evolving architecture?
2. Who is the user of data warehouse?
3. Give the hierarchy of storage of data when managing multimedia.
4. Define multidimensional DBMS.
5. What do you mean by EIS?
6. Write the basic types of external data.
7. Define unstructured data.
8. What is CMSM approach?
9. Write about snowflake structure.
10. Draw the diagram for the life cycle of data.
PART – B (5 x 3 = 15 MARKS)
11. Draw the structure of data warehouse?
12. What are the reasons and considerations for changing DBMS technology?
13. How do you store an external data?
14. Write a short note on moving data from the web to the data warehouse.
15. How do you trace the flow of data through the data warehouse?
PART – C (5 x 15 = 75 MARKS)
16. How do you take partitioning as a design approach in warehouse? Explain it.
(OR)
17. Explain in detail about data warehouse data model and physical data model.
18. Illustrate the levels of granularity with all kinds of environment.
(OR)
19. Explain the types of distributed data warehouse.
20. Explain how you set the data warehouse as a basis for Executive Information system.
(OR)
21. Explain in detail about the migration plan to the architectural environment.
22. How do you integrate structured and unstructured data? Explain with diagram.
(OR)
23. Explain disk storage in the face of data separation.
24. Differentiate relational model and multidimensional model. Explain with diagram.
(OR)
25. Explain the data warehouse and the web based eBusiness environment.
Earning: ₹ 0.00/- |