Integration flow database runtime

Patent metadata

Field	Value
Publication number	US-9411845-B2
Application number	US-201313916889-A
Country	US
Kind code	B2
Filing date	Jun 13, 2013
Priority date	Jun 13, 2013
Publication date	Aug 9, 2016
Grant date	Aug 9, 2016

Abstract

The present disclosure describes methods, systems, and computer program products for providing application integration functionality directly on a relational database according to an implementation. One computer-implemented method includes inserting relational data into a start table of a database, detecting a change in the start table, retrieving the inserted relational data from the start table, processing, using a computer, the relational data using a database integration flow runtime into result data, inserting the result data into an end table of the database, detecting a change in the end table, and retrieving the result data from the end table.

First claim

What is claimed is:

1. A computer-implemented method comprising:
inserting relational data associated with a sending application and selected for sending to a receiving application into a start table of a database, the sending application having access to the database;
detecting a change in the start table;
retrieving the inserted relational data from the start table;
processing, using a computer, the relational data using a database integration flow runtime that compiles an integration design pattern into database constructs for converting the relational data into result data;
inserting the result data into an end table of the database;
detecting a change in the end table; and
retrieving the result data from the end table.

2. The method of claim 1 , further comprising selecting the relational data from a source table of the database.

3. The method of claim 1 , further comprising inserting the result data into a target table of the database.

4. The method of claim 1 , further comprising:
serializing the result data;
passing the serialized data to a transmission application; and
transmitting the serialized data.

5. The method of claim 3 , further comprising deserializing received data into relational data.

6. The method of claim 5 , further comprising:
serializing the result data for transmission;
passing the serialized data to a transmission application; and
transmitting the serialized data.

7. A non-transitory, computer-readable medium storing computer-readable instructions executable by a computer to:
insert relational data associated with a sending application and selected for sending to a receiving application into a start table of a database, the sending application having access to the database;
detect a change in the start table;
retrieve the inserted relational data from the start table;
process the relational data using a database integration flow runtime that compiles an integration design pattern into database constructs for converting the relational data into result data;
insert the result data into an end table of the database;
detect a change in the end table; and
retrieve the result data from the end table.

8. The medium of claim 7 , further comprising instructions to select the relational data from a source table of the database.

9. The medium of claim 7 , further comprising instructions to insert the result data into a target table of the database.

10. The medium of claim 7 , further comprising instructions to:
serialize the result data;
pass the serialized data to a transmission application; and
transmit the serialized data.

11. The medium of claim 9 , further comprising instructions to deserialize received data into relational data.

12. The medium of claim 11 , further comprising instructions to:
serialize the result data for transmission;
pass the serialized data to a transmission application; and
transmit the serialized data.

13. A computer-implemented system comprising:
a memory configured to hold a database integration flow runtime;
a processor interoperably coupled with the memory and configured to perform operations comprising:
insert relational data associated with a sending application and selected for sending to a receiving application into a start table of a database, the sending application having access to the database;
detect a change in the start table;
retrieve the inserted relational data from the start table;
process the relational data using the database integration flow runtime that compiles an integration design pattern into database constructs for converting the relational data into result data;
insert the result data into an end table of the database;
detect a change in the end table; and
retrieve the result data from the end table.

14. The system of claim 13 , further configured to select the relational data from a source table of the database.

15. The system of claim 13 , further configured to insert the result data into a target table of the database.

16. The system of claim 13 , further configured to:
serialize the result data;
pass the serialized data to a transmission application; and
transmit the serialized data.

17. The system of claim 15 , further configured to deserialize received data into relational data.

18. The system of claim 17 , further configured to:
serialize the result data for transmission;
pass the serialized data to a transmission application; and
transmit the serialized data.

Assignees

• Mathis Christian
• Ritter Daniel
• Sap Se

Inventors

• Mathis Christian
• Ritter Daniel

Classifications

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• G06F16/24549

  Run-time optimisation · CPC title

• G06F16/23

  Updating · CPC title

• G06F16/284

  Relational databases · CPC title