Skip to main content
Log in

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

  • Published:
GeoInformatica Aims and scope Submit manuscript

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14
Fig. 15
Fig. 16
Fig. 17
Fig. 18
Fig. 19
Fig. 20

Similar content being viewed by others

References

  1. Bakalov P, Hoel E, Heng WL, Tsotras VJ (2008) Maintaining connectivity in dynamic multimodal network models. In proceedings of the International Conference on Data Engineering (ICDE 2008), Cancun, Mexico, pages 1267–1276, April

  2. Borchert R (2003) Geometric network: what is it and how to make it? In Proceedings of the 23 rd Annual ESRI User Conference, San Diego, July

  3. Caldwell T (1961) On finding minimum routes in a network with turn penalties. Commun ACM 4(2):107–108

    Article  Google Scholar 

  4. Cho H-J, Chung C-W (2005) An efficient and scalable approach to CNN queries in a road network. In Proceedings of the 31st International Conference on Very Large Data Bases (VLDB 2005), Trondheim, Norway, pages 865–876, August

  5. Caliper Corporation (1996) TransCAD Transportation GIS Software Reference Manual. Caliper Corporation

  6. Dittrich K, Lorie R (1988) Version support for engineering database systems. IEEE Transactions on Software Engineering, 14 (4), April 1988

  7. Dueker K, Butler A (1998) GIS-T enterprise data model with suggested implementation choices. J Urban Reg Inf Syst 10(1):12–36

    Google Scholar 

  8. Easterfield M, Newell R, Theriault G (1990) Version management in GIS—applications and techniques. In Proc. of the European Conference on Geographical Information Systems (EGIS 1990), Amsterdam, pages 1–8, April

  9. ESRI (2002) Building a Geodatabase. Prepared by Environmental Systems Research Institute, ESRI Press, Redlands, CA

  10. Evans J, Minieka E (1992) Optimization algorithms for networks and graphs. Marcel Incorporated, Dekker

    Google Scholar 

  11. Goodchild M (1998) Geographic information systems and disaggregate transportation modeling. Geogr Syst 5(1–2):19–44

    Google Scholar 

  12. Hage C, Jensen C, Pedersen T, Speicys L, Timko I (2003) Integrated Data Management for Mobile Services in the Real World. In Proceedings of the 29th Intl. Conf. on Very Large Data Bases (VLDB 2003), Berlin, pages 1019–1030, September

  13. Hoel E, Menon S, Morehouse S (2003) Building a robust relational implementation of topology. In Proceedings of the 8th International Symposium on Advances in Spatial and Temporal Databases (SSTD 2003). Santorini Island, Greece, July. 508–524

  14. Hoel E, Heng WL, Honeycutt D (2005) High performance multimodal networks. In Proceedings of the 9th International Symposium on Advances in Spatial and Temporal Databases (SSTD 2005), Angra dos Reis, Brazil. 308–327, August

  15. Jensen C, Pedersen T, Speicys L, Timko I (2003) Data Modeling for Mobile Services in the Real World. In Proc. of Symposium on Advances in Spatial and Temporal Databases (SSTD 2003), Santorini Island, Greece, pages 1–9, July

  16. Katz R (1990) Toward a unified framework for version modeling in engineering databases. ACM Computing Surveys. 22(4)

  17. Longley P, Goodchild M, Maguire D, Rhind D (1999) Geographical Information systems, principles, techniques, applications and management. Wiley

  18. Mainguenaud M (1995) Modeling of the geographical information system network component. Intl J Geogr Inf Syst 9(6):575–593

    Article  Google Scholar 

  19. Menon S, Aronson P, Brown T, Muller M, Ryden K, Morehouse S (2000) Requirements and design considerations for versioned geographic data management. Unpublished manuscript. ESRI, Redlands, CA, July

  20. Miller H, Shaw S-L (2001) Geographic information systems for transportation. Oxford University Press, Oxford

    Google Scholar 

  21. Morehouse S (1985) ARC/INFO: A Geo-relational Model for Spatial Information. In Proceedings of AUTOCARTO 7, Washington, DC, pages 388–397, March

  22. Oracle Corp (2005) Oracle Database 10 g: Oracle Spatial Network Data Model: technical white paper, May

  23. Papadias D, Zhang J, Mamoulis N, Tao Y (2003) Query Processing in Spatial Network Databases. In Proceedings of the 29th International Conference on Very Large Data Bases (VLDB 2003), Berlin, pages 802–813, September 2003

  24. Peuquet D, Duan N (1995) An event-based spatiotemporal data model (ESTDM) for Temporal Analysis of Geographic Data. International Journal of Geographical Information Science, 9(1)

  25. Ralston B (2000) GIS and its traffic assignment: issues in dynamic user-optimal assignments. Geoinformatica 4(2):231–243

    Article  Google Scholar 

  26. Sciore E (1994) Versioning and configuration management in an object-oriented data model. International journal on very large data bases. 3(1)

  27. Shahabi C, Kolahdouzan M, Sharifzadeh M (2002) A road network embedding technique for k-nearest neighbor search in moving object databases. In Proceedings of the 10th ACM International Symposium on Advances in Geographic Information Systems (ACMGIS 2002), McLean Virginia, pages 94–100, November

  28. Shekhar S, Liu D-R (1997) Ccam: a connectivity-clustered access method for networks and network computations. IEEE Trans Knowl Data Eng 9(1):102–119

    Article  Google Scholar 

  29. Speicys L, Jensen C, Kligys A (2003) Computational data modeling for network-constrained moving objects. In Proceedings.of the 11th ACM Intl. Symp. on Advances in Geographic Information Systems (ACMGIS 2003), New Orleans. 118–125

  30. Stokes A, Balasubramanian S, Harrison S (2000) Building versioning applications with the oracle internet file system. Oracle Technical Brief, Oracle Corporation

  31. Winter S (2002) Modeling costs of turns in route planning. GeoInformatica 6(4):345–361

    Article  Google Scholar 

  32. Worboys M, Hearnshaw H, Maguire D (1990) Object-oriented data modeling for spatial databases. Intl J Geogr Inf Syst 4(4):369–383

    Article  Google Scholar 

  33. Smallworld Core Spatial Technology 4, Managing change in the world of spatial data—the long transaction, GER-4231 (10/04), 2004

  34. Bakalov P, Hoel E, Menon S, Tsotras VJ (2009) Versioning of network models in a multiuser environment. In Proceedings of 11th International Symposium on Advances in Spatial and Temporal Databases (SSTD 2009), Aalborg, Denmark, July 8–10. 6–24

  35. Sankaranarayanan J, Samet H (2010) Query processing using distance oracles for spatial networks. IEEE Trans Knowl Data Eng 22(8):2010

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Vassilis J. Tsotras.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Bakalov, P., Hoel, E., Heng, WL. et al. Editing and versioning for high performance network models in a multiuser environment. Geoinformatica 15, 769–803 (2011). https://doi.org/10.1007/s10707-011-0126-7

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10707-011-0126-7

Keywords

Navigation