DATA WAREHOUSING — Winter 2022

Explain need of Data Warehousing with suitable example? Write any three differences between traditional DBMS and Data Warehousing.

1. Explain any four characteristics of Date warehouse. 2. Write any three issues and benefits of Data warehouse. 0

What do you mean by data homogeneity and heterogeneity? Explain with suitable example.

What do you mean by Data model? Explain mid level and physical level data model with example.

Explain the need and techniques used for Data transformation and Data integration.

What do you mean by indexing? Explain how data warehouse is different than multidimensional DBMS?

1. Write any four differences between data mart and data warehouse. 2. Write short note on Meta data management.

1. What are issues involved while loading data in data warehouse? 2. Explain three types of contextual information used in data warehouse.

What is the role of programmer and designer in data placement? What is the need of data locking?

1. Write any three differences between OLAP and OLTP. 2. Explain any four OLAP operations with example.

What is Executive Information system (EIS)? Explain its potentials and Applications.

Explain two tired data warehouse model in detail using suitable diagram.

Explain detailed VS summarized data in EIS using suitable example.

How does a snowflake schema differ from a star schema? Name two advantages and two disadvantages of the snowflake schema.

What do you mean by independent Data mart? Explain its advantages and disadvantages.

What do you mean by operational data store? How its provide flow between data warehouse and web?

1. Explain dimension and fact table with example. 2. Explain star schema with suitable example.