Query dispatching system and method

A computer system for dispatching a database request, the computer system comprising:

• a plurality of databases;
• a database management system (DBMS) that manages the plurality of databases;
• the DBMS operated to:
• receive a database request;
• determine a plurality of latency times corresponding to a plurality of respective databases managed by the DBMS, wherein the latency times for each database of the plurality of databases are current estimates of the times to complete replications from the other databases of the plurality of databases of all unreplicated data changes in the other databases;
• determine, for each database of the plurality of databases, a capture velocity, which is a number of data changes applied to the database that can be identified in a predefined time interval, and an apply velocity, which is a number of identified data changes that can be applied to the database in a predefined time interval;
• determine, for each database of the plurality of databases, an estimated time to complete the database request;
• identify a database of the plurality of databases having an estimated minimum time of execution of the database request, wherein the time of execution for each database of the plurality of databases 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;
• and
• dispatch the database request to the database of the plurality of databases having the estimated minimum time of execution of the database request.

A computer program product for dispatching a database request, the computer program product comprising:

• one or more non-transitory computer readable storage media and program instructions stored on at least one of the one or more non-transitory computer readable storage media, the program instructions, when executed by a computer, cause the computer to perform a method comprising:
• receiving, by a database management system (DBMS), a database request;
• determining, by the DBMS, a plurality of latency times corresponding to a plurality of respective databases managed by the DBMS, wherein the latency times for each database of the plurality of databases are current estimates of the times to complete replications from the other databases of the plurality of databases of all unreplicated data changes in the other databases;
• determining, by the DBMS, for each database of the plurality of databases, a capture velocity, which is a number of data changes applied to the database that can be identified in a predefined time interval, and an apply velocity, which is a number of identified data changes that can be applied to the database in a predefined time interval;
• determining, by the DBMS, for each database of the plurality of databases, an estimated time to complete the database request;
• identifying, by the DBMS, a database of the plurality of databases having an estimated minimum time of execution of the database request, wherein the time of execution for each database of the plurality of databases 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;
• and
• dispatching, by the DBMS, the database request to the database of the plurality of databases having the estimated minimum time of execution of the database request.