Patent US6047267A successfully refreshed from Google Patents.
US6047267A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for tracking multiple payment resources and charging transactions to payment resources in on line transaction processing system
Assignee: Oracle International Corp
•
Filing: 1997-05-14
•
Granted: 2000-04-04
•
Expires: 2017-05-14
Abstract
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.
Inventors
- 👤 Gary L. Owens
- 👤 David S. Labuda
- 👤 James R. Haddock
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 18:08
CPC Classifications
G; G06; G06Q; G06Q40/00; G06Q40/12; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; G06Q30/00; G06Q30/04; G06Q40/02
Claims Analysis
Total Claims: 20
Claim 1
Independent Claim
173 words
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.
Claim 2
Dependent Claim
173 words
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.
Claim 3
Dependent Claim
14 words
A method as recited in claim 1 wherein the default account balance is zero.
Claim 4
Dependent Claim
15 words
A method as recited in claim 1 wherein the RDBMS query is an SQL query.
Claim 5
Dependent Claim
27 words
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.
Claim 6
Dependent Claim
19 words
A method as recited in claim 1 wherein the object server formulates the RDBMS query using an hierarchical tree.
Claim 7
Dependent Claim
192 words
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.
Claim 8
Dependent Claim
192 words
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.
Claim 9
Dependent Claim
16 words
A computer program product as recited in claim 6 wherein the default account balance is zero.
Claim 10
Dependent Claim
17 words
A computer program product as recited in claim 6 wherein the RDBMS query is an SQL query.
Claim 11
Dependent Claim
32 words
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.
Claim 12
Dependent Claim
21 words
A computer program product as recited in claim 6 wherein the object server formulates the RDBMS query using an hierarchacal tree.
Claim 13
Dependent Claim
27 words
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.
Claim 14
Independent Claim
192 words
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.
Claim 15
Independent Claim
192 words
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.
Claim 16
Dependent Claim
13 words
A system recited in claim 12 wherein the default account balance is zero.
Claim 17
Dependent Claim
15 words
A system as recited in claim 12 wherein the RDBMS query is an SQL query.
Claim 18
Dependent Claim
30 words
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.
Claim 19
Dependent Claim
19 words
A system as recited in claim 12 wherein the object server formulates the RDBMS query using an hierarchical tree.
Claim 20
Dependent Claim
25 words
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.
References Cited (Backward Citations)
US4918593A
Cited
US5291583A
Cited
US5295256A
Cited
US5483445A
Cited
US5684965A
Cited
US5530853A
Cited
WO1995004960A2
Cited
US5649118A
Cited
WO1995027255A1
Cited
WO1996034350A1
Cited
WO1997003406A1
Cited
WO1998052131A1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-04-04 | 2003-10-04 | 2004-04-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-04-04 | 2007-10-04 | 2008-04-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-04-04 | 2011-10-04 | 2012-04-04 | $7700.00 | Window Closed / Lapsed |