DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
top-down view
|
|
|
data source view
|
|
|
data warehouse view
|
|
|
business query view
|
Detailed explanation-1: -The data source view − This view presents the information being captured, stored, and managed by the operational system. The data warehouse view − This view includes the fact tables and dimension tables. It represents the information stored inside the data warehouse.
Detailed explanation-2: -The view over an operational data warehouse is known as a virtual warehouse. It is easy to build a virtual warehouse. Building a virtual warehouse requires excess capacity on operational database servers.
Detailed explanation-3: -An operational data store (ODS) is a central database that provides a snapshot of the latest data from multiple transactional systems for operational reporting. It enables organizations to combine data in its original format from various sources into a single destination to make it available for business reporting.
Detailed explanation-4: -An operational data store will take transactional data from one or more production systems and loosely integrate it, in some respects it is still subject oriented, integrated and time variant, but without the volatility constraints. This integration is mainly achieved through the use of EDW structures and content.
Detailed explanation-5: -1. Operational systems are designed to deal with the running values of data. Informational Systems deals with the collection, compilation and deriving information from data.