company logo

database version

A database object version defines a validity period for data stored for a database object or a database. By default, the database version is 0 and covers the whole time domain. Defining a new database object version will close the previous version and start a new version, which starts at the same time as the previous version ends. The last version is always unlimited, until the next version will be created.

Creating a version will conserve all data stored for the database object until it has been versioned. One can read data in older versions, but updated instances are stored in the current version, always. Thus, opening a database object with an older version allows updating instances in the older version, but only, as long as those do note have an updated instance in a newer version.

Database versions are numbered consecutively and associated with a version date.

Specialisations:  schema version

Related topics