International Business Machines Corporation

Johannes S Kern

Felix O Beier

Daniel Martin

Christian Wilhelm Paul Hoerst

Vassil Radkov Dimov

Jens Müller

Stefan Renner

Eirini Kalogeiton

Knut Stolze

Oliver Benke

Eberhard Schoeck

Tunca Karabel

Philipp Klippel

Klaus J Liegert

Namik Hrle

Luis Eduardo Oliveira Lizardo

Nicole Finnie

Kevin Pelletier

Mehmet Cuneyt Goksu

Christian W P Hoerst

Timotheus Db Giuliani

Timotheus D B Giuliani

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

A method for processing an unsupported data type in a database is disclosed. The method for processing an unsupported data type in a database comprises detecting, while copying data from a primary to a secondary database, a table for data comprising a data type that is unsupported by the secondary database. Furthermore, the method comprises generating a base table in the secondary database as a copy of the detected table of the primary database without the data of the unsupported data type, generating an additional table in the secondary database for data of the unsupported data type, and linking the additional table to the base table in the secondary database via a row-identifier relationship. Additionally, the method comprises accessing data of the unsupported data type via the additional table while performing queries against the secondary database.

Large object data type support for column-based database system

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

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

A technique for logging tasks in a computer system. Tasks are logged into the computer system by executing at least one task at the computer system. A set of log metadata and a set of log levels of log records of the at least one task may be determined from an execution log output of the at least one task. Execution outputs of a further task may be determined according to the determined set of log metadata and associated set of log levels.

Task-specific logging in digital computer systems

The present disclosure relates to a problem management method for a user system. A method may include detecting an error in the user system. A signed package may be provided in accordance with the detected error, wherein the package comprises at least a script. The user system may verify the authenticity of the package using a signature of the package, and may execute the script if the package is authentic.

Problem management in a user system

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 generating an event specific log file for a computer system. The generation comprises storing buffered log data in at least one memory buffer during an execution of one or more threads in real time. The generation further comprises receiving thread execution data. The generation further comprises inputting the thread execution data into an anomalous program event detector module configured to generate an anomalous program event signal in response to detecting an anomalous program execution event. The generation further comprises searching the buffered log data for event specific log data in the at least one memory buffer with a log dependency analyzer module in response to the anomalous program event signal. The method further comprises writing the event specific log data to an event specific log file using a log archive writer module.

Event specific log file generation

The method includes identifying a first data table that includes a set of rows and a structure. The method further includes creating a second data table and a third data table having a matching structure as the first table. The method further includes distributing the set of rows of the first data table, wherein the set of rows is distributed between one or more of the second data table and the third data table based upon preset parameters. The method further includes, generating one or more operations for the set of rows. The method further includes executing one of the one or more generated operations on the second data table and the third data table.

Generating data tables

In an approach for processing data in a database management system, a processor performs a delete operation on a first data container, wherein the first data container includes one or more data records and wherein the delete operation logically deletes at least one data record of the one or more data records. A processor associates a time of the performed delete operation with the first data container. A processor performs a write operation on a first data record of the first data container. A processor associates a time of the performed write operation with the first data record of the first data container. Responsive to receiving a database query directed at the first data container, a processor grants access to the first data record of the first data container based on, at least, the time of the performed write operation being chronologically after the time of the performed delete operation.

Efficient full delete operations

In an approach for testing a software application on a target system, a computer provides a test framework being executed on a test framework system, the system being coupled with the target system via network and receives a test scenario by the test framework, the scenario including information regarding a software application to be tested, the target system on which said software application should be executed and regarding one or multiple protocols supported by the target system. The computer interprets information included in said scenario by said test framework and deriving properties associated with at least one software application to be generated based on said information interpretation. The computer then generates an executable software application in a programming language, said application being adapted to the target system by using said derived software application properties. The computer triggers execution of said application thereby obtaining test results, and evaluates said results.

Growing community of inventors

Boeblingen, Germany

Johannes S Kern