DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Write only
|
|
|
Read only
|
|
|
Write and Read
|
|
|
Copy
|
Detailed explanation-1: -An operational database query allows to read and modify operations, while an OLAP query needs only read only access of stored data.
Detailed explanation-2: -Data warehouses are typically set to read-only for analyst users, who are primarily reading and aggregating data for insights. Since data is already clean and archival, there is usually no need to insert or update data.
Detailed explanation-3: -Use Data Warehouse Models which are optimized for information retrieval which can be the dimensional mode, denormalized or hybrid approach.
Detailed explanation-4: -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-5: -OLTP and OLAP: The two terms look similar but refer to different kinds of systems. Online transaction processing (OLTP) captures, stores, and processes data from transactions in real time. Online analytical processing (OLAP) uses complex queries to analyze aggregated historical data from OLTP systems.