DATABASE QUERY PROFILER
First 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.
2 Assignments
0 Petitions
Accused Products
Abstract
A query profiling system and associated operating methods implement a database query profiler. The illustrative database system comprises a parser, a query model, a catalog manager, a binder and view rewriter, and a query analyzer. The parser parses statements by checking syntax of a statement according to a structured query language (SQL) grammar and representing the statements in a syntax-oriented internal format. The catalog manager processes data definition SQL statements (DDL) that are transformed to the internal representation; transform the representations of the DDL to database objects abstractions; groups the database objects into a Catalog. The binder and view rewriter take the internal representations obtained by parsing workload queries (data manipulation SQL statements or DML) and rewrite table references by their corresponding View definitions; bind database object references to their actual database objects contained in the catalog. The query analyzer analyzes the queries for relevant attributes and stores the attributes in a profile repository.
-
Citations
15 Claims
-
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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
9. A controller-executed method for operating a query profiling system comprising:
-
profiling database queries in a workload comprising; parsing queries against metadata extracted from a data definition language (DDL) model in a catalog of database objects comprising; checking syntax of a query according to a structured query language (SQL) grammar; and representing the query in a syntax-oriented internal format; binding references in a query to objects contained in the catalog; analyzing the queries for relevant attributes; and storing the attributes in a repository.
-
-
10. A query profiling system comprising:
-
a parser that parses by checking syntax of a query according to a structured query language (SQL) grammar and representing the queries in a syntax-oriented internal format;
then compares the queries against metadata extracted from a data definition language (DDL) model in a catalog of database objects; anda binder and view rewriter that rewrites table references with their corresponding view definitions and binds references in a query to objects contained in the catalog; and a query analyzer that analyzes the queries for relevant attributes and stores the attributes in a profile repository. - View Dependent Claims (11, 12, 13, 14, 15)
-
Specification