International Business Machines Corporation

Kyndryl, Inc.

Ruiping Li

Namik Hrle

Daniel Martin

Guogen Zhang

Oliver Benke

Peter Bendel

Maryela Evelin Weihrauch

Oliver Draese

Knut Stolze

Mengchu Cai

Al Chakra

Andreas Brodt

Terence Patrick Purcell

Roland Seiffert

Oliver Koeth

Lee-Chin Hsu Liu

Claus Kempfert

Irene Ching-Hua Liu

Lily Zhou

Robert S Muse

Brian M O'Connell

Yun Yu Wang

Wei Ey Li

Robert William Lyle

Shelbee D Smith-Eigenbrode

Thomas Abel Beavin

James Alan Ruddy

Shantan Kethireddy

Yao-Ching Stephen Chen

Yefim Shuf

Brian Thinh-Vinh Tran

Bjoern Broll

Xiaohong Fu

Yao Ching Stephen Chen

Gary W Crupi

James D Johnston, Jr

Ding-Wei Chieh

Hsuiying Yen Cheng

David D Weck

Susan K Schreitmueller

Douglas G Kinnaird

David R Trotter

Sachin P Sant

A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.

Optimizing query processing and routing in a hybrid workload optimized database system

A blockchain may store transactions for various purposes which may be later accessed by interested parties for ledger verification. One example method of operation may comprise one or more of receiving a blockchain transaction, identifying a proof-of-work is generated for the blockchain transaction via a network entity, transmitting the proof-of-work and a select portion of ledger data to a registered third party via an encrypted message based on a third party key, validating the proof-of-work via the third party, and providing a reward to the network entity.

Triggering actions responsive to blockchain transactions

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&#x2014;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.

Accelerator based data integration

A mechanism is provided for generating statistical information for query optimization in a data processing system. The mechanism comprises a first database engine maintaining a current first dataset currently being stored, a second database engine maintaining a second dataset. The second dataset is generated from previous first datasets or from the previous first datasets and current first dataset, the previous first datasets being datasets that were previously maintained by the first database engine. The first database engine receives a database query for accessing the first dataset, the database query involving one or more attributes of the first data set. The first database engine generates a query execution plan for the database query on the first dataset using collected statistical information on at least the second dataset. The first database engine processes the database query according to the query execution plan.

Query optimization in hybrid DBMS

A distributed database system (or federated database system) where a catalogue is used to store metadata descriptive of data containers for the constituent database system(s) and/or accelerator system(s) of the federated database. In response to the generation of the trigger signal corresponding to a database definition language (DDL) statement, the accelerator system updates metadata in the catalogue.

Distributed system with accelerator and catalog

A central relational database management system (RDBMS) is operatively interconnected to one or more back-end database systems. A set of different query criteria specified for each of different types of queries for a mixed query workload is evaluated. At least one remote derived source of data requested by at least one of the different types of queries is dynamically created using at least one of the one or more back-end database systems that supports remote processing of the at least one of the different types of queries.

Runtime creation of remote derived sources for query offload

A distributed database system (or federated database system) where a catalog is used to store metadata descriptive of data containers for the constituent database system(s) and/or accelerator system(s) of the federated database. In response to the generation of the trigger signal corresponding to a database definition language (DDL) statement, the accelerator system updates metadata in the catalog.

An indication of data of a first table in a first database is received. The data includes one or more rows of data. The indicated data is transferred from the first table in the first database component to a backup table in the same database component. The data is transferred from the backup table to a second table in a second database component.

Row-based archiving in database accelerators

Embodiments disclosed herein generally relate to techniques for managing processing of data in computing systems. One embodiment provides a method which includes receiving a set of inputs to apply to at least a first big data definition. Each big data definition encapsulates information specified in the set of inputs into a set of reusable software components. The method also includes generating, based on the reusable software components, a first executable code component for the at least first big data definition. The method further includes deploying the first executable code component to an executing application without interrupting services provided by the executing application to which the first executable code component is deployed.

Big data assistant

A system and method is provided for query processing comprises: creating an index of a database and ordering a set of index candidates from the index into a list based on a set of heuristic rules. A query defining a query path is then reduced into a list of single path expressions. Each index candidate is matched against the list of single path expressions according to the ordering of the index candidates. The matched candidate nodes are also verified to insure that they satisfy the query path.

Efficient method of using XML value indexes without exact path information to filter XML documents for more specific XPath queries

Growing community of inventors

San Jose, CA, United States of America

Ruiping Li