Design And Development Of China Telecom Route Report System Based On ETL

China telecom route report system is a subsystem of China telecom international route system, which will bring useful analysis Report to users and the data mining application. The data market is an interface between the report system and other systems. After initializing related data report in the data market, the data report is refreshed timely according to a specific mechanism.This will satisfy some real-time search application. And we can use triggered refresh mechanism which adopts the synchronising buffering data method to deal with other basic information.This paper includes the following aspects:First, design the ETL processing daemo of route report system which combine the ETL theory with the route report system to improve the report presentation efficiency of China telecom international route system;Second, we apply the EOS to the report system. EOS is a kind of excellent open source software, which complied in java with the advantage of porting feature between different platforms. We analyze the code of the operating elements and improve it in the following ways:1) Redesign the page layout using javaScript and HTML, because the page layout style of EOS cann't satisfy China telecom route report system;2) Realize databases integration, which help to synchronization of mass data;Third, develop the data report with the ETL and EOS technology which realize the separation of report presentation and background database development serviceslogic and the programe logic;Last, the report system meets the reqirements of China Telecom and it has been used in the China telecom international route system; This paper not only meets the requirements of China telecom route system, but also lays the foundation for further report system research. It is a beneficial attempt to combine the EOS technology and ETL technology, which can be used for reference for other report system.