Patent ID: 6047267
Filing Date: 2000-04-04
Classification: G06F,G06Q

Abstract:
A computer implemented method of adjusting an account balance stored in an RDBMS table comprising:instantiating a balance adjusting container object that includes an account element identification number, a balance element identification number of a balance element that will be adjusted and an adjusting amount, the account element identification number and balance element identification number identifying the account balance;formulating an RDBMS query to determine whether an entry in an account balance table exists that corresponds to the account element identification number and the balance element identification number;if an entry in the account balance table is found, then adjusting an account balance in the found entry in the account balance table by the adjusting amount; andif no entry in the account balance table is found, then creating an entry in the account balance table with a default account balance and adjusting the account balance in the created entry by the adjusting amount;wherein the account balance table is not required to include entries for account balances that have not been adjusted.