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 5:
5. The method according to claim 1 further comprising: binding table and column references comprising: cannonicalizing table references into a catalog.schema.tablename format; checking a table reference for registration in the catalog; determining whether the table reference is defined as a view; substituting the table reference for a table reference defined as a view by using a corresponding select statement; checking that attribute references are correct using the catalog; determining whether column references point to a base table column or a derived table column; binding a column reference directly to the base table column if the column reference points to the base table column; and following a path of the derived table column to a base table where the column reference originates and substituting all column references contained in predicates if the column reference points to the derived table column.