Title:
【発明の名称】データベースにアクセスするための改良された方法および装置
Document Type and Number:
Japanese Patent JPH09510306
Kind Code:
A
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:
You, Hong-lee
Mitchell, Thomas Sea
Nichols, Albert James Jr.
Mitchell, Thomas Sea
Nichols, Albert James Jr.
Application Number:
JP52011495A
Publication Date:
October 14, 1997
Filing Date:
January 24, 1995
Export Citation:
Assignee:
Wall Data Incorporated
International Classes:
G06F12/00; G06F1/00; G06F17/30; G06F21/00; (IPC1-7): G06F17/30; G06F12/00; G06F17/30
Attorney, Agent or Firm:
Takehiko Suzue (4 outside)