The Application Of Data Synchronization Technology In The Provincial Data Integration

The core of the application system is database, and data warehouse need many different data from numerous database to improve their own data mart, database synchronous technology is a data integration method. At present, data integration through the data synchronization technology and establishing large data warehouse has become the mainstream of domestic tax department, electronic government, enterprise information construction. Taxation information integration applies extensively, involving multiple levels, and is common in and abroad china. Its realization including data synchronization, processing integration,equipment integration, application integration, etc. Taxation data integration is not only bring about a series of changes to the business model, the management model and the operation model but also bring opportunities and challenges to the business restructuring and sustainable development of future taxation information.In2009Guizhou taxation has already realized municipal data integration which fully embodies the high availability of Oracle database. It started the provincial data project in2011, using data synchronization technology to integrate nine(cities, states) and1provincial affiliated MIS production data.This paper set in guizhou provincial taxation bureau, mainly discussed the application of data synchronization technology in the provincial data integration. Today at home and abroad,data synchronization is mainly achieved by the third-party software.The database of Guizhou Taxation Bureau mainly uses Oracle.The extensive use of virtual database,partition table and materialized view badly support the third-party software.Oracle streams technology highly integrate with Oracle.According to the actual situation and after a lot of tests and experiments,Guizhou provincial data synchronization applies Oracle Streams technology.Oracle Streams with complex technology and technical difficulties need the developers possess higher professional skills and optimization experience. Although applications appear in foreign countries, in china there exists no successful cases.Guizhou provincial integration project applies Oracle Streams to synchronize data is the first case in china. The Oracle Streams data synchronization technology is the base of guizhou data synchronization. After a series of ETL processing the synchronization data, mainly as the source data of multidimensional analysis,data mining and business intelligence data analysis Based on this, it provides the leaders and departments with basic inquiry, statistics, analysis and decision functions etc. Supervising the real-time tax with data synchronization is the most striking feature,which allows managers to inquire the simultaneous taxation situation.Through the feedbacks,finding out problems and solving them timely is a high-point application of data synchronization in provincial data integration.