International Business Machines Corporation

Anatoly Tulchinsky

Alagesan Krishnapillai

Luc Bertin

Ricardo G Borba

Michael Adendorff

Tom Fazal

Simon Palmer

Simon Evans

Gregory Dorval

Carm Janneteau

A method for archiving monitoring data by enabling real-time analysis within a live database. A processor receives a set of parameters, which is selected based on monitoring data of a system application. The processor determines a historical schema of monitoring data and a retention period for a current schema of monitoring data, based on the set of parameters. The processor performs an impact analysis of the historical schema and retention period of the monitoring data. Upon acceptance of the impact analysis, the processor generates the historical schema which is applied to a table of monitoring data, populated by copying monitoring data from the current schema to the historical schema, within the live database. The processor removes monitoring data exceeding the rolling retention period from both the current schema and historical schema, based on the rolling retention period of the current schema.

Smart archiving of real-time performance monitoring data

A data warehouse solution system comprises a metadata model, a user interface and an engine. The metadata model has an information needs model including metadata regarding information needs for building reports by users, and a data information model including metadata describing data that is available for building reports. The user interface has a customer user interface for presenting the information needs model to the users for report generation, and a modeling user interface for presenting the data information model to the users for manipulating data warehouse objects. The engine has a report management service unit for providing report management service using the information needs model, and a data management service unit for providing data management service including generation of a data warehouse using the data information model.

Method of generating and maintaining a data warehouse

Growing community of inventors

Ottawa, Canada

Anatoly Tulchinsky