数据库工作流在地下管线数据处理中的应用

The Method of Data Processing Workflow for Database

当前测绘项目中对于数据后处理的要求是多样的,不同作业部门要求的成果结构和表达形式存在着差异。数据库工作流工具实现了数据库中基本逻辑错误的检查及错误报表输出、数据库间的结构转换,通过一次作业配置文件的定制,达到底层数据修改时最终成果快速生成的目的。在金坛市地下管线普查工作中将定制的配置文件分发至不同的作业组,并通过导入不同的配置文件实现了多个地下管线作业组独立进行数据处理、多个数据库批量合并、数据库平台间的数据转换,大大提高了数据处理的效率和安全性。

The requirements for data post processing in the current surveying and mapping project are diverse,and there are differences in the result structure and expression form required by different operating departments.Through operating configuration file customized once,the database workflow tool has the functions of checking basic logic errors,exporting reports and executing the structure conversion between databases,and achieves the purpose of rapid generation of the final results when the underlying data is modified.In the survey of underground pipelines in Jintan,the database workflow implements the works that independent data processing for multiple underground pipeline operation groups,batch merging of multiple databases,data conversion between database platforms through distributing the custom configuration files to different job groups and importing different configuration files.The database workflow greatly improves the efficiency and security of data processing.