International Business Machines Corporation

Vassil Radkov Dimov

Daniel Martin

Johannes S Kern

Christian Michel

Jens Müller

Felix O Beier

Eirini Kalogeiton

Knut Stolze

Namik Hrle

Reinhold Geiselhart

Christian Wilhelm Paul Hoerst

Iliyana P Ivanova

Frank Küster

Zalina Baysarova

Aaron K Baughman

Dennis Butterstein

Sowmya Kameswaran

Manogari Nogi Simanjuntak

Basem Elasioty

Kevin Pelletier

Adnan Ahmad

Jéssica Costa Da Rocha

Samy Tafasca

Zeyuan Zhang

Kareem Amin

Stephane Rodet

Cornelius Wiehl

According to one embodiment, a method, computer system, and computer program product for performing data synchronization between a source DBMS, comprising a trusted database, and a target DBMS, comprising an untrusted datastore and a trusted datastore, is disclosed. The present invention may include upon the source DBMS performing an update to an object in the trusted source database, sending the object change to a trusted data replication engine, encrypting the object change, sending the encrypted object change with a related decryption key to the target DBMS, upon receiving the encrypted object change and the related decryption key at the target DBMS, searching an object related to the object change in the untrusted target data store, identifying a decryption key for the searched object, replacing the identified decryption key by the received decryption key, and integrating the encrypted object change in encrypted form into the untrusted target data store.

Restricting data access to target databases

The present disclosure relates to a method for enabling access to data of a data analysis system by a set of one or more external database systems. The data analysis system comprises a source database system and target database system. The data analysis system is configured for synchronizing the data in the source database system with the target database system using a primary source transaction log in the source database system. The method comprises: creating a secondary transaction log. Data changes applied at the target database system may be received from the target database system. At least one log entry that represents each received data change may be creating in the secondary transaction log. The secondary transaction log may be used by the set of external database systems for applying data changes according to the secondary transaction log, thereby storing the data in the set of external database systems.

Access to data of a data analysis system by external database systems

A computer-implemented method for detecting a change in a meta-environment is disclosed. The method comprises collecting historic parameter values from at least one actor being active in the meta-environment, wherein each of the at least one actors has a set of abilities represented by parameters relating to the collected parameter values, collecting current parameter values from the at least one actor being active in the meta-environment, determining weight values of the collected historic parameters and weight values of the collected current parameters, and upon a value of a function of the determined weight values of the historic parameters and the weight values of the collected current parameters being greater than a predefined threshold value, determining a detection of the change in the meta-environment.

Detecting meta-environment changes

A method for executing a query on a target database against the most recent source data is disclosed. The method comprises maintaining linked—i.e., at least partially synchronized—databases comprising a source and a target database. The method comprises receiving a direct query against a table in the target database, the query comprising a request for using the most recent source data and requesting by the target database from the source database a status about latest data regarding the table. Upon the status indicating that data in the table do not correspond to the most recent data, the method comprises waiting up to a predefined time period for the most recent data of the table to be synchronized from the source database to the target database, and upon the data of the table not being synchronized within the predefined time period, the method comprises issuing a timeout signal.

Query execution on a replicated database with most recent data

In an approach, a processor receives a data manipulation request on a target database. A processor sends the data manipulation request to a source database. The source database attempts to persist a data manipulation action relating to the data manipulation request. Responsive to a successful attempt to persist the data manipulation action: the source database sends a log position of the data manipulation action to a data replication engine; a processor replicates the data manipulation request triggering the data manipulation action in the target database; and a processor confirms to the target database that the data manipulation action in the target database has been completed.

Bidirectional data replication with wait for data function

The present disclosure relates to a method for data synchronization between a source database system and target database system, wherein execution of a database transaction of the source database system is complete if a processing step followed by an application step of the database transaction is performed. For each identified database transaction, a processing step and/or application step may be performed.

Data synchronization between a source database system and target database system

Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: receiving by primary database system a query statement that references a first table, wherein the primary database system is associated to a first accelerator database system and a second accelerator database system, wherein modifications performed on tables of the primary database system are iteratively replicated into the first accelerator database system and the second accelerator database system; examining latency data that specifies a latency with which a modification to the first table has been replicated into the first accelerator database system and a latency with which a modification to the first table has been replicated into the second accelerator database system; selecting, in dependence on the examining, the first accelerator database system for execution of the query statement; routing the query statement to the first accelerator database system for execution in response to the selecting.

Reduced latency query processing

Creating at a target database system, a target table and a history table each having a set of attributes of a source table in addition to at least one time attribute, wherein the time attribute of a record indicates the time when the record is valid. Receiving a request for applying a change of the source table to the target table. The request comprises a time value generated by the source database system indicating a time of the change. The change to the target table and the time value may be assigned to the time attribute of the current version and previous version of the record. The previous version of the record may be stored in the history table. The target table and the history table may be used to process a redirected query comprising a selection criterion on the time attribute.

Maintaining at a target database system a copy of a source table of a source database system

The present disclosure relates to a computer implemented method for applying changes into tables of a target database system using a data synchronization system, the data synchronization system being configured to automatically use at least one configurable parameter for applying a requested change in the target database system. The method provides a trained machine learning model, the machine learning model being configured to adjust the at least one configurable parameter based on a workload level. The method determines a current workload level at the target database system and uses the machine learning model for adjusting the at least one configurable parameter according to the determined workload level.

Machine learning based application of changes in a target database system

Aspects of the present disclosure relate to enhancing reading retention of users reading electronic text. A set of user data associated with a user currently reading electronic text on a device is received, the set of user data indicative of a reading retention of the user. The set of user data is analyzed to determine whether a retention enhancement action should be issued. In response to a determination that a retention action should be issued, the retention enhancement action is issued at the device the user is currently reading electronic text on.

Memory retention enhancement for electronic text

According to one embodiment, a method, computer system, and computer program product for data synchronization between a source database system and a target database system, the source database system including a source dataset and the target database system including a target dataset that is configured to include a copy of the source dataset. The embodiment may include configuring the target database system to detect data changes in the source dataset. The embodiment may include applying the detected data changes on the target dataset.

Growing community of inventors

Stuttgart, Germany

Vassil Radkov Dimov