Invention Grant
- Patent Title: Efficient workload balancing in replicated databases based on result lag computation
-
Application No.: US17722104Application Date: 2022-04-15
-
Publication No.: US11625397B2Publication Date: 2023-04-11
- Inventor: Yinghua Ouyang , Zhen Tian
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2458 ; G06F16/27 ; G06F16/23 ; G06F9/50

Abstract:
A computer system comprises one or more processors, a primary database system, and a secondary database system. The secondary database system is configured as a hot-standby system for the primary database system. The secondary database system is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system. The primary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to determine from a query request from a client application directed to the primary database system that workload from a query may be shifted to the secondary database system and selectively instruct the client application to direct the secondary database system to execute the query based on a per-table calculated result lag. Related apparatus, systems, techniques and articles are also described.
Public/Granted literature
- US20220245149A1 EFFICIENT WORKLOAD BALANCING IN REPLICATED DATABASES BASED ON RESULT LAG COMPUTATION Public/Granted day:2022-08-04
Information query