ACCESS CONCURRENCY FOR CACHED AUTHORIZATION INFORMATION IN RELATIONAL DATABASE SYSTEM

摘要

A method and system for permitting concurrent access to cached authorization information for an SQL database system. The authorization information is cached as consolidated bitmaps. A first, authorization, bitmap in the cache represents committed authorization information for a grantee and type of grantee. A second, cumulative delta, bitmap in each cache entry represents authorization information not yet committed. A cache entry state is recorded for each cach e entry. Access to the cumulative delta bitmap is provided where the database agent requesting acce ss is the agent carrying out a modification to the cached authorization information. Access to the authorization bitmap information is permitted, amongst other conditions, where a grant statement is uncommitted and the database agent requesting access is not seeking to modify the authorization< /SDOAB>