Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2008-05-06
2008-05-06
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07370062
ABSTRACT:
A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.
REFERENCES:
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5499359 (1996-03-01), Vijaykumar
patent: 5701460 (1997-12-01), Kaplan et al.
patent: 5761654 (1998-06-01), Tow
patent: 5963933 (1999-10-01), Cheng et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6477525 (2002-11-01), Bello et al.
patent: 6496819 (2002-12-01), Bello et al.
patent: 6578028 (2003-06-01), Egilsson et al.
patent: 6801914 (2004-10-01), Barga et al.
patent: 7152073 (2006-12-01), Gudbjartsson et al.
patent: 7222131 (2007-05-01), Grewal et al.
patent: 7283995 (2007-10-01), Miller
patent: 2001/0013030 (2001-08-01), Colby et al.
Efficient SELECT Statements—http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0005283.htm; Accessed Jan. 15, 2004.
SQL Tuning Tips—http://www.wisc.edu/dermt/oratips/sess006.html; (Accessed Jan. 30, 2004) Mar. 31, 1998.
Cave Stephen
Evans Christopher
Fragapane Paolo
Nash Kathryn
Osborn Andrew
Bingham & McCutchen LLP
Corrielus Jean M.
Oracle International Corporation
LandOfFree
SQL predicate migration 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 predicate migration, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and SQL predicate migration will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2807107