Patents by Inventor Kishore Chilagani

Kishore Chilagani 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).

  • Patent number: 11640399
    Abstract: In some examples, a database system identifies a plurality of query portions in a database query that contain references to a first external table, the first external table being based on data from a remote data store coupled to the database system over a network. The database system creates a common spool portion that includes projections and selections of the plurality of query portions, and rewrites the plurality of query portions into rewritten query portions that refer to a spool containing an output of the common spool portion. For execution of the database query, the database system determines, as part of optimizer planning, whether to use the plurality of query portions or the common spool portion and the rewritten query portions.
    Type: Grant
    Filed: December 9, 2020
    Date of Patent: May 2, 2023
    Assignee: Teradata US, Inc.
    Inventors: Naveen Jaiswal, Kishore Chilagani, Vivek Kumar, Sanjib Kumar Mishra
  • Publication number: 20220179864
    Abstract: In some examples, a database system identifies a plurality of query portions in a database query that contain references to a first external table, the first external table being based on data from a remote data store coupled to the database system over a network. The database system creates a common spool portion that includes projections and selections of the plurality of query portions, and rewrites the plurality of query portions into rewritten query portions that refer to a spool containing an output of the common spool portion. For execution of the database query, the database system determines, as part of optimizer planning, whether to use the plurality of query portions or the common spool portion and the rewritten query portions.
    Type: Application
    Filed: December 9, 2020
    Publication date: June 9, 2022
    Inventors: Naveen Jaiswal, Kishore Chilagani, Vivek Kumar, Sanjib Kumar Mishra