DATA WAREHOUSING — Summer 2022

Write a short note on architectured environment

Write a short note on partitioning of data in a data warehouse

What is data warehouse? Explain the salient features of data warehouse in brief

Differentiate between Primitive data and derived data.

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

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

Explain various data structures found in a data warehouse in detail

What is EIS? State the uses of EIS.

Write a short note on midlevel data model

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

Explain the concept of direct operational access of data warehouse data along with appropriate example

What is a multidimensional DBMS? Compare multidimensional DBMS and data warehouse.

What is multidimensional model? Explain the star and snowflake structures in detail

What do you mean by independent data mart? State its advantages and disadvantages

Explain the issues that may arise out of an effort to match structured and unstructured data based on text.

Explain two-tiered data warehouse in detail

What is data visualization? Explain structured and unstructured data visualization in brief.