lecture: An Open Source Approach to Multi-user Distributed Geospatial Data Management
Open source tools have been successful in managing geospatial data in central data stores. However, performance issues can arise from many users accessing the same table in a geospatial database at once, especially in a multi-user editing environment. The geospatial landscape also changes constantly, as a result of human activity and natural forces, this gives a need to track these changes within the geospatial database and perform change detection activities to understand changes across time, hence a need to version history. These use cases springs up the requirements to employ a data distribution across multiple geospatial databases using versioning and replication technology to integrate several desktop and mobile user applications into an adaptive geospatial communications environment connecting operations across the enterprise and throughout the organisations to improve data availability to multiple users, tracking change history within multiple table versions while increasing system performance.
Several commercial geospatial applications have successfully implemented full versioning replication capabilities by leveraging middleware with the core database versioning capabilities – for example ArcSDE technology from Esri . The realization of a full solution has been far-fetched on open source geospatial applications. This presentation discusses the development of QGIS plugin and implementation of FOSS4G solutions for versioning and replication capabilities with to support multi-user access while optimizing performance using QGIS, PostgreSQL, PostGIS and SpatialLite DB technologies.