Page 24 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes (c) Relational On Line Transactional Processing
(d) Relational On Line Transactional Program

Fill in the blanks:
5. A ..................... warehouse is created based on a set of views defined for an operational
RDBMS.
6. The ..................... contains a subset of the organisation-wide data that is of value to a small
group of users.
7. ..................... stores the data based on the already familiar relational DBMS technology.
8. Data warehouse is a kind of analytical tool used in .....................

9. A data warehouse focuses on the modeling and analysis of data for .....................
10. The data warehouse is normally a .....................
11. A ..................... is a physical database that receives all its information from the data
warehouse.

1.12 review Questions

1. What is a data warehouse? How is it better than traditional information-gathering
techniques?
2. Describe the data warehouse environment.

3. List and explain the different layers in the data warehouse architecture.
4. What are metadata? Why are metadata so important to a data warehouse?
5. Describe operational components of data warehouse.
6. Explain why business analysts need data warehouse.
7. Describe the process of data warehouse design.

8. Differentiate between ROLAP and MOLAP.
9. “A data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection
of data in support of management’s decision making process.” Discuss.
10. What are the various uses of data warehouses in organizations?

11. Differences between operational database systems and data warehouses.
12. Describe three-tier data warehouse architecture in detail.

answers: self assessment

1. (a) 2. (b)
3. (d) 4. (c)

5. virtual 6. data mart
7. ROLAP 8. business area
9. decision makers 10. relational database
11. dependent data mart

18 LoveLy professionaL university