International Business Machines Corporation

Torsten Steinbach

Gregor Moehler

Knut Stolze

Bjoern Broll

Stefanie Scherzinger

Oliver Draese

David C Kalmuk

Matthias Tschaffler

Michael Reichert

Gordon Andrew Booman

Mathias Trumpp

Sourashis Roy

Martin Oberhofer

Timo Kussmaul

Namik Hrle

Michal Bodziony

Michael Man Behrendt

Eric B Libow

Oliver Koeth

Michael Wurst

Carsten Leue

Michael Jeffrey Winer

Holger Karn

Raghavendra Singh

James L Finnie

Bryan Frederick Smith

Jayanta Basak

Laurent Sebastien Mignet

Markus Lorch

Rafal Korczyk

Benno Staebler

Sachin Lingadahalli Vittal

Michael Haide

Gregor Möhler

Ranga Raju Vatsavai

Alexander Eckert

Manuela Kohler

S Venkatesh Gopal

David Faller

Johannes Lebek

Laurent Sébastien Mignet

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. The method further includes determining, from the determined correlations, optimal configuration parameter values comprising optimal configuration parameters for executing the selected number of service queries of the one category classes.

Shadow experiments for serverless multi-tenant cloud services

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.

Processing messages of a plurality of devices

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.

Method and system for handling binary large objects

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.

Managing resource consumption in a computing system

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.

Method for en passant workload shift detection

Method for EN passant workload shift detection

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.

Method and system for optimizing data access in a database using multi-class objects

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.

Tunable computerized job scheduling

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 statement includes at least a database command.

Transaction prediction modeling method

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.

Intermediate result set caching for a database system

A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.

Automatic query execution plan management and performance stabilization for workloads

A method, computer program product, and infrastructure for accessing a remote application running on a system A by a system B, each being connected to an open network and located behind a firewall, are provided. The method, computer program product, and infrastructure provide for system A sending a first HTTP request to system B via the open network, blocking the first HTTP request from system A till an application request is available at system B, system B sending an HTTP response to system A via the open network, the HTTP response comprising the application request, system A processing the application request from system B to generate an application response, system A sending a second HTTP request to system B via the open network, the second HTTP request comprising the application response, and blocking the second HTTP request from system A till another application request is available at system B.

Method and infrastructure for accessing remote applications through a secure firewall

A method, system, and computer program product for merging monitoring data streams includes: receiving a first monitoring data stream relating to a server containing first records, each first record has a first transaction identifier relating to a first transaction and first monitoring data, relating to a performance of executing the first transaction; receiving a second monitoring data stream relating to a client containing second records, each second record has a list of second transaction identifiers relating to one or more second transactions and second monitoring data, relating to a performance of executing the second transactions; buffering at least parts of the first and the second monitoring data streams; and merging the buffered first and second monitoring data streams by computing an outer-join with a join-condition that the first records have the first transaction identifier that occurs in the list of second transaction identifiers to provide a merged data stream.

System and method for merging monitoring data streams from a server and a client of the server

Growing community of inventors

Holzgerlingen, Germany

Torsten Steinbach