The Research Of Teaching Management Heterogeneous Data Sources Processing Technology

With the development of computer technology, particularly the development of Internet technology, Teaching in schools has gradually realized a computerized management. Because of the continuity of management teaching in various schools and the special circumstances of the various departments and schools makes between computer platforms there are some differences, the resulting heterogeneous data sources. The rapid development of database technology makes heterogeneous database management system of the data processing has become increasingly important, especially from a small data or low version of the database management system migrated to large, high version of the database management system.The research of this article is the middleware of heterogeneous database data transmission, using intermediate data source solutions. Its contents is: a data source of multiple heterogeneous data sources was turned into the format of intermediate data sources, in the middle of its data source will be dealt with again as a unified, standardized, objective data sources which can be accepted. Then intermediate data sources will be saved to aiming database in order to achieve the exchange of visits between heterogeneous databases.In this paper, the middleware designed three-tier structure: source data control part, middle data document, aiming data controlling part. The Middle Ware uses the schema of middle data source: Taking data out of the source data table; then, restoring the source data into the middle data document to reorganize these data and making them acceptable to the aiming data table; finally, putting these organized data into the aiming data table. Additionally, in the designing, the author writes the data types contrasting tables of heterogeneous databases by XML (eXtensible Markup Language) documents, and uses the XML document as middle data source. XML Schema defines the structures of the XML documents. The program uses JDBC-ODBC Bridge to connect and operate the databases.