DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Integrated
|
|
Time-variant
|
|
Subject oriented
|
|
Non-volatile
|
Detailed explanation-1: -A data warehouse focuses on the modeling and analysis of data for decision makers, not on daily operations or transaction processing. A data warehouse provides a simple and concise view around particular subject issues by excluding data that are not useful in the decision support process.
Detailed explanation-2: -Subject-oriented – A data warehouse is always a subject oriented as it delivers information about a theme instead of organization’s current operations. It can be achieved on specific theme. That means the data warehousing process is proposed to handle with a specific theme which is more defined.
Detailed explanation-3: -Subject Oriented − A data warehouse is subject oriented because it provides information around a subject rather than the organization’s ongoing operations. These subjects can be product, customers, suppliers, sales, revenue, etc.
Detailed explanation-4: -A data warehouse is a system that stores data from a company’s operational databases as well as external sources. Data warehouse platforms are different from operational databases because they store historical information, making it easier for business leaders to analyze data over a specific period of time.
Detailed explanation-5: -A data warehouse is subject-oriented since it provides topic-wise information rather than the overall processes of a business. Such subjects may be sales, promotion, inventory, etc. For example, if you want to analyze your company’s sales data, you need to build a data warehouse that concentrates on sales.