Computer program product for database query optimization

Details Computer program product for database query optimization Computer program product for database query optimization

2011-06-28

2011-06-28

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S713000

Reexamination Certificate

active

07970757

ABSTRACT:
A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.

REFERENCES:
patent: 5732258 (1998-03-01), Jakobsson et al.
patent: 6466931 (2002-10-01), Attaluri et al.
patent: 6629094 (2003-09-01), Colby et al.
patent: 6898588 (2005-05-01), Kosciuszko et al.
patent: 7092931 (2006-08-01), Kaluskar et al.
patent: 7720839 (2010-05-01), Barsness et al.
patent: 7752197 (2010-07-01), Dettinger et al.
patent: 7877378 (2011-01-01), Gray
patent: 2003/0120643 (2003-06-01), Bird et al.
patent: 2003/0200204 (2003-10-01), Limoges et al.
patent: 2004/0002941 (2004-01-01), Thorne et al.
patent: 2004/0162836 (2004-08-01), Aronoff et al.
patent: 2004/0196845 (2004-10-01), Kunze et al.
patent: 2006/0155683 (2006-07-01), Bangel et al.
patent: 2006/0212428 (2006-09-01), Nelson
patent: 2006/0224563 (2006-10-01), Hanson et al.
patent: 2007/0168324 (2007-07-01), Grabs et al.
Khaled, et al., “SQL Statement Template: A Development Approach for Database-Driven Applications”, 2004 IEEE, pp. 12-17.
Oracle Corporation, “Build Internet Applications with Oracle Forms and Oracle Reports”, Hands On Session Building Reports, pp. 1-28.

Affiliated with

Also associated with

Rating

Computer program product for database query optimization does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Computer program product for database query optimization, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer program product for database query optimization will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2714502