System and method for maintaining a plurality of summary levels in a single table
First Claim
Patent Images
1. A computer-implemented method comprising:
- collecting data indicative of performance of a monitored computer system;
storing the data in a database table, wherein the database table is stored on a storage device;
summarizing the data into a plurality of summary levels, wherein each of the summary levels comprises summarized data over a respective one of a plurality of intervals of time;
storing the summarized data in the plurality of summary levels in the database table, wherein the database table comprises a respective one or more partitions corresponding to each of the plurality of summary levels, wherein the summarized data for each of the plurality of summary levels is stored in the corresponding one or more partitions of the database table, and wherein storing the summarized data comprises, for each of the plurality of summary levels;
determining a storage size of each of the one or more partitions for the respective summary level prior to storing the summarized data for the respective summary level, comprising dividing a respective retention period for the respective summary level by a pre-defined constant, wherein at least one of the retention periods is configurable by a user;
storing the summarized data for the respective summary level in one or more partitions of a respective temporary database table; and
merging the one or more partitions of the respective temporary database table with the one or more partitions of the database table for the respective summary level; and
deleting the summarized data from the database table, wherein the summarized data for each of the plurality of summary levels is deleted upon expiration of the respective retention period for the respective summary level.
9 Assignments
0 Petitions
Accused Products
Abstract
A system, method, and computer-accessible medium are disclosed for maintaining data at a plurality of summary levels in a single table. Data may be summarized into a plurality of summary levels. Each of the summary levels may comprise summarized data over a respective one of a plurality of intervals of time. The plurality of summary levels may vary in granularity of the summarized data. The summarized data in the plurality of summary levels may be stored in a single table in a database.
-
Citations
10 Claims
-
1. A computer-implemented method comprising:
collecting data indicative of performance of a monitored computer system;
storing the data in a database table, wherein the database table is stored on a storage device;
summarizing the data into a plurality of summary levels, wherein each of the summary levels comprises summarized data over a respective one of a plurality of intervals of time;
storing the summarized data in the plurality of summary levels in the database table, wherein the database table comprises a respective one or more partitions corresponding to each of the plurality of summary levels, wherein the summarized data for each of the plurality of summary levels is stored in the corresponding one or more partitions of the database table, and wherein storing the summarized data comprises, for each of the plurality of summary levels;
determining a storage size of each of the one or more partitions for the respective summary level prior to storing the summarized data for the respective summary level, comprising dividing a respective retention period for the respective summary level by a pre-defined constant, wherein at least one of the retention periods is configurable by a user;
storing the summarized data for the respective summary level in one or more partitions of a respective temporary database table; and
merging the one or more partitions of the respective temporary database table with the one or more partitions of the database table for the respective summary level; and
deleting the summarized data from the database table, wherein the summarized data for each of the plurality of summary levels is deleted upon expiration of the respective retention period for the respective summary level.- View Dependent Claims (2, 3, 4)
-
5. A non-transitory, computer-accessible memory medium comprising program instructions, wherein the program instructions are computer-executable to implement:
- collecting data indicative of performance of a monitored computer system;
storing the data in a database table, wherein the database table is stored on a storage device;
summarizing the data into a plurality of summary levels, wherein each of the summary levels comprises summarized data over a respective one of a plurality of intervals of time;
storing the summarized data in the plurality of summary levels in the database table, wherein the database table comprises a respective one or more partitions corresponding to each of the plurality of summary levels, wherein the summarized data for each of the plurality of summary levels is stored in the corresponding one or more partitions of the database table, and wherein storing the summarized data comprises, for each of the plurality of summary levels;
determining a storage size of each of the one or more partitions for the respective summary level prior to storing the summarized data for the respective summary level, comprising dividing a respective retention period for the respective summary level by a pre-defined constant, wherein at least one of the retention periods is configurable by a user;
storing the summarized data for the respective summary level in one or more partitions of a respective temporary database table; and
merging the one or more partitions of the respective temporary database table with the one or more partitions of the database table for the respective summary level; and
deleting the summarized data from the database table, wherein the summarized data for each of the plurality of summary levels is deleted upon expiration of the respective retention period for the respective summary level. - View Dependent Claims (6, 7)
- collecting data indicative of performance of a monitored computer system;
-
8. A system comprising:
- a database management system comprising a storage device, wherein the storage device is configured to store a statistics table;
a processor; and
a memory coupled to the processor, wherein the memory stores program instructions which are executable by the processor to;
collect data indicative of performance of a monitored computer system;
store the data in the statistics table;
summarize the data into a plurality of summary levels, wherein each of the summary levels comprises summarized data over a respective one of a plurality of intervals of time;
store the summarized data in the plurality of summary levels in the statistics table, wherein the database table comprises a respective one or more partitions corresponding to each of the plurality of summary levels, wherein the summarized data for each of the plurality of summary levels is stored in the corresponding one or more partitions of the statistics table, and wherein the program instructions are executable by the processor to;
determine a storage size of each of the one or more partitions for the respective summary level prior to storing the summarized data for the respective summary level, comprising dividing a respective retention period for the respective summary level by a pre-defined constant, wherein at least one of the retention periods is configurable by a user;
store the summarized data for the respective summary level in one or more partitions of a respective temporary database table, wherein the database management system is configured to store the respective temporary database table; and
merge the one or more partitions of the respective temporary database table with the one or more partitions of the statistics table for the respective summary level; and
delete the summarized data from the statistics table, wherein the summarized data for each of the plurality of summary levels is deleted upon expiration of the respective retention period for the respective summary level. - View Dependent Claims (9, 10)
- a database management system comprising a storage device, wherein the storage device is configured to store a statistics table;
Specification