Patents by Inventor Hiren S. Patel

Hiren S. Patel 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: 12013853
    Abstract: The cloud-based query workload optimization system disclosed herein the cloud-based query workloads optimization system receives query logs from various query engines to a cloud data service, extracts various query entities from the query logs, parses query entities to generate a set of common workload features, generates intermediate representations of the query workloads, wherein the intermediate representations are agnostic to the language of the plurality of the queries, identifies a plurality of workload patterns based on the intermediate representations of the query workloads, categorizes the workloads in one or more workload type categories based on the workload patterns and the workload features, and selects an optimization scheme based on the category of workload pattern.
    Type: Grant
    Filed: September 25, 2019
    Date of Patent: June 18, 2024
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Hiren S. Patel, Rathijit Sen, Zhicheng Yin, Shi Qiao, Abhishek Roy, Alekh Jindal, Subramaniam Venkatraman Krishnan, Carlo Aldo Curino
  • Publication number: 20230418819
    Abstract: In a set of data analytics queries, at least a one of the queries comprising more than one operator, and each query being at least one of i) a producer of data for an other query in the set, and ii) a consumer of data from an other query in the set. In such examples, one or more computing devices identify each producer/consumer relationship between the queries. The one or more computing devices identify one or more optimizations among the queries based on the identified relationships. The one or more computing devices then apply at least one identified optimization to at least one of the queries.
    Type: Application
    Filed: June 22, 2022
    Publication date: December 28, 2023
    Inventors: Jyoti LEEKA, Sunny GAKHAR, Hiren S. PATEL, Marc Todd FRIEDMAN, Brandon HAYNES, Shi QIAO, Alekh JINDAL
  • Patent number: 11847118
    Abstract: In a set of data analytics queries, at least a one of the queries comprising more than one operator, and each query being at least one of i) a producer of data for an other query in the set, and ii) a consumer of data from an other query in the set. In such examples, one or more computing devices identify each producer/consumer relationship between the queries. The one or more computing devices identify one or more optimizations among the queries based on the identified relationships. The one or more computing devices then apply at least one identified optimization to at least one of the queries.
    Type: Grant
    Filed: June 22, 2022
    Date of Patent: December 19, 2023
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Jyoti Leeka, Sunny Gakhar, Hiren S. Patel, Marc Todd Friedman, Brandon Haynes, Shi Qiao, Alekh Jindal
  • Publication number: 20230177053
    Abstract: Methods for optimization in query plans are performed by computing systems via a query optimizer advisor. A query optimizer advisor (QO-Advisor) is configured to steer a query plan optimizer towards more efficient plan choices by providing rule hints to improve navigation of the search space for each query in formulation of its query plan. The QO-Advisor receives historical information of a distributed data processing system as an input, and then generates a set of rule hint pairs based on the historical information. The QO-Advisor provides the set of rule hint pairs to a query plan optimizer, which then optimizes a query plan of an incoming query through application of a rule hint pair in the set. This application is based at least on a characteristic of the incoming query matching a portion of the rule hint pair.
    Type: Application
    Filed: March 28, 2022
    Publication date: June 8, 2023
    Inventors: Matteo INTERLANDI, Wangda ZHANG, Paul S. MINEIRO, Marc T. FRIEDMAN, Alekh JINDAL, Hiren S. PATEL, Rafah Aboul HOSN, Shi QIAO
  • Publication number: 20210089532
    Abstract: The cloud-based query workload optimization system disclosed herein the cloud-based query workloads optimization system receives query logs from various query engines to a cloud data service, extracts various query entities from the query logs, parses query entities to generate a set of common workload features, generates intermediate representations of the query workloads, wherein the intermediate representations are agnostic to the language of the plurality of the queries, identifies a plurality of workload patterns based on the intermediate representations of the query workloads, categorizes the workloads in one or more workload type categories based on the workload patterns and the workload features, and selects an optimization scheme based on the category of workload pattern.
    Type: Application
    Filed: September 25, 2019
    Publication date: March 25, 2021
    Inventors: Hiren S. PATEL, Rathijit SEN, Zhicheng YIN, Shi QIAO, Abhishek ROY, Alekh JINDAL, Subramaniam Venkatraman KRISHNAN, Carlo Aldo CURINO
  • Publication number: 20200349161
    Abstract: Methods, systems, apparatuses, and computer program products are provided for evaluating a resource consumption of a query. A logical operator representation of a query generated to be executed (e.g., obtained from a query generating entity) may be determined. The logical operator representation may be transformed to a plurality of different physical operator representations for executing the query. A plurality of resource consumption models may be applied to each of the physical operator representations to determine a resource consumption estimate for the physical operator representation. The resource consumption models may be trained in different manners based at least on a history of query executions, such that each model may have different granularity, coverage and/or accuracy characteristics in estimating a resource consumption of a query.
    Type: Application
    Filed: July 15, 2019
    Publication date: November 5, 2020
    Inventors: Tarique Ashraf Siddiqui, Alekh Jindal, Shi Qiao, Hiren S. Patel
  • Patent number: 6486150
    Abstract: The present invention involves a process for preparing a stable final formulation product of a compound of formula I, or its pharmaceutically acceptable salt, hydrate or solvate by incorporating a suitable carbon dioxide source to an unstable monosodium adduct of carbapenem antibiotic compound.
    Type: Grant
    Filed: April 27, 2001
    Date of Patent: November 26, 2002
    Assignee: Merck & Co., Inc.
    Inventors: William A. Hunke, Kathleen J. Illig, Anand Kanike, Scott D. Reynolds, Stelios C. Tsinontides, Anthony S. Al-Dehneh, Hiren S. Patel
  • Publication number: 20020002160
    Abstract: The present invention involves a process for preparing a stable final formulation product of a compound of formula I, 1
    Type: Application
    Filed: April 27, 2001
    Publication date: January 3, 2002
    Inventors: William A. Hunke, Kathleen J. Illig, Anand Kanike, Scott D. Reynolds, Stelios C. Tsinontides, Anthony S. Al-Dehneh, Hiren S. Patel