Transactionstimesupport 5

1.8.1995:
  • VALIDTIME PERIOD '[1995-06-01 - 9999-12-31)'
    UPDATE angestellte
    SET strasse = '124 Alberca' WHERE name = 'Lilian';
  • COMMIT;

  • Tabelle angestellte:
    name ano strasse stadt geburtstag VALID TRANSACTION
    Franz 6542 Rennweg 683 Zürich 1963-07-04 [1995-02-01 - 1995-07-01) [1995-07-01 - 9999-12-31)
    Franz 6542 Rennweg 683 Zürich 1963-07-04 [1996-01-01 - 9999-12-31) [1995-07-01 - 1995-08-01)
    Franz 6542 Niederndorfstrasse 2 Zürich 1963-07-04 [1996-01-01 - 9999-12-31) [1995-08-01 - 9999-12-31)
    Lilian 3463 46 Speedway Tuscon 1970-03-09 [1995-02-02 - 9999-12-31) [1995-07-01 - 1995-10-01)
    Lilian 3463 46 Speedway Tuscon 1970-03-09 [1995-02-02 - 1995-06-01) [1995-10-01 - 9999-12-31)
    Lilian 3463 124 Alberca Tuscon 1970-03-09 [1995-06-01 - 9999-12-31) [1995-10-01 - 9999-12-31)