Sending control information with database statement

• US 20050187958A1
• Filed: 02/24/2004
• Published: 08/25/2005
• Est. Priority Date: 02/24/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Wong, Daniel Manhung
• Granted Patent: US 8,825,702 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2448 for particular applications; for extensibility, e.g. user defined types
• CPC Class Codes: G06F 16/2457 with adaptation to user needs

Abstract

Sending control information that is associated with a statement that controls how the statement is processed is disclosed. The information is available to the server even after the window session is closed. The information may be contained in a tag appended to the statement. In an embodiment, the information may be viewed by an administrator. The information may determine aspects of how the statement is executed that is not controlled by the execution engine. For example, the information may relate to security access, priority, quality of service, scheduling, and or use supplied routines.

Claims

1. A machine-implemented method for executing a database statement, the method comprising the steps of:

a database server receiving a request to execute a database statement, wherein the request specifies the database statement and a tag that does not conform to a database language;

wherein said tag specifies at least one parameter field and at least one parameter value;

in response to receiving the request, said database server storing the tag;

said database server executing said database statement, wherein during execution of said database statement said database server provides access to one or more of the at least one parameter values through a tag access mechanism provided by said database server.

2. The method of claim 1, wherein the database statement is written in a language in which results desired are specified, but no procedures for obtaining the results desired are specified.

3. The method of claim 1, wherein a priority for executing the database statement is determined based on the at least one parameter value.

4. The method of claim 1, wherein a security level is associated with the at least one parameter such that whether the database is entitled to access a component is based on the at least one parameter.

5. The method of claim 1, wherein the at least one parameter is accessible to a systems administrator.

6. The method of claim 1, wherein the at least one parameter is related to user context information.

7. The method of claim 1, wherein the tag comprises an indicator of a beginning of the tag, and an indicator of an end of the tag.

8. The method of claim 7, wherein the at least one parameter value is located between the indicator of the beginning and the indicator of the end of the tag.

9. The method of claim 8, wherein each of the at least one parameter fields comprises an indicator of a beginning of the parameter field, followed by the parameter value, which in turn is followed by an indicator of an end of the parameter field.

10. The method of claim 1 wherein the at least one parameter value can be accessed without accessing a session space associated with a database window, wherein the database statement was issued within the session window.

11. The method of claims 4, wherein the at least one parameter value can be accessed without accessing a session space associated with a database window, wherein the database statement was issued within the session window.

12. The method of claims 5, wherein the at least one parameter value can be accessed without accessing a session space associated with database window, wherein the database statement was issued within the session window.

13. The method of claims 6, wherein the at least one parameter value can be accessed after a session window has closed, wherein the database statement was issued within the session window.

14. A machine-readable medium carrying one or more sequences of instructions, which when executed by one or more processors, causes the one or more processors to perform a method comprising the steps of:

a database server receiving a request to execute a database statement, wherein the request specifies the database statement and a tag that does not conform to a database language;

wherein said tag specifies at least one parameter field and at least one parameter value;

in response to receiving the request, said database server storing the tag;

said database server executing said database statement, wherein during execution of said database statement said database server provides access to one or more of the at least one parameter values through a tag access mechanism provided by said database server.

15. The machine-readable medium of claim 14, wherein the database statement is written in a language in which results desired are specified, but no procedures for obtaining the results desired are specified.

16. The machine-readable medium of claim 14, wherein a priority for executing the database statement is determined based on the at least one parameter value.

17. The machine-readable medium of claim 14, wherein the at least one parameter is accessible to a systems administrator.

18. The machine-readable medium of claim 14, wherein the at least one parameter is related to user context information.

19. The machine-readable medium of claim 14, wherein the tag comprises an indicator of a beginning of the tag, and an indicator of an end of the tag.

20. The machine-readable medium of claim 19, wherein the at least one parameter value is located between the indicator of the beginning and the indicator of the end of the tag.

21. The machine-readable medium of claim 20, wherein each of the at least one parameter fields comprises an indicator of a beginning of the parameter field, followed by the parameter value, which in turn is followed by an indicator of an end of the parameter field.

22. The machine-readable medium of claim 21, wherein the at least one parameter value can be accessed without accessing a session space associated with a database window, wherein the database statement was issued within the session window.

23. The machine-readable medium of claim 26, wherein the at least one parameter value can be accessed without accessing a session space associated with a database window, wherein the database statement was issued within the session window.

24. The machine-readable medium of claims 17, wherein the at least one parameter value can be accessed without accessing a session space associated with a database window, wherein the database statement was issued within the session window.

25. The machine-readable medium of claims 18, wherein the at least one parameter value can be accessed after a session window has closed, wherein the database statement was issued within the session window.

26. The machine-readable medium of claim 14, wherein a security level is associated with the at least one parameter such that whether the database is entitled to access a component is based on the at least one parameter.