Patents by Inventor Pradeep Dorairaj

Pradeep Dorairaj 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: 12367186
    Abstract: The subject technology receives first data. The subject technology transforms first data to a wide format, the wide format comprising a second table. The subject technology splits a set of rows into a set of shards of rows. The subject technology, for each shard from the set of shards, sends a particular user defined table function (UDTF), including a particular shard of rows, to a different execution node to perform a set of operations for determining a rolling correlation over a window size. The subject technology provides a set of output values of each particular UDTF corresponding to each shard from the set of shards in a second UDTF. The subject technology sends the second UDTF to a particular execution node to perform an aggregate operation. The subject technology receives a value of the rolling correlation from the particular execution node based on the aggregate operation.
    Type: Grant
    Filed: October 27, 2023
    Date of Patent: July 22, 2025
    Assignee: Snowflake Inc.
    Inventors: Pradeep Dorairaj, Garrett Frere, Carsten Stann, Boyu Wang, Mengjia Xia
  • Publication number: 20250217343
    Abstract: The subject technology determines a set of shards of rows from a data set based on a number of rows and a number of execution nodes to execute a request for determining a correlation. For each shard from the set of shards, the subject technology sends a particular user defined table function (UDTF), including a particular shard of rows, to a different execution node to perform a set of operations for determining the correlation. The subject technology provides a set of output values of each particular UDTF corresponding to each shard from the set of shards in a second UDTF. The subject technology sends the second UDTF to a particular execution node to perform an aggregate operation using the set of output values of each particular UDTF. The subject technology receives a value of the correlation from the particular execution node based on the aggregate operation.
    Type: Application
    Filed: December 18, 2024
    Publication date: July 3, 2025
    Inventors: Pradeep Dorairaj, Garrett Frere
  • Publication number: 20250139076
    Abstract: The subject technology receives first data. The subject technology transforms first data to a wide format, the wide format comprising a second table. The subject technology splits a set of rows into a set of shards of rows. The subject technology, for each shard from the set of shards, sends a particular user defined table function (UDTF), including a particular shard of rows, to a different execution node to perform a set of operations for determining a rolling correlation over a window size. The subject technology provides a set of output values of each particular UDTF corresponding to each shard from the set of shards in a second UDTF. The subject technology sends the second UDTF to a particular execution node to perform an aggregate operation. The subject technology receives a value of the rolling correlation from the particular execution node based on the aggregate operation.
    Type: Application
    Filed: October 27, 2023
    Publication date: May 1, 2025
    Inventors: Pradeep Dorairaj, Garrett Frere, Carsten Stann, Boyu Wang, Mengjia Xia
  • Patent number: 12197413
    Abstract: The subject technology receives a set of values for a data set corresponding to a request for determining a Pearson correlation. The subject technology determines a number of rows from the data set. The subject technology determines a number of execution nodes to execute the request. The subject technology determines a set of shards of rows from the data set. The subject technology, for each shard from the set of shards, sends a particular user defined table function (UDTF), including a particular shard of rows, to a different execution node to perform a set of operations. The subject technology provides a set of output values of each particular UDTF corresponding to each shard from the set of shards in a second UDTF. The subject technology sends the second UDTF to a particular execution node to perform an aggregate operation using the set of output values of each particular UDTF.
    Type: Grant
    Filed: September 6, 2023
    Date of Patent: January 14, 2025
    Assignee: Snowflake Inc.
    Inventors: Pradeep Dorairaj, Garrett Frere
  • Publication number: 20240256515
    Abstract: The subject technology receives a set of values for a data set corresponding to a request for determining a Pearson correlation. The subject technology determines a number of rows from the data set. The subject technology determines a number of execution nodes to execute the request. The subject technology determines a set of shards of rows from the data set. The subject technology, for each shard from the set of shards, sends a particular user defined table function (UDTF), including a particular shard of rows, to a different execution node to perform a set of operations. The subject technology provides a set of output values of each particular UDTF corresponding to each shard from the set of shards in a second UDTF. The subject technology sends the second UDTF to a particular execution node to perform an aggregate operation using the set of output values of each particular UDTF.
    Type: Application
    Filed: September 6, 2023
    Publication date: August 1, 2024
    Inventors: Pradeep Dorairaj, Garrett Frere
  • Patent number: 11734286
    Abstract: Automatic database analysis includes identifying a current context for accessing data from a low-latency database and generating an exploration query based on the current context, which includes identifying a column from the low-latency database as a column of utility in response to determining that a probabilistic utility for the column satisfies a defined utility criterion. The current context includes a requested result set satisfying a requested search criterion, and the probabilistic utility is based on the current context. The analysis includes generating an exploration result set based on the exploration query, generating insights based on the exploration result set, ranking the insights, and outputting at least one insight based on the ranking.
    Type: Grant
    Filed: October 10, 2018
    Date of Patent: August 22, 2023
    Assignee: ThoughtSpot, Inc.
    Inventors: Amit Prakash, Antony Chuxiao Chen, Gunjan Jha, Jasmeet Singh Jaggi, Manoj Krishna Ghosh, Pavan Ram Piratla, Pradeep Dorairaj, Sanjay Agrawal
  • Publication number: 20190108230
    Abstract: A method and system may be implemented for automatically analyzing data in a database. The method and system may receive a current context of the database. The method and system may identify one or more columns of utility based on the current context and generate a current context based on the one or more columns of utility. The method and system may generate one or more exploration queries. The method and system may explore the one or more exploration queries to generate an exploration result set. The method and system may generate one or more insights. The one or more insights may be based on the current context, the exploration result set, or both. The method and system may rank the insights. The method and system may display, transmit, or store the one or more insights based on the rank.
    Type: Application
    Filed: October 10, 2018
    Publication date: April 11, 2019
    Inventors: Amit Prakash, Antony Chuxiao Chen, Gunjan Jha, Jasmeet Singh Jaggi, Manoj Krishna Ghosh, Pavan Ram Piratla, Pradeep Dorairaj, Sanjay Agrawal