Patent Document ID: 9898383
Application ID: 14511097

Base Claim:
1. A method of analyzing a plurality of database queries within a database environment, the method comprising: determining a first statistical evaluation of a first query plan for a first database query corresponding to a first database having a first database schema with at least one computing device within the database environment; determining a second statistical evaluation for a second query plan for a second database query corresponding to a second database having a second database schema with at least one computing device within the database environment; comparing the first statistical evaluation and the second statistical evaluation to determine whether the first query plan matches the second query plan with at least one computing device within the database environment; storing an indication in a repository of the database environment that the first query matches the second query if the first statistical evaluation matches the second statistical evaluation; determining a function that provides the first query plan with at least one computing device within the database environment; determining if the second query plan is provided by the function that provides the first query plan with at least one computing device within the database environment; evaluating data objects referenced by the first query plan and the second query plan if the function provides both the first query plan and the second query plan with at least one computing device within the database environment to determine if the first query plan and the second query plan are syntactically different versions of equivalent database queries; and storing query statistics in the statistical repository of the database environment if the first query plan and the second query plan are syntactically different versions of equivalent database queries.

---

Claim 4:
4. The method of claim 1 wherein the first query plan is directed to a first database and the second query plan is directed to a second database.