DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Data Warehouse
|
|
Data Marts
|
|
Data Store
|
|
None
|
Detailed explanation-1: -Data marts contain repositories of summarized data collected for analysis on a specific section or unit within an organization, for example, the sales department. A data warehouse is a large centralized repository of data that contains information from many sources within an organization.
Detailed explanation-2: -A data mart can be created from an existing data warehouse-the top-down approach-or from other sources, such as internal operational systems or external data.
Detailed explanation-3: -A data mart is a data storage system that contains information specific to an organization’s business unit. It contains a small and selected part of the data that the company stores in a larger storage system. Companies use a data mart to analyze department-specific information more efficiently.
Detailed explanation-4: -Organizations do not need to know in advance how the data will be used. A data mart is a simple form of a data warehouse that is focused on a single subject or line of business, such as sales, finance, or marketing. Given their focus, data marts draw data from fewer sources than data warehouses.