Patents by Inventor Renu Varshneya

Renu Varshneya 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).

  • System and method for optimizing queries
    Patent number: 10528553
    Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method retrieves a subset of rows from a sample table based on a query for a table associated with the sample table. The query specifies the table. The sample table is generated in a previous optimization of the query. The sample table includes a scrambled, random selection of rows from the table. A cardinality of the table is determined based on the subset. A query plan is generated based on the query and the cardinality.
    Type: Grant
    Filed: December 19, 2014
    Date of Patent: January 7, 2020
    Assignee: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
    Inventors: Roger Mitchell, Renu Varshneya, Awny K. Al-Omari
  • System and method for optimizing queries
    Patent number: 9141664
    Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first request from an optimizer that specifies a table, a first predicate and a first sample size, wherein the optimizer is optimizing a relational query language statement that specifies the table and the first predicate. The exemplary method also comprises generating a sample table, comprising a first subset of rows from the table, based on the request. The exemplary method also comprises selecting a second subset of rows from the sample table based on the predicate. The exemplary method additionally comprises sending a count of rows in the second subset to the optimizer.
    Type: Grant
    Filed: August 31, 2009
    Date of Patent: September 22, 2015
    Assignee: Hewlett-Packard Development Company, L.P.
    Inventors: Roger Mitchell, Renu Varshneya, Awny K. Al-Omari
  • System and Method for Optimizing Queries
    Publication number: 20150106397
    Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method retrieves a subset of rows from a sample table based on a query for a table associated with the sample table. The query specifies the table. The sample table is generated in a previous optimization of the query. The sample table includes a scrambled, random selection of rows from the table. A cardinality of the table is determined based on the subset. A query plan is generated based on the query and the cardinality.
    Type: Application
    Filed: December 19, 2014
    Publication date: April 16, 2015
    Inventors: Roger Mitchell, Renu Varshneya, Awny K. Al-Omari
  • Skew-based costing for database queries
    Patent number: 8190598
    Abstract: One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.
    Type: Grant
    Filed: October 30, 2008
    Date of Patent: May 29, 2012
    Assignee: Hewlett-Packard Development Company, L.P.
    Inventors: Awny K Al-Omari, Ramakumar Kosuru, Renu Varshneya, Robert L. Wall
  • SYSTEM AND METHOD FOR OPTIMIZING QUERIES
    Publication number: 20110055198
    Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first request from an optimizer that specifies a table, a first predicate and a first sample size, wherein the optimizer is optimizing a relational query language statement that specifies the table and the first predicate. The exemplary method also comprises generating a sample table, comprising a first subset of rows from the table, based on the request. The exemplary method also comprises selecting a second subset of rows from the sample table based on the predicate. The exemplary method additionally comprises sending a count of rows in the second subset to the optimizer.
    Type: Application
    Filed: August 31, 2009
    Publication date: March 3, 2011
    Inventors: Roger Mitchell, Renu Varshneya, Awny K. Al-Omari
  • Skew-based Costing for Database Queries
    Publication number: 20100114870
    Abstract: One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.
    Type: Application
    Filed: October 30, 2008
    Publication date: May 6, 2010
    Inventors: Awny K. Al-Omari, Ranajynar Kosuru, Renu Varshneya, Robert l. Wall