Method of optimizing SQL queries where a predicate matches...

Details Method of optimizing SQL queries where a predicate matches... Method of optimizing SQL queries where a predicate matches...

2006-02-07

2006-02-07

Breene, John (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06996557

ABSTRACT:
An optimization technique for SQL queries, a program storage device storing the optimization program, and an apparatus for optimizing a query is provided. A query is analyzed to determine whether it includes a predicate for matching nullable operands and, if so, it is transformed to return TRUE when all operands are NULLs. If the DBMS supports this new function, the predicate is marked. If not, the predicate is re-written into a CASE expression having two SELECT clauses. The query is then executed in the computer to efficiently retrieve data from the relational database.

REFERENCES:
patent: 5239663 (1993-08-01), Faudemay et al.
patent: 5724570 (1998-03-01), Zeller et al.
patent: 5761657 (1998-06-01), Hoang
patent: 6044370 (2000-03-01), Anfindsen
patent: 6154876 (2000-11-01), Haley et al.
patent: 6171109 (2001-01-01), Ohsuga
patent: 6199063 (2001-03-01), Colby et al.

Affiliated with

Also associated with

Rating

Method of optimizing SQL queries where a predicate matches... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method of optimizing SQL queries where a predicate matches..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of optimizing SQL queries where a predicate matches... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3701846