基于ArcGIS Engine的SDE数据库版本管理及历史归档的研究与实现

The Research and Implementation of SDE Database Version Management and Historical Filing Based on ArcGIS Engine

版本(Version)是无重复存储的数据库副本,SDE版本管理能完成数据备份、长事务处理、模拟场景与方案等;历史归档(Archiving)是将空间数据库的所有变化都保存下来,记录其变化的时间和变化前后的状态。历史归档是能够实现无冗余历史数据备份,实现任意时刻数据的查看,以及某时间段内历史数据动态回放显示。本文以胶南市地理信息系统为实例,简单介绍SDE版本管理与历史归档的基本原理,阐述了数据库版本的创建、查看、协调、提交以及版本差异的实现方案,并结合长事务处理的应用,介绍了版本管理在数据编辑和数据更新中的应用,分析并指出了利用版本和历史归档实现历史数据回溯的优缺点,并展示了采用历史归档实现历史回溯的实现。

Version is the database copy without the repeat storage and SDE version management can finish the data backup and long transaction processing, and simulate the scene and scheme and so on. Archiving is used to save all changes of the spatial database and record the time and state before and after the change. Archiving can realize the historical data backup without the redundant, and by using archiving we can review the historical data at any time and display the historical data in a certain period dynamically. In this paper,we take Jiaonan geographic information systems for example. We give the outline of the basic principle of SDE version management and historical filing, expound the implementation scheme of database version - explain the version creation, show the version view, reconcile with father version, post to default version, and calculate the difference of two versions. Combining with the application of long transaction processing, the paper introduces the Version management application in data editing and data updating, analyses and points out the advantages and disadvantages for realizing the historical data tracing by using version and historical filing, and presents how to realize history tracing by historical filing.