System and method for automated construction of URL, cookie, and database query mapping

• US 6,748,386 B1
• Filed: 05/08/2001
• Issued: 06/08/2004
• Est. Priority Date: 04/24/2001
• Status: Expired due to Fees

• Current Assignee: NEC Corporation
• Original Assignee: NEC Corporation
• Inventors: Li, Wen-Syan
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): Black, Linh
• Application Number:
  US09/851,709
• Time in Patent Office: 1,127 Days
• Field of Search: 707/1-10, 707/100-104, 715/500.1, 715/501.1, 709/201, 709/203, 709/238, 709/239
• US Class Current: 1/1
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method for constructing a URL, cookie, and database query mapping is disclosed. The method is employed within a content delivery system comprising a Web server, an application server and a database management system (DBMS), wherein the Web server is coupled for receiving a URL request destined for an original servlet in the Web server. The method comprises redirecting the URL request to a wrapper servlet, which includes statements for extracting the URL string and cookie information, and assigning a job identification system variable containing the URL string and cookie information to the redirected URL request. The redirected URL request is then forwarded to the original servlet in the form of an HttpServletRequest. The HttpServletRequest is then communicated to the application server, which issues at least one query destined for an original database connection API the DBMS. The at least one query includes the job identification system. The query is then redirected to a wrapper database connection API within the DBMS, which includes statements for recovering the URL string and cookie information from the at least one query and constructing a URL, cookie, and database query mapping.

Claims

1. In a content delivery system comprising one or more servers for receiving a user information request destined for an original servlet in the one or more servers, a method for extracting user information request identification information from the user information request and attaching the user information request identification information to the user information request, comprising:

redirecting the user information request to a wrapper servlet, the wrapper servlet comprising statements for extracting the user information request identification information;

assigning a job identification system variable containing the user information request identification information to the redirected user information request; and

forwarding the redirected user information request to the original servlet.

2. The method as recited in claim 1, the content delivery system further including a database application or other program or servlet, the method further including:

issuing at least one query to the database application or other program or servlet, the at least one query including the job identification system variable;

redirecting the at least one query to a wrapper database connectivity API instead of an original database connectivity API;

executing the wrapper database connectivity API to recover the user information request identification information from the at least one query;

constructing a user information request identification information and query mapping; and

forwarding the redirected at least one query to the original database connectivity API.

3. The method as recited in claim 2, the method further including:

storing locations of cached content;

detecting changes to data associated with one or more queries; and

utilizing the user information request identification information and query mapping to send refresh or invalidate commands to the locations of the cached content associated with the changed data.

4. The method as recited in claim 3, further including capturing timestamp information at any of the process steps for Web site profiling.

5. The method as recited in claim 1, the user information request comprising a URL request.

6. The method as recited in claim 1, the user information request identification information comprising URL string and cookie information.

7. In a content delivery system comprising one or more servers for receiving a user information request destined for an original servlet in the one or more servers, a method for extracting user information request identification information from the user information request and attaching the user information request identification information to the user information request, comprising:

renaming the original servlet as original servlet′

;

renaming a wrapper servlet as a new original servlet;

redirecting the user information request to the new original servlet;

executing the new original servlet to extract the user information request identification information from the redirected user information request, and to assign a job identification system variable containing the user information request identification information to the redirected user information request; and

forwarding the redirected user information request to the original servlet′

.

8. The method as recited in claim 7, the content delivery system further including a database application or other program or servlet, the method further including:

issuing at least one query to the database application or other program or servlet, the at least one query including the job identification system variable;

redirecting the at least one query to a wrapper database connectivity API instead of an original database connectivity API;

executing the wrapper database connectivity API to recover the user information request identification information from the at least one query;

constructing a user information request identification information and query mapping; and

forwarding the redirected at least one query to the original database connectivity API.

9. The method as recited in claim 8, the method further including:

storing locations of cached content;

detecting changes to data associated with one or more queries; and

utilizing the user information request identification information and query mapping to send refresh or invalidate commands to the locations of the cached content associated with the changed data.

10. The method as recited in claim 9, further including capturing timestamp information at any of the process steps for Web site profiling.

11. The method as recited in claim 7, the user information request comprising a URL request.

12. The method as recited in claim 7, the user information request identification information comprising URL string and cookie information.

13. In a content delivery system comprising one or more servers for receiving a user information request destined for one or more original servlets in the one or more servers, a method for profiling Web site performance, comprising:

redirecting all user information requests destined for each particular original servlet in the one or more servers to a wrapper servlet associated with that particular original servlet, the wrapper servlet comprising statements for extracting user information request identification information from each redirected user information request;

assigning timestamp information and a job identification system variable containing the user information request identification information to each redirected user information request;

forwarding each redirected user information request to its associated particular original servlet; and

processing the timestamp information and the user information request identification information of each redirected URL request to generate a profile of the Web site performance.

14. The method as recited in claim 13, the user information request comprising a URL request.

15. The method as recited in claim 13, the user information request identification information comprising URL string and cookie information.

16. A content delivery system for extracting user information request identification information from a user information request and attaching the user information request identification information to the user information request, comprising:

one or more servers programmed for

receiving the user information request and redirecting the user information request to a wrapper servlet instead of an original servlet,

executing the wrapper servlet to extract the user information request identification information from the redirected user information request, and to assign a job identification system variable containing the user information request identification information to the redirected user information request, and

forwarding the redirected user information request to the original servlet.

17. The system as recited in claim 16, further including at least one database application or other program or servlet in communication with the one or more servers, the one or more servers further programmed for:

issuing at least one query to the at least one database application or other program or servlet, the at least one query including the job identification system variable; and

wherein the database application or other program or servlet is programmed for

receiving the at least one query and redirecting the at least one query to a wrapper database connectivity API instead of an original database connectivity API,

executing the wrapper database connectivity API to recover the user information request identification information from the at least one query,

constructing a user information request identification information and query mapping, and

forwarding the redirected at least one query to the original database connectivity API.

18. The system as recited in claim 17, the one or more servers further programmed for:

storing locations of cached content;

detecting changes to data associated with one or more queries; and

utilizing the user information request identification information and query mapping to send refresh or invalidate commands to the locations of the cached content associated with the changed data.

19. The system as recited in claim 18, further including capturing timestamp information at any of the server programmed steps for Web site profiling.

20. The system as recited in claim 16, the user information request comprising a URL request.

21. The method as recited in claim 16, the user information request identification information comprising URL string and cookie information.

22. A content delivery system for extracting user information request identification information from a user information request and attaching the user information request identification information to the user information request, comprising:

one or more servers programmed for

receiving the user information request destined for an original servlet, and renaming the original servlet as original servlet′

,

renaming a wrapper servlet as a new original servlet,

redirecting the user information request to the new original servlet,

executing the new original servlet to extract the user information request identification information from the redirected user information request, and to assign a job identification system variable containing the user information request identification information to the redirected user information request, and

forwarding the redirected user information request to the original servlet′

.

23. The system as recited in claim 22, further including at least one database application or other program or servlet in communication with the one or more servers, the one or more servers further programmed for:

issuing at least one query to the at least one database application or other program or servlet, the at least one query including the job identification system variable; and

wherein the database application or other program or servlet is programmed for

receiving the at least one query and redirecting the at least one query to a wrapper database connectivity API instead of an original database connectivity API,

executing the wrapper database connectivity API to recover the user information request identification information from the at least one query, and

constructing a user information request identification information and query mapping.

24. The system as recited in claim 23, the one or more servers further programmed for:

storing locations of cached content;

detecting changes to data associated with one or more queries; and

utilizing the user information request identification information and query mapping to send refresh or invalidate commands to the locations of the cached content associated with the changed data.

25. The system as recited in claim 24, further including capturing timestamp information at any of the server programmed steps for Web site profiling.

26. The system as recited in claim 22, the user information request comprising a URL request.

27. The system as recited in claim 22, the user information request identification information comprising URL string and cookie information.

28. A content delivery system for profiling Web site performance, comprising:

one or more servers programmed for

receiving one or more user information requests destined for one or more original servlets in the one or more servers,

redirecting all user information requests destined for each particular original servlet in the one or more servers to a wrapper servlet associated with that particular original servlet, the wrapper servlet comprising statements for extracting user information request identification information from each redirected user information request,

assigning timestamp information and a job identification system variable containing the user information request identification information to each redirected user information request,

forwarding each redirected user information request to its associated particular original servlet, and

processing the timestamp information and the user information request identification information of each redirected user information request to generate a profile of the Web site performance.

29. The system as recited in claim 28, the user information request comprising a URL request.

30. The system as recited in claim 28, the user information request identification information comprising URL string and cookie information.