Method and apparatus for accessing a database
First Claim
1. A method of improving the efficiency of a database system, said database system including a database management system (DBMS) resident on a host computer, said DBMS communicatively linked to a plurality of work stations, said DBMS storing information that may be accessed via said work stations, said method including the steps of:
- (a) forming at least one query package, said query package including a plurality of procedures, said procedures being pre-compiled static statements that when executed by the DBMS manipulate said information stored in said DBMS; and
(b) associating with each said query package an authorization table, said authorization table enumerating a predetermined set of users that have access to said query package, said predetermined set of users of said query package being able to perform an invocation of said procedures of said query package via said work stations and being able to manipulate said information stored in said DBMS.
3 Assignments
0 Petitions
Accused Products
Abstract
A method and apparatus for improving the efficiency and security of a database management system (DBMS) is disclosed. A plurality of query packages are stored at a host DBMS. Generation of the query packages is limited only to those users that have authorization, such as the database administrator of the DBMS. The query packages include a plurality of procedures. Each procedure is a single SQL statement that has been pre-compiled. Each query package also includes an authorization table that enumerates each individual user, or category of user, that can invoke any procedure within the query package. By formulating a plurality of query packages, each package tailored to a particular category of user, security of the data on the DBMS is enhanced. Further, by having static statements that are pre-compiled, access time to the data on the DBMS is significantly reduced. Moreover, the database administrator and users can interactively generate and use the query packages in a user friendly environment.
-
Citations
11 Claims
-
1. A method of improving the efficiency of a database system, said database system including a database management system (DBMS) resident on a host computer, said DBMS communicatively linked to a plurality of work stations, said DBMS storing information that may be accessed via said work stations, said method including the steps of:
-
(a) forming at least one query package, said query package including a plurality of procedures, said procedures being pre-compiled static statements that when executed by the DBMS manipulate said information stored in said DBMS; and (b) associating with each said query package an authorization table, said authorization table enumerating a predetermined set of users that have access to said query package, said predetermined set of users of said query package being able to perform an invocation of said procedures of said query package via said work stations and being able to manipulate said information stored in said DBMS. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. An improved database system comprising:
-
(a) a database management system (DBMS) resident of a host computer, said DBMS operative to store information; (b) a plurality of user work stations, said user work stations communicatively linked to said DBMS, said user work stations being able to access and manipulate said stored information on said DBMS; (c) a database administrator work station, said database administrator work station being able to interactively communicate with said DBMS to form a query package that is stored by said DBMS, said query package including a plurality of procedures, said procedures being pre-compiled static statements that when executed by the DBMS manipulate said information stored in said DBMS, said database administrator work station also being able to interactively communicate with said DBMS to form an authorization table associated with said query package, said authorization table enumerating a predetermined set of users that have access to said query package, said predetermined set of users set forth in said authorization table of said query package being able to invoke said procedures of said query package and being able to manipulate said information stored in said DBMS. - View Dependent Claims (10, 11)
-
Specification