EFFICIENTLY DELIVERING EVENT MESSAGES USING COMPILED INDEXING AND PAGINATED REPORTING
First Claim
1. A data processing method comprising:
- receiving a plurality of event messages from internetworking devices, each of the event messages including a sequential identifier;
storing the event messages in a working table in a data storage unit;
when a number of the event messages exceeds a specified threshold, renaming the working table as a rollover table and creating a new working table to receive a plurality of subsequent event messages;
repeating the preceding receiving, storing, and creating as additional event messages are received and for additional rollover tables each storing the specified threshold number of messages;
for each rollover table, storing, in a management table, a reference to the rollover table, wherein the reference identifies a range of sequential identifiers included in the rollover table;
generating summary data that summarizes at least a subset of the event messages included in the rollover tables according to one or more criteria;
storing, in a summary table, the summarized data in association with the reference to the rollover tables.
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques for compiled indexing and paginated reporting are described. Event messages, having sequential identifiers, are received and stored in a working table. The working table is renamed as a rollover table upon receiving a threshold number of the event messages and a new working table is created. A reference to the rollover table is stored in a management table. Summary data which summarizes each rollover table according to predetermined criteria is stored in a summary table with the reference to the corresponding rollover table. When a query to the event messages is received, a response to the query is generated based on the contents of the summary table and management table. The response may also include a predetermined quantity of event messages based on a dimension of a window of a graphical user interface of a client computer which issued the query.
-
Citations
20 Claims
-
1. A data processing method comprising:
-
receiving a plurality of event messages from internetworking devices, each of the event messages including a sequential identifier; storing the event messages in a working table in a data storage unit; when a number of the event messages exceeds a specified threshold, renaming the working table as a rollover table and creating a new working table to receive a plurality of subsequent event messages; repeating the preceding receiving, storing, and creating as additional event messages are received and for additional rollover tables each storing the specified threshold number of messages; for each rollover table, storing, in a management table, a reference to the rollover table, wherein the reference identifies a range of sequential identifiers included in the rollover table; generating summary data that summarizes at least a subset of the event messages included in the rollover tables according to one or more criteria; storing, in a summary table, the summarized data in association with the reference to the rollover tables. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A non-transitory computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform:
-
receiving a plurality of event messages from internetworking devices, each of the event messages including a sequential identifier; storing the event messages in a working table in a data storage unit; when a number of the event messages exceeds a specified threshold, renaming the working table as a rollover table and creating a new working table to receive a plurality of subsequent event messages; repeating the preceding receiving, storing, and creating as additional event messages are received and for additional rollover tables each storing the specified threshold number of messages; for each rollover table, storing, in a management table, a reference to the rollover table, wherein the reference identifies a range of sequential identifiers included in the rollover table; generating summary data that summarizes at least a subset of the event messages included in the rollover tables according to one or more criteria; storing, in a summary table, the summarized data in association with the reference to the rollover tables. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
Specification