Re: [WEB400] Row / Record Versioning Design

[Charles Wilt <charles.wilt@xxxxxxxxx>]

[question posted in WEB400]
What's you're talking about is a "temporal database"
https://en.wikipedia.org/wiki/Temporal_database

Joe Celko has some good discussions online and in his books around them.

Charles



On Thu, Jan 15, 2015 at 8:51 PM, Holm, Paul <pholm@xxxxxxxxxxxxxxxxx> wrote:

> Hi,
>
> Looking for design ideas or experience with the following.
>
> We are creating a DB to hold equipment where each record holds a
> description of equipment.  They want to have the ability to have 1 to many
> "versions" of the record.  For example, if a device firmware or
> configuration is updated, they want to maintain the old record.
>
> I'm thinking I can accomplish all this by simply adding a "Version" column
> to the database.  Version could have values such as "1.0", "1.2", or
> *CURRENT if it's the latest.   When a new version is needed, we simply copy
> the record and update the VERSION  field.
>
> Feedback with this approach?
>
> Thanks in advance, Paul
> --
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.