Identifying database request sources

• US 8,280,867 B2
• Filed: 10/20/2005
• Issued: 10/02/2012
• Est. Priority Date: 10/20/2005
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Brown, Douglas P., Ramesh, Bhashyam, Richards, Anita
• Primary Examiner(s): Casanova, Jorge A
• Application Number:
  US11/254,374
• Publication Number:
  US 20070100793A1
• Time in Patent Office: 2,539 Days
• Field of Search: 707/100, 707/3, 707/1, 707/2, 707/4, 707/999.001, 707/999.002, 707/999.003, 707/999.004, 707/608, 707/703, 707/705, 707/899, 719/313
• US Class Current: 707/705
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

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.

Claims

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.