Design And Implement Of Teaching Quality Supervision System Based On ETL

In the information age,teaching management information level has become one of important standards in promoting teaching quality level and increasing core competitiveness.With the consistent improvement of education information,massive information redundancies or isolated information have emerged among all kinds of business system data,which has seriously restrained effective development of education information.Based on the background,it is a critical and important project how present business system data will effectively be integrated and how compound teaching quality supervision system.which is in favor of teaching information'sustained development will be exploited to solve the problems of data integration,complex implementation process and lack of integrated analysis and effective estimate teaching quality.This article has deeply done research on ETL data extracting system.It has also designed highly converted and accurate ETL model,which is applied to teaching quality supervision system based on ETL.In all,the author has finished the following tasks.(1)The author analyzes the situation of educational administration system at the education information environment and points out its existent problem and development bottleneck.At the same time,through the features of teaching quality supervision system,technology solution is well constructed based on the technology of WEB standard,asynchronous communication,load balancing and stored procedure.(2)According to the characteristics of monitoring system,the author analysizes the data base environment of the existing education quality monitoring,designs high efficiency,active incremental attribute extraction mechanism based on high accuracy rate,and also designs the optimization scheme based on SQL,Index,and the Cursor for the realization of ETL.(3)The author accomplishes the overall and detailed design and reaches collection,analysis and statistics of teaching quality supervision information.Based on ETL system,through collecting,analyzing and counting the key statistical data during the teaching operation,it also provides the support for teaching quality monitoring.The experimental results show that the incremental extraction method has proivded a feasible program to improvement of the ETL efficiency,reduction of data entry duplication and information sharing failure.