Talking about the development direction of business intelligence data warehouse support for ERP applications
Introduction
Modern enterprises can not develop without the use of information technology integration. How to improve data quality, provide effective data to support enterprises to avoid the risks in decision-making and is the current field of business intelligence and processing system of research priorities.
Business Intelligence and Features
Business Intelligence in general by the data warehouse, data analysis, data mining, on-line analysis, data backup and recovery components. Business Intelligence works are mainly two parts: first, the source data extraction, transformation, the collection will be distributed in the financial, logistics, manufacturing and other parts of the data set is stored; and management model based on the data stored after the multi-dimensional multi-point analysis of the data to find the linkages between the various proposed management decision-making basis.
Direction for the development of business intelligence
Enterprise information systems (IS), there are two different needs: First, combine the advanced management ideas can be efficiently integrated enterprise business strategy and external resources for the target service transaction processing system; second, we will be able to deal with the internal affairs of companies and enterprises external data into information. There is a demand there will be development in the 20th century 90 years, IS technological development there have been two new directions. Enterprise Resource Planning (ERP) and data warehouse (Data Warehousing), these two kinds of IS technology in the enterprise will be able to solve the above-mentioned problems encountered in the enterprise of new, which is the mutual integration of two technologies and support, has become a to support future business intelligence development, a point the problem.
ERP and Data Warehouse
Enterprise Resource Planning (ERP) concept by Gartner Inc. in the early 20th century, made 90. ERP is an integration of a variety of advanced management information systems thinking, the core management philosophy is to achieve the effective management of the entire supply chain. If we are from a different perspective, ERP, its development process is the gradual integration of enterprise resources to the enterprise IS system development process.
The concept of data warehouse is proposed by the Bill Inmon, the aim is to solve the company faced a "spider's web enterprise applications" phenomenon and better support management decision-making. Data warehouse technology stated clearly that the data inside and outside the enterprise to conduct a comprehensive integrated, cleaning and finishing, removing a number of purely transactional data, enterprise data by subject placed in a "warehouse" and then on this basis, It is built by a variety of decision support applications for enterprises. ERP and data warehousing technology can separate these two types of information to provide enterprise transaction processing and decision support functions, the two integrated to form a complete enterprise IS system architecture.
Based on ERP data warehouse
Mentioned earlier, enterprise information systems must be able to provide transaction processing and decision supports both functions. When an enterprise implementation of ERP, the company encountered the first problem can be solved, the remaining question is how to ERP system transaction data and other external data integration into information.
ERP is a technology-based information system, but also contains a variety of advanced management thought of the social-based information system, with its emphasis on the management of advanced, timeliness, safety, reliability, and so on. Although it's ERP software systems have provided part of the management decision support functions, such as the various reports, etc., but they can not completely solve the needs of enterprise management decision-making, because, after all, when the ERP system design concern is the data "into the "rather than" out ", from the real-time access to valuable information is more difficult.
If the ERP transaction data into the data warehouse through the clean-up, and then in the data warehouse based on a variety of analytical applications, then it would be a perfect combination, ERP handling corporate affairs, data warehouse supporting business management decision-making, each perform their own level. The establishment of ERP-based data warehouse, first of all is to analyze ERP data model, based on their corresponding data warehouse data model, then the identification of critical data, sorting, cleaning, transformation, and the theme is very important to determine the domain, followed by data extraction procedures for the establishment of such testimony was not be overlooked. Information is also needed for business decisions not only all from the ERP system, there are still some data from other systems within the enterprise and outside the enterprise in building enterprise data warehouse, it must be the sum of ERP data into the data integration warehouse. |
