Versioning of Network Models in a Multiuser Environment

The standard database mechanisms for concurrency control, which include transactions and locking protocols, do not provide the support needed for updating complex geographic data in a multiuser environment. The preferred method to resolve conflicts in GIS systems is to encapsulate the modifications generated by the end users through the use of multiple versions. Multiuser (or versioned) geographic databases allow users to operate as though they have full access to the entire dataset. Instead of relying upon row locking, versioned databases allow multiple users to simultaneously edit the same row. They implement a model for conflict detection and resolution where the first to commit the change wins by default (though clients can manually intervene and select the latter change as the winner). Network models are frequently used as a mechanism to describe the connectivity information between spatial features in many emerging GIS applications. Supporting networks within the context of a versioned database imposes additional requirements --- the complex network model must retain integrity irrespective of the sequence of simultaneous edits by various clients. In this paper, we review our network model and discuss the enhancements necessary to maintaining topological network integrity in this complex environment. Our solution is based on the notion of dirty areas and dirty objects (i.e., regions or elements that contain edits that have not been reflected in the network connectivity index). The dirty areas and objects are identified and marked during editing of the network feature data. They are then subsequently cleaned as a byproduct of the incremental update of the connectivity network.

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

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

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

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

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

[6]  Chengyang Zhang,et al.  Advances in Spatial and Temporal Databases , 2015, Lecture Notes in Computer Science.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[21]  Timothy C. Coburn,et al.  Geographical Information Systems: Principles, Techniques, Applications and Management: 2nd Edition, Volumes 1 and 2, Paul A. Longley, Michael F. Goodchild, David J. Maguire and David W. Rhind (Eds.), 11240 pp., Wiley, New York, 1999, ISBN 0-471-32182-6, US $345.00 , 2000 .

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

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

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

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

[26]  Michel Mainguenaud,et al.  Modelling of the geographical information system network component , 1995 .

[27]  Ray Wild,et al.  Optimization Algorithms for Networks and Graphs , 1980 .

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