DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
transaction system
|
|
|
decision support system
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A decision support system (DSS) is a system-specifically, an interactive information system-built on top of a data warehouse to make it easy to query or pull information from data.
Detailed explanation-2: -A data warehouse, meanwhile, is a centralized repository and information system that is used to develop insights and guide decision-making through business intelligence. A data warehouse stores summarized data from multiple sources, such as databases, and employs online analytical processing (OLAP) to analyze data.
Detailed explanation-3: -A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data.
Detailed explanation-4: -A data warehouse supports [1] business analysis and decision-making by creating an enterprise-wide integrated database of summarized, historical information. It integrates data from multiple, incompatible sources.