Real-Time Compilation System for Input-Output Table Based on Distributed Database and Remote Data Replication Technology

Input-output (IO) table plays a very important role in macroeconomic analysis. However, the traditional manual compilation of input-output table always lacks timeliness, for example, the compilation period of 10 table is usually five years in China and three years in America. In order to speed up the compilation process, we develop a real-time compilation system based on distributed database and remote data replication technology in this paper. According to the derivation method of compilation, we first design the basic level database to manage the data from the local units, and then take advantage of middleware TongLINK/Q to realize the remote data replication from the basic database to higher layer database. At last, we realize the data verification and the final compilation of input- output table through data convergence system. This system can realize the real-time compilation of input-output table and provide the timely, exact and secure information for all national economic departments.