Patent ID: 7664772

Claim:
A method of managing a computer database, comprising: storing, by a database system, a first record in the computer database representing a first transaction and having a supply quantity associated therewith; storing, by the database system, a second record in the computer database representing a second transaction and having a consumption quantity associated therewith; forming, by the database system, a first association link record storing a first association quantity representing a portion of the supply quantity from the first record to be assigned to a first portion of the consumption quantity of the second record; and during processing of the second record: creating, by the database system, a third record in the computer database representing a second portion of the consumption quantity that has been processed by a third transaction, creating, by the database system, a second association link record storing a second association quantity representing a portion of the first association quantity to be assigned to the third record and representing whether the portion was assigned from the supply quantity or the consumption quantity, and adjusting, by the database system, the first association link record to represent an original first association quantity and a current first association quantity after the assignment to the third record.