COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
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: -Data warehouse systems serve users or knowledge workers in the role of data analysis and decision-making. Such systems can organize and present data in various formats in order to accommodate the diverse needs of the different users. These systems are called on-line analytical processing (OLAP) systems.
Detailed explanation-3: -A data warehouse stores large amounts of historical data so you can analyze different time periods and trends to make future predictions. Such data typically cannot be stored in a transactional database or used to generate reports from a transactional system.
Detailed explanation-4: -A DSS leverages a combination of raw data, documents, personal knowledge, and/or business models to help users make decisions. The data sources used by a DSS could include relational data sources, cubes, data warehouses, electronic health records (EHRs), revenue projections, sales projections, and more.