Data warehouse is the technique used to collect data from various sources and to manage this data to do meaningful business analysis. Data warehouse, known as the whole of the technology that provides the strategic use of the database, allows storage of large amounts of data in the electronic environment. Data coming from different sources and distributed is gathered at one point and it becomes more difficult to analyze and report as the data increases.
The data warehouse is a place, not a product.
The data warehouse is the foundation for the BI (Business Intelligence) system for data analysis and reporting
History of Data Warehouse
Datawarehouse enables business managers to understand and improve the performance of their organization. As computer systems become more sophisticated and incremental amounts of information are needed to process new solutions have been developed, but the data warehouse is not a new technology.
Here are some important events in the history of Data Warehouse:
1960- Dartmouth and General Mills develop dimensions and realities in a joint research project.
1970- A Nielsen and IRI introduced dimensional data markets for retail sales.
1983- Tera Data Corporation offers a database management system specially designed for decision support.
The data warehouse began in the late 1980s when IBM employee Paul Murphy and Barry Devlin developed Work Data Ambassador.
But the real concept was used by Bill Inmon and Inmon was accepted as the father of the data warehouse.
How Does Data Warehouse Work?
A Data Warehouse serves as a central repository where information comes from one or more data sources. Information flows from the data base to the data warehouse. Data warehouse, as a vital component of business intelligence, makes data mining possible. Data mining creates models that can lead to higher sales and profits in data.
Data storage is the electronic storage of large amounts of information by a business. Data warehouse is a vital component of business intelligence that uses analytic techniques on business data.
The concept of data warehouse was introduced in 1988 by IBM researchers Barry Devlin and Paul Murphy. As computer systems became more complex, and as we were handling the data in increasing quantities, the need for repository data became evident.
Types of Data Ambassadors
There are three main types of Data Warehousing:
- Enterprise Data Warehouse:
Enterprise Data Warehouse is a central warehouse. Provides decision support service throughout the organization. It provides a unified approach to organize and represent the data.
- Operational Data Warehouse:
In ODS, the data warehouse is refreshed in real time. For this reason, it is a widely preferred type of data warehouse for routine activities such as keeping records of employees or customers.
- Data March:
A data mart is a subset of the data warehouse. It is specially designed for a specific business area such as sales and finance. In an independent data mark, the data can be collected directly from the sources.
Who needs data warehouse?
The data warehouse is required for users as follows:
People with a large number of decision-makers who trust the donation.
- Users who deal with complex operations that are specialized to receive information from multiple data sources.
- It is also used by people who need simple technology to access the data.
- It is also necessary for those who need a systematic approach to making a decision.
- Data warehouse can be useful if you want fast performance on existing data.
- Data warehouse is the first step. If you want to discover the hidden patterns of data streams and groups, you should use Data warehouse.