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: Controlling the timing of an execution of a database query for test purposes includes: receiving the database query, the database query comprising control code; the control code causing a database management system to control the timing of the execution of the database query within the database management system; executing the database query within the database management system.

Abstract: Managing concurrent accesses by a set of tasks to a shared resource of a computer system. Synchronizing the set of tasks for assigning and releasing a resource according to a predefined access period with flexibility of providing an extended access period where an external task is not detected during the predefined access period. Where an extended access period is provided, resynchronizing is performed, and the external task is identified and access is prevented when the external task is determined to be a particular type of task.

Abstract: Methods, computer program products, and/or systems are provided that perform the following operations: generating log files while performing data changes of a source database system table; storing the log files on a first memory device having a first access time; archiving a part of the log files from the first memory device on a second memory device having a second access time, the second access time being higher than the first access time; tracking a second number of pending data changes, the pending data changes being data changes of the records of data change of log files archived on the second memory device which are not yet replicated in a target database system table; selecting a type of data replication from a first type of data replication and a second type of data replication based on the second number; and replicating the data changes in the target database system table.

Abstract: A computer implemented method includes identifying a query view of a target database system enabling access to a first source table stored in a first target table, executing a load program for a current version of a first source partition of the first source table, wherein executing the load program includes loading the first source partition in a second load target partition of the first target table, changing the query view to select records of the first target table, executing an update program for assigning records of the first replication target partition to the first load target partition, selecting a mode of operation for a replication program based on determining whether the execution of the update program is finished, executing the replication program in accordance with the selected mode of operation, and changing the query view to further select the records of the first replication target partition.

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

Abstract: A computer-implemented method, a computer program product, and a computer system for detecting an inappropriate data type of a column in a database and correcting an encoding for the column. The computer system detects in a table a candidate column that has a mismatching type definition, using database usage statistics. The computer system determines whether conversion of the candidate column is possible. In response to determining that the conversion of the candidate column is possible, the computer system converts values in the candidate column with a first data type to values in a new column with a second data type. The computer system appends the new column in the table. The computer system registers the new column and the second data type in a metadata catalog. The computer system generates a query plan operator for processing a query for the new column.

Abstract: The present disclosure relates to a computer implemented method for loading data in a target database system. The method comprises: determining that a load of a source table is expected to occur in the target database system. A future target table may be provided in advance in accordance with a defined table schema, and thereafter a load request for loading the source table may be received. Data of the source table may be loaded into the future target table.

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 method for wearable computing device, the method comprising acquiring, by the wearable computing device, a first body status information of a person from a first data acquisition unit, wherein the person is wearing the wearable computing device. Receiving, by the wearable computing device, external information from other wearable computing devices via a wireless communication interface. In response to a fulfillment of a predefined crowd detection criterion by the external information, automatically, by the wearable computing device, transmitting the first body status information by the wireless communications interface.

Abstract: In an approach for character encoding, a processor receives a first query involving an attribute, wherein the first query utilizes a value encoded in accordance with a first encoding scheme. A processor identifies a table comprising values of the attribute in a compressed format. A processor creates at least one dictionary associated with the attribute, wherein the at least one new dictionary associated with the attribute maps a compressed value to a corresponding uncompressed value. A processor executes the first query by invoking a conversion operation in a query plan of the first query for decoding one or more queried values of the attribute. A processor fills the at least one new dictionary with one or more decoded query values to create at least one full dictionary. A processors stores the at least one full dictionary in a cache using a predefined cache management policy of the cache.

Abstract: A computer-implemented system and method process insertions into a target table of a target database system. A single query language INSERT statement is received that is related to a source partition of a source table in a source database system that identifies a block of data (BOD), having a partition identifier (PID), to be inserted into the target table. The INSERT statement contains no literal PID. Responsive to receiving the INSERT statement, a processor receives the BOD from the source table via a data stream, and inserts the BOD into the target table. This reduces the overhead associated with using an INSERT statement to insert multiple rows of data into a target table.

Abstract: A DBMS manages a high-performance accelerated database that is synchronized with a conventional client database. The accelerated database contains both “regular” accelerated tables, which each duplicate a table of the client database, and accelerator-only tables (AOTs) that are unique to the accelerated database and that may be used for analytical purposes. AOT rows are archived by moving the rows to a dedicated accelerator-only archive stored in the accelerated database. When a user query attempts to access accelerator-only data, the DBMS rewrites the query to adapt the requested operations to the accelerated database's partitioned archive/non-archive structure. The rewritten query specifies steps for accessing archived and non-archived accelerator-only data without forcing the DBMS front-end to generate a merged view of archived and non-archived accelerator-only data.

Abstract: In an approach to online reorganization of database tables with concurrent updates, a second table is created, where the second table has the same schema as the first table. A union of the first table and the second table is projected to create a view, where the view allows table data to be queried and modified while the database table reorganization is performed. Responsive to one or more running replication transactions completing, the database table reorganization is executed. Responsive to receiving a query, the query is allowed to access the view.

Abstract: A computer-implemented method, a computer program product, and a computer system for detecting an inappropriate data type of a column in a database and building a physical access path over a correct data type. The computer system detects in a table a candidate column with a first data type that has a mismatching type definition, using database usage statistics. The computer system determines whether it is possible to build an additional index as an access path over values with a second data type. The computer system, in response to determining that it is possible to build the additional index, converts values in the candidate column to the values with the second data type. The computer system builds the additional index over the values with the second data type in the table. The computer system generates a query plan operator for the additional index.

Abstract: A computer-implemented method, a computer program product, and a computer system for detecting an inappropriate data type of a column in a database and correcting an encoding for the column. The computer system detects in a table a candidate column that has a mismatching type definition, using database usage statistics. The computer system determines whether conversion of the candidate column is possible. In response to determining that the conversion of the candidate column is possible, the computer system converts values in the candidate column with a first data type to values in a new column with a second data type. The computer system appends the new column in the table. The computer system registers the new column and the second data type in a metadata catalog. The computer system generates a query plan operator for processing a query for the new column.

Abstract: A computer-implemented method, a computer program product, and a computer system for detecting an inappropriate data type of a column in a database and building a physical access path over a correct data type. The computer system detects in a table a candidate column with a first data type that has a mismatching type definition, using database usage statistics. The computer system determines whether it is possible to build an additional index as an access path over values with a second data type. The computer system, in response to determining that it is possible to build the additional index, converts values in the candidate column to the values with the second data type. The computer system builds the additional index over the values with the second data type in the table. The computer system generates a query plan operator for the additional index.

Abstract: A method for wearable computing device, the method comprising acquiring, by the wearable computing device, a first body status information of a person from a first data acquisition unit, wherein the person is wearing the wearable computing device. Receiving, by the wearable computing device, external information from other wearable computing devices via a wireless communication interface. In response to a fulfillment of a predefined crowd detection criterion by the external information, automatically, by the wearable computing device, transmitting the first body status information by the wireless communications interface.