[postgis-users] Data Versioning?

[Jeff McKenna]

Thank you everyone for your replies to my spatial versioning question. 
It's given me lots to think about.  cya.


Jeff




Paul Ramsey wrote:
> Hi Jeff,
> I'll just finish off the Refractions tag-teaming of you :)
>   I am writing from the Heart of Darkness itself, the ESRI UC, so I know 
> whereof I speak, when I say: Jeff, free your mind! Do not confuse the 
> particular terminology and implementation of a vendor with the application 
> of a broader concept. ArcSDE versioning is a particular application of a 
> form of spatio-temporal database schema. But it is not the only possible 
> application, and it may not fit the needs of every user -- Chris has given 
> some examples of change tracking which go well beyond the ArcSDE paradigm, 
> but which *can* be supported through a well designed database schema.
>   Remember, at root, all that ArcSDE "versioning" is, is a particular schema 
> implemented in the RDBMS, and managed via the ArcSDE middleware. You can go 
> into your ArcSDE geodatabase and interrogate the tables, see how they 
> modelled the particular problem.
>   Here in the Heart of Darkness, it is easy to forget that GIS transcends 
> the particular boundaries and terminology used by ESRI, but it does.
> Yours,
> Paul
> 
> 
> Quoting Jeff McKenna <mckenna at dmsolutions.ca>:
> 
> 
>>I guess I was hoping to hear that PostGIS/PostgreSQL already handled
>>spatial data versioning similar to ArcSDE.
>>I understand the concept of 'meta tables' storing extra timestamp info,
>>but are there examples of this already in use out there?  Has anyone
>>been successful in implementing spatial data versioning with
>>PostGIS/PostgreSQL????  (we deal with large datasets and this would
>>impact the way we do things bigtime)
>>
>>thanks.
>>
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


-- 
Jeff McKenna
GIS Specialist
DM Solutions Group Inc.
http://www.dmsolutions.ca