Patents by Inventor Swati Vora

Swati Vora has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Method of simplifying and optimizing scalar subqueries and derived tables that return exactly or at most one tuple
    Patent number: 6826562
    Abstract: An optimization technique for SQL queries, a program storage device storing the optimization program, and an apparatus for optimizing a query is provided. A query is analyzed to determine whether it includes subselect expressions that return exactly or at most one tuple. If so, the quantifier merger or elimination is performed, if possible, to allow query to perform more efficiently than that of the original query while providing same results. The query is then executed in the computer to efficiently retrieve data from the database.
    Type: Grant
    Filed: November 29, 1999
    Date of Patent: November 30, 2004
    Assignee: International Business Machines Corporation
    Inventors: Ting Yu Leung, Monica Sachiye Urata, Swati Vora