Patent ID: 7640235

Claim:
A method for real-time correlating between requests to a web server and requests to a database server, comprising: identifying correlated pairs of structured query language (SQL) templates and uniform resource locators (URLs); for each incoming request to the database server, binding a web application context in which the request to the database server is made; wherein identifying the correlated pairs of SQL templates and URLs, further comprises: creating a first matrix, wherein each row of the first matrix represents a URL and each column represents a SQL template and wherein each entry in the first matrix includes a counter; extracting the URL from an incoming HTTP request; inserting the URL to an available row in the first matrix; adding the incoming HTTP request to a list of pending HTTP requests for the URL: converting an incoming SQL query to a SQL template; inserting the SQL template to an available column in the first matrix; incrementing the counter of each entry of a respective URL that has at least one pending HTTP request; and marking all entries in the first matrix having a counter's value greater than a predefined threshold.