Mechanism for monitoring data using watchlist items

• US 10,454,947 B2
• Filed: 04/08/2014
• Issued: 10/22/2019
• Est. Priority Date: 04/08/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Rodgers, Michael Patrick, Walsh, Christopher Lee
• Primary Examiner(s): Bayou, Yonas A
• Application Number:
  US14/247,810
• Publication Number:
  US 20140304811A1
• Time in Patent Office: 2,023 Days
• CPC Class Codes: H04L 63/1408 by monitoring network traffic monitoring network traffic per se H04L43/00

Abstract

Embodiments of the present invention provide a mechanism for monitoring data using a watchlist item and a watchlist item definition that includes a set of parameters for identifying a set of data items for user action and criteria for recommending or requiring user action for the set of data items to be identified.

Claims

1. A method for monitoring one or more data items in a database, comprising:

using at least one processor that is programmed or configured for performing a process, the process comprising;

determining a set of parameters for identifying at least one data item amongst the one or more data items in the database;

determining criteria for recommending or requiring user action for the at least one data item to be identified;

creating a watchlist item definition for evaluating the one or more data items in the database, wherein the watchlist item definition defines at least the determined set of parameters for identifying the at least one data item amongst the one or more data items in the database and the determined criteria for recommending or requiring user action for the at least one data item to be identified, wherein at least one parameter of the determined set of parameters defines an interval at which the data items in the database is to be evaluated;

evaluating the watchlist item definition at the defined interval to identify the at least one data item, wherein the evaluation comprises comparing the one or more data items in the database against the defined set of parameters in the watchlist item definition;

presenting an indication of the identified at least one data item; and

providing an alert recommending or requiring user action when the identified at least one data item meets the criteria for recommending or requiring user action defined in the watchlist item definition, wherein the alert is a warning alert when the identified at least one data item meets a warning threshold, and wherein the alert is a critical alert when the identified at least one data item meets the warning threshold and a critical threshold.

2. The method of claim 1, wherein identifying the at least one data item comprises utilizing an existing framework for a database having the at least one data item.

3. The method of claim 2, wherein identifying the at least one data item involves performing logical operations on the database.

4. The method of claim 2, wherein utilizing the existing framework comprises performing a query.

5. The method of claim 1, further comprising re-evaluating the watchlist item definition.

6. The method of claim 5, wherein the watchlist item definition is re-evaluated upon user request.

7. The method of claim 5, wherein the watchlist item definition is re-evaluated periodically.

8. The method of claim 1, wherein the indication of the identified at least one data item and the alert recommending or requiring user action are provided to a user without requiring the user to perform an active step.

9. The method of claim 1, wherein selecting the indication of the identified a least one data item allows the user to be presented with identified at least one data item.

10. A non-transitory computer program product embodied on a computer readable medium, the non-transitory computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method for monitoring data items in a database comprising:

determining a set of parameters for identifying at least one data item amongst the one or more data items in the database;

determining criteria for recommending or requiring user action for the at least one data item to be identified;

creating a watchlist item definition for evaluating the one or more data items in the database, wherein the watchlist item definition defines at least the determined set of parameters for identifying the at least one data item amongst the one or more data items in the database and the determined criteria for recommending or requiring user action for the at least one data item to be identified, wherein at least one parameter of the determined set of parameters defines an interval at which the data items in the database is to be evaluated;

evaluating the watchlist item definition at the defined interval to identify the at least one data item, wherein the evaluation comprises comparing the one or more data items in the database against the defined set of parameters in the watchlist item definition;

presenting an indication of the identified at least one data item; and

providing an alert recommending or requiring user action when the identified at least one data item meets the criteria for recommending or requiring user action defined in the watchlist item definition, wherein the alert is a warning alert when the identified at least one data item meets a warning threshold, and wherein the alert is a critical alert when the identified at least one data item meets the warning threshold and a critical threshold.

11. The computer program product of claim 10, wherein identifying the at least one data item comprises utilizing an existing framework for a database having the at least one data item.

12. The computer program product of claim 11, wherein identifying the at least one data item involves performing logical operations on the database.

13. The computer program product of claim 11, wherein utilizing the existing framework comprises performing a query.

14. The computer program product of claim 10, further comprising re-evaluating the watchlist item definition.

15. The computer program product of claim 14, wherein the watchlist item definition is re-evaluated upon user request.

16. The computer program product of claim 14, wherein the watchlist item definition is re-evaluated periodically.

17. The computer program product of claim 10, wherein the indication of the identified at least one data item and the alert recommending or requiring user action are provided to a user without requiring the user to perform an active step.

18. The computer program product of claim 10, wherein selecting the indication of the identified at least one data item allows the user to be presented with the set of data items for user action.

19. A system for monitoring data items in a database, comprising:

a processor;

a memory comprising computer code executed using the processor, in which the computer code implements a process for;

determining a set of parameters for identifying at least one data item amongst the one or more data items in the database;

determining criteria for recommending or requiring user action for the at least one data item to be identified;

creating a watchlist item definition for evaluating the one or more data items in the database, wherein the watchlist item definition defines at least the determined set of parameters for identifying the at least one data item amongst the one or more data items in the database and the determined criteria for recommending or requiring user action for the at least one data item to be identified, wherein at least one parameter of the determined set of parameters defines an interval at which the data items in the database is to be evaluated;

evaluating the watchlist item definition at the defined interval to identify the at least one data item, wherein the evaluation comprises comparing the one or more data items in the database against the defined set of parameters in the watchlist item definition;

presenting an indication of the identified at least one data item; and

providing an alert recommending or requiring user action when the identified at least one data item meets the criteria for recommending or requiring user action defined in the watchlist item definition, wherein the alert is a warning alert when the identified at least one data item meets a warning threshold, and wherein the alert is a critical alert when the identified at least one data item meets the warning threshold and a critical threshold.

20. The system of claim 19, wherein identifying the at least one data item comprises utilizing an existing framework for a database having the at least one data item.

21. The system of claim 20, wherein identifying the at least one data item involves performing logical operations on the database.

22. The system of claim 20, wherein utilizing the existing framework comprises performing a query.

23. The system of claim 19, further comprising re-evaluating the watchlist item definition.

24. The system of claim 23, wherein the watchlist item definition is re-evaluated upon user request.

25. The system of claim 23, wherein the watchlist item definition is re-evaluated periodically.

26. The system of claim 19, wherein the indication of the identified at least one data item and the alert recommending or requiring user action are provided to a user without requiring the user to perform an active step.

27. The system of claim 19, wherein selecting the indication of the identified at least one data item allows the user to be presented with the set of data items for user action.