DATA WAREHOUSING — Winter 2019

Differentiate between Primitive Data and Derived Data.

What do you mean by Data Granularity? Explain the concerns of granularity in a data warehouse.

What is Multidimensional model? Explain the Star and Snowflake structures in detail.

Write a short note on Partitioning of data in a Data Warehouse

What is Data Warehouse? Explain the need for building a data warehouse.

Explain the issues related to placement of operational data into the data warehouse.

Explain in brief the feedback loop techniques for deciding the levels of granularity in a data warehouse.

What are profile records? Explain the concept of creating multiple profile records along with appropriate example.

Explain various types of contextual information and their importance in the data warehouse environment

What is EIS? State the uses of EIS.

Answer the following : i. Differentiate between Structured and Unstructured Data. ii. Explain the terms “stop word” and “stem” along with appropriate example.

Explain the relation between EIS and Data Warehouse in detail.

Explain the process of relating the Structured and Unstructured environments of Data Warehouse.

Explain the terms “granularity manager” and “ODS”. Explain their importance in the interaction between the web and data warehouse environments.

Answer the following: i. What is ETL? State the varieties of ETL software. ii. Differentiate between ETL and ELT.

What do you mean by Independent Data Mart? State its advantages and disadvantages.

Write a short note on Midlevel Data Model.