×

Method and apparatus for a complete SQL subquery elimination process

  • US 5,724,570 A
  • Filed: 06/07/1995
  • Issued: 03/03/1998
  • Est. Priority Date: 06/07/1995
  • Status: Expired due to Term
First Claim
Patent Images

1. A method for the transformation of a nested SQL query to eliminate all subqueries of the nested SQL query, the method comprising the steps, performed by a computer processor, of:

  • representing in a memory a nested SQL language query including at least one subquery in a first dataflow tree diagram with nodes of expressional operators and relational operators;

    eliminating each of said subqueries of said representing step according to a plurality of predetermined transformation rules being selected from a group of SQL transformation rules including the normalization rules NR1, NR2, NR3, NR4, NR5, NR6, NR7, said eliminating step transforming said nested SQL language query of said first dataflow tree diagram in the memory to a normalized and syntactically transformed equivalent second dataflow tree diagram, so that said relational operators in the second dataflow tree depend from one another and each of said relational operators are not isolated between expressional operators.

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