Method and apparatus for accessing a database

Details Method and apparatus for accessing a database Method and apparatus for accessing a database

1994-01-26

1995-04-25

Black, Thomas G.

Boots, shoes, and leggings

364DIG1, 395700, G06F 1540

Patent

active

054106931

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.

REFERENCES:
patent: 4751635 (1988-06-01), Kret
patent: 4799153 (1989-01-01), Hann et al.
patent: 4956769 (1990-09-01), Smith
patent: 5113499 (1992-05-01), Ankney et al.
patent: 5239648 (1993-08-01), Nukui
patent: 5261102 (1993-11-01), Hoffman
patent: 5263157 (1993-11-01), Janis
patent: 5263158 (1993-11-01), Janis
patent: 5263167 (1993-11-01), Conner, Jr. et al.
patent: 5317742 (1994-05-01), Bapat

Affiliated with

Also associated with

Rating

Method and apparatus for accessing a database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for accessing a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for accessing a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1574500