Page 190 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes 9.8 self assessment

Choose the appropriate answers:

1. OLTP stands for:
(a) Offline Transaction Processing
(b) Online Transaction Processing
(c) Only Transaction Processing
(d) Online Transaction Program

2. ODS stands for:
(a) Operational Data Store
(b) Organisational Data Store
(c) Operational Data Source
(d) Operational Design Store

3. CDW stands for:
(a) Corporate Design Warehouse
(b) Computing Data Warehouse
(c) Common Data Warehouse

(d) Corporate Data Warehouse
Fill in the blanks:
4. Research on data warehouse refreshment has mainly focused on update propagation
through .........................

5. A ......................... is a set of coordinated activities which might be manual or automated
activities performed by actors.
6. The ......................... aims to propagate changes raised in the data sources to the data
warehouse stores.
7. The ......................... reconciliates the source changes coming from multiple sources and
adds them to the ODS.

8. Materialized views can perform a number of roles, such as .........................
9. The ......................... creates one or more materialized views, which are the equivalent of a
summary.
10. Materialized views are useful in ......................... data marts.

9.9 review Questions

1. “A workflow is a set of coordinated activities which might be manual or automated
activities performed by actors”. Explain
2. “The refreshment process is similar to the loading process in its data flow but, while the
loading process is a massive feeding of the data warehouse”. Explain
3. Define refreshment scenarios.
4. What do you mean by nested materialized views? Explain with suitable example.

184 LoveLy professionaL university