Patent ID: 7136856
Filing Date: 2006-11-14
Classification: G06F,Y10S

Abstract:
1. A computer implemented method for performing a multi-level refresh of a cached user security profile associated with a client in a database management system comprising the steps of: receiving a user request from a user associated with said client, wherein the user request comprises a transaction aging value defining an updated maximum time for trusting a cached user security profile without a refresh from a permanent data store; in response to the presence of said transaction aging value on the user request, copying the transaction aging value to a security aging value associated with said cached user security profile; calculating a decay time equal to the time since the user security profile in cache was last refreshed from a permanent data store utilizing a profile refresh time stamp associated with said cached user security profile and a system clock; and refreshing said cached user security profile from the permanent data store in response to a refresh event, wherein said client is a software application, and wherein said refresh event occurs in response to one of the decay time being larger than the security aging value, and the security aging value being larger than the transaction aging value prior to said copying step.