Study And Application Of Data Integration Technology On Educational Decision Support System Of President

With the continuous development of information technology and the rapid growth of the scale of higher education, various universities have established their own educational management information system. Most of these systems is the On-Line Transaction Processing (OLTP), each department has its own data sources, which constitute a huge heterogeneous data environment. So it causes a series of issues, such as the decentralization of data and information systems, without making use of the mass accumulated information of history and the poor capacity of management decision-making. It can effectively resolve the problem of information island through data integration technology, data warehouse technology and On-Line Analytical Processing(OLAP) tool, and mine a lot of valuable data analysis. They play an important guiding significance for managers to make teaching decisions.In this paper, I research deeply data integration technology, data warehouse design and OLAP technology to the Administration Information System in Beijing polytechnic college, construct a data warehouse, and develop data integration system, including Extract, Transform,Load and OLAP decision analysis. In the design and establishment of data warehouse, I mainly research the logic of the model for data warehouse and establish star model for the every theme. On this basis, I extract and transform data in the original Educational Administration database system. Finally, I load them into the data warehouse, and realize data cleaning and integration of the Educational Administration System.Finally, the use of OLAP tools verifies the results of the data integration. On the basis of the establishment of multi-dimensional data set, it analyses students' scores, Students' case, and the employment situation and display clearly through histograms, pie chart, Curve, and so on. According to the results of the analysis, it put forward specific support of making decision and proposals to the Educational managers.Through data integration, the establishment of the data center essentially eliminates informational island. It has improved the level of the educational administration and realized the intelligent scientific process with decision of educational administration management.