US 12,189,603 B2
Flexible routing of database operations accessing remote tables
Won Wook Hong, Suwon (KR); Joo Yeon Lee, Seoul (KR); Hyeong Seog Kim, Seoul (KR); Jane Jung Lee, Ansan (KR); and Younkyoung Lee, Bucheon (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Oct. 21, 2022, as Appl. No. 17/971,506.
Prior Publication US 2024/0134838 A1, Apr. 25, 2024
Prior Publication US 2024/0232159 A9, Jul. 11, 2024
Int. Cl. G06F 16/23 (2019.01)
CPC G06F 16/23 (2019.01) 20 Claims
OG exemplary drawing
 
1. A computing system comprising:
at least one memory;
one or more hardware processor units coupled to the at least one memory; 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 database system, receiving a first request for one or more database operations;
determining that a first database operation of the one or more database operations of the first request comprises a first data request for a first remote data object, the first remote data object located on a first remote computing system accessed by the database system using data federation;
determining whether the first database operation includes an insert, delete, or update operation for the first remote data object;
in response to determining that the first database operation does not include an insert, delete, or update operation for the first remote data object, assigning the first database operation to a first non-anchor node of the database system, wherein data operations for remote data sources that do not include an insert, delete, or update operation for a remote data object are assignable for execution by a non-anchor node of the database system or by an anchor node of the database system;
causing the first database operation to be executed by the first non-anchor node;
determining that a second database operation, the second database operation being a database operation of the one or more database operations of the first request or a database operation of a second request for one or more database operations, comprises a second data access request for the first remote data object;
determining whether the second database operation includes an insert, delete, or update operation for the first remote data object;
in response to determining that the second database operation includes an insert, delete, or update operation for the first remote data object, causing the second database operation to be performed by the anchor node;
at the database system, after causing the second database operation to be performed at the anchor node, receiving a third request for one or more database operations, wherein a database operation of the one or more database operations of the third request comprises a read request; and
causing the third database operation to be performed by the anchor node.