Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Dynamic Structured Query Language Prepared Statement Cache

IP.com Disclosure Number: IPCOM000117373D
Original Publication Date: 1996-Feb-01
Included in the Prior Art Database: 2005-Mar-31
Document File: 2 page(s) / 55K

Publishing Venue

IBM

Related People

Young, NG: AUTHOR

Abstract

Dynamic Structured Query Language (SQL) is required for database access when the tables used and the precise SQL commands to be processed must be generated by a system at runtime. Such systems include the class of TP Monitor and Application Management systems that do not translate or compile resource management commands when applications are built.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 57% of the total text.

Dynamic Structured Query Language Prepared Statement Cache

      Dynamic Structured Query Language (SQL) is required for
database access when the tables used and the precise SQL commands to
be processed must be generated by a system at runtime.  Such systems
include the class of TP Monitor and Application Management systems
that do not translate or compile resource management commands when
applications are built.

      Relational Database Management System (RDBMS) associates a
"Statement" with a particular SQL command.  A Statement is an RDBMS
entity that encapsulates the state of that command.  In order to
process an SQL command, the associated RDBMS Statement must, in RDBMS
terms, be "prepared".  This is an expensive process that involves
work by the RDBMS.  For instance, the RDBMS will determine the most
effective path through which to access data when the SQL command is
later executed.

      In a TP-monitor or Application Management system, it is
possible that the same Dynamic SQL command against the same table may
be executed many times.  In such an environment, it is important to
minimize the work involved in repeated RDBMS Statement preparation.

      The solution described here optimises the use of dynamic SQL
for Relational Database access by a TP-monitor or Application
Management system through a Dynamic SQL Prepared Statement Cache.

      A fixed set of RDBMS Statements is predefined.  Associated with
each Statement is a cache entry...