Identifying similar database queries
Assigneesalesforce.com, inc.
InventorRupesh Khandelwal
Life of this patent
Estimating the term…
Abstract
Some embodiments of the present invention include a method for identifying unique and duplicate queries from a group of queries associated with a database system. The method includes forming, by a server computing system, two or more subgroups of queries from a group of queries based on a characteristic of the queries, the group of queries associated with a first database system; determining, by the server computing system, unique and duplicate queries in each of the subgroups based on a similarity threshold; and migrating, by the server computing system, the unique queries from each of the subgroups to a second database system.
Claims18
A method comprising:
- forming, by a server computing system, two or more subgroups of queries from a group of queries based on a query length characteristic of the queries such that the queries in each subgroup share the query length characteristic of the corresponding subgroup, the group of queries associated with a first database system;
- determining, by the server computing system, unique and duplicate queries in each of the subgroups based on a similarity threshold;
- storing the duplicate and unique queries that have been identified from the two or more subgroups for determining duplicate queries in the two or more subgroups of the first database system;
- and
- migrating, by the server computing system, the unique queries from each of the subgroups to a second database system.
An apparatus for identifying unique and duplicate queries from a group of queries, the apparatus comprising:
- a processor;
- and
- one or more stored sequences of instructions which, when executed by the processor, cause the processor to:
- form two or more subgroups of queries from a group of queries based on a query length characteristic of the queries such that the queries in each subgroup share the query length characteristic of the corresponding subgroup, the group of queries associated with a first database system;
- determine unique and duplicate queries in each of the subgroups based on a similarity threshold;
- store the duplicate and unique queries that have been identified from the two or more subgroups for determining duplicate queries in the two or more subgroups of the first database system;
- and
- migrate the unique queries from each of the subgroups to a second database system.
A computer program product comprising computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code including instructions to:
- form two or more subgroups of queries from a group of queries based on a query length characteristic of the queries such that the queries in each subgroup share the query length characteristic of the corresponding subgroup, the group of queries associated with a first database system;
- determine unique and duplicate queries in each of the subgroups based on a similarity threshold;
- store the duplicate and unique queries that have been identified from the two or more subgroups for determining duplicate queries in the two or more subgroups of the first database system;
- and
- migrate the unique queries from each of the subgroups to a second database system.
Dependencies are inferred from the claim text.