Database system with methods for executing system-created internal SQL command statements
First Claim
1. In a database system having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements, a method for executing system-created internal command statements, the method comprising:
- creating a command buffer comprising a command statement which is internally generated by the database system itself;
setting an internal status flag for indicating to the database system that the internally-generated command statement is from a client with system privileges;
invoking said parser for parsing said command buffer for generating a parsed command statement; and
at said execution unit, executing instructions based on said parsed command statement with system privileges, whereupon said database system operates under control of the executing internally-generated command statement.
1 Assignment
0 Petitions
Accused Products
Abstract
A Client/Server Database system is described which includes a Database Server providing methods for executing system-created internal command statements (e.g., SQL statements), such as those which ordinarily are submitted to the server by various Clients. The Database Server is modified so that it can be its own "user," thus removing the fundamental schism which had existed in prior systems. The system is allowed to issue SQL commands to itself and, thus, can do anything that either the system or the user can do. The methodology is particularly useful for carrying out upgrades. The system can now set flags that are not accessible to users. Unlike a standalone "utility" approach, however, authentication is assured. Here, the system is assured that a known user--itself--has issued the command. As a result, it is no longer necessary to expose "dangerous" system functions to users.
-
Citations
20 Claims
-
1. In a database system having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements, a method for executing system-created internal command statements, the method comprising:
-
creating a command buffer comprising a command statement which is internally generated by the database system itself; setting an internal status flag for indicating to the database system that the internally-generated command statement is from a client with system privileges; invoking said parser for parsing said command buffer for generating a parsed command statement; and at said execution unit, executing instructions based on said parsed command statement with system privileges, whereupon said database system operates under control of the executing internally-generated command statement. - View Dependent Claims (2, 3, 4, 5, 6, 9)
-
-
7. In a database system having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements, a method for executing system-created internal command statements, the method comprising:
-
creating a command buffer comprising a command statement which is internally generated by the database system itself; setting an internal status flag for indicating to the database system that the internally-generated command statement is from a client with system privileges; invoking said parser for parsing said command buffer for generating a parsed command statement; and at said execution unit, executing instructions based on said parsed command statement with system privileges, whereupon said database system operates under control of the executing internally-generated command statement, wherein said parser also parses command statements received from clients connected to the database system.
-
-
8. In a database system having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements, a method for executing system-created internal command statements, the method comprising:
-
creating a command buffer comprising a command statement which is internally generated by the database system itself; setting an internal status flag for indicating to the database system that the internally-generated command statement is from a client with system privileges; invoking said parser for parsing said command buffer for generating a parsed command statement; and at said execution unit, executing instructions based on said parsed command statement with system privileges, whereupon said database system operates under control of the executing internally-generated command statement, wherein said internally-generated command statement comprises at least one structured query language (SQL) statement for performing an upgrade of the database system, so that the system can be automatically upgraded without providing a standalone upgrade utility having system privileges.
-
-
10. In a database system having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements, a method for executing system-created internal command statements, the method comprising:
-
creating a command buffer comprising a command statement which is internally generated by the database system itself; setting an internal status flag for indicating to the database system that the internally-generated command statement is from a client with system privileges; invoking said parser for parsing said command buffer for generating a parsed command statement; and at said execution unit, executing instructions based on said parsed command statement with system privileges, whereupon said database system operates under control of the executing internally-generated command statement, wherein said invoking step includes; automatically generating an "end of buffer" message for said parser, so that said parser begins parsing said internally-generated command statement without awaiting receipt of additional buffers.
-
-
11. A database system capable of operating as a "system" user, the system comprising:
-
a database server having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements; a memory for storing a command buffer comprising a command statement which is internally generated by the database system itself, and for storing an internal flag for indicating to the database system that the internally-generated command statement is from a user with system privileges; means for invoking said parser for parsing said command buffer for generating a parsed command statement; and means for executing with system privileges instructions based on said parse command statement at said execution unit, so that said database system operates under control of itself as a "system" user. - View Dependent Claims (12, 13, 14, 15, 16, 18)
-
-
17. A database system capable of operating as a "system" user, the system comprising:
-
a database server having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements; a memory for storing a command buffer comprising a command statement which is internally generated by the database system itself, and for storing an internal flag for indicating to the database system that the internally-generated command statement is from a user with system privileges; means for invoking said parser for parsing said command buffer for generating a parsed command statement; and means for executing with system privileges instructions based on said parse command statement at said execution unit, so that said database system operates under control of itself as a "system" user, wherein said parser also parses command statements received from clients connected to the database system.
-
-
19. A database system capable of operating as a "system" user, the system comprising:
-
a database server having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements; a memory for storing a command buffer comprising a command statement which is internally generated by the database system itself, and for storing an internal flag for indicating to the database system that the internally-generated command statement is from a user with system privileges; means for invoking said parser for parsing said command buffer for generating a parsed command statement; means for executing with system privileges instructions based on said parse command statement at said execution unit, so that said database system operates under control of itself as a "system" user; and means for repeating invocation and execution for a plurality of command buffers, so that the database system operates under control of a sequence of internally-generated command statements.
-
-
20. A database system capable of operating as a "system" user, the system comprising:
-
a database server having a parser for parsing command statements and an execution unit for executing instructions based on parsed command statements; a memory for storing a command buffer comprising a command statement which is internally generated by the database system itself, and for storing an internal flag for indicating to the database system that the internally-generated command statement is from a user with system privileges; means for invoking said parser for parsing said command buffer for generating a parsed command statement; and means for executing with system privileges instructions based on said parse command statement at said execution unit, so that said database system operates under control of itself as a "system" user, wherein said invoking means includes; means for automatically generating an "end of buffer" message for said parser, so that said parser begins parsing said internally-generated command statement without awaiting receipt of additional buffers.
-
Specification