Invention Grant
- Patent Title: Efficient workload balancing in replicated databases based on result lag computation
-
Application No.: US16836469Application Date: 2020-03-31
-
Publication No.: US11379477B2Publication Date: 2022-07-05
- 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 is configured to provide a database system. The computer system comprises one or more processors, a primary database system implemented by the one or more processors, and a secondary database system implemented by the one or more processors. 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
- US20210303572A1 Efficient Workload Balancing in Replicated Databases Based on Result Lag Computation Public/Granted day:2021-09-30
Information query