US5809505A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for relational to object mapping
Assignee: Citibank NA
•
Filing: 1996-12-18
•
Granted: 1998-09-15
•
Expires: 2016-12-18
Abstract
Abstract A relational to object mapping system and method permit the transfer and translation of data between a database server having a relational database and an object-oriented apparatus. The object code, such as C++, is translated by a generator object into suitable relational database statements, such as structured query language (SQL). The SQL statement is passed to a query object which executes the statement. In executing the SQL statement, the query object accesses an environment object which supplies the query object with appropriate connection objects for establishing a link between the query object and the database server. The database server supplies the requested data from the relational database to the query object which then stores the data in a storage buffer. The object-oriented apparatus can then access the data from the storage buffer. The query object may activate a transaction object for processing the data before the data is accessed by the object-oriented apparatus.
Inventors
- 👤 Thomas Lo
- 👤 Frank Longo
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 21:32
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 19
Claim 1
Independent Claim
116 words
A method for mapping an object-oriented apparatus to a relational database, comprising the steps of: producing at least one connection object for establishing communications with a database server which interfaces with said relational database; generating an environment object for managing said at least one connection object; linking a query object with a database query statement having a defined environment object; producing a generator object generating said database query statement for said object-oriented apparatus; and forming an interface link between said query object and a storage medium, said interface link transferring said database query statement to said database server and returning said relational data to said storage medium, said storage medium being accessible by said object-oriented apparatus.
Claim 2
Independent Claim
116 words
A method for mapping an object-oriented apparatus to a relational database, comprising the steps of: producing at least one connection object for establishing communications with a database server which interfaces with said relational database; generating an environment object for managing said at least one connection object; linking a query object with a database query statement having a defined environment object; producing a generator object generating said database query statement for said object-oriented apparatus; and forming an interface link between said query object and a storage medium, said interface link transferring said database query statement to said database server and returning said relational data to said storage medium, said storage medium being accessible by said object-oriented apparatus.
Claim 3
Dependent Claim
71 words
The method as set forth in claim 1, further comprising the steps of: executing said query object to cause said query object to access said environment object, and to acquire said connection object, said query object passing said database query statement over said interface link to said database server; and receiving relational data from said database server and storing said relational data in said storage medium defined by said interface link.
Claim 4
Dependent Claim
63 words
The method as set forth in claim 2, further comprising the steps of: testing error and status messages; and revising at least one of said connection object, said environment object, said query object, or said interface link upon one of said error or status messages; and repeating said executing, testing, and revising steps until none of said error or status messages is received.
Claim 5
Dependent Claim
22 words
The method as set forth in claim 1, further comprising a step of translating object-oriented code into database syntax with expression objects.
Claim 6
Dependent Claim
29 words
The method as set forth in claim 4, wherein said step of linking said query object comprises a step of building said database query statement from said expression objects.
Claim 7
Dependent Claim
24 words
The method as set forth in claim 1, wherein said object comprises a C++ object and said database query statement comprises an SQL statement.
Claim 8
Dependent Claim
27 words
The method as set forth in claim 1, further comprising a step of providing a transaction object for processing said relational data received from said database server.
Claim 9
Independent Claim
128 words
A system for mapping an object-oriented apparatus to a relational database, comprising: at least one connection object for establishing communications with a database server having said relational database; an environment object for managing said at least one connection object; a query object for executing a database query statement and for communicating with said environment object to acquire said connection object; a generator object for generating said database query statement on behalf of said object-oriented apparatus and for providing said database query statement to said query object; and an interface link between said query object and a storage medium, said interface link transferring said database query statement to said database server and returning said relational data to said storage medium, said storage medium being accessible by said object-oriented apparatus.
Claim 10
Independent Claim
128 words
A system for mapping an object-oriented apparatus to a relational database, comprising: at least one connection object for establishing communications with a database server having said relational database; an environment object for managing said at least one connection object; a query object for executing a database query statement and for communicating with said environment object to acquire said connection object; a generator object for generating said database query statement on behalf of said object-oriented apparatus and for providing said database query statement to said query object; and an interface link between said query object and a storage medium, said interface link transferring said database query statement to said database server and returning said relational data to said storage medium, said storage medium being accessible by said object-oriented apparatus.
Claim 11
Dependent Claim
23 words
The system as set forth in claim 8, further comprising a transaction object for processing said relational data received from said database server.
Claim 12
Dependent Claim
25 words
The system as set forth in claim 8, wherein said database query statement comprises an SQL statement and said object-oriented apparatus is programmed with C++.
Claim 13
Independent Claim
110 words
A method for interfacing between a database server having a relational database and an object-oriented apparatus, comprising the steps of: translating code from said object-oriented apparatus into a database query statement for said database server; transferring said database query statement to a query object and retrieving at least one connection object through an environment object; passing said database query statement from said query object to said database server through an interface link defined by said connection object; and receiving over said interface link data from said relational database and storing said data in a storage medium defined by said connection object, said storage medium being accessible by said object-oriented apparatus.
Claim 14
Independent Claim
110 words
A method for interfacing between a database server having a relational database and an object-oriented apparatus, comprising the steps of: translating code from said object-oriented apparatus into a database query statement for said database server; transferring said database query statement to a query object and retrieving at least one connection object through an environment object; passing said database query statement from said query object to said database server through an interface link defined by said connection object; and receiving over said interface link data from said relational database and storing said data in a storage medium defined by said connection object, said storage medium being accessible by said object-oriented apparatus.
Claim 15
Dependent Claim
21 words
The method as set forth in claim 11, further comprising a step of processing said data received from said database server.
Claim 16
Independent Claim
134 words
A system for transferring data between a relational database and an object-oriented apparatus, comprising: at least one connection object; an environment object for managing said at least one connection object; a generator object for translating code from said object-oriented apparatus into a database query statement for said database server; a query object for receiving said database query statement from said generator object and for retrieving the at least one connection object through said environment object, said query object establishing a connection to said database server over an interface link defined via said connection object; said query object receiving said data in said relational database from said database server over said interface link and storing said data in a storage medium specified by said interface link, said storage medium being accessible by said object-oriented apparatus.
Claim 17
Independent Claim
134 words
A system for transferring data between a relational database and an object-oriented apparatus, comprising: at least one connection object; an environment object for managing said at least one connection object; a generator object for translating code from said object-oriented apparatus into a database query statement for said database server; a query object for receiving said database query statement from said generator object and for retrieving the at least one connection object through said environment object, said query object establishing a connection to said database server over an interface link defined via said connection object; said query object receiving said data in said relational database from said database server over said interface link and storing said data in a storage medium specified by said interface link, said storage medium being accessible by said object-oriented apparatus.
Claim 18
Dependent Claim
26 words
The system as set forth in claim 13, further comprising a transaction object for processing said data received by said query object from said database server.
Claim 19
Dependent Claim
18 words
The system as set forth in claim 13, wherein said generator object translates C++ code into SQL statements.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-09-14 | 2002-03-16 | 2002-09-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-09-14 | 2006-03-16 | 2006-09-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-09-14 | 2010-03-16 | 2010-09-15 | $7700.00 | Window Closed / Lapsed |