Patents by Inventor Qiuye Jin

Qiuye Jin 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).

  • Publication number: 20240012796
    Abstract: A system to identify optimal cloud resources for executing workloads. The system deduplicates historical client queries based on a workload selection configuration to determine a grouping of historical client queries. The system generates a workload based on at least a portion of the grouping of historical client queries. The system repeatedly executes a test run of the workload using resources of a cloud environment to determine whether there is a performance difference in the test run. The system, in response to determining that there is no performance difference, identifies one or more sets of decreased resources of the cloud environment. The system re-executes the test run using the one or more sets of decreased resources of the cloud environment to determine whether there is a performance difference in the test run that is attributed to the one or more sets of decreased resources of the cloud environment.
    Type: Application
    Filed: September 20, 2023
    Publication date: January 11, 2024
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Patent number: 11782890
    Abstract: A system to repeatedly execute a test run of a workload using resources of a cloud environment to determine whether there is a performance difference in the test run. The system to, in response to determining that there is no performance difference, identify one or more sets of decreased resources of the cloud environment. The system to re-execute the test run using the one or more sets of decreased resources of the cloud environment to determine whether there is a performance difference in the test run that is attributed to the one or more sets of decreased resources of the cloud environment. The system to determine minimum resources of the cloud environment to repeatedly execute the test run using the minimum resources without existence of a performance difference in response to re-executing the test run using the one or more sets of decreased resources of the cloud environment.
    Type: Grant
    Filed: June 16, 2022
    Date of Patent: October 10, 2023
    Assignee: Snowflake Inc.
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Patent number: 11500838
    Abstract: Systems, methods, and devices for feature release and workload capture in database systems are disclosed. The method includes determining a workload based on one or more client queries to be rerun to test a feature that is unreleased to one or more database clients. The method includes repeatedly executing a test run of the workload to determine a stability factor of the test run. The method includes re-executing, in response to determining the stability factor of the test run, the test run using resources with a different concurrency to confirm the stability factor of the test run. The method includes releasing the feature to the one or more database clients in response to confirming the stability factor of the test run.
    Type: Grant
    Filed: July 20, 2022
    Date of Patent: November 15, 2022
    Assignee: Snowflake Inc.
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Publication number: 20220358107
    Abstract: Systems, methods, and devices for feature release and workload capture in database systems are disclosed. The method includes determining a workload based on one or more client queries to be rerun to test a feature that is unreleased to one or more database clients. The method includes repeatedly executing a test run of the workload to determine a stability factor of the test run. The method includes re-executing, in response to determining the stability factor of the test run, the test run using resources with a different concurrency to confirm the stability factor of the test run. The method includes releasing the feature to the one or more database clients in response to confirming the stability factor of the test run.
    Type: Application
    Filed: July 20, 2022
    Publication date: November 10, 2022
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Publication number: 20220318215
    Abstract: A system to repeatedly execute a test run of a workload using resources of a cloud environment to determine whether there is a performance difference in the test run. The system to, in response to determining that there is no performance difference, identify one or more sets of decreased resources of the cloud environment. The system to re-execute the test run using the one or more sets of decreased resources of the cloud environment to determine whether there is a performance difference in the test run that is attributed to the one or more sets of decreased resources of the cloud environment. The system to determine minimum resources of the cloud environment to repeatedly execute the test run using the minimum resources without existence of a performance difference in response to re-executing the test run using the one or more sets of decreased resources of the cloud environment.
    Type: Application
    Filed: June 16, 2022
    Publication date: October 6, 2022
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Patent number: 11416463
    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. The method includes determining a workload based on one or more client queries to be rerun for testing the feature release. The method further includes repeatedly executing a test run of the workload to identify whether there is a performance difference in the test run. The method further includes re-execute, in response to identifying the performance difference, the test run using resources with a different concurrency to identify whether the performance difference still exists. The method further includes flagging the performance difference as a false positive in response to identifying that the performance difference no longer exists when the test run is re-executed using the resources with different concurrency.
    Type: Grant
    Filed: April 15, 2022
    Date of Patent: August 16, 2022
    Assignee: Snowflake Inc.
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Publication number: 20220237161
    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. The method includes determining a workload based on one or more client queries to be rerun for testing the feature release. The method further includes repeatedly executing a test run of the workload to identify whether there is a performance difference in the test run. The method further includes re-execute, in response to identifying the performance difference, the test run using resources with a different concurrency to identify whether the performance difference still exists. The method further includes flagging the performance difference as a false positive in response to identifying that the performance difference no longer exists when the test run is re-executed using the resources with different concurrency.
    Type: Application
    Filed: April 15, 2022
    Publication date: July 28, 2022
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Patent number: 11386059
    Abstract: A baseline run of a workload and a target run of the workload are compared to identify whether there is a performance regression in the target run, wherein the target run implements a feature that is not implemented in the baseline run. In response to identifying the performance regression, the target run is executed to identify whether the performance regression still exists. The performance regression is flagged as a false positive in response to identifying that the performance regression no longer exists when the target run is executed.
    Type: Grant
    Filed: August 31, 2021
    Date of Patent: July 12, 2022
    Assignee: Snowflake Inc.
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Patent number: 11321290
    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. A method includes determining a workload having one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic. The method further includes executing a baseline run of the workload that does not implement the feature and executing a target run of the workload while implementing the feature. The method further includes comparing the baseline run and the target run to identify whether there is a performance regression in the target run. The method further includes, in response to identifying the performance regression, rerunning the target run to identify whether the performance regression still exists.
    Type: Grant
    Filed: March 20, 2019
    Date of Patent: May 3, 2022
    Assignee: Snowflake Inc.
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Publication number: 20210397593
    Abstract: A baseline run of a workload and a target run of the workload are compared to identify whether there is a performance regression in the target run, wherein the target run implements a feature that is not implemented in the baseline run. In response to identifying the performance regression, the target run is executed to identify whether the performance regression still exists. The performance regression is flagged as a false positive in response to identifying that the performance regression no longer exists when the target run is executed.
    Type: Application
    Filed: August 31, 2021
    Publication date: December 23, 2021
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Patent number: 11138167
    Abstract: A baseline run of a workload and a target run of the workload are compared to identify whether there is a performance regression in the target run, wherein the target run implements a feature that is not implemented in the baseline run. In response to identifying the performance regression, the target run is executed to identify whether the performance regression still exists. The performance regression is flagged as a false positive in response to identifying that the performance regression no longer exists when the target run is executed.
    Type: Grant
    Filed: July 30, 2020
    Date of Patent: October 5, 2021
    Assignee: Snowflake Inc.
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Publication number: 20200356540
    Abstract: A baseline run of a workload and a target run of the workload are compared to identify whether there is a performance regression in the target run, wherein the target run implements a feature that is not implemented in the baseline run. In response to identifying the performance regression, the target run is executed to identify whether the performance regression still exists. The performance regression is flagged as a false positive in response to identifying that the performance regression no longer exists when the target run is executed.
    Type: Application
    Filed: July 30, 2020
    Publication date: November 12, 2020
    Inventors: Allison Lee, Shrainik Jain, Qiuye Jin, Stratis Viglas, Jiaqi Yan
  • Patent number: 10762067
    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. A method includes determining a workload having one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic. The method further includes executing a baseline run of the workload that does not implement the feature and executing a target run of the workload while implementing the feature. The method further includes comparing the baseline run and the target run to identify whether there is a performance regression in the target run. The method further includes, in response to identifying the performance regression, rerunning the target run to identify whether the performance regression still exists.
    Type: Grant
    Filed: November 22, 2019
    Date of Patent: September 1, 2020
    Assignee: Snowflake Inc.
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Publication number: 20200089665
    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. A method includes determining a workload having one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic. The method further includes executing a baseline run of the workload that does not implement the feature and executing a target run of the workload while implementing the feature. The method further includes comparing the baseline run and the target run to identify whether there is a performance regression in the target run. The method further includes, in response to identifying the performance regression, rerunning the target run to identify whether the performance regression still exists.
    Type: Application
    Filed: November 22, 2019
    Publication date: March 19, 2020
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stratis Viglas, Allison Lee
  • Publication number: 20190294596
    Abstract: Systems, methods, and devices for incremental feature development and workload capture in database systems are disclosed. A method includes determining a workload having one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic. The method further includes executing a baseline run of the workload that does not implement the feature and executing a target run of the workload while implementing the feature. The method further includes comparing the baseline run and the target run to identify whether there is a performance regression in the target run. The method further includes, in response to identifying the performance regression, rerunning the target run to identify whether the performance regression still exists.
    Type: Application
    Filed: March 20, 2019
    Publication date: September 26, 2019
    Inventors: Jiaqi Yan, Qiuye Jin, Shrainik Jain, Stralis Viglas, Allison Lee