Browse Prior Art Database

An Algorithm aiding in SQL Diagnosis

IP.com Disclosure Number: IPCOM000016789D
Original Publication Date: 2003-Jul-15
Included in the Prior Art Database: 2003-Jul-15

Publishing Venue

IBM

Abstract

A recurring problem in daily DBMS operation, is the failure of SQL due to bad data from the source table. Small changes in the semantic meaning of a column or NLS characters may result in an unexpected SQL statement failure. This paper describes an algorithm for diagnosing SQL failures in an autromated fashion using combinatorial methods on the predicates in the WHERE clauses of each SELECT statement in the SQL statement.