DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
To keep track of transactional data
|
|
|
To keep summarized historical information
|
|
|
To manage data from heterogeneous sources
|
|
|
To produce management reports
|
Detailed explanation-1: -Data warehouses offer the overarching and unique benefit of allowing organizations to analyze large amounts of variant data and extract significant value from it, as well as to keep a historical record. Subject-oriented. They can analyze data about a particular subject or functional area (such as sales).
Detailed explanation-2: -It possesses consolidated historical data, which helps the organization to analyze its business. A data warehouse helps executives to organize, understand, and use their data to take strategic decisions. Data warehouse systems help in the integration of diversity of application systems.
Detailed explanation-3: -Data warehousing improves the speed and efficiency of accessing different data sets and makes it easier for corporate decision-makers to derive insights that will guide the business and marketing strategies that set them apart from their competitors.
Detailed explanation-4: -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-5: -A data warehouse stores historical data about your business so that you can analyze and extract insights from it. It does not store current information, nor is it updated in real-time.