Location based version

Idea created by safraeli on Oct 31, 2012
    New
    Score30
    Currently Versioning is implemented by adding the A and D tables.
    This approach is not scalable as every view operation requires complicated join operations in the database.
    More importantly, this approach does not use the SPATIAL nature of the data where editors typically work on a specific area.

    Long transaction model can be implemented on a single table where each editor locks a polygon.
    Obviously, some flexibility will be lost as two editors will not be able to edit the same area.
    Yet the gain in performance relatively to the current model will be enormous and will allow scaling the geodatabase to a much larger size.
    Another advantage of this model is mitigating the need to perform reconcile and post every day/week.