Methods, systems, and computer program products for database table aggregation
First Claim
1. A method for database table aggregation, comprising:
- encoding first and second components via a waveform definition and attribute values of the respective first and second components, the first component specifying first criteria for aggregating data and the second component specifying second criteria for aggregating data;
generating a complex periodic aggregation waveform having variable-sized square waves respectively representing the first component and the second component in a repeating pattern that corresponds to the waveform definition and the first and second criteria, respectively, and which spans a length of a first axis that corresponds to a period of time for aggregating the data;
providing a maximum byte count for aggregated data stored in a first table defined by at least one of the first and second criteria, the maximum byte count specifying a threshold value;
aggregating the data for the duration of the period of time and in accordance with the attribute values of the respective first and second components;
creating a second table for overflow of data determined for the first table when the threshold value has been exceeded;
updating the complex periodic aggregation waveform to reflect results of the data aggregation, the updating including generating a waveform representing the second table along a second axis, the second axis depicted at a location corresponding to time in which the data aggregation for the first table was initiated;
outputting a graphical depiction of the updated complex periodic aggregation waveform;
wherein the method further comprises;
in response to receiving a date/time value and a read/write indicator value, wherein a read indicator specifies a read operation and a write indicator specifies a write operation;
searching the database of complex periodic aggregation waveforms until the date/time value is equal to or exceeds a unique identifier of a complex periodic aggregation waveform;
scanning the complex periodic aggregation waveform, found in response to the searching, until a period of time specified in one of the first and second criteria encloses the start date/time value;
searching a list of the tables until the start date/time value is equal to an identifier of one of the tables in the list;
determining whether the table found in response to the searching has an amount of aggregated data that exceeds a specified threshold;
performing one of the read operation and the write operation with respect to the table found in response to the searching based upon the read/write indicator value;
if the read/write indicator value is equal to the write operation, returning a maximum table name representing the table having the latest start date and time; and
if the read/write indicator value is equal to the read operation, returning the list of table names for a component indicating the threshold value has been exceeded.
4 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
15 Claims
-
1. A method for database table aggregation, comprising:
-
encoding first and second components via a waveform definition and attribute values of the respective first and second components, the first component specifying first criteria for aggregating data and the second component specifying second criteria for aggregating data; generating a complex periodic aggregation waveform having variable-sized square waves respectively representing the first component and the second component in a repeating pattern that corresponds to the waveform definition and the first and second criteria, respectively, and which spans a length of a first axis that corresponds to a period of time for aggregating the data; providing a maximum byte count for aggregated data stored in a first table defined by at least one of the first and second criteria, the maximum byte count specifying a threshold value; aggregating the data for the duration of the period of time and in accordance with the attribute values of the respective first and second components; creating a second table for overflow of data determined for the first table when the threshold value has been exceeded; updating the complex periodic aggregation waveform to reflect results of the data aggregation, the updating including generating a waveform representing the second table along a second axis, the second axis depicted at a location corresponding to time in which the data aggregation for the first table was initiated; outputting a graphical depiction of the updated complex periodic aggregation waveform; wherein the method further comprises; in response to receiving a date/time value and a read/write indicator value, wherein a read indicator specifies a read operation and a write indicator specifies a write operation; searching the database of complex periodic aggregation waveforms until the date/time value is equal to or exceeds a unique identifier of a complex periodic aggregation waveform; scanning the complex periodic aggregation waveform, found in response to the searching, until a period of time specified in one of the first and second criteria encloses the start date/time value; searching a list of the tables until the start date/time value is equal to an identifier of one of the tables in the list; determining whether the table found in response to the searching has an amount of aggregated data that exceeds a specified threshold; performing one of the read operation and the write operation with respect to the table found in response to the searching based upon the read/write indicator value; if the read/write indicator value is equal to the write operation, returning a maximum table name representing the table having the latest start date and time; and if the read/write indicator value is equal to the read operation, returning the list of table names for a component indicating the threshold value has been exceeded. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A system for database table aggregation, comprising:
-
a host system computer; and an aggregation application executing on the host system computer, the aggregation application including an encoder, the encoder encoding first and second components via a waveform definition and attribute values of the respective first and second components, the first component specifying first criteria for aggregating data and the second component specifying second criteria for aggregating data; the aggregation application generating a complex periodic aggregation waveform having variable-sized square waves respectively representing the first component and the second component in a repeating pattern that corresponds to the waveform definition and the first and second criteria, respectively, and which spans a length of a first axis that corresponds to a period of time for aggregating the data; providing, via a user interface of the aggregation application, a maximum byte count for aggregated data stored in a first table defined by at least one of the first and second criteria, the maximum byte count specifying a threshold value; the aggregation application aggregating the data for the duration of the period of time and in accordance with the attribute values of the respective first and second components; the aggregation application creating a second table for overflow of data determined for the first table when the threshold value has been exceeded; the aggregation application updating the complex periodic aggregation waveform to reflect results of the data aggregation, the updating including generating a waveform representing the second table along a second axis, the second axis depicted at a location corresponding to time in which the data aggregation for the first table was initiated; the aggregation application outputting a graphical depiction of the updated complex periodic aggregation waveform to a user interface screen of a computer system; wherein the aggregation application further implements; in response to receiving a date/time value and a read/write indicator value via the user interface, wherein a read indicator specifies a read operation and a write indicator specifies a write operation; the aggregation application searches the database of complex periodic aggregation waveforms until the date/time value is equal to or exceeds a unique identifier of a complex periodic aggregation waveform; the aggregation application scans the complex periodic aggregation waveform, found in response to the searching, until a period of time specified in one of the first and second criteria encloses the start date/time value; the aggregation application searches a list of the tables until the start date/time value is equal to an identifier of one of the tables in the list; the aggregation application determines whether the table found in response to the searching has an amount of aggregated data that exceeds a specified threshold; the aggregation application performs one of the read and the write operation with respect to the table found in response to the searching based upon the read/write indicator value;
if the read/write indicator value is equal to the write operation, the aggregation application returns a maximum table name representing the table having the latest start date and time; andif the read/write indicator value is equal to the read operation, the aggregation application returns the list of table names for a component indicating the threshold value has been exceeded. - View Dependent Claims (7, 8, 9, 10)
-
-
11. A computer program product for database table aggregation, the computer program product comprising a non-transitory storage medium having computer-readable program code embodied thereon, the program code causing a computer to implement:
-
encoding first and second components via a waveform definition and attribute values of the respective first and second components, the first component specifying first criteria for aggregating data and the second component specifying second criteria for aggregating data; generating a complex periodic aggregation waveform having variable-sized square waves respectively representing the first component and the second component in a repeating pattern that corresponds to the waveform definition and the first and second criteria, respectively, and which spans a length of a first axis that corresponds to a period of time for aggregating the data; providing a maximum byte count for aggregated data stored in a first table defined by at least one of the first and second criteria, the maximum byte count specifying a threshold value; aggregating the data for the duration of the period of time and in accordance with the attribute values of the respective first and second components; creating a second table for overflow of data determined for the first table when the threshold value has been exceeded; updating the complex periodic aggregation waveform to reflect results of the data aggregation, the updating including generating a waveform representing the second table along a second axis, the second axis depicted at a location corresponding to time in which the data aggregation for the first table was initiated; outputting a graphical depiction of the updated complex periodic aggregation waveform; wherein the program code further causes a computer to implement; in response to receiving a date/time value and a read/write indicator value, wherein a read indicator specifies a read operation and a write indicator specifies a write operation; searching the database of complex periodic aggregation waveforms until the date/time value is equal to or exceeds a unique identifier of a complex periodic aggregation waveform; scanning the complex periodic aggregation waveform, found in response to the searching, until a period of time specified in one of the first and second criteria encloses the start date/time value; searching a list of the tables until the start date/time value is equal to an identifier of one of the tables in the list; determining whether the table found in response to the searching has an amount of aggregated data that exceeds a specified threshold; performing one of the read operation and the write operation with respect to the table found in response to the searching based upon the read/write indicator value; if the read/write indicator value is equal to the write operation, returning a maximum table name representing the table having the latest start date and time; and if the read/write indicator value is equal to the read operation, returning the list of table names for a component indicating the threshold value has been exceeded. - View Dependent Claims (12, 13, 14, 15)
-
Specification