Editing and versioning for high performance network models in a multiuser environment

Network data models are frequently used as a mechanism to describe the connectivity between spatial features in GIS applications. Real-life network models are dynamic in nature since spatial features can be periodically modified to reflect changes in the real world objects that they model. Such updates may change the connectivity relations with the other features in the model. In order to perform analysis the connectivity must be reestablished. Existing editing frameworks are not suitable for a dynamic environment, since they require network connectivity to be reconstructed from scratch. Another requirement for GIS network models is to provide support for a multiuser environment, where users are simultaneously creating and updating large amounts of geographic information. The system must support edit sessions that typically span a number of days or weeks, the facility to undo or redo changes made to the data, and the ability to develop models and alternative application designs without affecting the published database. The row-locking mechanisms adopted by many DBMSs is prohibitively restrictive for many common workflows. To deal with long-lasting transactions, a solution based on versioning is thus preferrable. In this paper we provide a unified solution to the problems of dynamic editing and versioning of network models. We first propose an efficient algorithm that incrementally maintains connectivity within a dynamic network. Our solution is based on the notion of dirty areas and dirty objects (i.e., regions or elements containing edits that have not been reflected in the network connectivity index). The dirty areas and objects are identified and marked during the editing of the network feature data; they are then subsequently cleaned and connectivity is re-built. Furthermore, for improving performance, we propose a ‘hyperedge’ extension to the basic network model. A hyperedge drastically decreases the number of edge elements accessed during solve time on large networks; this in turn leads to faster solve operations. We show how our connectivity maintenance algorithms can support the hyperedge enhanced model. We then propose a new network model versioning scheme that utilizes the dirty areas/objects of the connectivity rebuild algorithm. Our scheme uses flexible reconciling rules that allow the definition of a resolving mechanism between conflicting edits according to user needs. Moreover, the utilization of dirty areas/objects minimizes the overhead of tracking the editing history. The unified editing and versioning solution has been implemented and tested within ESRI’s ArcGIS system.

[1]  Edward Sciore,et al.  Versioning and configuration management in an object-oriented data model , 2005, The VLDB Journal.

[2]  Klaus R. Dittrich,et al.  Version Support for Engineering Database Systems , 1988, IEEE Trans. Software Eng..

[3]  Erik G. Hoel,et al.  Building a Robust Relational Implementation of Topology , 2003, SSTD.

[4]  Petko Bakalov,et al.  Versioning of Network Models in a Multiuser Environment , 2009, SSTD.

[5]  Michel Mainguenaud,et al.  Modelling the Network Component of Geographical Information Systems , 1995, Int. J. Geogr. Inf. Sci..

[6]  Petko Bakalov,et al.  Maintaining Connectivity in Dynamic Multimodal Network Models , 2008, 2008 IEEE 24th International Conference on Data Engineering.

[7]  Torben Bach Pedersen,et al.  Integrated Data Management for Mobile Services in the Real World , 2003, VLDB.

[8]  ScioreEdward Versioning and configuration management in an object-oriented data model , 1994, VLDB 1994.

[9]  Cyrus Shahabi,et al.  A Road Network Embedding Technique for K-Nearest Neighbor Search in Moving Object Databases , 2002, GIS '02.

[10]  David J. Maguire,et al.  Object-oriented data modelling for spatial databases , 1990, Int. J. Geogr. Inf. Sci..

[11]  Donna Peuquet,et al.  An Event-Based Spatiotemporal Data Model (ESTDM) for Temporal Analysis of Geographical Data , 1995, Int. J. Geogr. Inf. Sci..

[12]  Scott Morehouse Arc/info: a geo-relational model for spatial information , 1985 .

[13]  Hanan Samet,et al.  Query Processing Using Distance Oracles for Spatial Networks , 2010, IEEE Transactions on Knowledge and Data Engineering.

[14]  Yufei Tao,et al.  Query Processing in Spatial Network Databases , 2003, VLDB.

[15]  Stephan Winter,et al.  Modeling Costs of Turns in Route Planning , 2002, GeoInformatica.

[16]  M. Goodchild,et al.  Geographical information systems. 2nd. , 1999 .

[17]  Michael F. Goodchild Geographic information systems and disaggregate transportation modeling , 1998 .

[18]  Torben Bach Pedersen,et al.  Data Modeling for Mobile Services in the Real World , 2003, SSTD.

[19]  K J Dueker,et al.  GIS-T ENTERPRISE DATA MODEL WITH SUGGESTED IMPLEMENTATION CHOICES , 1997 .

[20]  Randy H. Katz,et al.  Toward a unified framework for version modeling in engineering databases , 1990, CSUR.

[21]  Shashi Shekhar,et al.  CCAM: A Connectivity-Clustered Access Method for Networks and Network Computations , 1997, IEEE Trans. Knowl. Data Eng..

[22]  Chin-Wan Chung,et al.  An Efficient and Scalable Approach to CNN Queries in a Road Network , 2005, VLDB.

[23]  Tom Caldwell,et al.  On finding minimum routes in a network with turn penalties , 1961, CACM.

[24]  Erik G. Hoel,et al.  High Performance Multimodal Networks , 2005, SSTD.

[25]  Christian S. Jensen,et al.  Computational data modeling for network-constrained moving objects , 2003, GIS '03.

[26]  Bruce A. Ralston GIS and ITS Traffic Assignment: Issues in Dynamic User-Optimal Assignments , 2000, GeoInformatica.

[27]  James Evans,et al.  Optimization algorithms for networks and graphs , 1992 .

[28]  Richard G. Newell,et al.  Technical Paper No. 4 - Version Management in GIS - Applications and Techniques , 2006 .

[29]  Timothy L. Nyerges,et al.  GEOGRAPHIC INFORMATION SYSTEMS IN TRANSPORTATION , 1989 .