An arrangement for archiving data in a relational database is disclosed.
The arrangement includes a first table having a first data field. A value
in the first data field is updated by a Relational Database Management
System (RDBMS) associated with the relational database when there is a
change in the value in the first data field. The arrangement further
includes a second table having a second data field represented by a
lookup function. The lookup function references the first data field. The
lookup function acquiring the value in the first data field for use as a
value of the second data field only when a value of the second data field
is required by an application program that operates on the relational
database.