Methods, systems and software for identifying and managing database work

• US 7,853,579 B2
• Filed: 04/24/2007
• Issued: 12/14/2010
• Est. Priority Date: 08/14/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Colrain, Carol Lyndall, Chidambaran, Luxi, Chen, Jane X., Tsukerman, Alex, Ramacher, Mark, Ngai, Gary, Dageville, Benoit, Wood, Graham
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): Chbouki; Tarek
• Application Number:
  US11/739,277
• Publication Number:
  US 20070255757A1
• Time in Patent Office: 1,330 Days
• Field of Search: 707/706, 705/26
• US Class Current: 707/706
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

Various embodiments of the invention provide solutions to allow more sophisticated management of the relationship between a database and its clients (which can be, inter alia, end users, business applications, etc.). Merely by way of example, some embodiments can facilitate the management of work requests in a database, as well as the management of the quality-of-service in a database system. In some embodiments, an identification handle may be assigned to a database work request. A database management application can use the identification handle to identify the work request, as well, perhaps, as any related work requests. The identification handle may also identify the database (and/or an instance thereof) and/or a clustered database node, and the identification handle may be transmitted to a mid-tier application, e.g., to notify the mid-tier about the processing of the work request, changes in quality-of service, server availability, etc.

Claims

1. A method of identifying a database work request, the method comprising:

assigning a first identification handle to a first database work request, wherein the first identification handle comprises a first identifier that identifies an entity that created the first database work request;

receiving at a database management application the first work request together with the first identification handle assigned to the work request, wherein the database management application manages a database to which the work request corresponds; and

generating a first hash value associated with the identification handle assigned to the work request;

receiving at a database management application a second database work request together with a second identification handle assigned to the second database work request, wherein the second identification handle comprises a second identifier;

generating a second hash value associated with the second identification handle and corresponding to the second identifier;

comparing the second hash value with the first hash value;

associating the second database work request with the first database work request, based on a comparison of the second hash value with the first hash value;

associating a plurality of database work requests based on identification handles assigned to each of the plurality of database work requests, wherein the plurality of database work requests comprises the first database work request and the second database work request;

taking one or more actions based on the associated first database work request and the associated second database work request, wherein taking one or more actions comprises;

collecting an aggregate statistic for the plurality of database work requests;

calculating a metric for the plurality of database work requests; and

using the calculated metric to control a quality-of-service for the plurality of database work requests.

2. A method of identifying a database work request as recited in claim 1, the method further comprising using the hash value to identify the database work request.

3. A method of identifying a database work request as recited in claim 1, wherein the identification handle comprises a plurality of identifiers, wherein generating at least one hash value comprises generating a plurality of hash values, and wherein each of the hash values is associated with one of the plurality of identifiers.

4. A method of identifying a database work request as recited in claim 3, wherein the plurality of identifiers comprises at least two identifiers selected from the group consisting of a client identifier, a service identifier, a service/module/action identifier, a unique database name, a cluster node name and an instance name.

5. A method of identifying a database work request as recited in claim 1, wherein the entity associated with the database work request is a database client application.

6. A method of identifying a database work request as recited in claim 1, wherein the entity associated with the database work request is a web browser.

7. A method of identifying a database work request as recited in claim 6, wherein the identification handle corresponds to a cookie stored by the web browser.

8. A method of identifying a database work request as recited in claim 1, wherein the entity associated with the database work request is a mid-tier application.

9. A method of identifying a database work request as recited in claim 1, wherein the entity associated with the database work request is a database service.

10. A method of identifying a database work request as recited in claim 1, wherein the entity associated with the database work request is combination of a database service, a database module and a database action.

11. A method of identifying a database work request as recited in claim 1, wherein the identification handle comprises a client identifier.

12. A method of identifying a database work request as recited in claim 1, wherein the identification handle comprises a username for a mid-tier application.

13. A method of identifying a database work request as recited in claim 1, wherein the identification handle comprises a value selected from a group consisting of a unique name of the database to which the work request corresponds, an instance name for an instance of the database to which the work request corresponds, and a node name for a clustered node on which the database to which the work request corresponds resides.

14. A method of identifying a database work request as recited in claim 1, wherein the identification handle comprises a service identifier.

15. A method of identifying a database work request as recited in claim 1, wherein the identification handle comprises a service identifier, a module identifier, and an action identifier.

16. A method of identifying a database work request as recited in claim 1, wherein storing the hash value associated with the identification handle comprises storing the hash value in the database to which the work request corresponds.

17. A method of identifying a database work request as recited in claim 1, wherein the identification handle is configured to persist throughout the life of a database call associated with the work request.

18. A method of identifying a database work request as recited in claim 1, wherein the identification handle is configured to persist throughout the life of a database session associated with the work request.

19. A method of identifying a database work request as recited in claim 1, the method further comprising:

measuring work for a database session, wherein the database session comprises the first work request and the second work request.

20. A method of identifying a database work request as recited in claim 1, wherein the work request is associated with a first database session, the method further comprising:

establishing a second database session; and

passing the identification handle from the first database session to the second database session.

21. A method of identifying a database work request as recited in claim 20, wherein the first database session and the second database session are parallel database sessions.

22. A method of identifying a database work request as recited in claim 20, wherein the first database session and the second database session have a hierarchical relationship.

23. A method of identifying a database work request as recited in claim 1, wherein the work request is initiated by a mid-tier application, and wherein the method further comprises:

associating the identification handle with a set of information; and

transmitting the set of information, together with the identification handle, from the database for reception by the mid-tier application.

24. A method of identifying a database work request as recited in claim 23, wherein the set of information pertains to a quality-of-service related to the database work request.

25. A method of identifying a database work request as recited in claim 23, wherein the set of information pertains to an availability of a database server associated with the database work request.

26. A method of identifying a database work request as recited in claim 23, wherein the identification handle comprises an identifier corresponding to a database name, the method further comprising:

the mid-tier application identifying, with the identifier, the database to which the work request corresponds.

27. The method of claim 1, wherein taking an action comprises:

measuring work for a database session, wherein the database session comprises the first work request and the second work request; and

outputting a record of a measurement of the work for the database session.

28. The method of claim 27, wherein outputting a record of the measurement of the work for the database session comprises an operation selected from the group consisting of storing the measurement in the database, storing the measurement in a separate file, displaying the measurement for a user, and printing the measurement.

29. The method of claim 1, wherein taking one or more actions comprises tracing the first database work request and the second database work request.

30. A computer system for identifying a database work request, the computer system comprising:

a first computer, comprising;

a processor; and

a computer readable medium, the computer readable medium comprising instructions executable by the processor to;

assign a first identification handle to a first database work request, wherein the first identification handle comprises an identifier that identifies an entity that created the first database work request; and

assign a second identification handle to a second database work request, wherein the second identification handle comprises a second identifier; and

a second computer, comprising;

a second processor; and

a second computer readable medium in communication with the second processor, the second computer readable medium comprising a database management application executable by the processor, a database managed by the database management application, and instructions executable by the second processor to;

receive at the database management application the first work request together with the first identification handle assigned to the first work request, wherein the first work request corresponds to the database managed by the database management application;

generate a first hash value associated with the first identification handle assigned to the first work request;

receive at the database management application the second work request together with the second identification handle assigned to the second work request;

generate a second hash value associated with the second identification handle and corresponding to the second identifier;

compare the second hash value with the first hash value;

associate the second database work request with the first database work request, based on a comparison of the second hash value with the first hash value;

associate a plurality of database work requests based on identification handles assigned to each of the plurality of database work requests, wherein the plurality of database work requests comprises the first database work request and the second database work request;

take one or more actions based on the associated first database work request and the associated second database work request, wherein taking one or more actions comprises;

collecting an aggregate statistic for the plurality of database work requests;

calculating a metric for the plurality of database work requests; and

using the calculated metric to control a quality-of-service for the plurality of database work requests.

31. A computer system for identifying a database work request as recited in claim 30, wherein the first computer is a client computer.

32. A computer system for identifying a database work request as recited in claim 31, wherein the first computer comprises a web browser configured to serve as a database client.

33. A computer system for identifying a database work request as recited in claim 31, wherein the first computer comprises a client application configured to interact with the database.

34. A computer system for identifying a database work request as recited in claim 31, the computer system further comprising:

a third computer comprising a mid-tier application configured to interact with the database.

35. A computer program stored on a computer-readable storage medium for identifying a database work request, the computer program comprising instructions executable by a computer to:

receive at a database management application a first work request together with a first identification handle assigned to the first work request, wherein the first work request corresponds to a database managed by the database management application, and wherein the first identification handle comprises an identifier that identifies an entity that created the first database work request;

generate a hash value associated with the identification handle assigned to the work request;

receive at the database management application a second database work request together with a second identification handle assigned to the second database work request, wherein the second identification handle comprises a second identifier;

generate a second hash value associated with the second identification handle and corresponding to the second identifier;

compare the second hash value with the first hash value;

associate the second database work request with the first database work request, based on a comparison of the second hash value with the first hash value;

associate a plurality of database work requests based on identification handles assigned to each of the plurality of database work requests, wherein the plurality of database work requests comprises the first database work request and the second database work request;

take one or more actions based on the associated first database work request and the associated second database work request, wherein taking one or more actions comprises;

collecting an aggregate statistic for the plurality of database work requests;

calculating a metric for the plurality of database work requests; and

using the calculated metric to control a quality-of-service for the plurality of database work requests.

36. A computer program as recited in claim 35, wherein the computer program is part of a relational database management application.

37. A computer program as recited in claim 35, wherein the computer program is configured to interoperate with a relational database management application.