Patents by Inventor Huong T. Tran

Huong T. Tran 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).

  • Query transformation for union all view join queries using join predicates for pruning and distribution
    Patent number: 7188098
    Abstract: A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization includes: (a) combining join predicates from a query with local predicates from each branch of one or more UNION ALL views referenced by the query; (b) analyzing the combined predicates; and (c) not generating the join when the analysis step indicates that the combined predicates lead to an empty result.
    Type: Grant
    Filed: September 24, 2003
    Date of Patent: March 6, 2007
    Assignee: International Business Machines Corporation
    Inventors: Yao-Ching S. Chen, Ding-Wei L. Chieh, Huong T. Tran, Yumi K. Tsuji, Guogen Zhang