COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
One or more very large databases containing both detailed and summarized data for a number of years that is used for analysis rather than transaction processing.
|
Data warehouse
|
|
Data Sharing
|
|
Database
|
|
Data Mining
|
Explanation:
Detailed explanation-1: -data warehouse-Very large databases containing detailed and summarized data for a number of years that are used for analysis rather than transaction processing.
Detailed explanation-2: -Historical data. Data warehouses usually store many months or years of data. This is to support historical analysis. OLTP systems usually store data from only a few weeks or months. The OLTP system stores only historical data as needed to successfully meet the requirements of the current transaction.
Detailed explanation-3: -By Relational OLAP (ROLAP), which is an extended relational database management system. The ROLAP maps the operations on multidimensional data to standard relational operations.
There is 1 question to complete.