System and method for generating aggregate data
AssigneeServiceNow, Inc.
InventorGeorgi Kamenov Ivanov
Life of this patent
Estimating the term…
Abstract
A system is provided for updating an aggregate value used to generate a display on a client device. The system can include a server device including a processor and a memory, the memory including instructions executable by the processor to: generate the aggregate value based on a set of records stored in a database; generate a metadata record that includes values based on the set of records used to generate the aggregate value; identify a change to the set of records; determine whether the change will affect a validity of the aggregate value; generate an updated aggregate value based on the change and a metadata record; update the metadata record to include values based on the change; and communicate the updated aggregate value to the client device.
Claims27
A system for updating an aggregate value used to generate a display on a client device, the system comprising:
- a server device including a processor and a memory, the memory including instructions executable by the processor to:
- generate the aggregate value based on a set of records stored in a database;
- generate and store a metadata record that includes the aggregate value and an aggregation type of the aggregate value;
- intercept an impending database operation associated with the set of records;
- determine whether the database operation will affect the aggregate value based on a comparison between the database operation and the metadata record;
- and
- in response to a determination that the database operation will affect the aggregate value:
- generate an updated aggregate value based on the database operation, the aggregate value, and the aggregate type;
- update the metadata record to include the updated aggregate value;
- and
- communicate the updated aggregate value to the client device.
A method for updating an aggregate value used to generate a display on a client device, the method comprising:
- generating the aggregate value based on a set of records stored in a database;
- generating and storing a metadata record that includes the aggregate value and an aggregation type of the aggregate value;
- intercepting a database operation associated with the set of records;
- determining whether the database operation will affect the aggregate value based on a comparison between the database operation and the metadata record before the database operation is executed against the set of records;
- and
- in response to a determination that the database operation will affect the aggregate value:
- generating an updated aggregate value based on the database operation, the aggregate value, and the aggregate type;
- updating the metadata record to include the updated aggregate value;
- and
- communicating the updated aggregate value to the client device.
A non-transitory computer-readable storage medium, comprising executable instructions that, when executed by a processor, facilitate performance of operations, comprising:
- generating an aggregate value based on a set of records stored in a database;
- generating and storing a metadata record that includes the aggregate value and an aggregation type of the aggregate value;
- intercepting a database operation associated with the set of records;
- determining whether the database operation will affect the aggregate value based on a comparison between the database operation and the metadata record;
- and
- in response to a determination that the database operation will affect the aggregate value:
- generating an updated aggregate value based on the database operation, the aggregate value, and the aggregate type;
- updating the metadata record to include values the updated aggregate value;
- and
- communicating the updated aggregate value to a client device.
Dependencies are inferred from the claim text.