Integration flow database runtime
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.
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;
processing, using a computer and a database integration flow (DIF) runtime, the relational data from the start table, wherein the DIF runtime 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; and
retrieving the result data from the end table for transmission to the receiving application.
2. The computer-implemented method of claim 1 , comprising deserializing data received from the sending application into the relational data for insertion into the start table of the database.
3. The computer-implemented method of claim 1 , comprising detecting a change in the start table or in the end table.
4. The computer-implemented method of claim 3 , wherein the detected change in the start table or in the end table is triggered by a database operation performed by the sending application or by the DIF runtime, respectively.
5. The computer-implemented method of claim 1 , comprising serializing the result data.
6. The computer-implemented method of claim 5 , comprising passing the serialized data to a transmission application.
7. The computer-implemented method of claim 6 , comprising transmitting, using the transmission application, the serialized data to the receiving application.
8. A non-transitory, computer-readable medium storing one or more 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;
process, using a database integration flow (DIF) runtime, the relational data from the start table, wherein the DIF runtime 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; and
retrieve the result data from the end table for transmission to the receiving application.
9. The non-transitory, computer-readable medium of claim 8 , comprising one or more computer-readable instructions to deserialize data received from the sending application into the relational data for insertion into the start table of the database.
10. The non-transitory, computer-readable medium of claim 8 , comprising one or more computer-readable instructions to detect a change in the start table or in the end table.
11. The non-transitory, computer-readable medium of claim 10 , wherein the detected change in the start table or in the end table is triggered by a database operation performed by the sending application or by the DIF runtime, respectively.
12. The non-transitory, computer-readable medium of claim 8 , comprising one or more computer-readable instructions to serialize the result data.
13. The non-transitory, computer-readable medium of claim 12 , comprising one or more computer-readable instructions to pass the serialized data to a transmission application.
14. The non-transitory, computer-readable medium of claim 13 , comprising one or more computer-readable instructions to transmit, using the transmission application, the serialized data to the receiving application.
15. A computer-implemented system comprising:
a computer memory configured to hold a database integration flow (DIF) runtime;
a computer processor interoperably coupled with the computer memory and configured to:
insert relational data associated with a sending application and selected for sending to a receiving application into a start table of a database;
process, using the DIF runtime, the relational data from the start table, wherein the DIF runtime 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; and
retrieve the result data from the end table for transmission to the receiving application.
16. The computer-implemented system of claim 15 , configured to deserialize data received from the sending application into the relational data for insertion into the start table of the database.
17. The computer-implemented system of claim 15 , configured to detect a change in the start table or in the end table.
18. The computer-implemented system of claim 17 , wherein the detected change in the start table or in the end table is triggered by a database operation performed by the sending application or by the DIF runtime, respectively.
19. The computer-implemented system of claim 15 , configured to serialize the result data.
20. The computer-implemented system of claim 19 , configured to pass the serialized data to a transmission application for transmission to the receiving application.