DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Virtual datwarehouse
|
|
|
Data mart
|
|
|
Enterprise Datawarehouse
|
|
|
All the above
|
Detailed explanation-1: -Three main types of Data warehouses are Enterprise Data Warehouse (EDW), Operational Data Store, and Data Mart. General state of a datawarehouse are Offline Operational Database, Offline Data Warehouse, Real time Data Warehouse and Integrated Data Warehouse.
Detailed explanation-2: -4.1. 5 Data Warehouse Models: Enterprise Warehouse, Data Mart, and Virtual Warehouse. From the architecture point of view, there are three data warehouse models: the enterprise warehouse, the data mart, and the virtual warehouse.
Detailed explanation-3: -Data modeling is the process of creating a visual representation of either a whole information system or parts of it to communicate connections between data points and structures.
Detailed explanation-4: -What are the key components of a data warehouse? A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly.
Detailed explanation-5: -Explanation: Information processing, analytical processing, and data mining are the three types of data warehouse applications.