Identifying database request sources
View Patent ↗A method, computer program, and database system are disclosed for identifying a second source of a request sent to a database management system by a first source. A database message is received from the first source. The database message includes a second value for a second source-identifying parameter. The second value identifies a second source. The second value for the second source-identifying parameter is stored in a log.
1. A method for identifying the source of a request to a database management system, the method including:
a source application including source application identifying information along with the request when it is sent from the source application through a plurality of intermediate applications in sequence to the database management system;
each of the plurality of intermediate applications including along with the request intermediate application identifying information regarding itself along with the source application identifying information and any intermediate application identifying information for intermediate applications that earlier received and passed on the request;
the last intermediate application passing on the request, the source identifying information, and all intermediate application identifying information to the database management system;
the database management system logging the source identifying information and all intermediate application identifying information and executing the request; and
the database management system receiving a subsequent request from the last intermediate application without information identifying the source application.
2. A method for identifying the source of a request by a database management system, the method including the database management system:
receiving a request from a last intermediate application, the last intermediate application being the last of a plurality of intermediate applications that passed on the request between the source application and the database management system, the request including:
source application identifying information providing information regarding a source application that originated the request; and
a plurality of intermediate application identifying information, each intermediate identifying information providing information regarding one of the plurality of intermediate applications;
identifying the source application from the source application identifying information;
identifying the plurality of intermediate applications;
logging the source application and the plurality of intermediate applications;
executing the request; and
receiving a subsequent request from the last intermediate application without information identifying the source application.
3. A method for identifying the source of a request by a database management system, the method including:
the database management system receiving a session-initiating message from a last intermediate application including the request and information identifying a source application that originated the request;
the database management system logging the identity of the last intermediate application and the source application with the request;
the database management system receiving a subsequent request from the last intermediate application without information identifying the source application;
the database management system logging the identity of the last intermediate application and the source application with the subsequent request; and
the database management system executing the request.