Invention Grant
- Patent Title: Query dispatching system and method
-
Application No.: US15944816Application Date: 2018-04-04
-
Publication No.: US10762108B2Publication Date: 2020-09-01
- Inventor: Namik Hrle , Andreas Lohrer , Daniel Martin , Matthias Tschaffler
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Dmitry Paskalov
- Priority: com.zzzhc.datahub.patent.etl.us.BibliographicData$PriorityClaim@5d1b28ba
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/27 ; G06F16/22 ; G06F16/23

Abstract:
Dispatching a database request. A database request is received. Latency times are determined for databases managed by the DBMS, the latency times being estimates of the times to complete replications from the other databases of all unreplicated data changes in the other databases. For each database, a capture velocity and an apply are determined, which are a number of data changes applied to the database that can be identified or applied in a predefined time interval. For each database, an estimated time to complete the database request is determined. The database request is dispatched to the database having an estimated minimum time of execution of the database request, wherein the time of execution is function of the estimated time for the database to complete the database request, the latency time of the database, and the capture and apply velocities of the database.
Public/Granted literature
- US20180225350A1 QUERY DISPATCHING SYSTEM AND METHOD Public/Granted day:2018-08-09
Information query