Patents by Inventor Ze Yuan Hu

Ze Yuan Hu 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).

  • Using a unique index to remove group by based on set analysis
    Patent number: 10776358
    Abstract: A technique relates to determining when to skip a group by clause in a query. A computer checks that a condition is satisfied for a table. The condition is selected from the group consisting of having a unique index on one or more columns of the table or having a function on the one or more columns that makes rows in the GROUP BY clause unique. The group by clause is part of the query on the table. In response to the condition being satisfied, the group by clause associated with the one or more columns is skipped. In response to the condition not being satisfied, the group by clause associated with the one or more columns is executed.
    Type: Grant
    Filed: September 21, 2017
    Date of Patent: September 15, 2020
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Ze Yuan Hu, Bing Qing Sun, Hang Xiao, Xin Ying Yang
  • USING A UNIQUE INDEX TO REMOVE GROUP BY BASED ON SET ANALYSIS
    Publication number: 20190087461
    Abstract: A technique relates to determining when to skip a group by clause in a query. A computer checks that a condition is satisfied for a table. The condition is selected from the group consisting of having a unique index on one or more columns of the table or having a function on the one or more columns that makes rows in the GROUP BY clause unique. The group by clause is part of the query on the table. In response to the condition being satisfied, the group by clause associated with the one or more columns is skipped. In response to the condition not being satisfied, the group by clause associated with the one or more columns is executed.
    Type: Application
    Filed: September 21, 2017
    Publication date: March 21, 2019
    Inventors: Ze Yuan Hu, Bing Qing Sun, Hang Xiao, Xin Ying Yang