Organization of SQL working memory in a transaction-bounded processing environment

A query database management system, the system comprising plural agents for executing requests received from at least one application, the requests received by the agents comprising references to database system representations of a query statement and query context information, the system comprising:

• a. means for defining and utilizing agent workspaces, each agent workspace comprising a defined set of memory associated with an agent and capable of storing execution-ready representations of query statements;
• and
• b. means for defining and utilizing a set of application workspaces, each application workspace comprising a defined set of memory associated with a defined set of applications and capable of storing execution-ready representation of query statements, in which each of the application workspaces and each of the agent workspaces has a common structure characterized by a first portion for storing a set of information relating to dynamic query statements and a second portion for storing information relating to static query statements.

A query database management system in which query context and query statement information is maintained in a global query cache and is organized in a hierarchical arrangement of data structures comprising packages, section entries and sections, the system comprising:

• means for defining and maintaining a set of application workspaces, a set of agent workspaces, and a set of application query context data structures, each of the agent workspaces and each of the application workspace being configurable to receive working copies of package, section entry and section information, each application query context data structure being configurable to receive copies of package and section entry information and to reference copies of package, section entry and section information in the global query cache, and in the associated agent workspace and application workspace for facilitating executing, by agents operating in respective agent workspaces, queries from applications operating in respective application workspace.

A computer program product for a query database management system, the system comprising a set of agents for executing requests received from one or more applications, the requests received by the agents comprising references to database system representations of query statement and query context information, the computer program product comprising a computer usable medium having computer readable code means embodied in said medium for organizing working memory, comprising:

• computer readable program code means for defining and utilizing a set of agent workspaces, each agent workspace comprising a defined set of memory associated with an agent in the set of agents and capable of storing execution-ready representations of query statements, and
• computer readable program code means for defining and utilizing a set of application workspaces, each application workspace comprising a defined set of memory associated with a defined set of applications and capable of storing execution-ready representations of query statements, in which each of the application workspaces and each of the agent workspaces have a common structure characterized by a first portion for storing a set of information relating to dynamic query statements and a second portion storing information relating to static query statements, the query statements being used by the agents.

A computer program product for a query database management system in which query context and query statement information is maintained in a global query cache and is organized in a hierarchical arrangement of data structures comprising packages, section entries and sections, the computer program product comprising a computer usable medium having computer readable code means embodied in said medium for organizing working memory, comprising:

• computer readable program code means for defining and maintaining a set of application workspaces, a set of agent workspaces, and a set of application query context data structures, each of the agent workspaces and each of the application workspace being configurable to receive working copies of package, section entry and section information, each application query context data structure being configurable to receive copies of package and section entry information and to reference copies of package, section entry and section information in the global query cache, and in the associated agent workspace and application workspace for facilitating executing, by agents operating in respective agent workspaces, queries from applications operating in respective application workspaces.

A query database management, the method using at least one agent for executing requests received from at least one application, the requests received by agents comprising at least one reference to database system representations of query statement and query context information, the method comprising:

• a. defining and utilizing agent workspaces, each agent workspace comprising a defined set of memory associated with an agent and capable of storing execution-ready representations of query statements;
• and
• b. defining and utilizing a set of application workspaces, each application workspace comprising a defined set of memory associated with a defined set of applications and capable of storing execution-ready representations of query statements, in which each of the application workspaces and each of the agent workspaces has a common structure characterized by a first portion for storing a set of information relating to dynamic query statements and a second portion for storing information relating to stark query statements.

A query database management method in which query context and query statement information is maintained in a global query cache and is organized in a hierarchical arrangement of data structures comprising packages, section entries and sections, the method comprising:

• defining and maintaining a set of application workspaces, a set of agent workspaces, and a set of application query context data structures, each of the agent workspaces and each of the application workspace being configurable to receive working copies of package, section entry and section information, each application query context data structure being configurable to receive copies of package and section entry information and to reference copies of package, section entry and section information in the global query cache, and in the associated agent workspace and application workspace for facilitating executing, by agents operating in respective agent workspaces, queries from applications operating in respective application workspaces.