In organizations which have set up many separate information systems that support specific areas of their business, very often there is a problem the proper management of data stored in them. The vastness of the data and the lack of logical connections between them make the acquisition of information actually needed and credible is a challenge.
And in the case of using a modular system that comprehensively supports all processes in the organization, there may be a problem with the assignment of rights to access only the specified data range.
With the help of a solution to these problems come to us Data Warehouses.
How the data warehouse
The data warehouse is a dedicated multi-dimensional database integrating data from all database systems operating in an enterprise or institution. Supply data warehouse is done repeatedly, with any frequency, depending on the information needs of users. Data warehouses can be powered by data from various sources: domain systems (eg finance and accounting, payroll, warehouse, sales, and for the health of individuals with medical systems), spreadsheets or text files. Gather all the data, which also are subject to pre-aggregated and organized in a single data warehouse to increase the consistency, so the analysis becomes much simpler and less time consuming.
One of the biggest advantages of a data warehouse is that they collect copies of the data gathered in transactional systems, ensuring their safety and affect the rate calculation.
Creating a data warehouse
The implementation of data warehouse consists of several stages:
- Determining the information needs of users
- Development of warehouse database architecture
- Definition of interfaces for data exchange between data warehouse and transaction systems operating in the organization
- The term data warehousing requirements in terms of hardware and software
- Installation and parameterization
- Training of users
Presentation of data
Reviewing, processing and analysis of data collected in data warehouses is usually with the use of OLAP (On-line Analytical Processing). They allow you to analyze data in multiple dimensions and cross sections, taking into account the various factors affecting the phenomena occurring in the organization.
No comments:
Post a Comment