International Business Machines Corporation

James C Cook

Randal Lee Bertram

John Sebastian Warren

Frederick Scott Hunter Krauss

Gary M Quesenberry

Dawn Ashley Comfort

Patrick E McCamish

Robert C Robinson, Jr

A computerized method, program product, and a service that facilitates the storage of multiple rows of data in a relational database. If the data is clustered data, the method, program product and the service first obtains the clustered data from its source. An identifying primary key of the clustered data is resolved, and the clustered data is parsed, compressed and stored as a binary large object (BLOB). The BLOB may be stored within the relational database or may be stored separately. Storage and access times for large amount of data used in relational databases are optimized.

Optimal data storage and access for clustered data in a relational database

Disclosed are embodiments of a method, a system and a computer program product for selecting data to be presented in a report form. A selector window is displayed to a user, the selector window displaying periods of time for indicating those periods of time for which data is available. The periods of time are displayed as a stack of temporally aligned time lines that are each partitioned into time periods of different duration, where each partition of a given time line has a spatial extent that differs from the spatial extent of partitions of other time lines, with longer partitions encompassing a plurality of shorter partitions. In response to the user selecting a point on a time line, the method, system and computer program product displays a report of that data. The method, system and computer program product further display a partition within a time line to comprise a visual indicator to indicate the occurrence of at least one event of interest that occurred during the time that corresponds to that partition. The data may represent computer system performance metric data that includes rolled-up data, and an absence of a displayed partition indicates to the user that the corresponding data is not available.

System, method and computer program for providing a time map of rolled-up data

Growing community of inventors

Georgetown, KY, United States of America

James C Cook