topic Re: SDE and Versioning History in Geodatabase Questions

SDE and Versioning History

forestknutsen1 — Thu, 18 Nov 2021 18:27:41 GMT

What year was SDE versioning released? And who came up with the original system? I seem to recall it was some Australian professor.

Wikipedia suggests that SDE was released in 1995 was versioning part of the original systems?

https://en.wikipedia.org/wiki/ArcSDE

Re: SDE and Versioning History

VinceAngelo — Fri, 19 Nov 2021 16:29:57 GMT

The original SDBE 1.2 was ported to Oracle at SDE 2.0, fundamentally restructured at SDE 3.0 (adding shapelib and the Projection Engine), then ported to databases not named Oracle (DB2, Informix, Sybase, MS SQL Server) in subsequent snapshots.

Versioning was added to ArcSDE by Esri at 8.0 (which also discontinued Sybase support; PostgreSQL was added later).

I'm not sure who started the concept of multiversion state trees. It probably wasn't original to Esri, but the details of the Esri implementation certainly were.

- V

Re: SDE and Versioning History

forestknutsen1 — Fri, 19 Nov 2021 18:45:42 GMT

Thanks Vince. I know I have read an article about the original work someplace... but my google skills are failing me.

What about the geometric network? Do you know when that was released?

Re: SDE and Versioning History

VinceAngelo — Mon, 22 Nov 2021 16:32:18 GMT

No idea. I was trained on 1.2, a certified instructor at 2.0, and one of the class developers at 3.0, but Ed Services moved the training back to full-time instructors at 8.0, so various enhancements after that ran outside my radar. All the "What's New" docs are likely still online somewhere (well, at least 9.0 forward), so that seems a likely source for that history.

- V

Re: SDE and Versioning History

Robert_LeClair — Tue, 23 Nov 2021 22:32:17 GMT

I "think" Geometric Networks were released with ArcInfo Workstation 7 but it had simple edges vs. the complex edge seen with the release of ArcInfo Workstation 8. My Google skills found this that makes me think this was close to the release date - Developing an ArcInfo SDE Geodatabase for Hydraulic Modeling (esri.com)