Abstract: 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.

Abstract: A computer-implemented method for facilitating large data transfers from a first data management system to a second data management system is disclosed. The method comprises receiving data from the first data management system by a first buffer component, rerouting, upon the first buffer component reaching a predefined fill-level, dynamically the received data to a second buffer component, wherein the second buffer component is adapted to process the rerouted received data, forwarding, by the second buffer component, the rerouted data once the first buffer component is again ready for receiving the rerouted data from the second buffer component, and sending, by a sending component, the data buffered in the first component to the second data management system.

Abstract: The present disclosure relates to a computer implemented method for data synchronization in a data analysis system. The data analysis system comprises a source and target database system. The method comprises: receiving a change record describing an operation performed on a data record in the source database system. The change record may be read for determining a value of a distribution key of the data record. The value of the distribution key may be used for selecting a target database node of the target database system where the operation is to be performed. A direct connection may be established to the selected target database node and the change record may be provided to the selected target database node through the direct connection.

Abstract: The invention relates to a computer-implemented method for managing multiple services in a DBMS. The services respectively are configured to process data that is stored in or is received for being stored in a database managed by the DBMS. The method comprises providing a service manager operatively coupled to the DBMS; registering the multiple services automatically and dynamically at runtime of the DBMS at the service manager; and automatically managing, by the service manager, dependencies between different ones of the multiple registered services.

Abstract: Disclosed herein is a computer implemented method of using a logical view of a base database table of a database system for mirroring or replicating changes in the logical view. The method includes receiving a change request for the logical view; generating a log record for the change request in a transaction log; performing a replication operation to replicate the change request for the logical view in a target database table by inputting the transaction log into a replication tool configured for modifying the target database table using the transaction log.

Abstract: In an approach to copying of table rows across logical nodes in a distributed database system comprising a plurality of logical nodes, for each logical node of a plurality of logical nodes, a connection is made to a current logical node of the plurality of logical nodes. One or more rows are selected from source nodes of the logical nodes to be stored in a target table on the current logical node, where the one or more rows are selected based on a distribution rule for distributing data in the distributed database system. The rows are stored into the target table, where the rows are pulled from the source nodes and stored in the current logical node.

Abstract: 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.

Abstract: The present disclosure relates to a method for executing a query against a table of a database system, the table being configured to comprise records. The record comprises values of a set of columns, wherein one or more changes are being applied to the table in order to be synchronized with a corresponding table. The method comprises: receiving a query against the table, the query referencing one or more columns of the set of columns. It may be determined whether the application of one or more changes involving the one or more columns is completed. In response to determining that said one or more changes are applied, the query may be executed.

Abstract: A method for storing data in a table of a database system is disclosed. The table comprises a first column and a second column. The first column is configured for comprising first type data. The second column is configured for comprising second type data, wherein the second type data has a maximum size higher than a maximum size of the first type data. The method comprises: receiving a query to store a record in the table. It may be determined whether the record comprises a value of the second column. In case the record comprises the value of the second column, the value may be stored in a version control system and a reference token representing the value may be stored in the second column of the table. In case the record does not comprise the value of the second column, the record may be stored in the table.

Abstract: The present disclosure relates to a method including repeatedly synchronizing a source table with a target table. The synchronizing includes receiving changes of the source table, the changes indicating delete records to be deleted and/or insert records to be inserted, replicating the changes to the target table, storing in a storage device the delete records and the insert records of the changes; and deleting from the storage device the records of the changes that are applied at the target table. A query referencing data of the source table may be received. A first query and a second query may be derived from the received query. The first query may be executed on the target table excluding the records in the storage device. The second query may be executed on the insert records of the storage device. The results of the executions may be provided to a sender of the query.

Abstract: Modifying original computer-generated messages is provided. An original computer-generated message is modified by at least one of replacing text or appending text of the original computer-generated message according to instructions located in a structure of a selected modification layer to form a modified computer-generated message corresponding to a current user-system context of a user of the computer system. The modified computer-generated message corresponding to the current user-system context of the user is output.

Abstract: 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.

Abstract: The present disclosure relates to a method for storing a table in a database system. The table comprises a first set of one or more columns of first data type and a second set of one or more columns of second data type. The method comprises: storing the first set of columns and a set of locator columns in a first regular table space. The second set of columns may be stored in a second large object table space. In case a first recorded data volume is higher than or equal to a second recorded data volume, data of the second large object table space may be assigned to a first large object table space. In case the first recorded data volume is smaller than the second recorded data volume, data of the first regular table space may be assigned to a second regular table space.

Abstract: 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.

Abstract: In an approach for dynamically selecting the application algorithm to be used for each change in a target database system, a processor provides at least two application algorithms for applying changes to a table in a target database system. A processor determines, for each application algorithm of the at least two application algorithms, a performance behavior of each application algorithm for sizes of changes that are applied to the table by the respective application algorithm. A processor receives a data change request for applying a change to the table. A processor determines a size of the change to the table. A processor selects one of the at least two application algorithms that provides a best performance for the size based on the performance behavior of each application algorithm. A processor applies the change to the table using the selected application algorithm that provides the best performance for the size.

Abstract: A computer-implemented method for facilitating large data transfers from a first data management system to a second data management system is disclosed. The method comprises receiving data from the first data management system by a first buffer component, rerouting, upon the first buffer component reaching a predefined fill-level, dynamically the received data to a second buffer component, wherein the second buffer component is adapted to process the rerouted received data, forwarding, by the second buffer component, the rerouted data once the first buffer component is again ready for receiving the rerouted data from the second buffer component, and sending, by a sending component, the data buffered in the first component to the second data management system.

Abstract: A computer-implemented method for facilitating large data transfers from a first data management system to a second data management system is disclosed. The method comprises receiving data from the first data management system by a first buffer component, rerouting, upon the first buffer component reaching a predefined fill-level, dynamically the received data to a second buffer component, wherein the second buffer component is adapted to process the rerouted received data, forwarding, by the second buffer component, the rerouted data once the first buffer component is again ready for receiving the rerouted data from the second buffer component, and sending, by a sending component, the data buffered in the first component to the second data management system.

Abstract: 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.

Abstract: A computer-implemented method for a crash recovery for linked databases may be provided. The linked databases comprise a source and related target database. Selected queries of the source database are transferred to the target database. The method comprises synchronizing selected portions of the source database with tables of an in-memory portion of target database and, storing persistently applied changes to the in-memory target database portion asynchronously and persistently. Upon a database crash of the target database system, the method also comprises restoring, the in-memory target database portion with the latest snapshot available, and applying, changes from the source database recovery log file that have a later timestamp than the latest snapshot available in the persistent target database storage of the in-memory target database portion.

Abstract: 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.