Patents by Inventor Gautam Kumar Parai

Gautam Kumar Parai 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).

  • Outer-joined and cross-joined table elimination for duplicate-insignificant queries
    Patent number: 9965516
    Abstract: A method and apparatus for outer-joined and/or cross-joined table elimination for duplicate-insignificant queries is provided. A query block of a query specifies a join between a first table and a second table. The join is one of an outer join and a cross join. A first determination is made that the query block contains no references to the second table to be processed after the join. A second determination is made that the query block is duplicate-insignificant. In response to making the first determination and the second determination, the query block is transformed into a transformed query, where the second table is eliminated from a corresponding query block in the transformed query.
    Type: Grant
    Filed: May 21, 2014
    Date of Patent: May 8, 2018
    Assignee: Oracle International Corporation
    Inventors: Rafi Ahmed, Gautam Kumar Parai
  • OUTER-JOINED AND CROSS-JOINED TABLE ELIMINATION FOR DUPLICATE-INSIGNIFICANT QUERIES
    Publication number: 20150339349
    Abstract: A method and apparatus for outer-joined and/or cross-joined table elimination for duplicate-insignificant queries is provided. A query block of a query specifies a join between a first table and a second table. The join is one of an outer join and a cross join. A first determination is made that the query block contains no references to the second table to be processed after the join. A second determination is made that the query block is duplicate-insignificant. In response to making the first determination and the second determination, the query block is transformed into a transformed query, where the second table is eliminated from a corresponding query block in the transformed query.
    Type: Application
    Filed: May 21, 2014
    Publication date: November 26, 2015
    Inventors: Rafi Ahmed, Gautam Kumar Parai