Patent Document ID: 8122066
Application ID: 12251320

Base Claim:
1. A controller-executed method for operating a query profiling system comprising: profiling database queries in a workload comprising: receiving a query set and a data definition language (DDL) model; extracting metadata of the DDL model; converting data definition elements of the metadata into a catalog of database objects; parsing queries corresponding to a workload to create a set of instances of query representations; binding table and column references in a query to a real table, view, or column object contained in the catalog; analyzing the queries for relevant attributes comprising complexity and number of predicates; and storing the attributes in a repository.

---

Claim 7:
7. The method according to claim 1 further comprising: extracting attributes for SELECT statements comprising columns contained in a list of columns contained in a select list, tables contained in a from list, restriction predicates, join predicates, group by columns, order by columns, and subqueries; and extracting attributes for DELETE, INSERT, and UPDATE statements comprising restriction predicates and subqueries.