×

Extending the semantics of the outer join operator for un-nesting queries to a data base

  • US 5,412,804 A
  • Filed: 04/30/1992
  • Issued: 05/02/1995
  • Est. Priority Date: 04/30/1992
  • Status: Expired due to Term
First Claim
Patent Images

1. A method of operating a digital computer for un-nesting an inner query from an outer query, said inner query referencing a first relation also referenced in said outer query, said inner query including a first predicate joining said first relation to a second relation, said inner query also including a count aggregate, said outer query having a second predicate referencing said first relation and said inner query, said method comprising the steps of:

  • a) converting said inner query to a first un-nested query by removing said first predicate and modifying said count aggregate function to count over groups of distinct values of said second relation; and

    b) converting said outer query to a second un-nested query receiving results of said inner query by modifying said second predicate so that said second predicate is applied to said first relation and said results for values of said first relation which are joined to said results by said first predicate and so that said second predicate is applied to said first relation and a value of zero for values of said first relation which are not joined to any of said results by said first predicate.

View all claims
  • 5 Assignments
Timeline View
Assignment View
    ×
    ×