Why do data warehouses need to keep historical data instead of simply the most current values?
- Why do data warehouses need to keep historical data instead of simply the most current values?
Answer:
Data Warehouses
A data center is an extensive array of market data used to help a corporation evaluate. The data warehouse paradigm existed since the 1980s, in which transfer information from mere delivery into fueling decision-making systems disclosing market intelligence was developed. The vast volume of data contained in data stores comes from a multitude of locations, such as internal systems such as marketing, distribution and finance.
Instead of merely holding the latest values, data stores must hold historical data:
A data warehouse routinely draws information from such programs and systems on a technological level; then, the data is formatted and inferred to complement the data already in the warehouse. This processed data is retained by the data center, which makes it accessible to decision makers. Based on business specifications, how many data pulls occur, how data is formatted, etc.
The Data Warehouse Inventory is stored independently from the operating database of the organization. The data warehouse is however not a commodity but an atmosphere. It is an architectural framework of an information system that gives users information that is impossible to obtain or display in conventional data stores, including historical and current decision support information.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
