Re: [WEB400] Row / Record Versioning Design -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

[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.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.