Patents by Inventor Torsten Steinbach
Torsten Steinbach 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).
-
Publication number: 20220043822Abstract: Aspects of the present invention disclose a method, computer program product, and system for query execution in a multi-tenant cloud service. The method includes one or more processors determining category classes for service queries. The method further includes sending for execution, a selected number of service queries from one of the determined category classes to a shadow query engine. Respective service queries of the categorically classified service queries comprise a different set of configuration parameter values for the shadow query engine. The method further includes recording metadata for the selected number of service queries of the one category class executed on said shadow query engine. The method further includes determining correlations between the recorded metadata.Type: ApplicationFiled: August 4, 2020Publication date: February 10, 2022Inventors: Gregor Möhler, Oliver Koeth, Timo Kussmaul, Michael Haide, Torsten Steinbach, Alexander Eckert, Sachin Lingadahalli Vittal, Michael Behrendt, Manuela Kohler
-
Patent number: 10762072Abstract: An embodiment of the invention pertains to processing messages received from a set of devices. A mapping of message fields to fact table columns is stored in a mapping table of a relational database. The method comprises, for each received message, determining all fields of the received message. If it is determined that the mapping table does not assign a fact table column to each of the determined fields of the message, a new mapping between message fields to respective fact table is automatically stored in the mapping table. A mapping is identified in the mapping table that assigns each of the determined fields of the message to a respective one of the columns of the fact table. The field values of the message are stored in the fact table in accordance with the identified mapping.Type: GrantFiled: January 30, 2017Date of Patent: September 1, 2020Assignee: International Business Machines CorporationInventors: Eric B. Libow, Markus Lorch, Martin A. Oberhofer, Torsten Steinbach
-
Patent number: 10235401Abstract: A method includes storing data entities in data storage blocks, a logical structure of the storage of the data entities in the data storage blocks is a database including the data entities stored in tables, receiving a request message including an instruction to execute operations using data of the data entities being logically stored in one or more rows of the data entities in the table and physically stored in the data storage blocks of a processing set, determining that the data entity to be used for execution of the operations is stored across the data storage blocks, generating a processing subset in response to the determining that the data entity is stored across the data storage blocks, and executing the operations using a portion of the data stored in the processing subset.Type: GrantFiled: October 25, 2016Date of Patent: March 19, 2019Assignee: International Business Machines CorporationInventors: Gregor Moehler, Torsten Steinbach, Knut Stolze, Mathias Trumpp
-
Patent number: 10229142Abstract: A method includes storing data entities in data storage blocks, a logical structure of the storage of the data entities in the data storage blocks is a database including the data entities stored in tables, receiving a request message including an instruction to execute operations using data of the data entities being logically stored in one or more rows of the data entities in the table and physically stored in the data storage blocks of a processing set, determining that the data entity to be used for execution of the operations is stored across the data storage blocks, generating a processing subset in response to the determining that the data entity is stored across the data storage blocks, and executing the operations using a portion of the data stored in the processing subset.Type: GrantFiled: September 14, 2015Date of Patent: March 12, 2019Assignee: International Business Machines CorporationInventors: Gregor Moehler, Torsten Steinbach, Knut Stolze, Mathias Trumpp
-
Patent number: 10120719Abstract: Embodiments relate to managing resource consumption in a computing system. An aspect includes providing a resource policy by defining a plurality of threshold values relating to the resource consumption, wherein the resources are consumed by a plurality of user-defined functions performing tasks for a database management system, wherein the user-defined functions are executed by a plurality of processes external to the database management system. Another aspect includes performing an action, as defined by the resource policy, on at least one of the user-defined functions.Type: GrantFiled: March 17, 2015Date of Patent: November 6, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: James L. Finnie, Torsten Steinbach, Michael Wurst
-
Publication number: 20180218019Abstract: An embodiment of the invention pertains to processing messages received from a set of devices. A mapping of message fields to fact table columns is stored in a mapping table of a relational database. The method comprises, for each received message, determining all fields of the received message. If it is determined that the mapping table does not assign a fact table column to each of the determined fields of the message, a new mapping between message fields to respective fact table is automatically stored in the mapping table. A mapping is identified in the mapping table that assigns each of the determined fields of the message to a respective one of the columns of the fact table. The field values of the message are stored in the fact table in accordance with the identified mapping.Type: ApplicationFiled: January 30, 2017Publication date: August 2, 2018Inventors: Eric B. Libow, Markus Lorch, Martin A. Oberhofer, Torsten Steinbach
-
Patent number: 9858283Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.Type: GrantFiled: February 19, 2015Date of Patent: January 2, 2018Assignee: International Business Machines CorporationInventors: Michael Reichert, Torsten Steinbach, Matthias Tschaffler
-
Patent number: 9852142Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.Type: GrantFiled: February 10, 2016Date of Patent: December 26, 2017Assignee: International Business Machines CorporationInventors: Michael Reichert, Torsten Steinbach, Matthias Tschaffler
-
Patent number: 9805077Abstract: Methods for optimizing data access in a row-oriented relational database containing data sets having attributes using a computer are presented the method including: causing a computer to analyze a database workload to determine an access frequency for each of the attributes; causing the computer to assign each of the attributes to a priority classes corresponding with the access frequency, where the priority classes include a higher priority class and a lower priority class, and where a higher priority class corresponds with a higher access frequency and a lower priority class corresponds with a lower access frequency; causing the computer to store the attributes in accordance with the classes, where the attributes assigned to the higher priority class are stored in a high priority storage medium, and where the attributes assigned to a lower priority class are stored in a low priority storage medium.Type: GrantFiled: February 13, 2009Date of Patent: October 31, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Oliver Draese, Benno Staebler, Torsten Steinbach, Knut Stolze
-
Publication number: 20170075937Abstract: A method includes storing data entities in data storage blocks, a logical structure of the storage of the data entities in the data storage blocks is a database including the data entities stored in tables, receiving a request message including an instruction to execute operations using data of the data entities being logically stored in one or more rows of the data entities in the table and physically stored in the data storage blocks of a processing set, determining that the data entity to be used for execution of the operations is stored across the data storage blocks, generating a processing subset in response to the determining that the data entity is stored across the data storage blocks, and executing the operations using a portion of the data stored in the processing subset.Type: ApplicationFiled: September 14, 2015Publication date: March 16, 2017Inventors: Gregor Moehler, Torsten Steinbach, Knut Stolze, Mathias Trumpp
-
Publication number: 20170075934Abstract: A method includes storing data entities in data storage blocks, a logical structure of the storage of the data entities in the data storage blocks is a database including the data entities stored in tables, receiving a request message including an instruction to execute operations using data of the data entities being logically stored in one or more rows of the data entities in the table and physically stored in the data storage blocks of a processing set, determining that the data entity to be used for execution of the operations is stored across the data storage blocks, generating a processing subset in response to the determining that the data entity is stored across the data storage blocks, and executing the operations using a portion of the data stored in the processing subset.Type: ApplicationFiled: October 25, 2016Publication date: March 16, 2017Inventors: Gregor Moehler, Torsten Steinbach, Knut Stolze, Mathias Trumpp
-
Publication number: 20160246839Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.Type: ApplicationFiled: February 19, 2015Publication date: August 25, 2016Inventors: Michael Reichert, Torsten Steinbach, Matthias Tschaffler
-
Publication number: 20160246843Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.Type: ApplicationFiled: February 10, 2016Publication date: August 25, 2016Inventors: Michael Reichert, Torsten Steinbach, Matthias Tschaffler
-
Patent number: 9417913Abstract: A computer-implemented method for scheduling a set of jobs executed in a computer system can include determining a workload-time parameter for a set of at least one job. The workload-time parameter can relate to execution-time parameters for the set of at least one job. The method can include determining a schedule tuning parameter for the set of at least one job, the schedule tuning parameter based on the workload-time parameter. The method can include generating a scheduling factor for each job in the set, the scheduling factor generated based on the schedule tuning parameter. The method can include scheduling the set of at least one job based on the scheduling factor.Type: GrantFiled: May 8, 2015Date of Patent: August 16, 2016Assignee: International Business Machines CorporationInventors: Gordon Booman, David Kalmuk, Torsten Steinbach
-
Patent number: 9361154Abstract: A computer-implemented method for scheduling a set of jobs executed in a computer system can include determining a workload-time parameter for a set of at least one job. The workload-time parameter can relate to execution-time parameters for the set of at least one job. The method can include determining a schedule tuning parameter for the set of at least one job, the schedule tuning parameter based on the workload-time parameter. The method can include generating a scheduling factor for each job in the set, the scheduling factor generated based on the schedule tuning parameter. The method can include scheduling the set of at least one job based on the scheduling factor.Type: GrantFiled: September 30, 2014Date of Patent: June 7, 2016Assignee: International Business Machines CorporationInventors: Gordon Booman, David Kalmuk, Torsten Steinbach
-
Publication number: 20160092269Abstract: A computer-implemented method for scheduling a set of jobs executed in a computer system can include determining a workload-time parameter for a set of at least one job. The workload-time parameter can relate to execution-time parameters for the set of at least one job. The method can include determining a schedule tuning parameter for the set of at least one job, the schedule tuning parameter based on the workload-time parameter. The method can include generating a scheduling factor for each job in the set, the scheduling factor generated based on the schedule tuning parameter. The method can include scheduling the set of at least one job based on the scheduling factor.Type: ApplicationFiled: September 30, 2014Publication date: March 31, 2016Inventors: Gordon Booman, David Kalmuk, Torsten Steinbach
-
Publication number: 20160092275Abstract: A computer-implemented method for scheduling a set of jobs executed in a computer system can include determining a workload-time parameter for a set of at least one job. The workload-time parameter can relate to execution-time parameters for the set of at least one job. The method can include determining a schedule tuning parameter for the set of at least one job, the schedule tuning parameter based on the workload-time parameter. The method can include generating a scheduling factor for each job in the set, the scheduling factor generated based on the schedule tuning parameter. The method can include scheduling the set of at least one job based on the scheduling factor.Type: ApplicationFiled: May 8, 2015Publication date: March 31, 2016Inventors: Gordon Booman, David Kalmuk, Torsten Steinbach
-
Publication number: 20150363237Abstract: Embodiments relate to managing resource consumption in a computing system. An aspect includes providing a resource policy by defining a plurality of threshold values relating to the resource consumption, wherein the resources are consumed by a plurality of user-defined functions performing tasks for a database management system, wherein the user-defined functions are executed by a plurality of processes external to the database management system. Another aspect includes performing an action, as defined by the resource policy, on at least one of the user-defined functions.Type: ApplicationFiled: March 17, 2015Publication date: December 17, 2015Inventors: James L. Finnie, Torsten Steinbach, Michael Wurst
-
Patent number: 9195693Abstract: The present invention provides database systems configured for creating and utilizing a transactions predictive model using a computer, the database system including: a database management system (DBMS) for handling transactions in the database system, the DBMS including a prediction component for generating the transactions predictive model; a database workload table for capturing commands associated with the transactions, the commands utilized for generating the transactions predictive model; database data for providing data in response to the transactions; and a prediction model database for storing the transactions predictive model, where the prediction component is configured for generating a generalized statement for each statement corresponding with the transactions, identifying a sequence of transactions of the transactions, creating a transaction class based on the sequence of transactions, identifying a current transaction, and then calculating probabilities between transactions, where each statemenType: GrantFiled: April 27, 2012Date of Patent: November 24, 2015Assignee: International Business Machines CorporationInventors: Bjoern Broll, Torsten Steinbach
-
Patent number: 8930347Abstract: A method for storing intermediate result sets in a database is provided. An access plan for a single query for accessing data stored in the database system is received. An intermediate result set is generated during execution of the access plan. A value of an intermediate result set rating of the intermediate result set is determined during execution of the access plan at runtime of the query for determining if the intermediate result set, generated during the execution of the access plan, is to be stored. Based on determining that the value of the intermediate result set rating meets a predefined criterion, the determined intermediate result set is stored for a longer period of time than the runtime of the query as a stored intermediate result set.Type: GrantFiled: December 11, 2012Date of Patent: January 6, 2015Assignee: International Business Machines CorporationInventors: Bjoern Broll, Torsten Steinbach