International Business Machines Corporation

Gary W Crupi

Natalie Brooks Powell

Ho-Yiu Lam

David Charles Martin

Timothy T Bohn

Sandhya ReddyVeera

Shantan Kethireddy

Jason Arnold

Ruiping Li

Henry E Calzaretta

Chon N Lei

Dylan S Murphy

David R Trotter

Mei Hing Jackson

Embodiments of the present invention provide techniques for identifying and quantifying waste in a process. Waste information is input via images and/or natural language. The amount of waste is estimated based on information in images and/or a natural language description. A computer-implemented technique extracts metadata on waste products from the images and/or natural language description. A variety of factors such as social media trends, weather, traffic, and/or sports schedules are evaluated by the computer and used in predicting the amount of waste that will occur.

Waste analysis system and method

A central relational database management system (RDBMS) is operatively interconnected to one or more back-end database systems. A set of different query criteria specified for each of different types of queries for a mixed query workload is evaluated. At least one remote derived source of data requested by at least one of the different types of queries is dynamically created using at least one of the one or more back-end database systems that supports remote processing of the at least one of the different types of queries.

Runtime creation of remote derived sources for query offload

A system, method and program product for providing latency management for use with a database management system. A system is disclosed having: a system for capturing and storing a maximum latency (ML) whenever a derived source is created from a source data; a system for determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query; and a system for causing the source data to be used in response to the difference being greater than the ML, and for causing the derived source to be used in response to the difference being less than the ML.

Latency management and advising tool for a database management system

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

Growing community of inventors

Pewaukee, WI, United States of America

Gary W Crupi