We are building an application with several spatial tables, provided by a commercial vendor, at its core. The vendor provides updates quarterly. We maintain several tables of our own, derived from these commercial tables. Our application would benefit from versioning the commercial tables along with our derived tables, such that we can see a consistent view of things at any point in time.
Upon each update from the vendor, I would like to "diff" the changes and apply them to our database, then update our derived tables accordingly. Can this be accomplished with ESRI's implementation of versioning? Would this require registering our tables with the GDB? (I prefer to do the heavy lifting with PL/SQL, so I'm not sure how I feel about this.)