×

Bridging native JDBC calls with DBaaS using ESB

  • US 10,489,402 B2
  • Filed: 11/08/2016
  • Issued: 11/26/2019
  • Est. Priority Date: 11/08/2016
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • receiving, by an Enterprise Service Bus (ESB) component of an ESB system, from a first system, a database query formatted in a first format;

    generating a Structured Query Language (SQL) query plan for executing the database query, wherein the SQL query plan comprises a plurality of operations;

    generating an execution sequence based on the SQL query plan, by mapping each of the plurality of operations within the SQL query plan to be processed by either the ESB component a second system, wherein mapping the plurality of operations comprises;

    upon determining that a first operation of the plurality of operations is a database operation used to insert data into a database, generating an HTTP request to carry out the first operation, wherein the HTTP request is a POST request;

    mapping, to the second system, the first operation comprising the HTTP request; and

    mapping, to the ESB component, a second operation comprising a data processing operation to be performed on a result of the database operation;

    transmitting, based on the mapping, the HTTP request to a RESTful API provided by the second system, wherein the second system is configured to execute the HTTP request against the database;

    receiving, by the ESB component, from the second system, a first set of results generated by executing the HTTP request against the database;

    generating, by the ESB component, a set of query results for the database query by processing the received first set of results, comprising executing, based on the mapping, the data processing operation on the first set of results received from the second system; and

    sending, to the first system, the set of query results.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×