基于ArcSDE和ArcEngine的管道燃气数据增量更新

An Incremental Updating Method of Gas Pipeline Data Using ArcSDE and ArcEngine

采用增量信息文件记录燃气管道的变化信息,将燃气管道及其附属设施数据分为当前数据和历史数据,存储于Oracle数据库中。采用ArcSDE空间数据库引擎和ArcEngine二次开发工具,设计了基于事务机制的更新处理策略,有效地保证了更新过程中数据的完整性和一致性。用C#程序设计语言开发了包括增量信息文件读取,燃气管网数据增量更新、历史数据归档、日志记录等功能的管道燃气数据增量更新自动化处理系统。该系统在海南民生管道燃气有限公司正式应用。本文为管道燃气数据增量更新与历史数据查询提供了一套及时、高效的应用模式。

A designed change-only information file is used to record the gas pipeline changed data in this paper. Gas pipelines and the ancillary facilities data are stored in the current and historical database respectively according to the currency of the objects. Oracle database is used to store the spatial and attribute data;ArcSDE and ArcEngine are utilized to implement the incremental updating functions. A transactional processing strategy is used to ensure the data integrity and consistency during the updating effectively. A gas pipeline incremental updating prototype system including the functions, e.g., the reading the change-only information file, incremental updating of gas pipeline data, archiving historical data, and logging, is implemented by programming with Visual C# 2008. The system has been applied in the Hainan Mingsheng Piping Gas Co.,Ltd currently. This study represents a timely and efficient application mode of incremental updating and historical data query of gas pipeline data.