METHODS AND APPARATUS FOR ENTERPRISE APPLICATION INTEGRATION

• US 20080109485A1
• Filed: 10/29/2007
• Published: 05/08/2008
• Est. Priority Date: 05/15/2001
• Status: Active Grant

• Current Assignee: Objectstore Incorporated
• Original Assignee: Metatomix, Inc. (ESW Capital, LLC)
• Inventors: Azmi, Amir, Angelo, Robert, Britton, Colin, Kaufman, Noah, Kumar, Ashok, Bajpai, Chandra
• Granted Patent: US 7,831,604 B2
• Time in Patent Office: Days
• US Class Current: 707/104.1
• 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-9. -9. (canceled)

10. A digital data processing method for enterprise application integration comprising

electronically downloading to a digital data processor functionality for effecting information transfers between a first database and a second database,

executing the functionality on the digital data processor to effect transferring information between the first database and the second database, the transferring step including at least receiving information from the second database using the API and transmitting that information to the first database using the first protocol.

11. A method according to claim 10, wherein the step of transmitting information using the first protocol includes transmitting resource definition format (“

RDF”

) triplets, the step of receiving information using the API includes transforming to/from RDF triplets information from/to the second database.

12. A method according to claim 11, wherein the step transmitting information using the first protocol includes transmitting an RDF triplet whose subject comprises any of a literal value, reference value and uniform identification number (“

URI”

).

13. A method according to claim 12, wherein the step transmitting information using the first protocol includes transmitting an RDF triplet whose subject reflects transactional information.

14. A method according to claim 11, wherein the step of transmitting information using the first protocol includes transmitting an RDF triplet whose predicate comprises a URI, such that related data being transferred between the first and second databases is represented by URIs in a hierarchical ordering.

15. A method according to claim 11, wherein the step transmitting information using the first protocol includes transmitting an RDF triplet through whose object each related predicate and subject can be referenced.

16. A method according to claim 11, wherein the step of transmitting information using the first protocol includes transmitting an RDF triplet whose object is any of a literal or an identifier.

17. A method according to claim 11, wherein the step of transmitting information using the first protocol includes transmitting an representing any of marketing information or an e-commerce or other transaction.

18-22. -22. (canceled)

23. A digital data processing method for enterprise application integration comprising

downloading functionality for effecting information transfers between a first database and a second database,

storing a query for application to the second database,

transferring information between the first database and the second database,

the transferring step including applying a query to the second database using an application program interface (“

API”

) associated therewith, receiving information from the second database using the API and caching it for subsequent transfer to the first database.

24. A method according to claim 23, wherein the wherein the transforming step includes transmitting the cached information to the first database using the first protocol.

25. A method according to claim 24, wherein the wherein the transferring step includes transmitting the cached information to the first database as RDF triplets.

26. A method according to claim 25, wherein the step of transmitting RDF triplets includes transmitting triplets wherein at least one of

a subject comprises any of a literal value, reference value and uniform identification number (“

URI”

),

a predicate comprises a URI such that related data being transferred between the first and second databases is represented by URI'"'"'s in a hierarchical ordering,

an object relates a predicate and subject comprising any of a literal or identifier.

27. A digital data processing method for enterprise application integration comprising storing, in a data store, RDF triplets representing transactional information received from each of a plurality of databases.

28. A method according to claim 27, wherein at least one of the databases stores data other than as RDF triplets.

29. A method according to claim 27, wherein the storing step includes storing an RDF triplet whose subject comprises any of a literal value, reference value and uniform identification number (“

URI”

).

30. A method according to claim 27, wherein the storing step includes storing an RDF triplet whose subject reflects transactional information.

31. A method according to claim 27, wherein the storing step includes storing an RDF triplet whose predicate comprises a URI, such that related data from the databases is represented by URIs in a hierarchical ordering.

32. A method according to claim 27, wherein the storing step includes storing an RDF triplet through whose object each related predicate and subject can be referenced.

33. A method according to claim 27, wherein the storing step includes storing an RDF triplet whose object is any of a literal or an identifier.

34. A method according to claim 27, wherein the storing step includes storing and RDF triplet representing any of marketing information or an e-commerce or other transaction.

35. A method according to claim 27, comprising storing a query for application to at least one of the databases.

36. A digital data processing method for enterprise application integration comprising storing, in a data store, RDF triplets representing transactional information received from each of a plurality of databases and periodically removing redundancies in the RDF triplets.

37. A method according to claim 36, wherein the step of reducing redundancies includes combining related triplets into bags.

38. A method according to claim 36, wherein the step of reducing redundancies includes determining a confidence level that two or more triplets represent redundant information.

39. A digital data processing method for enterprise application integration comprising

storing, in a data store, RDF triplets representing transactional information received from each of a plurality of databases,

generating a directed graph from the RDF triplets.

40. A method according to claim 39, comprising the step of generating the directed graph in response to a query.

41. A method according to claim 39, wherein the directed graph reflects any of marketing information or an e-commerce or other transaction.

42. A method according to claim 39, wherein the storing step includes storing RDF triplets wherein at least one of

a subject comprises any of a literal value, reference value and uniform identification number (“

URI”

),

a predicate comprises a URI such that related data being transferred between the first and second databases is represented by URI'"'"'s in a hierarchical ordering,

an object relates a predicate and subject comprising any of a literal or identifier.

43. A digital data processing method for enterprise application integration comprising storing, in a data store, RDF triplets representing transactional information received from each of plurality of databases,

generating a directed graph from the RDF triplets,

parsing the directed graph and presenting therefrom information from one or more of the databases.

44. A method according to claim 43 wherein the parsing step includes parsing the directed graph and presenting therefrom consolidated information from plural ones of the databases.

45. A method according to claim 43 wherein the presenting step includes presenting the information on a web browser.

46-52. -52. (canceled)