How to build a data center information exchange platform?

This article combines the concrete practice of the digital campus construction of Zhejiang Media College. Based on the analysis of data integration method, the construction framework of data center information exchange platform is proposed. It provides a scheme to eliminate information Island, establish information and Application specification and integrate application service.

Background analysis of data center information exchange Platform construction

1. Current situation of business system construction

In the process of information construction in our school. Various departments according to their own business needs. Separately developed their own business systems. As shown in the table. Each of these systems has its own way of storing and accessing data. Independent. Formed a "information island." Addition。 Each system does not follow the unified information standard and the norm in the construction. Increase the difficulty of interoperability between data. For some basic data duplication, not only waste human and material resources, but also difficult to ensure the authority of data, uniqueness, integrity and accuracy.

Main business System

2, the 阃 of the business system needs to share

The school is in the process of daily affairs. Often integrated into the various systems of data, a lot of key information is closely linked, there is the need to share. If you can share the basic data information, you can solve the problem of inconsistent data. For example: The library borrowing system, the financial system, the school work system, the educational administration system and so on will use the student's basic information. Each system needs to maintain a correct student list, resulting in many repetitive entries. It also increases the likelihood that the data will not be unified. Furthermore。 Students ' basic information does not come from the same department. The same system: the students during the school period of various systems, such as the orientation system, the academic system, the school system, the school system, the employment system is constantly supplementing, updating the basic information of students, to produce a variety of changes, such as the lack of a source of authority. It's hard to keep data consistent. It is the sharing between these business systems that requires the construction of the data center information exchange platform.

II. Data Center Information Exchange Platform Construction framework

1. Selection of data integration methods

Data integration can also be called information integration. Used to resolve data interoperability issues. The core task of data integration is to integrate interconnected distributed heterogeneous data sources. Enables users to access these data sources in a transparent manner. Integration means maintaining the data consistency of the data source as a whole and improving the efficiency of information sharing utilization. Transparency means that users do not have to care about how to access heterogeneous data source data. Only care about the way in which data is accessed.

The difficulties of data integration mainly focus on three aspects: heterogeneity, distribution and autonomy of data sources. 12I heterogeneity: The integrated data source is usually developed independently, and there are differences in the data semantics, the expression of the same semantic data and the use environment of the data source. Distribution: And the data source is distributed geographically. relies on the network for data transfer. There are problems with the performance and security of network transmissions. Autonomy: Each data source has a strong autonomy. They can change their structure and data without notifying the integration system.

Typical data integration methods include pattern integration method and data replication method. These two data integration methods have their advantages and disadvantages and scope of application. The Mode integration method provides the user with the global Data View and the unified access interface. High transparency. However, this method does not implement data interaction between data sources. Users often need to access multiple data sources when they are in use. Therefore, network dependence is strong. Execution efficiency is also relatively low. Data replication methods replicate data from other data sources that users may use before they use a data source. Users need only access to a data source or a small number of data sources when they are in use. This greatly increases the efficiency of the system in processing user requests. However, it is difficult to guarantee the real-time consistency of data between data sources. The mode integration method is suitable for the system with large scale, frequent data updating and high real-time consistency. Data replication is suitable for situations where the data source is relatively stable and the user query pattern is known or limited.

Federated database systems with pattern integration. Each system implements an interface to a virtual shared library. Modify the original system accordingly. In the same way, it is necessary to build a global model for the integration of middleware. It takes a lot of time. What is more important is that the main purpose of establishing data centers at this stage is not to query data. It's about sharing and exchanging data. So. The simple model integration method can not fully meet the needs of the digital campus construction program. therefore。 After detailed needs investigation, analysis and comprehensive consideration of various factors, we choose the data replication method. Establish data center Data warehouse. For future application requirements to provide space for implementation. For some systems that are closed to their business, they use a unified data encapsulation format such as XML. The communication front machine realizes the sharing of the data information.

2. Information Exchange Platform Framework

The information exchange platform needs to provide all the data integration features that an integrated platform includes: data based, event-based, and service based.

The core Exchange components are shown in the figure:

Data center Information Exchange Platform Exchange component

Design points:

(1) Maintain the existing business system basically unchanged. Interface between business systems and data centers. Complete docking. Realize the purpose of extracting and pushing data. Cost savings.

(2) According to the actual application demand, the data exchange adopts the combination of database level Exchange and application level data exchange to deal with different data exchange requirements. Database-level data exchange is more suitable for data sets that require high data volumes in real time. Exchange。 such as Student status change, performance modification and other types of data exchange to provide data for the business system through the CDC (changedatacapture) Dynamic Data capture mechanism. Capture and integrate data with varying portions at a time. Thereby alleviating the burden of network transmission and system processing of data center platform. Application-level data exchange is more suitable for data exchange which is not very high in real time, but has a large amount of data.

(3) Adhere to the basic principle of information sharing, to master, the role of the main line. The basic data scattered in various departments ' business systems will be centrally stored in the data center, providing comprehensive data of the cross-functional personnel, teaching, scientific research and public assets, thus providing a full range of information services for teachers and students.

(4) To ensure the authority of the central database data. Update and synchronize the data of each business system in time.

(5) Although the main purpose of establishing the data center at present stage is not for data query, but for sharing data  and exchange. But it also needs to provide a good data environment. Provide data preparation for future high-level decisions and applications.

(6) Establish unified information standards to ensure the exchange and sharing of information.

Iii. concluding remarks

Data center Information Exchange platform is an important part of digital campus core technology support platform. It retains the database of the original business system. The exchange of information between heterogeneous databases is realized. Promote the centralization and sharing of data. It solves the problem of Information island in the construction of digital school. Lay the foundation for implementing application integration. And it provides the possibility for data analysis and mining. Addition。 For the orderly flow of information. Also need to develop school-level information coding standards. So that all the information in the school can be interconnected in real time. Eliminates data redundancy between business units. Avoid duplication of work in multiple sectors. Save labor costs. Ensure the standardization of data storage (Source: Engine room 360)