首页>
外国专利>
Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment
Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment
展开▼
机译:监视动态SQL语句以在数据共享环境中实现自动稳定的方法
展开▼
页面导航
摘要
著录项
相似文献
摘要
A database system searches for any statements that satisfy one or more of a set of filtering criteria. When a given dynamic query statement fully satisfies the set of filtering criteria, the given statement is stabilized by persistently storing a bound form of the given dynamic query statement. When the given dynamic query statement partly satisfies the set of filtering criteria, a monitoring request is created with the set of filtering criteria to begin monitoring subsequent executions of the statement, and the statement is linked to the monitoring request. When the given dynamic query statement subsequently fully satisfies the set of filtering criteria, the statement is stabilized by persistently storing the bound form of the statement. When the given dynamic query is re-executed, the stabilized statement is loaded, and the PREPARE process is bypassed.
展开▼