Multiple source database system consolidation

Patent metadata

Field	Value
Publication number	US-11093477-B1
Application number	US-202016820790-A
Country	US
Kind code	B1
Filing date	Mar 17, 2020
Priority date	Mar 17, 2020
Publication date	Aug 17, 2021
Grant date	Aug 17, 2021

Abstract

A method, system, and program product for enabling multiple source database coherency is provided. The method includes detecting an incoming query to be executed with respect to an accelerator server. An initial timestamp of the incoming query is analyzed and additional timestamps of database tables referenced by the incoming query are retrieved. It is determined that each timestamp of the additional timestamps is reached with respect to a corresponding replication engine and target data from the database tables is synchronized with source data of a source database. In response, the incoming query is accelerated for execution with respect to a target database management system.

First claim

What is claimed is:

1. A multiple source database coherency method comprising:
detecting, by a processor of an accelerator server, an incoming query to be executed with respect to said accelerator server;
analyzing, by said processor, an initial timestamp of said incoming query;
retrieving, by said processor, additional timestamps of database tables referenced by said incoming query;
first determining, by said processor, that each timestamp of said additional timestamps is reached with respect to a corresponding replication engine of said accelerator server;
determining, by said processor based on results of said analyzing and said first determining, that target data from said database tables referenced by said incoming query and located within a target database management system (DBMS) is synchronized with source data of a source DBMS; and
accelerating, by said processor in response to results of said determining, said incoming query for execution with respect to said target DBMS.

2. The method of claim 1 , wherein said accelerator server comprises a shared accelerator server configured to be shared between multiple source DBMS' operating in combination with respect to specified data associated with incoming analytical process based queries executed with respect to a first source DBMS of said multiple source DBMS', and wherein said incoming analytical process based queries are enabled to access additional data from additional DBMS' of said multiple source DBMS' without physically hosting said additional data.

3. The method of claim 2 , further comprising:
loading, by said processor, input data of at least one database table of said database tables from various source DBMS' of said multiple source DBMS' into said shared accelerator server;
executing, by said processor in response to determining that said incoming analytical process requires access data from various source DBMS', grant step code providing temporary access to a requestor DBMS comprising source tables of said database tables within said source DBMS; and
executing, by said processor, reference creation code executed for creating an executable link within said requestor DBMS for accessing database tables requiring accessed data within said requestor DBMS.

4. The method of claim 3 , further comprising:
executing, by said processor, at least one incoming query from said requestor DBMS, wherein said at least one incoming query requires access, via said accelerator server, to data of database tables within said source DBMS.

5. The method of claim 1 , further comprising:
determining, by said processor, that access to data of said source DBMS has completed;
executing, by said processor in response to said determining that said access to said data of said source DBMS has completed, a reference removal process with respect to said target DBMS; and
revoking, by said processor, previously enabled permissions associated with enabling data sharing between a data requestor and said source DBMS.

6. The method of claim 1 , further comprising:
determining, by said processor, that data for a group of tables of said database tables referenced by said incoming query is not current with respect to data of said source DBMS; and
disabling, by said processor, execution of said incoming query until the data between said source DBMS and said target DBMS is currently synchronized.

7. The method of claim 1 , further comprising:
granting, by said processor, temporary access by said accelerator server to said target DBMS.

8. The method of claim 1 , further comprising:
providing at least one support service for at least one of creating, integrating, hosting, maintaining, and deploying computer-readable code in the control hardware, said code being executed by the computer processor to implement: said detecting, said analyzing, said retrieving, said first determining, said determining, and said accelerating.

9. A computer program product, comprising a computer readable hardware storage device storing a computer readable program code, said computer readable program code comprising an algorithm that when executed by a processor of an accelerator server implements a multiple source database coherency method, said method comprising:
detecting, by said processor, an incoming query to be executed with respect to said accelerator server;
analyzing, by said processor, an initial timestamp of said incoming query;
retrieving, by said processor, additional timestamps of database tables referenced by said incoming query;
first determining, by said processor, that each timestamp of said additional timestamps is reached with respect to a corresponding replication engine of said accelerator server;
determining, by said processor based on results of said analyzing and said first determining, that target data from said database tables referenced by said incoming query and located within a target database management system (DBMS) is synchronized with source data of a source DBMS; and
accelerating, by said processor in response to results of said determining, said incoming query for execution with respect to said target DBMS.

10. The computer program product of claim 9 , wherein said accelerator server comprises a shared accelerator server configured to be shared between multiple source DBMS' operating in combination with respect to specified data associated with incoming analytical process based queries executed with respect to a first source DBMS of said multiple source DBMS', and wherein said incoming analytical process based queries are enabled to access additional data from additional DBMS' of said multiple source DBMS' without physically hosting said additional data.

11. The computer program product of claim 10 , wherein said method further comprises:
loading, by said processor, input data of at least one database table of said database tables from various source DBMS' of said multiple source DBMS' into said shared accelerator server;
executing, by said processor in response to determining that said incoming analytical process requires access data from various source DBMS', grant step code providing temporary access to a requestor DBMS comprising source tables of said database tables within said source DBMS; and
executing, by said processor, reference creation code executed for creating an executable link within said requestor DBMS for accessing database tables requiring accessed data within said requestor DBMS.

12. The computer program product of claim 11 , wherein said method further comprises:
executing, by said processor, at least one incoming query from said requestor DBMS, wherein said at least one incoming query requires access, via said accelerator server, to data of database tables within said source DBMS.

13. The computer program product of claim 9 , wherein said method further comprises:
determining, by said processor, that access to data of said source DBMS has completed;
executing, by said processor in response to said determining that said access to said data of said source DBMS has completed, a reference removal process with respect to said target DBMS; and
revoking, by said processor, previously enabled permissions associated with enabling data sharing between a data requestor and said source DBMS.

14. The computer program product of claim 9 , wherein said method further comprises:
determining, by said processor, that data for a group of tables of said database tables referenced by said incoming query is not current with respect to data of said source DBMS; and
disabling, by said processor, execution of said incoming query until the data between said source DBM

Assignees

• IBM

Inventors

• Martin Daniel
• Zhong Jia Heng
• Kameswaran Sowmya
• Simanjuntak Manogari Nogi

Classifications

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F16/245 Primary

  Query processing · CPC title

• G06F16/182

  Distributed file systems · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/178

  Techniques for file synchronisation in file systems · CPC title