US 11,914,572 B2
Adaptive query routing in a replicated database environment
Juchang Lee, Seoul (KR); Kyu Hwan Kim, Seoul (KR); Joo Yeon Lee, Seoul (KR); Kyungyul Park, Seoul (KR); and Deok Hoe Kim, Seoul (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Dec. 22, 2022, as Appl. No. 18/087,712.
Application 18/087,712 is a continuation of application No. 15/589,160, filed on May 8, 2017, granted, now 11,573,947.
Prior Publication US 2023/0129099 A1, Apr. 27, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/248 (2019.01); G06F 16/27 (2019.01); G06F 16/2458 (2019.01); G06F 11/20 (2006.01); H04L 67/1095 (2022.01); G06F 11/16 (2006.01)
CPC G06F 16/2329 (2019.01) [G06F 11/2035 (2013.01); G06F 11/2094 (2013.01); G06F 11/2097 (2013.01); G06F 16/2322 (2019.01); G06F 16/2379 (2019.01); G06F 16/248 (2019.01); G06F 16/2471 (2019.01); G06F 16/27 (2019.01); H04L 67/1095 (2013.01); G06F 11/1658 (2013.01); G06F 11/2048 (2013.01); G06F 2201/80 (2013.01)] 40 Claims
OG exemplary drawing
 
1. A computing system comprising:
at least one hardware processor;
at least one memory coupled to the at least one hardware processor; and
one or more computer-readable storage media storing computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
at a node of a database system comprising a plurality of nodes, the plurality of nodes comprising at least one source node and at least one replica node, receiving a prepared statement from a database client, the prepared statement specifying one or more nodes of the database system useable to execute the prepared statement;
at the node, updating the prepared statement to provide an updated prepared statement, the updating comprising adding a node to the one or more nodes in the prepared statement, or removing at least one of the one or more nodes in the prepared statement, depending on a type of availability status change of the replica node, wherein the type of availability status change of the replica node is (1) the replica node becoming unavailable and the updating the prepared statement comprises not including the replica node in the updated prepared statement; or (2) the replica node becoming available and the updating the prepared statement comprises including the replica node in the updated prepared statement; and
at the node, sending the updated prepared statement to the database client.