US 2019/0057141 A1Published application

Accelerator based data integration

AssigneeInternational Business Machines Corporation

InventorsPeter Bendel, Oliver Benke, Namik Hrle, Ruiping Li, Daniel Martin, Maryela E. Weihrauch

Life of this patent

Estimating the term…

Loading patent…

Abstract

A method, system and computer program product for providing consolidated access to data of a plurality of source databases. Tables of each of the source databases are replicated to a shared accelerator. The source DBMSs are configured to dispatch queries to the accelerator for accelerating query execution. The accelerator is configured such that the replicated tables can only be accessed by the source DBMS having provided said tables for executing a dispatched query. A user can select one of the source DBMSs to act as a consolidated DBMS—C-DBMS. The C-DBMS provides the consolidated access. The user is enabled to select tables managed by another one of the DBMSs. In response to receiving the selection of the tables, the accelerator is re-configuring such that the C-DBMS is granted access also to the copies of the selected tables in the accelerator.

Claims10

Dependent claims

A computer-implemented method for providing consolidated access to data of a plurality of source databases, the method comprising:

replicating one or more tables of each of the source databases to a shared accelerator, each of the source databases being managed by a respective source DBMS configured to dispatch queries to the shared accelerator for accelerating the execution of the dispatched queries by executing the queries on the replicated table copies rather than on the tables in the respective source database, the accelerator being configured such that the replicated tables of the source databases can only be accessed for executing a dispatched query by the one of the source DBMS which has provided said replicated tables;
receiving a user's selection of a first one of the source DBMSs, the selected first source DBMS to be used as a consolidated DBMS—C-DBMS—for providing the consolidated access;
receiving a user's selection of one or more of the tables managed by a second one of the source DBMSs;
and
in response to receiving the selection of the one or more tables, re-configuring the accelerator and the C-DBMS such that the C-DBMS is enabled to access also to the replicated copies of the one or more selected tables in the accelerator.

2 more elements

Dependencies are inferred from the claim text.

Facts

Application: 16/168,220Filed 23 Oct 2018
Priority: 5 Jan 2017
Published: 21 Feb 2019
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06F 16/2282
Indexing; Data structures therefor; Storage structures: tablespace storage structures; Management thereof
G06F 16/2453
Query processing: query optimisation
G06F 16/2455
Query processing: query execution
G06F 16/27
Of structured data, e.g. relational data: replication, distribution or synchronisation of data between databases or within a distributed database…

Family

Application15/398,956Continuation · filed 5 Jan 2017
Application16/168,220Continuation
US 10,452,682 B2Related patent
US 10,545,992 B2Related patent
US 2018/0189370 A1Published application
US 2019/0057141 A1This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key