Patent ID: 8386541

Claim:
One or more non-transitory computer-readable media storing computer-executable instructions which, when executed by a processor on a computer system, perform a method for producing an element-specific (“ES”) view within one or more relational databases, the method using a first record and a second record stored in the relational databases, the first record and the second record related by a foreign key, the first record comprising, a first effective date and a first end date, the second record comprising a second effective date and a second end date, the method comprising: generating a composite key, the composite key comprising a distinct list of dates, the generating comprising: assigning a first rank to the first record; assigning a second rank to the second record; deriving a first override end date for the first record; deriving a second override end date for second record; deriving a first trial end date for the first record, the first trial end date based on: the first effective date; the first end date; the first rank; and the first override end date; deriving a second trial end date for the second record the second trial end date based on: the second effective date; the second end date; the second rank; and the second override end date; when the first effective date is different from the second effective date the composite key comprises: the first effective date and the first trial end date; and the second effective date and the second trial end date; when the first effective date is identical to the second effective date: comparing the first trial end date to the second trial end date based on the comparing selecting one of: the first effective date and the first trial end date; or the second effective date and the second trial end date; and the composite key comprises the selected effective date and the selected trial end date; correlating a first table and a second table to the composite key; and forming the ES view based on the correlating.