SYSTEMS AND METHODS FOR AUTOMATIC QUERY GENERATION AND NOTIFICATION
Systems and methods for providing notifications to users of one or more client interfaces based on data retrieved from a plurality of databases remote to the one or more client interfaces. A notification definition data store can be configured to store one or more notification definitions each comprising one or more query criteria, or data requirements. A notification configuration data store can associate one or more notification definitions with one or more users. A processing server can generate a query request for each query criteria of each notification definition associated with each user in the set of active users. A query management engine can retrieve each query request and retrieve a query response based on the query criteria of the query request from the plurality of databases. A display generator can display user interface elements based on the retrieved query responses for each of the query criteria of the query execution queue.
1 . A system for providing notifications to users of one or more client interfaces based on data retrieved from a plurality of databases remote to the one or more client interfaces, the system comprising:
a notification definition data store configured to store one or more notification definitions each comprising one or more query criteria;
an notification configuration data store configured to associate one or more notification definitions with one or more users;
a user activity tracker configured to provide a set of active users;
a processing server configured to generate a query request for each query criteria of each notification definition associated with each user in the set of active users and store the query request in a query execution queue;
a query management engine configured to retrieve each query request from the query execution queue, and to retrieve a query response based on the query criteria of the query request from the plurality of databases; and
a display generator for each of the one or more client interfaces configured to display user interface elements based on the retrieved query responses for each of the query criteria of the query execution queue.
2 . The system of claim 1 , wherein each notification definition further comprises one or more thresholds associated with the one or more query criteria, and wherein the display generator is configured to display the user interface elements based on a query response only if the query response exceeds at least one of the associated thresholds.
3 . The system of claim 1 , wherein each notification definition further comprises a display format, and wherein the display generator is configured to display the user interface elements based on the display format of the associated notification definition.
4 . The system of claim 1 , wherein each notification definition further comprises a query frequency, and wherein the query management engine is further configured to retrieve the query response from the plurality of databases at an interval based on the query frequency.
5 . The system of claim 1 , wherein each notification definition further comprises a query priority, and wherein the query management engine is further configured to retrieve the query response from the plurality of databases at an interval based on the query priority.
6 . The system of claim 1 , wherein the query management engine is further configured to create one or more indexes on the plurality of databases based on the query requests in the query execution queue.
7 . The system of claim 1 , wherein the notification definition further comprises a role list, the user activity tracker is configured to provide a user role for each user in the set of active users, and the notification configuration data store is configured to automatically associate a notification definition with each active user in the set of active users having a user role included in the role list of the notification definition.
8 . The system of claim 1 , wherein the notification definition further comprises a site list, the user activity tracker is configured to provide a user site for each user in the set of active users, and wherein the notification configuration data store is configured to automatically associate a notification definition with each active user in the set of active users having a user site included in the site list of the notification definition.
9 . The system of claim 1 , wherein each of the one or more client interfaces is accessible by an active user on a computing system.
10 . The system of claim 9 , wherein the computing system comprises a mobile device.
11 . The system of claim 9 , wherein each of the one or more client interfaces comprises a web-based interface.
12 . A method for providing notifications to a user of one or more client interfaces based on data retrieved from a plurality of databases remote to the one or more client interfaces, the method comprising:
storing store one or more notification definitions each comprising one or more query criteria;
associating one or more notification definitions with one or more users;
providing a set of active users;
generating a query request for each query criteria of each notification definition associated with each user in the set of active users;
storing each query request an query execution queue;
executing each query request from the query execution queue to retrieve a query response from the plurality of databases; and
displaying user interface elements based on the retrieved query responses on each of the one or more client interfaces based on an identity of the user of the client interface.
13 . The method of claim 12 , wherein each notification definition further comprises one or more thresholds associated with the one or more query criteria; and
the method further comprises displaying a query response only if the query response exceeds at least one of the one or more associated thresholds.
14 . The method of claim 12 , wherein each notification definition further comprises a display format; and
the method further comprises displaying each query response based on the display format of the associated notification definition.
15 . The method of claim 12 , wherein each notification definition further comprises a query frequency; and
the method further comprises executing each query request from the query execution queue at an interval based on the query frequency.
16 . The method of claim 12 , wherein each notification definition further comprises a query priority; and
the method further comprises executing each query request from the query execution queue at an interval based on the query priority.
17 . The method of claim 12 , further comprising creating one or more indexes on the plurality of databases based on the query requests in the query execution queue.
18 . The method of claim 12 , wherein the notification definition further comprises a role list; and
the method further comprises providing a user role for each user in the set of active users, and automatically associating a notification definition with each active user in the set of active users having a user role included in the role list of the notification definition.
19 . The method of claim 12 , wherein the notification definition further comprises a site list; and
the method further comprises providing a user site for each user in the set of active users, and automatically associating a notification definition with each active user in the set of active users having a user site included in the site list of the notification definition.