DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Data warehouse
|
|
Data Sharing
|
|
Database
|
|
Data Mining
|
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: -Data warehouse systems provide online analytical processing (OLAP) tools for interactive analysis of multidimensional data at varied granularity levels. OLAP tools typically use the data cube and a multidimensional data model to provide flexible access to summarized data.
Detailed explanation-3: -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.