Patents by Inventor Knut Stolze
Knut Stolze has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 12198076Abstract: 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.Type: GrantFiled: February 21, 2020Date of Patent: January 14, 2025Assignee: International Business Machines CorporationInventors: Reinhold Geiselhart, Knut Stolze, Felix Beier, Luis Eduardo Oliveira Lizardo
-
Publication number: 20250013661Abstract: 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.Type: ApplicationFiled: September 5, 2023Publication date: January 9, 2025Inventors: Knut Stolze, Felix Beier, Luis Eduardo Oliveira Lizardo, Reinhold Geiselhart
-
Patent number: 12189600Abstract: 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.Type: GrantFiled: February 18, 2021Date of Patent: January 7, 2025Assignee: International Business Machines CorporationInventors: Knut Stolze, Luis Eduardo Oliveira Lizardo, Reinhold Geiselhart, Felix Beier
-
Publication number: 20240419645Abstract: 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.Type: ApplicationFiled: September 7, 2023Publication date: December 19, 2024Inventors: Reinhold Geiselhart, Max Fabian Gilbert, Felix Beier, Knut Stolze
-
Publication number: 20240419649Abstract: 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.Type: ApplicationFiled: September 7, 2023Publication date: December 19, 2024Inventors: Reinhold Geiselhart, Felix Beier, Max Fabian Gilbert, Knut Stolze
-
Publication number: 20240370441Abstract: 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.Type: ApplicationFiled: May 25, 2023Publication date: November 7, 2024Inventors: Felix Beier, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo, Knut Stolze
-
Publication number: 20240320067Abstract: The present disclosure relates to a method for execution of an application comprising a sequence of components. The first component is configured to store output data in an unused buffer and each subsequent component is configured to use a buffer comprising an output provided by the component preceding said subsequent component. The method comprises: providing a set of buffer states representing different contents of the buffer respectively, the set of buffer states comprising an initial state representing a content of the unused buffer and subsequent states representing the outputs of the sequence of components respectively. The buffer states may be sorted, wherein the sorting is circular so that a final state is followed by the initial state. During execution of the application a current state of a buffer may be changed to a subsequent state in case the current application component using the buffer finishes.Type: ApplicationFiled: April 27, 2023Publication date: September 26, 2024Inventors: Philipp Göttlich, Knut Stolze, Max Fabian Gilbert
-
Publication number: 20240281308Abstract: 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.Type: ApplicationFiled: February 21, 2023Publication date: August 22, 2024Inventors: Reinhold Geiselhart, Felix Beier, Knut Stolze, Luis Eduardo Oliveira Lizardo
-
Publication number: 20240220474Abstract: 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.Type: ApplicationFiled: February 24, 2023Publication date: July 4, 2024Inventors: Felix Beier, Knut Stolze, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo
-
Patent number: 11954119Abstract: 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.Type: GrantFiled: January 14, 2021Date of Patent: April 9, 2024Assignee: International Business Machines CorporationInventors: Knut Stolze, Felix Beier, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo
-
Publication number: 20240045874Abstract: 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.Type: ApplicationFiled: October 17, 2023Publication date: February 8, 2024Inventors: Felix Beier, Knut Stolze, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo
-
Patent number: 11893041Abstract: 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.Type: GrantFiled: March 26, 2020Date of Patent: February 6, 2024Assignee: International Business Machines CorporationInventors: Knut Stolze, Vassil Radkov Dimov, Christian Michel, Daniel Martin
-
Patent number: 11816110Abstract: 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.Type: GrantFiled: April 12, 2022Date of Patent: November 14, 2023Assignee: International Business Machines CorporationInventors: Felix Beier, Knut Stolze, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo
-
Patent number: 11755578Abstract: 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.Type: GrantFiled: January 4, 2021Date of Patent: September 12, 2023Assignee: International Business Machines CorporationInventors: Knut Stolze, Reinhold Geiselhart, Felix Beier, Luis Eduardo Oliveira Lizardo
-
Patent number: 11734085Abstract: 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.Type: GrantFiled: February 26, 2020Date of Patent: August 22, 2023Assignee: International Business Machines CorporationInventors: Reinhold Geiselhart, Knut Stolze, Felix Beier, Luis Eduardo Oliveira Lizardo
-
Patent number: 11675809Abstract: 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.Type: GrantFiled: March 2, 2021Date of Patent: June 13, 2023Assignee: International Business Machines CorporationInventors: Knut Stolze, Reinhold Geiselhart, Felix Beier, Luis Eduardo Oliveira Lizardo
-
Publication number: 20230153327Abstract: 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.Type: ApplicationFiled: November 17, 2021Publication date: May 18, 2023Inventors: Knut Stolze, Luis Eduardo Oliveira Lizardo, Reinhold Geiselhart, Felix Beier
-
Patent number: 11593382Abstract: 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.Type: GrantFiled: March 22, 2021Date of Patent: February 28, 2023Assignee: International Business Machines CorporationInventors: Felix Beier, Knut Stolze, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo
-
Patent number: 11573936Abstract: 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.Type: GrantFiled: September 15, 2020Date of Patent: February 7, 2023Assignee: International Business Machines CorporationInventors: Knut Stolze, Reinhold Geiselhart, Felix Beier, Luis Eduardo Oliveira Lizardo
-
Publication number: 20220405289Abstract: 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.Type: ApplicationFiled: April 12, 2022Publication date: December 22, 2022Inventors: Felix Beier, Knut Stolze, Reinhold Geiselhart, Luis Eduardo Oliveira Lizardo