International Business Machines Corporation

Chon N Lei

Rajesh P Ramachandran

Vanessa V Michelini

Snehal S Antani

Reza Ghasemi

Jayapreetha Natesan

Gary W Crupi

Adarsh R Pannu

Robert Maher

Diane Britton

Geoffrey G Kratz

Abuchi Obiegbu

Mei Hing Jackson

Loic Fura

Joseph Gentile

Olayinka Adesanya

A computer-implemented method, computer program product and computer system are provided. A processor retrieves instructions for a plurality of processes. A processor generates a sample of the instructions for the plurality of processes. A processor determines a probability that the sample includes instructions from malicious processes. A processor, in response to the probability exceeding a threshold value, restricts one or more aspects of operation for at least one process of the plurality of processes.

Workload pattern detection

A method, system, and computer program product for performing cognitive-based dynamic tuning of a software-based system include monitoring live operation of the system, and determining whether tuning is needed based on the monitoring. Analyzing information and suggesting a change in one or more parameters is based on the determining, the information including an output of a learning algorithm that learns an effect of changes in one or more of the one or more parameters on performance of the system.

Cognitive-based dynamic tuning

One or more embodiments characterize workloads in a data warehouse system. A set of accounting data associated with a data warehouse system comprising at least one database is collected. A set of query concurrency information associated with the database is determined determining based on the set of accounting data. The set of query concurrency information identifies a plurality of queries executed on the database simultaneously and a duration of this execution. A set of processor utilization distribution information associated with the plurality of queries is determined based on the set of accounting data. A set of data access information indicating a quantity of data accessed by each query in the plurality of queries is determined. A workload profile associated with the database is generated based on the set of query concurrency information, the set of processor utilization distribution information, and the set of data access information.

Characterizing business intelligence workloads

Methods, systems and computer program products for reducing database workload volume. Methods include collecting a sequence of database commands directed to a single database record in a database. The sequence of database commands are reduced to a net result by combining database commands within the sequence of database commands. The net result is written to an output entity when the net result includes a database command.

Methods, systems, and computer program products for reducing database workload volume

A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.

Computer program product for database query optimization

Growing community of inventors

Poughkeepsie, NY, United States of America

Chon N Lei