Quantifying complexity of a database application
AssigneeDatometry, Inc.
InventorsFlorian Michael Waas, Dmitri Korablev, Michele Gage, Mark Morcos, Amirhossein Aleyasen
Life of this patent
Estimating the term…
Abstract
Some embodiments provide a method for quantifying the workload placed on a database by an application. The method identifies a first group of database queries that the application directed towards the database. The method produces a second group of queries by removing, from the first group of queries, queries that are duplicates based on the semantic structure of the queries. Based on a set of properties of the second group of queries, the method computes a complexity indicator that represents a complexity expression of the second group of queries.
Claims20
A method for quantifying workload placed on a first database by an application, the method comprising:
- identifying a first plurality of database queries that the application directed towards the first database;
- producing a second plurality of queries by removing, from the first plurality, queries that are duplicates based on semantic structure of the queries;
- based on a set of properties of the second plurality of queries, computing a complexity indicator that represents a level of difficulty for rewriting the second plurality of queries for a second database that is a candidate database for migrating data in the first database;
- and
- presenting the complexity indicator in a display to allow a user to determine whether the data should be migrated from the first database to the second database.
A non-transitory machine readable medium storing a program which when executed by at least one processing unit quantifies a workload placed on a first database by an application, the program comprising sets of instructions for:
- identifying a first plurality of database queries that the application directed towards the first database;
- producing a second plurality of queries by removing, from the first plurality, queries that are duplicates based on semantic structure of the queries;
- based on a set of properties of the second plurality of queries, computing a complexity indicator that represents a level of difficulty for rewriting the second plurality of queries for a second database that is a candidate database for migrating data in the first database;
- and
- presenting the complexity indicator in a display to allow a user to determine whether the data should be migrated from the first database to the second database.
Dependencies are inferred from the claim text.