DATA WAREHOUSING — Summer 2023

Explain the following terms: 1. Data mart 2. Granularity 3. ETL 4. Metadata 5. Compound key 6. click stream data 7. Operational Data Store

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

Suppose that a data warehouse consists of the three dimensions time, doctor, and patient, and the two measures rental fee and late charge, where late charge is the fee that a doctor charges a patient for a visit. Design Star schema model

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

Explain various data structures found in a data warehouse in detail.

Explain OLAP operations in detail with example.

Explain the physical design techniques that are especially relevant to the data warehouse environment.

Explain the concepts of variable-length data, lock management, index-only processing and fast restore in the context of data warehouse.

Write a short note on midlevel data model.

Explain the terms “Corporate Data Model”, “Operational Data Model”, and “Data Warehouse Data Model”.

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

Explain the process of planning for granularity of data in the data warehouse.

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

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

Explain the terms “Exploration Warehouse” and “Data Mining Warehouse” in detail.

What is multidimensional model? Explain the snowflake structure in detail.

What is EIS? State the uses of EIS.