SQL distinct optimization in a computer database system

Details SQL distinct optimization in a computer database system SQL distinct optimization in a computer database system

2005-01-14

2011-10-04

Lie, Angela (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

08032514

ABSTRACT:
An apparatus and method optimize a query in a computer database system having a DISTINCT specifier. An SQL SELECT statement with a DISTINCT specifier is analyzed to determine if the expression can be optimized, and if so, the SELECT statement is reformulated to improve system performance. In preferred embodiments, the query optimizer eliminates the DISTINCT specifier in the outer select statement to reformulate the query. In other preferred embodiments, a query optimizer reformulates the query before being sent to the database manager to optimize the query to improve system performance.

REFERENCES:
patent: 5890148 (1999-03-01), Bhargava et al.
patent: 6029163 (2000-02-01), Ziauddin
patent: 6061676 (2000-05-01), Srivastava et al.
patent: 6088691 (2000-07-01), Bhargava et al.
patent: 6105018 (2000-08-01), Demers et al.
patent: 6615203 (2003-09-01), Lin et al.
patent: 2004/0225639 (2004-11-01), Jakobsson et al.

Affiliated with

Also associated with

Rating

SQL distinct optimization in a computer database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with SQL distinct optimization in a computer database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and SQL distinct optimization in a computer database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4289823