[mapguide-users] Repository corruption from multiple users creating redlines?

[Berg, James]

Windows Server 2003 32-bit
MapGuide Open Source 2.5.2
Maestro 5.1
ASP.NET + C# programming code (.NET 4.0)

Hello, all

I've been researching the feasibility of implementing a new function for our GIS product. First, I'd like to query if the following scenario is plausible:

1. User identifies an existing line or point layer whose feature source/class should be copied
2. A copy of the layer's feature source is saved permanently to the repository in SDF format. I imagine this could be done a couple ways:
            a. Use MgFeatureService to copy the feature source (I imagine this is slow)
            b. Use some other FDO api (maybe Fdo2Fdo would work? Not really familiar with other APIs, but will use them if they're faster)
3. From now on, the user can add the new sdf feature source to their map at run-time with a generic layer definition (maybe library references to saved SDFs feature sources are stored in a SQL table or something.)
4. After adding the new layer to the map, the user can create, update, and delete rows and values from the sdf feature source using the MgFeatureService
5. The user saves their changes to the sdf feature source back to the repository.

The purpose of this is so users can create addendums for existing layers without altering the primary feature source and share addendums with other users. This allows users to collaborate and eventually request that the primary feature be updated with their addendums. My research suggests this sort of thing is possible, it basically an implementation of the sharable markup concept, but please send any comments or criticism my way, I'd greatly appreciate it.

As an aside, using an RDBMS such as PostGIS, Oracle, or SQL Server 2008 to store geometry data as an alternate solution to editing SDF files directly is being considered.

I discovered one disturbing thing in my research in this mailing list that describes the possibility of crashing a repository in scenarios where multiple users create and edit SDF redlines:

http://osgeo-org.1560.x6.nabble.com/Creating-mark-ups-redlining-using-anything-other-than-SDF-td4198550.html

This concern was posted in 2008, does this limitation for SDF still stand? If so, would the limitation the poster describes negatively impact my proposed function.

Sorry for the long post. If anyone has a comment or two about what I'm trying to do I'd help me out a lot.

Thanks

James Berg
GIS Programmer Mechanic
Stantec
2335 Highway 36 West St. Paul MN 55113
Phone: (651) 604-4776
Fax: (651) 636-1311
James.Berg at stantec.com<mailto:James.Berg at stantec.com>

[http://www.stantec.com/content/dam/stantec/images/esignature/stantec.png]<http://www.stantec.com/>

The content of this email is the confidential property of Stantec and should not be copied, modified, retransmitted, or used for any purpose except with Stantec's written authorization. If you are not the intended recipient, please delete all copies and notify us immediately.

ü Please consider the environment before printing this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20140610/fd59afbb/attachment.html>