Object oriented query path expression to relational outer...

Details Object oriented query path expression to relational outer... Object oriented query path expression to relational outer...

2011-08-23

2011-08-23

LeRoux, Etienne P (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Reexamination Certificate

active

08005807

ABSTRACT:
Provided is an object oriented query path expression to relational outer join translator. A path expression, comprising a navigation path through a relationship in a schema, in an object oriented query is translated to a relational database outer join by analyzing each path expression defined in each level of the object oriented query, and by identifying each path expression which can be a candidate for a translation to an outer join. A quantifier is created for each path expression. A translation of the object oriented query to a relational query is then completed. An optimization may also be performed on the grouped quantifiers. After the optimization, an inner join is generated for each quantifier which remains a candidate for a translation to an inner join, and an outer join is generated for each quantifier which remains a candidate for a translation to an outer join.

REFERENCES:
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5548754 (1996-08-01), Pirahesh et al.
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5687362 (1997-11-01), Bhargava et al.
patent: 5724570 (1998-03-01), Zeller et al.
patent: 5761657 (1998-06-01), Hoang
patent: 5774692 (1998-06-01), Boyer et al.
patent: 5797136 (1998-08-01), Boyer et al.
patent: 5826077 (1998-10-01), Blakeley et al.
patent: 5832477 (1998-11-01), Bhargava et al.
patent: 5864847 (1999-01-01), Goel et al.
patent: 5873093 (1999-02-01), Williamson et al.
patent: 5899997 (1999-05-01), Ellacott
patent: 5960428 (1999-09-01), Lindsay et al.
patent: 5963933 (1999-10-01), Cheng et al.
patent: 6122627 (2000-09-01), Carey et al.
patent: 6134540 (2000-10-01), Carey et al.
patent: 6160549 (2000-12-01), Touma et al.
patent: 6167399 (2000-12-01), Hoang
patent: 6219663 (2001-04-01), Baxter et al.
patent: 6226637 (2001-05-01), Carey et al.
patent: 6285997 (2001-09-01), Carey et al.
patent: 6411951 (2002-06-01), Galindo-Legaria et al.
patent: 6640221 (2003-10-01), Levine et al.
patent: 6826558 (2004-11-01), Slutz
patent: 6941298 (2005-09-01), Chow et al.
patent: 7010542 (2006-03-01), Trappen et al.
patent: 7082433 (2006-07-01), Anonsen et al.
patent: 7152073 (2006-12-01), Gudbjartsson et al.
patent: 7426522 (2008-09-01), Nouri et al.
patent: 2005/0065927 (2005-03-01), Nouri et al.
Ambler, S., “Enterprise JavaBean Persistence 201”, Software Development, v8, n10, Oct. 2000, 5pp.
MVCSOFT Inc, “Persistence Manager”, Part I, 2000-2001, 143 pp.
MVCSOFT Inc, “Persistence Manager”, Part II, 2000-2001, 87 pp.
Amendment 1, Aug. 2, 2006, for U.S. Appl. No. 10/669,934, Total 14 pp.
Amendment 2, Aug. 21, 2007, for U.S. Appl. No. 10/669,934, Total 12 pp.
Final Office Action 1, Oct. 19, 2006, for U.S. Appl. No. 10/669,934, Total 11 pp.
Notice of Allowance 1, Nov. 2, 2007, for U.S. Appl. No. 10/669,934, Total 21 pp.
Notice of Appeal & Pre-Appeal Brief Request for Review, Jan. 19, 2007, for U.S. Appl. No. 10/669,934, Total 7 pp.
Office Action 1, May 2, 2006, for U.S. Appl. No. 10/669,934, Total 13 pp.
Office Action 3, May 21, 2007, for U.S. Appl. No. 10/669,934, Total 14 pp.

Affiliated with

Also associated with

Rating

Object oriented query path expression to relational outer... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Object oriented query path expression to relational outer..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Object oriented query path expression to relational outer... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2759762