Patents by Inventor Jalprakash G. Chimanchode

Jalprakash G. Chimanchode 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).

  • Eliminating sequenced inner and outer joins using temporal sequenced referential integrity and temporal uniqueness
    Patent number: 8396860
    Abstract: A computer receives a query for optimization. The query includes a SEQUENCED join between a temporal parent table and a temporal child table. The parent table has one or more rows. The child table has one or more rows. The parent table has a Primary Key (“PK”) column having a value for each row. The parent table has a temporal dimension having a value for each row. The child table has a Foreign Key (“FK”) column having a value for each row. The child table has a temporal dimension. The child table's temporal dimension has a value for each row. The computer determines that the query, the parent table, the child table, and the join satisfy a set of CURRENT temporal join elimination criteria. The computer determines that the query, the parent table, the child table, and the join satisfy a set of SEQUENCED temporal join elimination criteria. In response, the computer eliminates the join from the query to produce an optimized form of the query.
    Type: Grant
    Filed: December 14, 2010
    Date of Patent: March 12, 2013
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Jalprakash G. Chimanchode, Sai Pavan Kumar Pakala