US5410693A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for accessing a database
Assignee: Micro Focus US Inc
•
Filing: 1994-01-26
•
Granted: 1995-04-25
•
Expires: 2014-01-26
Abstract
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.
Inventors
- 👤 Hong-Lee Yu
- 👤 Thomas C. Mitchell
- 👤 Albert J. Nicholes, Jr.
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 18:13
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F21/00; G06F21/60; G06F21/62; G06F21/6218; G06F21/6227
Claims Analysis
Total Claims: 13
Claim 1
Independent Claim
150 words
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.
Claim 2
Independent Claim
150 words
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.
Claim 3
Dependent Claim
106 words
The method of claim 1, wherein the step of forming said query package is done by a database administrator interactively using one of said work stations, and further includes the steps of: (a) initiating said query package by transmitting a BGNBND command from said work station to said DBMS; (b) transmitting at least one structured query language (SQL) command to said DBMS; (c) said DBMS receiving said SQL command and compiling said command into said pre-compiled static statement; (d) associating said pre-compiled static statement with said query package; and (e) completing said query package by transmitting a ENDBND command from said work station to said DBMS.
Claim 4
Dependent Claim
22 words
The method of claim 2, wherein the communications between said work stations and said DBMS is via the advanced peer-to-peer protocol (APPC).
Claim 5
Dependent Claim
79 words
The method of claim 2, further including the steps of: (a) formulating parameter information on said query package, said parameter information uniquely identifying said query package and including information necessary for the invocation of said procedures in said query package; and (b) wherein after one of said predetermined set of users invokes said procedure of said query package via said work station, forming a local package table at said work station, said local package table including said parameter information.
Claim 6
Dependent Claim
76 words
The method of claim 2, wherein said authorization table associated with said query package is formed by a database administrator interactively using one of said work stations by: (a) transmitting to said DBMS said predetermined set of users that are authorized to invoke said query package; (b) including said predetermined set of users into said authorization table; (c) storing said authorization table as an authorization file; and (d) associating said authorization file with said query package.
Claim 7
Dependent Claim
79 words
The method of claim 1, further including the steps of: (a) formulating parameter information on said query package, said parameter information uniquely identifying said query package and including information necessary for the invocation of said procedures in said query package; and (b) wherein after one of said predetermined set of users invokes said procedure of said query package via said work station, forming a local package table at said work station, said local package table including said parameter information.
Claim 8
Dependent Claim
76 words
The method of claim 1, wherein said authorization table associated with said query package is formed by a database administrator interactively using one of said work stations by: (a) transmitting to said DBMS said predetermined set of users that are authorized to invoke said query package; (b) including said predetermined set of users into said authorization table; (c) storing said authorization table as an authorization file; and (d) associating said authorization file with said query package.
Claim 9
Dependent Claim
17 words
The method of claim 1, wherein said DBMS is a distributed relational database architecture (DRDA) compliant DBMS.
Claim 10
Dependent Claim
187 words
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.
Claim 11
Dependent Claim
187 words
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.
Claim 12
Dependent Claim
17 words
The apparatus of claim 9, wherein said DBMS is a distributed relational database architecture (DRDA) compliant DBMS.
Claim 13
Dependent Claim
13 words
The apparatus of claim 10, wherein said host computer is a mainframe computer.
References Cited (Backward Citations)
US4799153A
Cited
US4751635A
Cited
US4956769A
Cited
US5113499A
Cited
US5263158A
Cited
US5263157A
Cited
US5239648A
Cited
US5261102A
Cited
US5317742A
Cited
US5263167A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1998-04-24 | 1998-10-24 | 1999-04-25 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2002-04-24 | 2002-10-24 | 2003-04-25 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2006-04-24 | 2006-10-24 | 2007-04-25 | $7700.00 | Window Closed / Lapsed |