Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-11-30
2009-06-09
Mizrahi, Diane (Department: 2617)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07546311
ABSTRACT:
Techniques for left outer join (LOJ) and right outer join (ROJ) optimization are described herein. Each LOJ/ROJ is an expression that references a preserved side and a null supplying side. If Condition 1 is true, and either Condition 2 or Condition 3 is true, then the LOJ/ROJ is evaluated by evaluating the expression referencing only the preserved side, and not the null supplying side. Conditions 1, 2 and 3 are defined as follows: Condition 1: An expression from the null supplying side is not used outside of the LOJ/ROJ. Condition 2: The LOJ/ROJ is required to return only distinct values from the preserved side. Condition 3: The null supplying side returns at most one row for each row returned by the preserved side.
REFERENCES:
patent: 5659728 (1997-08-01), Bhargava et al.
patent: 5680603 (1997-10-01), Bhargava et al.
patent: 5687362 (1997-11-01), Bhargava et al.
patent: 5713015 (1998-01-01), Goel et al.
patent: 5855019 (1998-12-01), Bhargava et al.
patent: 6088691 (2000-07-01), Bhargava et al.
patent: 6665663 (2003-12-01), Lindsay et al.
patent: 6721730 (2004-04-01), Kiernan et al.
patent: 7184998 (2007-02-01), Nica
patent: 2004/0006561 (2004-01-01), Nica
patent: 2008/0097961 (2008-04-01), Dias et al.
Ghazal et al., “Outer Join Elimination in Teradata RDBMS”, Lecture Notes in Computer Science, pp. 730-740, 2004.
iAnywhere Solutions, Inc.
Mizrahi Diane
Sterne Kessler Goldstein & Fox P.L.L.C.
LandOfFree
Optimization of left and right outer join operations in... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Optimization of left and right outer join operations in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimization of left and right outer join operations in... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4146200