Method and apparatus for tracking multiple payment resources and charging transactions to payment resources in on line transaction processing system

• US 6,047,267 A
• Filed: 05/14/1997
• Issued: 04/04/2000
• Est. Priority Date: 05/14/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Portal Software, Inc. (Oracle Corporation)
• Inventors: Haddock, James R., Labuda, David S., Owens, Gary L.
• Primary Examiner(s): MacDonald, Allen R.
• Assistant Examiner(s): Kazimi, Hani M.
• Application Number:
  US08/856,313
• Time in Patent Office: 1,056 Days
• Field of Search: 705/1, 705/34, 705/40, 705/41, 705/30, 707/4, 707/101, 707/103
• US Class Current: 705/34
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

Disclosed is a container object that allows a user to define new payment resources without requiring the user to redesign a relational database system used for persistent storage of transaction information. An object server maps data that is represented in transient memory according to an object-oriented scheme to data that is represented in persistent memory according to a relational database scheme. The object server generates appropriate tables and columns for a relational database scheme automatically so that the object-oriented scheme generated by a user may be efficiently stored and searched in persistent memory. Preferably, array elements are represented as rows in a table, not as columns so that storage space is not wasted with place holder data. In certain embodiments, a rating engine is provided that searches available rates and creates a rate stack for the purpose of authorizing transactions and adjusting payment source balances when authorization events or payment events occur.

Claims

1. 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; and

if 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.

2. A method as recited in claim 1 wherein the default account balance is zero.

3. A method as recited in claim 1 wherein the RDBMS query is an SQL query.

4. A method as recited in claim 1 further including sending the balance adjusting container to an object server and wherein the object server formulates the RDBMS query.

5. A method as recited in claim 1 wherein the object server formulates the RDBMS query using an hierarchical tree.

6. A computer program product that adjusts an account balance stored in an RDBMS table comprising:

computer code that instantiates 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;

computer code that formulates 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;

computer code that adjusts an account balance in the found entry in the account balance table by the adjusting amount if an entry in the account balance table is found;

computer code that creates an entry in the account balance table with a default account balance and adjusts the account balance in the created entry by the adjusting amount if no entry in the account balance table is found, wherein the account balance table is not required to include entries for account balances that have not been adjusted; and

a computer readable medium that stores the computer codes.

7. A computer program product as recited in claim 6 wherein the default account balance is zero.

8. A computer program product as recited in claim 6 wherein the RDBMS query is an SQL query.

9. A computer program product as recited in claim 6 further including computer code that sends the balance adjusting container to an object server and wherein the object server formulates the RDBMS query.

10. A computer program product as recited in claim 6 wherein the object server formulates the RDBMS query using an hierarchacal tree.

11. A computer program product as recited in claim 6 wherein the computer readable medium is a memory, floppy disk, hard disk, tape, flash memory, or system memory.

12. A system that adjusts an account balance stored in an RDBMS table comprising:

a processor; and

a computer readable medium that stores a computer program comprising;

computer code that instantiates 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;

computer code that formulates 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;

computer code that adjusts an account balance in the found in the account balance table by the adjusting amount if an entry in the account balance table is found; and

computer code that creates an entry in the account balance table with a default account balance and adjusts the account balance in the created entry by the adjusting amount if no entry in the account balance table is found, wherein the account balance is not required to include entries for account balances that have not been adjusted.

13. A system recited in claim 12 wherein the default account balance is zero.

14. A system as recited in claim 12 wherein the RDBMS query is an SQL query.

15. A system as recited in claim 12 further including computer code that sends the balance adjusting container to an object server and wherein the object server formulates the RDBMS query.

16. A system as recited in claim 12 wherein the object server formulates the RDBMS query using an hierarchical tree.

17. A system as recited in claim 12 wherein the computer readable medium is a memory, floppy disk, hard disk, tape, flash memory, or system memory.