Page 23 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 1: Data Warehouse Practice

l z The data is sourced from front-end systems that capture the policy information into the notes
data warehouse.
l z The data might then be analyzed to identify windstorm exposures in coastal areas prone to
hurricanes and determine whether the insurance company is overexposed.

l z The goal is to utilize the existing information to make accurate business decisions.
1.10 keywords

Data Sources: Data sources refer to any electronic repository of information that contains data of
interest for management use or analytics.
Data Warehouse Architecture: It is a description of the elements and services of the warehouse,
with details showing how the components will fit together and how the system will grow over
time.

Data Warehouse: It is a relational database that is designed for query and analysis rather than
for transaction processing.
Job Control: This includes job definition, job scheduling (time and event), monitoring, logging,
exception handling, error handling, and notification.
Metadata: Metadata, or “data about data”, is used not only to inform operators and users of the
data warehouse about its status and the information held within the data warehouse

1.11 self assessment

Choose the appropriate answers:
1. OLTP stands for
(a) On Line Transactional Processing
(b) On Link Transactional Processing

(c) On Line Transnational Processing
(d) On Line Transactional Program
2. RDBMS stands for
(a) Relational Database Manager System
(b) Relational Database Management System
(c) Relative Database Management System

(d) Relational Design Management System
3. BPR stands for
(a) Business Program Reengineering
(b) Business Preview Reengineering

(c) Basic Process Reengineering
(d) Business Process Reengineering
4. ROLAP stands for
(a) Relational On Line Transition Processing
(b) Relative On Line Transactional Processing

LoveLy professionaL university 17