ORGANIZATION OF SQL WORKING MEMORY IN A TRANSACTION BOUNDED PROCESSING ENVIRONMENT

摘要

Working memory in an SQL database system is organized in workspaces. Age nt workspaces are defined into which working copies of SQL executable logic information are loaded. Application workspaces are also defined for the loading of working copies of SQL executable logic information. Reference copies of the SQL information are available in a global SQL cache. An application SQL context data structure is as an entry point to access working copies of SQL information in the agent or application workspaces. An application workspace is associated with an application and is maintained until the last applicati on in the set is not active. An agent workspace is associated with an agent in the database syste m and is maintained until the agent is no longer active.