Patent ID: 8706769

Claim:
A method comprising: reading a plurality of rows from a source, each row in the plurality of rows having a ValidTime dimension and a non-temporal value dimension, each row in the plurality of rows having the same value in the non-temporal value dimension; creating an intermediate-record-to-be-inserted by: inserting the value of the non-temporal value dimension in the plurality of rows into the non-temporal value dimension of the intermediate-record-to-be-inserted; and inserting a union of the ValidTime dimensions of the plurality of rows from the source into the ValidTime dimension of the intermediate-record-to-be-inserted; scanning, using a computer, a temporal target table stored on the computer, wherein the temporal target table has a ValidTime dimension and a value dimension; finding, during the scanning, a qualifying row having a value dimension having a value equal to a value of the value dimension in the intermediate-row-to-be-inserted; processing the qualifying row; creating a row-to-be-inserted by: inserting the value of the value dimension of the intermediate-row-to-be-inserted into a value dimension of the row-to-be-inserted; and inserting the union of the ValidTime dimension of the qualifying row and the ValidTime dimension of the intermediate-row-to-be-inserted into a ValidTime dimension of the row-to-be-inserted; and inserting the row-to-be-inserted in the temporal target table.