Explain the difference between a data warehouse and a data mart. Use the analogy of a...

Explain the difference between a data warehouse and a data mart. Use the analogy of a supply chain.

Expert Solution

Difference between a data warehouse and a data mart:-

Sr.No.	Basis of difference	Data Warehouse	Data Mart
1.	Definition	Data warehouse is a large centralized repository of data which is used for reporting, data analysis and data mining. It is a large source of accumulated from different sources also known as enterprise data.	Data Mart is a subset of data warehouse which contains a single functional data set. Data mart is a structure or access pattern specific to data warehouse environment which is used for specifice business line.
2.	Types	3 types of data warehouse: Enterprise data warehouse Operational data store Data Mart	3 types of data mart: Dependent Independent Hybrid
3.	Sources of data	Data warehouse many external and internal sources from variuos area/department of an organization.	Data mart has only few sources which are linked to single line of business.
4.	Centralization	Data warehouse is a centralized system.	Data mart is a decentralised system.
5.	Size of data	Data size is typically larger than 100 GB.	Data size is less than 100 GB.
6.	Focus	Data warehouse focuses on multiple subject area and is a wide repository of data source.	Data mart focuses on a single subject or functional organization area i.e. finance or sales.
7.	Model	Data warehouse is a top down model.	While data mart is a bottom up model
8.	Flexibility	In this the data is flexible	In this data is not flexible
9.	Nature	Data warehouse is data oriented in nature.	While data mart is project oriented in nature.
10	Life span	It has a long life can be more than a year.	It has short life only for 3-6 months.
11.	Decision types	Data warehouse includes strategic decisions that affect the entire enterprise.	Data mart contains tactiacl decision pertaining to specific business line.
12.	Data held	Data held in data warehouse is in detailed form i.e. raw data, meta data and summary data.	While data held in data mart is summarized type.

keosha answered 6 months ago

difference between electronic circuits and analogy circuits difference between electronic circuits and analogy electronics

What is a data mart? (worth 1 point) What is the difference between a dependent and...

What is a data mart? (worth 1 point) What is the difference between a dependent and independent data mart? (worth 3 points)

1. What is Big Data? Why Is Big Data Different? (from data mart, data warehouse) 2. What Are...

1. What is Big Data? Why Is Big Data Different? (from data mart, data warehouse) 2. What Are the Benefits of Big Data? 3. Some of the potential business benefits from implementing an effective big data analytics 4. How can organization leverage Big Data? For example, Big Data can be used to develop the next generation of products and services. For instance, manufacturers are using data obtained from sensors embedded in products to create innovative after-sales service offerings such as proactive maintenance to avoid...

Use an analogy of a candle in a room to explain the standard candle model to...

Use an analogy of a candle in a room to explain the standard candle model to estimate astronomical distances. Explain its context in the Tully-Fisher relation to estimate distances.

Explain the difference between the terms “variable” and “data.” Include an illustration that demonstrates this difference....

Explain the difference between the terms “variable” and “data.” Include an illustration that demonstrates this difference. For Q2 Recall: “Illustration” = “Example”

What is the analogy between people overgrazing a commonly owned area of land and the use...

What is the analogy between people overgrazing a commonly owned area of land and the use of public air space in the case of the coronavirus pandemic? What is a possible remedy to prevent air space from becoming overused during a pandemic? What is the cost of not regulating shared air space and letting individuals decide for themselves whether to go to work, go shopping, gather in groups, etc.? Would a single business sacrificing profit by closing down to prevent...

What are the similarities and differences between database, data warehouse, and data mining?

Explain the difference between online analytical processing and data mining.

what is some difference in 3PL warehouse and an Amazon warehouse?

Answer all three (a-c) questions about homology: (a) What is the difference between homology versus analogy?...

Answer all three (a-c) questions about homology: (a) What is the difference between homology versus analogy? (b) Why is it important to make sure you use homologous characters rather than analogous characters to make phylogenetic trees? (c) Give examples from molecular and anatomical studies of the consequences of mistaken homology.

Question