International Business Machines Corporation

Matthias Tschaffler

Michael Reichert

Namik Hrle

Daniel Martin

Roland Seiffert

Jochen F Doerre

Monika Matschke

Andreas Lohrer

Charles Daniel Wolfson

Albert Maier

Mike W Grasselt

Torsten Steinbach

Oliver Suhre

Matthias Kloppmann

Maryela Evelin Weihrauch

John Benjamin Tobler

Andreas Limmer

Stephan Arenswald

A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Assisted problem identification in a computing system

Dispatching a database request. A database request is received. Latency times are determined for databases managed by the DBMS, the latency times being estimates of the times to complete replications from the other databases of all unreplicated data changes in the other databases. For each database, a capture velocity and an apply are determined, which are a number of data changes applied to the database that can be identified or applied in a predefined time interval. For each database, an estimated time to complete the database request is determined. The database request is dispatched to the database having an estimated minimum time of execution of the database request, wherein the time of execution is function of the estimated time for the database to complete the database request, the latency time of the database, and the capture and apply velocities of the database.

Query dispatching system and method

A computer receives a database request to be executed on a source database or a target database. The source database is configured to efficiently process database queries of a first query type, the target database is configured to efficiently process database queries of a second query type, data changes in the source database are asynchronously replicated to the target database, and all changed data in the source database impacting a result of the database request are replicated to the target database before executing the database request. The computer determines a latency time to asynchronously complete a replication of unreplicated data changes and determines a velocity of replication. The computer predicts, using the latency time and velocity of replication, which of the databases will complete an execution of the database request first and dispatches the database request to the database predicted to complete the execution of the database request first.

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

A computer-implemented method, system, and/or computer program product monitors stored procedures that are executed in a database management system. A determination is made, for a stored procedure that is executed in a database management system, of an identification of the stored procedure and event data related to the stored procedure. The event data includes when the stored procedure began and ended executing, an SQL identifier for an SQL statement in the stored procedure, and a counter of how many times the SQL statement executed. The database management system provides values of parameters used when executing the SQL statement. These values are then correlated with the count of how many times the SQL statement executed.

Monitoring stored procedure execution

System and computer program product for processing a text search query in a collection of documents. A full posting index is generated that has first index terms and a full posting list for each first index term, enumerating occurrences of the first index terms in the documents of the collection. A text search query includes search conditions search terms. The search conditions are translated into conditions on the first index terms to provide translated conditions. At least one short posting index is generated, which includes second index terms and a short posting list for each second index term, enumerating documents in which the second index terms occur. Filter conditions and complementary conditions are generated to represent the translated conditions. The filter conditions approximate the translated conditions, and are processed using the short posting index. The complementary conditions are processed using the full posting index to provide a query result.

Processing a text search query in a collection of documents

Techniques are provided for processing a workflow. A workflow including one or more data management activities is received. A workflow description is generated from the workflow that includes a description of the one or more data management activities. One or more data management operations are generated from the workflow description. The one or more data management operations are executed against one or more data management systems.

System and article of manufacture for integration of data management operations into a workflow system

Integration of data management operations into a workflow system

A method, system, and computer program product are provided for processing a text search query in a collection of documents. A full posting index is generated. The full posting index comprises one or more first index terms and a full posting list for each first index term, enumerating occurrences of the first index term in the documents of the collection. A text search query comprises search conditions on search terms. These search conditions are translated into conditions on the search terms to provide translated conditions. At least one short posting index is generated. The short posting index comprises one or more second index terms and a short posting list for each second index term, enumerating the documents in which the second index term occurs. Filter conditions and complementary conditions to represent the full content of the translated conditions are generated, wherein the filter conditions approximate the translated conditions. The filter conditions are processed using the short posting index and the complementary conditions are processed using the full posting index to provide a query result.

Methods for processing a text search query in a collection of documents

Provided is a method for processing queries in a database in which data records have a parametric object and an extension of a nonparametric data type. A query includes a parametric condition for the parametric object of the data records and a nonparametric condition for the nonparametric extension of the data records. Parametric information of each data record is translated into constructs of the data type of the extension. A parametric result set of data records for the parametric condition is generated. The parametric condition of said query is translated into a filter condition for said constructs of the data type of the extension. The nonparametric condition of said query and said filter condition are employed to generate a nonparametric result set. The parametric result set and the nonparametric result set are joined to obtain a result set.

Growing community of inventors

Nufringen, Germany

Matthias Tschaffler