US 12,124,451 B2
System and method for efficient integration with a primary database to reduce unnecessary network traffic
Hani M Turaish, Al Qatif (SA); and Nabeel H Althagafi, Khobar (SA)
Assigned to Saudi Arabian Oil Company, Dhahran (SA)
Filed by Saudi Arabian Oil Company, Dhahran (SA)
Filed on Mar. 20, 2023, as Appl. No. 18/186,600.
Prior Publication US 2024/0320219 A1, Sep. 26, 2024
Int. Cl. G06F 16/245 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24545 (2019.01) [G06F 16/24539 (2019.01); G06F 16/24568 (2019.01)] 14 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving, at a middleware server, an input stream of query requests each requesting an electronic information service provided by an external database of an external trusted party, wherein the query requests are issued by internal enterprise applications;
establishing a service call log table that logs service calls made to the external database of the trusted party, a mapping table that records a validity period for each combination of an enterprise application and an electronic information service provided by the external database of the trusted party, and a staging table that stores, for each electronic information service, a corresponding query result retrieved from the external database of the trusted party;
determining, by the middleware server, a first service validity period for a query request from the input stream, wherein the first service validity period is pre-determined;
determining, by the middleware server, a gap between a current date for the query request and a corresponding past date when the query request was last successfully answered by the external database;
in response to determining that the gap is smaller than the first service validity period, fetching a corresponding query result from the staging table on the middleware server, wherein the corresponding query result was received when the query request was last successfully answered by the external database; and
in response to determining that the gap is not smaller than the first service validity period, invoking a cost control logic that determines a second service validity period, wherein the second service validity period customized for each specific query request in the input stream.