US7542990B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for providing a relational application domain model
Assignee: CA Inc
•
Filing: 2004-10-26
•
Granted: 2009-06-02
•
Expires: 2024-10-26
Abstract
Abstract This disclosure provides a system and method for providing a relational application domain model. In one embodiment, the system is operable to or includes software that is operable to receive a structured query language (SQL) query for one or more services by at least a first of a plurality of resources. The software may be further operable to convert the SQL query into an object-oriented request compatible with at least the first resource and execute the object-oriented request at at least the first resource.
Inventors
- 👤 Eugen Paval
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 12:46
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99941; Y10S707/99942; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 28
Claim 1
Independent Claim
272 words
A computer readable medium containing computer-executable instructions for modeling a relational application domain, wherein the instructions are configured to cause a processing device to: receive a structured query language (SQL) query from a client, wherein the SQL query includes a request for data referenced or stored on a plurality of data resources, wherein each of the plurality of data resources are associated with a respective object-oriented framework; convert the SQL query into a plurality of object-oriented requests using one or more transformation policies, wherein the one or more transformation policies include at least a mapping policy that provides a uniform map for converting the SQL query into an object oriented format compatible with the object-oriented frameworks respectively associated with the plurality of data resources, wherein to convert the SQL query into the plurality of object-oriented requests, the instructions further cause the processing device to: map one or more elements of the SQL query to a plurality of class definitions using the mapping policy, wherein the plurality of class definitions are respectively associated with the object-oriented frameworks of the plurality of data resources; and instantiate the plurality of object-oriented requests based on the mapped class definitions; execute the plurality of object-oriented requests on each of the plurality of data resources to retrieve the requested data from each of the plurality of data resources, wherein the plurality of data resources return the requested data in an object-oriented format compatible with the respective object-oriented framework; aggregate the data returned by the plurality of data resources in response to the object oriented requests; and communicate the aggregated data to the client that submitted the SQL query.
Claim 2
Dependent Claim
272 words
A computer readable medium containing computer-executable instructions for modeling a relational application domain, wherein the instructions are configured to cause a processing device to: receive a structured query language (SQL) query from a client, wherein the SQL query includes a request for data referenced or stored on a plurality of data resources, wherein each of the plurality of data resources are associated with a respective object-oriented framework; convert the SQL query into a plurality of object-oriented requests using one or more transformation policies, wherein the one or more transformation policies include at least a mapping policy that provides a uniform map for converting the SQL query into an object oriented format compatible with the object-oriented frameworks respectively associated with the plurality of data resources, wherein to convert the SQL query into the plurality of object-oriented requests, the instructions further cause the processing device to: map one or more elements of the SQL query to a plurality of class definitions using the mapping policy, wherein the plurality of class definitions are respectively associated with the object-oriented frameworks of the plurality of data resources; and instantiate the plurality of object-oriented requests based on the mapped class definitions; execute the plurality of object-oriented requests on each of the plurality of data resources to retrieve the requested data from each of the plurality of data resources, wherein the plurality of data resources return the requested data in an object-oriented format compatible with the respective object-oriented framework; aggregate the data returned by the plurality of data resources in response to the object oriented requests; and communicate the aggregated data to the client that submitted the SQL query.
Claim 3
Dependent Claim
55 words
The computer readable medium of claim 1 , wherein the instructions that cause the processing device to execute the plurality of object-oriented requests further cause the processing device to: communicate the plurality of object-oriented requests to the plurality of data resources; and request execution of the communicated object-oriented requests on the plurality of data resources.
Claim 4
Dependent Claim
59 words
The computer readable medium of claim 1 , wherein the instructions that cause the processing device to convert the SQL query into the plurality of object-oriented requests further cause the processing device to parse the SQL query into the one or more elements, wherein the one or more parsed elements include data characteristics and parameters of the SQL query.
Claim 5
Dependent Claim
19 words
The computer readable medium of claim 1 , wherein the plurality of data resources are remote from the client.
Claim 6
Dependent Claim
19 words
The computer readable medium of claim 1 , wherein the SQL query includes an eXtensible Markup Language (XML) query.
Claim 7
Dependent Claim
20 words
The computer readable medium of claim 1 , wherein the SQL query includes a select statement or an execute statement.
Claim 8
Dependent Claim
45 words
The computer readable medium of claim 1 , wherein the plurality of object-oriented requests include a plurality of Plain Old Java Objects (POJOs) respectively configured to be executed on the plurality of data resources to gather the requested data from the plurality of data resources.
Claim 9
Dependent Claim
41 words
The computer readable medium of claim 7 , wherein the plurality of object-oriented requests executed on the plurality of data resources each include one or more object-oriented queries or object-oriented commands compatible with the object-oriented framework of the respective data resource.
Claim 10
Independent Claim
249 words
A method for modeling a relational application domain, comprising: receiving a structured query language (SQL) query from a client, wherein the SQL query includes a request for data referenced or stored on a plurality of data resources, wherein each of the plurality of data resources are associated with a respective object-oriented framework; converting the SQL query into a plurality of object-oriented requests using one or more transformation policies, wherein the one or more transformation policies include at least a mapping policy that provides a uniform map for converting the SQL query into an object oriented format compatible with the object-oriented frameworks respectively associated with the plurality of data resources, wherein converting the SQL query into the plurality of object-oriented requests further includes: mapping one or more elements of the SQL query to a plurality of class definitions using the mapping policy, wherein the plurality of class definitions are respectively associated with the object-oriented frameworks of the plurality of data resources; and instantiating the plurality of object-oriented requests based on the mapped class definitions; executing the plurality of object-oriented requests on each of the plurality of data resources to retrieve the requested data from each of the plurality of data resources, wherein the plurality of data resources return the requested data in an object-oriented format compatible with the respective object-oriented framework; aggregating the data returned by the plurality of data resources in response to the object-oriented requests; and communicating the aggregated data to the client that submitted the SQL query.
Claim 11
Independent Claim
249 words
A method for modeling a relational application domain, comprising: receiving a structured query language (SQL) query from a client, wherein the SQL query includes a request for data referenced or stored on a plurality of data resources, wherein each of the plurality of data resources are associated with a respective object-oriented framework; converting the SQL query into a plurality of object-oriented requests using one or more transformation policies, wherein the one or more transformation policies include at least a mapping policy that provides a uniform map for converting the SQL query into an object oriented format compatible with the object-oriented frameworks respectively associated with the plurality of data resources, wherein converting the SQL query into the plurality of object-oriented requests further includes: mapping one or more elements of the SQL query to a plurality of class definitions using the mapping policy, wherein the plurality of class definitions are respectively associated with the object-oriented frameworks of the plurality of data resources; and instantiating the plurality of object-oriented requests based on the mapped class definitions; executing the plurality of object-oriented requests on each of the plurality of data resources to retrieve the requested data from each of the plurality of data resources, wherein the plurality of data resources return the requested data in an object-oriented format compatible with the respective object-oriented framework; aggregating the data returned by the plurality of data resources in response to the object-oriented requests; and communicating the aggregated data to the client that submitted the SQL query.
Claim 12
Dependent Claim
41 words
The method of claim 9 , wherein executing the plurality of object-oriented requests further includes: communicating the plurality of object-oriented requests to the plurality of data resources; and requesting execution of the communicated object-oriented requests on the plurality of data resources.
Claim 13
Dependent Claim
45 words
The method of claim 9 , wherein converting the SQL query into the plurality of object-oriented requests further includes parsing the SQL query into the one or more elements, wherein the one or more parsed elements include data characteristics and parameters of the SQL query.
Claim 14
Dependent Claim
17 words
The method of claim 9 , wherein the plurality of data resources are remote from the client.
Claim 15
Dependent Claim
17 words
The method of claim 9 , wherein the SQL query includes an eXtensible Markup Language (XML) query.
Claim 16
Dependent Claim
17 words
The method of claim 9 , wherein the SQL query includes a select statement an execute statement.
Claim 17
Dependent Claim
43 words
The method of claim 9 , wherein the plurality of object-oriented requests include a plurality of Plain Old Java Objects (POJOs) respectively configured to be executed on the plurality of data resources to gather the requested data from the plurality of data resources.
Claim 18
Dependent Claim
39 words
The method of claim 15 , wherein the plurality of object-oriented requests executed on the plurality of data resources each include one or more object-oriented queries or object-oriented commands compatible with the object-oriented framework of the respective data resource.
Claim 19
Independent Claim
263 words
A system for modeling a relational application domain, comprising one or more processors configured to: receive a structured query language (SQL) query from a client, wherein the SQL query includes a request for data referenced or stored on a plurality of data resources, wherein each of the plurality of data resources are associated with a respective object-oriented framework; convert the SQL query into a plurality of object-oriented requests using one or more transformation policies, wherein the one or more transformation policies include at least a mapping policy that provides a uniform map for converting the SQL query into an object oriented format compatible with the object-oriented frameworks respectively associated with the plurality of data resources, wherein to convert the SQL query into the plurality of object-oriented requests, the one or more processors are further configured to: map one or more elements of the SQL query to a plurality of class definitions using the mapping policy, wherein the plurality of class definitions are respectively associated with the object-oriented frameworks of the plurality of data resources; and instantiate the plurality of object-oriented requests based on the mapped class definitions; execute the plurality of object-oriented requests on each of the plurality of data resources to retrieve the requested data from each of the plurality of resources, wherein the plurality of data resources return the requested data in an object-oriented format compatible with the respective object-oriented framework; aggregate the data returned by the plurality of data resources in response to the object oriented requests; and communicate the aggregated data to the client that submitted the SQL query.
Claim 20
Independent Claim
263 words
A system for modeling a relational application domain, comprising one or more processors configured to: receive a structured query language (SQL) query from a client, wherein the SQL query includes a request for data referenced or stored on a plurality of data resources, wherein each of the plurality of data resources are associated with a respective object-oriented framework; convert the SQL query into a plurality of object-oriented requests using one or more transformation policies, wherein the one or more transformation policies include at least a mapping policy that provides a uniform map for converting the SQL query into an object oriented format compatible with the object-oriented frameworks respectively associated with the plurality of data resources, wherein to convert the SQL query into the plurality of object-oriented requests, the one or more processors are further configured to: map one or more elements of the SQL query to a plurality of class definitions using the mapping policy, wherein the plurality of class definitions are respectively associated with the object-oriented frameworks of the plurality of data resources; and instantiate the plurality of object-oriented requests based on the mapped class definitions; execute the plurality of object-oriented requests on each of the plurality of data resources to retrieve the requested data from each of the plurality of resources, wherein the plurality of data resources return the requested data in an object-oriented format compatible with the respective object-oriented framework; aggregate the data returned by the plurality of data resources in response to the object oriented requests; and communicate the aggregated data to the client that submitted the SQL query.
Claim 21
Dependent Claim
49 words
The system of claim 17 , wherein the one or more processors are further configured to execute the plurality of object-oriented requests by: communicating the plurality of object-oriented requests to the plurality of data resources; and requesting execution of the communicated object-oriented requests on the plurality of data resources.
Claim 22
Dependent Claim
53 words
The system of claim 17 , wherein the one or more processors are further configured to convert the SQL query into the plurality of object-oriented requests by parsing the SQL query into the one or more elements, wherein the one or more parsed elements include data characteristics and parameters of the SQL query.
Claim 23
Dependent Claim
17 words
The system of claim 17 , wherein the plurality of data resources are remote from the client.
Claim 24
Dependent Claim
40 words
The system of claim 17 , further comprising: a plurality of agents configured to convert the SQL query into the plurality of object-oriented requests based on compatibility with the object-oriented frameworks respectively associated each of the plurality of data resources.
Claim 25
Dependent Claim
17 words
The system of claim 17 , wherein the SQL query includes an eXtensible Markup Language (XML) query.
Claim 26
Dependent Claim
18 words
The system of claim 17 , wherein the SQL query includes a select statement or an execute statement.
Claim 27
Dependent Claim
43 words
The system of claim 17 , wherein the plurality of object-oriented requests include a plurality of Plain Old Java Objects (POJOs) respectively configured to be executed on the plurality of data resources to gather the requested data from the plurality of data resources.
Claim 28
Dependent Claim
39 words
The system of claim 24 , wherein the plurality of object-oriented requests executed on the plurality of data resources each include one or more object-oriented queries or object-oriented commands compatible with the object-oriented framework of the respective data resource.
References Cited (Backward Citations)
US5504885A
Cited
US6601034B1
Cited
US6263342B1
Cited
US6272488B1
Cited
US6611822B1
Cited
US6470354B1
Cited
US6711582B2
Cited
US6643633B2
Cited
US6418448B1
Cited
US6571252B1
Cited
US6751646B1
Cited
US20020023091A1
Cited
WO2002035395A2
Cited
US6785675B1
Cited
US20040103088A1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2012-06-01 | 2012-12-01 | 2013-06-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2016-06-01 | 2016-12-01 | 2017-06-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2020-06-01 | 2020-12-01 | 2021-06-02 | $7700.00 | Window Closed / Lapsed |