FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Focusing on the modeling and analysis of data for decision makers, not on daily operations or transaction processing is known
A
Integrated
B
Time-variant
C
Subject oriented
D
Non-volatile
Explanation: 

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.

There is 1 question to complete.