Patents Assigned to OPTISOFTWARE INCORPORATED
  • Transforming SQL Queries with Table Subqueries
    Publication number: 20070219943
    Abstract: A computer automated technique for rewriting SQL with table subqueries into more optimal table expression equivalents without derived tables. The context of the table subqueries, including any join and filter predicates are moved to the encompassing outer query. The advantage of this technique is to provide optimized source SQL to the relational database optimizers.
    Type: Application
    Filed: March 19, 2006
    Publication date: September 20, 2007
    Applicants: OPTISOFTWARE INCORPORATED
    Inventor: Alphonza Draughn