At&t Intellectual Property I, LP

Saiprakash Rao

Arthur L Zaifman

Philip E Brown

Database table aggregation is implemented by a method that includes encoding first and second components via a waveform definition, the first and second components specifying criteria for aggregating data, and the first component is defined to provide data aggregation at a higher granularity than the second component. The method also includes generating a complex waveform representing the components in a pattern corresponding to the waveform definition and criteria, which spans a first axis indicative of a time period for the aggregation. The method includes providing a byte count for aggregated data stored in a first table defined by the criteria, aggregating the data for the time period, and updating the complex waveform to reflect results of the aggregation that includes generating a waveform representing a second table along a second axis depicted at a location corresponding to a time in which the data aggregation for the first table was initiated.

Methods, systems, and computer program products for database table aggregation

Database table aggregation is implemented by a method that includes encoding first and second components via a waveform definition, the first and second components specifying criteria for aggregating data. The method also includes generating a complex waveform representing the components in a pattern corresponding to the waveform definition and criteria, which spans a first axis indicative of a time period for aggregating the data. The method further includes providing a byte count for aggregated data stored in a first table defined by the criteria, aggregating the data for the time period, and creating a second table for overflow data when the count is exceeded. The method also includes updating the complex waveform to reflect results of the aggregation that includes generating a waveform representing the second table along a second axis depicted at a location corresponding to a time in which the data aggregation for the first table was initiated.

Methods, systems, and computer program products for database table aggregation are provided. A method includes encoding first and second components via a waveform definition, the first and second components specifying first and second criteria, respectively, for aggregating data. The method includes generating a complex periodic aggregation waveform (CPAW) having variable-sized square waves representing the components in a repeating pattern corresponding to the definition and the criteria, and which spans a first axis. The method includes providing a maximum byte count for aggregated data stored in a table defined by the first and/or second criteria, aggregating the data in accordance with the criteria, and creating a new table for overflow of data determined for the table when the maximum byte count is exceeded. The method includes updating the CPAW with results of the aggregation and generating a waveform representing the new table along a second axis.

Growing community of inventors

Skillman, NJ, United States of America

Saiprakash Rao