Patent application EP16171927A (EP), filed 2016-05-30
Publication number: EP3252618A1
Title: DATABASE INTEGRATION SYSTEM
Abstract: The invention provides for a method of using a database assembly (100). The database assembly comprises at least three computing systems (102, 104, 106). Each of the at least three computing systems comprises at least one application (116) and a local database system (118).The database assembly further comprise a database integration system (108) and a network connection (110) between each of the at least three computing systems and the database integration system. The method comprises: receiving (200) a first root transaction (130) by the local database of a first computing system (102); executing (202) the first root transaction on the local database of the first computing system; generating (204) a first link transaction (132) by the local database of the first computing system; sending (206) the first link transaction from the first computing system to the database integration system via the network connection of the first computing system; generating (208) a first routed transaction (134, 136) for at least one of the first remaining computing systems (104, 106) by the data base integration system; sending (210) the first routed transaction to the at least one of the remaining computing systems via the network connection; and executing (212) the first routed transaction on the local database of the at least one of the remaining computer system.
IPC codes: G06F  17/    30            A I
G06F  16/    25            A I
Claims: number: 1
text: A method of using a database assembly (100), wherein the database assembly comprises:
number: 2
text: The method of claim 1, wherein the database integration system comprises at least one update queue (126) for holding routed transactions (136) before sending the routed transactions to the at least three computing systems, wherein the routed transactions comprise the first routed transaction for each of first remaining computing systems.
number: 3
text: The method of claim 2, wherein each of the at least three computing systems has a priority rating, wherein the method further comprises ordering the at least one update queue according to the priority rating.
number: 4
text: The database assembly of claim 2 or 3, wherein generating the first link transaction comprises generating a first time stamp for the first link transaction, wherein the method further comprises:
number: 5
text: The method of claim 4, wherein the method further comprises deleting one of the first routed transaction and the second routed transaction from the at least one update queue according to at least one predetermined rule if the first time stamp and the second time stamp occur within a predetermined time period.
number: 6
text: The method of any one of claims 2 through 5, wherein each of the routed transactions within the at least one update queue has a target system selected from the at least three computing systems, wherein the method further comprises:
number: 7
text: The method of claim 6, wherein the target system is an on demand computing system (114), wherein the method further comprises keeping the failed transaction in an on demand system buffer until the on demand computing system is instantiated.
number: 8
text: The method of claim 6 or 7, wherein each of the routed transactions within the at least one update queue has an originating system selected from the at least three computing systems, and wherein the method further comprises notifying the originating system when successful transactions are accepted by the target system.
number: 9
text: The method of any one of the preceding claims, wherein method further comprises:
number: 10
text: The method of any one of the preceding claims, wherein the method further comprises any one of the following:
number: 11
text: The method of any one of the preceding claims, wherein the first routed transaction comprises a database tunnel routing between the local database of the first computing system and the local database of the at least one of the remaining computer system, wherein executing the first routed transaction on the local database comprises:
number: 12
text: A database integration system (108), wherein the data base integration system comprises:
number: 13
text: The database integration system of claim 12, wherein the memory contains a data mapping library, wherein execution of the machine executable instructions further cause the processor to search the data mapping library for the first data mapping in response to receiving the first link transaction.
number: 14
text: The database integration system of claim 13, wherein execution of the machine executable instructions further cause the processor to generate the first data mapping using a data mapping algorithm if the first data mapping is not found in the data mapping library.
number: 15
text: The database integration system of claim 14, wherein the data mapping algorithm incorporates any one of the following: Intelligent mapping, machine learning, Natural Language Processing, Deep Learning, Graph Theory, Deep Linguistic processing, Neural Networks, Natural Language Understanding, Machine Translation, and combinations thereof.
Office action: search_report, dated 2017-12-06
Prior art cited: ref_id: US2015244567A1
ref_type: patent
severity: background
ref_id: US7523130B1
ref_type: patent
severity: background
ref_id: - "IBM WebSpere Administration Guide for Federated Systems Version 9", 1 January 2006 (2006-01-01), INTERNET, pages 1 - 362, XP055058352, Retrieved from the Internet <URL:ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/iiyfpe90.pdf> [retrieved on 20130403]
ref_type: npl
severity: background
ref_id: US7523130
ref_type: patent
severity: background
ref_id: - "IBM WebSpere Administration Guide for Federated Systems Version 9", INTERNET, (20060101), pages 1 - 362, URL: ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/iiyfpe90.pdf, (20130403), XP055058352 [I] 1,12 * Chapters 1, 8, 16, 17 and 26 *
ref_type: npl
severity: background
Final disposition: pending (2017-12-06)