Methods and apparatus for enterprise application integration

• US 8,335,792 B2
• Filed: 05/08/2006
• Issued: 12/18/2012
• Est. Priority Date: 05/15/2001
• Status: Active Grant

• Current Assignee: Objectstore Incorporated
• Original Assignee: Objectstore Incorporated
• Inventors: Britton, Colin P., Azmi, Amir, Kumar, Ashok, Kaufman, Noah W., Bajpai, Chandra, Angelo, Robert F.
• Primary Examiner(s): Kerzhner, Aleksandr
• Application Number:
  US11/430,258
• Publication Number:
  US 20060277227A1
• Time in Patent Office: 2,416 Days
• Field of Search: 707/758, 707/999.003
• US Class Current: 707/758
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/2462 Approximate or statistical queries
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method for enterprise application integration that uses “connectors” that can be instantiated via downloading (e.g., using Java® or other such technologies) to provide interfaces to respective disparate database systems. The databases systems may comprise any variety of now or heretofore known systems, e.g. SAP, Oracle, and so forth. The connectors can, for example, translate between a native language (or API) of the respective database systems and an internal language/protocol of the enterprise application integration system. To this end, the connectors can utilize a scripting language to access the respective database systems. Data retrieved from the database systems can be stored in a central data store in the form of RDF triplets, from which directed graphs can be generated for to generate presentations consolidated from the multiple database systems.

Claims

1. A digital data processing method for enterprise application integration, comprising:

A. with a data store, applying the first query to a plurality of data sources using connector logic associated with each of the plurality of data sources,

B. receiving with the data store, in the form of resource definition framework (“

RDF”

) triplets, information from the plurality of data sources in response to the first query,

C. with the data store, applying a second query to one or more of the plurality of data sources using connector logic associated with each of the plurality of data sources,

D. with the data store, receiving in the form of RDF triplets information from the plurality of data sources in response to the second query,

E. periodically reducing redundancies in the RDF triplets received by the data store in response to the first query and the second query, wherein the step of reducing redundancies includes combining related triplets into bags and merging triplets and bags of similar objects.

2. The method according to claim 1, wherein the step of reducing redundancies includes determining a confidence level that two or more RDF triplets represent redundant information.

3. The method according to claim 1, comprising generating the first query based on user input and applying the first query to the data store.

4. The method according to claim 3, comprising generating the first query based on user input in a web browser.

5. The method according to claim 1, comprising storing, in the connector logic, the first query for subsequent application to the plurality of data sources.

6. The method according to claim 5, comprising applying the stored query to the plurality of data sources at predetermined intervals.

7. The method according to claim 6, comprising caching information received from the plurality of data sources in the connector logic for subsequent transmittal to the data store.

8. A digital data processing method for enterprise application integration, comprising:

A. with a data store, applying the first query to a plurality of data sources using connector logic associated with each of the plurality of data sources,

B. with the data store, receiving in the form of resource definition framework (“

RDF”

) triplets information from the plurality of data sources in response to the first query,

C. with the data store, generating and applying a second query to one or more of the plurality of data sources in order to update the data store,

D. applying a third query to the data store,

E. with the data store, generating and applying a fourth query to one or more of the plurality of data sources in order to obtain information necessary to respond to the third query, based at least in part on the data store'"'"'s determination that it does not include sufficient information to respond to the third query; and

F. reducing redundancies in the RDF triplets received by the data store in response to the first query and the second query, wherein the step of reducing redundancies includes combining related triplets into bags and merging triplets and bags of similar objects.

9. The method of claim 8, wherein generating and applying a fourth query to one or more of the plurality of data sources comprises generating the fourth query based at least in part on the RDF triplets information received in response to the first query.

10. The method of claim 8, wherein the data store generates the fourth query by passing the third query to connector logic for application to the plurality of data sources.

11. The method of claim 8, wherein the data store generates the fourth query by constructing that query.

12. A digital data processing method for enterprise application integration comprising:

applying a first query to a data store,

with the data store, generating and applying a second query to one or more of a plurality of data sources in order to obtain information necessary to respond to the first query, based at least in part on the data store'"'"'s determination that it does not include sufficient information to respond to the first query;

wherein the data store applies the second query to the plurality of data sources using connector logic associated with each of the plurality of data sources and receives, in the form of resource definition framework (“

RDF”

) triplets, information from the plurality of data sources in response, the method further comprising;

reducing redundancies in the RDF triplets received by the data store in response to the first query and the second query, wherein the step of reducing redundancies includes combining related triplets into bags and merging triplets and bags of similar objects.

13. The method of claim 12, wherein the data store generates the second query by passing the first query to connector logic for application to the plurality of data sources.

14. The method of claim 12, wherein the data store generates the second query by constructing that query.

15. A digital data processing method for enterprise application integration comprising:

A. with a data store, applying a first query to a plurality of data sources using connector logic associated with each of the plurality of data sources,

B. with the data store, receiving in the form of resource definition framework (“

RDF”

) triplets information from the plurality of data sources in response to the first query,

C. applying a second query to the data store,

D. with the data store, generating and applying a third query to one or more of the plurality of data sources using the connector logic in order to obtain information necessary to respond to the second query, based at least in part on the data store'"'"'s determination that it does not include sufficient information to respond to the second query; and

E. reducing redundancies in the RDF triplets received by the data store in response to the first query and the second query, wherein the step of reducing redundancies includes combining related triplets into bags and merging triplets and bags of similar objects.

16. The method according to claim 15, comprising generating the first query based on user input and applying the first query to the data store.

17. The method according to claim 16, comprising generating the first query based on user input in a web browser.

18. The method according to claim 15, comprising storing, in the connector logic, the first query for subsequent application to the plurality of data sources.

19. The method according to claim 18, comprising applying the stored query to the plurality of data sources at predetermined intervals.

20. The method according to claim 19, comprising caching information received from the plurality of data sources in the connector logic for subsequent transmittal to the data store.

21. The method of claim 15, wherein the data store generates the third query by passing the second query to connector logic for application to the plurality of data sources.

22. The method of claim 15, wherein the data store generates the third query by constructing that query.