Patent ID: 8666956

Claim:
A method comprising: receiving a SEQUENCED request to apply a temporal Source table to a temporal Target table under a predicate, the Source table including a plurality of rows that qualify to apply to a single Target table row under the predicate, the predicate specifying a Source table join column, each of the plurality of Source table rows and the single Target table row including a ValidTime dimension; ordering the plurality of Source table rows by the Source table join column and a period-to-be-modified; applying the next of the ordered plurality of Source table rows by: determining that the Target table row has a TransactionTime and, in response, closing out the TransactionTime of the Target table row; identifying an RDIFF range as the period-to-be-modified of the Source table row being applied that is entirely later than the ValidTime range of the single Target table row; creating an RDIFF row being the same as the Target table row except the ValidTime of the RDIFF row is set to RDIFF range; applying a second of the ordered plurality of Source table rows by applying the determining, identifying, and creating steps to the RDIFF row as the Target table row.