International Business Machines Corporation

Sourashis Roy

Torsten Steinbach

Jayanta Basak

Laurent Sebastien Mignet

Raghavendra Singh

Martin Keller

Laurent Sébastien Mignet

Ranga Raju Vatsavai

A method, system, and computer program product for a multi-resolution storage scheme for historical data are provided. The method includes dividing the historical data into a plurality of time frames and determining an amount of compression for each of the time frames, where at least two of the time frames have a different amount of compression. The method further includes applying the amount of compression to each of the time frames, resulting in multi-resolution historical data, and storing the multi-resolution historical data.

Methods, systems, and computer program products for a multi-resolution storage scheme for historical data

A window size for outlier detection in a time series of a database system is determined. Strength values are calculated for data points using a set of window sizes, resulting at least in one set of strength values for each window size. The strength values increase as a distance between a value of a respective data point and a local mean value increases. For each set of strength values, a weighted sum is calculated based on the respective set of strength values. A weighting function is used to suppress the effect of largest strength values and a window size is selected based on the weighted sums.

Determining a window size for outlier detection

A method for scheduling a workload comprising a plurality of transactions relating to a database management system is disclosed. The method comprises the steps of determining a log space amount required by each transaction in the workload, estimating the total log space required for executing the workload based on the log space amounts required by each transaction, and scheduling execution of the workload based on the estimated total log space.

Method and system for scheduling workload in databases

Growing community of inventors

New Delhi, India

Sourashis Roy