System and method for caching database query statements

Details System and method for caching database query statements System and method for caching database query statements

2006-08-29

2006-08-29

Gaffin, Jeffrey (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07099863

ABSTRACT:
In a database system that supports object name overloading, database query statements are compiled and cached as data structures so that object level privileges are correctly resolved. Database query statements stored in the cached data structures are utilized when appropriate and a new compilation is performed when an incorrect resolution would result. The data structures are stored in a predefined order to ensure that a deterministic search of the cache is efficiently performed.

REFERENCES:
patent: 5261102 (1993-11-01), Hoffman
patent: 5897634 (1999-04-01), Attaluri et al.
patent: 6012067 (2000-01-01), Sarkar
patent: 6212634 (2001-04-01), Geer, Jr. et al.
patent: 6253208 (2001-06-01), Wittgreffe et al.
patent: 6321235 (2001-11-01), Bird
patent: 6604096 (2003-08-01), Couch et al.
patent: 6618718 (2003-09-01), Couch
patent: 2002/0073089 (2002-06-01), Schwartz et al.
patent: 2002/0078094 (2002-06-01), Krishnaprasad et al.
patent: 2002/0107835 (2002-08-01), Coram et al.
patent: 2002/0123978 (2002-09-01), Bird et al.
patent: 2005/0203897 (2005-09-01), Kapitskaia et al.
patent: 2000163448 (2001-04-01), None
Sandhu, “Relational Database Access Controls”, Handbook of Information Security Management (1994-95 Yearbook), Auerback Publishers, 1994, pp. 145-160.
Keller et al., “A predicate-based caching scheme for client-server database architectures”, The VDLB Journal (1996) 5, pp. 35-47; Springer-Verlag.
Ren et al., “Semantic Caching and Query Processing”, IEEE Transactions on Knowledge and Data Engineering, vol. 15, No. 1; Jan./Feb. 2003.
Luo et al., “Active Query Caching for Database Web Servers”, WebDB 2000, LNCS 1997, pp. 92-104; 2001; Springer-Verlag Berlin Heidelberg.
Lou Anna Noatargiacomo, “Role-Based Access Control in ORACLE7 and Trusted ORACLE7,” ACM RBAC Workshop, MD, USA 1996.
H. M. Gladney, “Access Control for Large Collections,” ACM Transactions on Information Systems, vol. 15, No. 2, Apr. 1997, pp. 154-194.
“Determining Database Object Authorization,” IBM Technical Disclosure Bulletin vol. 32, No. 9B. Feb. 1990.

Affiliated with

Also associated with

Rating

System and method for caching database query statements does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for caching database query statements, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for caching database query statements will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3705729