首页>
外国专利>
Query optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generation
Query optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generation
展开▼
机译:查询优化器系统,在执行计划生成之前,该系统可检测并防止查询中的数据库完整性突变表违规
展开▼
页面导航
摘要
著录项
相似文献
摘要
An automated system for detecting and preventing mutating table violations of database integrity in a SQL query before generation and selection of an optimal query execution plan (QEP). This system modifies the query graph model (QGM) to restrict the choice of execution plans to those that avoid mutating table integrity (MTI) violations, thereby forcing database integrity during table mutation when executing the optimal QEP. Mutating table integrity violations are detected by evaluating the position in the QGM of each write-node referencing a particular base table with respect to each of the positions of all other read- and write-nodes referencing of the same base table. Every common- referencing node pair is tested for sequencing conflicts and a data-flow dam is inserted in the QGM where necessary to force the completion of the execution of one node before initiating execution of the other common- referencing node. The system of this invention allows processing of all non-cyclic and most cyclic SQL queries known to cause mutating table integrity violations, such as queries having searched and positioned inserts, deletes and updates, and row-level triggers.
展开▼