Hewlett-Packard Development Company, L.p.

Eric Y Shan

Ming-Chien Shan

Fabio Casati

Maria G Castellanos

Various approaches are disclosed for loading data from a vertical database table into a horizontal database table. In one embodiment, a number of rows in a vertical database table and a number of columns in a horizontal database table are determined. Entries in a first column of the vertical table contain object identifiers, entries in a second column contain attribute names corresponding to the object identifiers, and entries in a third column contain attribute values corresponding to the attribute names. The horizontal table includes a column for the object identifiers and respective attribute columns for the attributes names. One of a plurality of methods is selected and used for reading data from the vertical database table and writing data to the horizontal database table based in part on the number of rows in the vertical database table and the number of columns in the horizontal database table.

Loading data from a vertical database table into a horizontal database table

The disclosed embodiments relate to a system and method of refreshing metrics. The method may comprise obtaining a plurality of data elements that comprise information about a process and computing a plurality of metrics from a plurality of mappings, each of the plurality of mappings relating to an operation on at least one of the plurality of data elements. Each of the plurality of metrics may have a refresh rate. Additionally, the method may comprise analyzing the refresh rate of the plurality of metrics to identify at least one shared refresh interval between groups of the plurality of metrics, identifying at least one common mapping between the plurality of metrics, and periodically refreshing the plurality of metrics, accounting for the at least one shared refresh interval and the at least one common mapping between the plurality of metrics.

Growing community of inventors

Saratoga, CA, United States of America

Eric Y Shan