动态SQL方法4在数据同步中的应用

Application of Fourth Method of Dynamic SQL in Data Synchronization Module

采用动态SQL方法4对医疗保险信息系统前后台数据库的数据进行数据一致性处理。结合日志法和时间戳法,在前后台数据库中各建一张表syn_data。源数据库与目标数据库间的数据传送用中间件For-TPCS完成,选择表项,变量个数、长度和数据类型后,通过对每张表插入、修改、删除操作构造动态SQL语句以实现数据同步处理。

Data of front and background databases for information system of medical insurance were processed synchronously with fourth method of dynamic SQL. According to log and timestamp methods, a list syn_data was respectively set up in front and background databases. The data transfer between source database and target database was implemented with middle ware For-TPCS. After selecting list item, variable number, length and data type, dynamic SQL sentence was built through that each list syn_data was inserted, modified and deleted, and data synchronous processing was realized with it.