Question1) Answer all the questions.
(i) Briefly explain data warehousing?
(ii) What do you understand by Indexing?
(iii) What do you mean by data integration and aggregation?
(iv) Write down the difference between centralized & decentralized database?
(v) What are the goals of multi dimensional data model?
Question2) Describe the concept of CRM? Also describe the role of data warehouse in CRM.
Question3) Describe the designing concept about relational database and OLAP cubes.
Question4) Describe ETL and its various stages.
Question5) Answer all the questions.
(i) What is metadata synchronization?
(ii) Distinguish between operational and analytical database.
(iii) What do you understand by knowledge driven DSS?
(iv) What is event analysis?
(v) What is enterprise data warehouse?
Question6) Describe the concept of strategic information system. What role the strategic information system plays in the process of decision making?
Question7) What are DBA’s? Describe the types of DBA’s & their responsibilities.
Question8) Write brief note
(i) OLAP
(ii) Clustering
(iii) Data cleanup & transformation tools.