Trigger system for databases using proxy
First Claim
Patent Images
1. A computer system comprising:
- at least one processor; and
at least one computer-readable medium having stored thereon machine readable instructions that are executable by the at least one processor to implement a proxy that is positioned between one or more clients and a database, implementing the proxy including at least;
monitoring traffic to and from the database, including monitoring one or more queries to the database from the one or more clients, and monitoring one or more corresponding responses from the database to the one or more clients;
based on monitoring the traffic to and from the database, identifying at least one of;
a query from a client of the one or more clients to the database corresponding to a request to modify the database;
ora response from the database to the client that indicates that the database performed a modification of the database associated with the request;
based on the request being a request to modify the database, or based on the response indicating that the database performed the modification, determining that the request requires a triggering event;
generating the trigger event based on the request, the trigger event indicating the modification of the database associated with the request; and
causing the trigger event to be communicated to at least one client of the one or more clients.
1 Assignment
0 Petitions
Accused Products
Abstract
A proxy module for monitoring modifications to a database and external to the database includes a query processing module to monitor traffic to and from the database. The traffic includes queries to the database. The query processing module is further to identify a query corresponding to a request to modify the database. A trigger event module is to generate a trigger event based on the request. The trigger event indicates a modification of the database associated with the request. The trigger event module is further to cause the trigger event to be communicated from the proxy module to at least one entity accessing the database.
-
Citations
20 Claims
-
1. A computer system comprising:
-
at least one processor; and at least one computer-readable medium having stored thereon machine readable instructions that are executable by the at least one processor to implement a proxy that is positioned between one or more clients and a database, implementing the proxy including at least; monitoring traffic to and from the database, including monitoring one or more queries to the database from the one or more clients, and monitoring one or more corresponding responses from the database to the one or more clients; based on monitoring the traffic to and from the database, identifying at least one of; a query from a client of the one or more clients to the database corresponding to a request to modify the database;
ora response from the database to the client that indicates that the database performed a modification of the database associated with the request; based on the request being a request to modify the database, or based on the response indicating that the database performed the modification, determining that the request requires a triggering event; generating the trigger event based on the request, the trigger event indicating the modification of the database associated with the request; and causing the trigger event to be communicated to at least one client of the one or more clients. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A method for triggering based on modifications to a database, the method comprising:
-
monitoring, external to the database, traffic to and from the database, including monitoring one or more queries to the database from one or more clients of the database, and monitoring one or more corresponding responses from the database to the one or more clients; based on monitoring the traffic to and from the database, identifying at least one of; a query from a client of the one or more clients to the database corresponding to a request to modify the database;
ora response from the database to the client that indicates that the database performed a modification of the database associated with the request; based on the request being a request to modify the database, or based on the response indicating that the database performed the modification, determining that the request requires a triggering event; generating a trigger event based on the request, the trigger event indicating the modification of the database associated with the request; and causing the trigger event to be communicated to at least one client of the one or more clients. - View Dependent Claims (15, 16, 17, 18, 19)
-
-
20. A computer program product comprising one or more hardware storage devices having stored thereon machine readable instructions that are executable by at least one processor to implement a proxy that is positioned between one or more clients and a database, implementing the proxy including at least:
-
monitoring traffic to and from the database, including monitoring one or more queries to the database from the one or more clients, and monitoring one or more corresponding responses from the database to the one or more clients; based on monitoring the traffic to and from the database, identifying at least one of; a query from a client of the one or more clients to the database corresponding to a request to modify the database;
ora response from the database to the client that indicates that the database performed a modification of the database associated with the request; based on the request being a request to modify the database, or based on the response indicating that the database performed the modification, determining that the request requires a triggering event; generating the trigger event based on the request, the trigger event indicating the modification of the database associated with the request; and causing the trigger event to be communicated to at least one client of the one or more clients.
-
Specification