专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08122066B2 Database query profiler 有权
标题翻译：数据库查询分析器
公开(公告)号：US08122066B2
公开(公告)日：2012-02-21
申请号：US12251320
申请日：2008-10-14
申请人： Maria G. Castellanos , Ivo Jose Jimenez Ramos
发明人： Maria G. Castellanos , Ivo Jose Jimenez Ramos
IPC分类号： G06F7/00
CPC分类号： G06F17/30306
摘要： 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.
摘要翻译：查询分析系统和相关操作方法实现数据库查询分析器。说明性数据库系统包括解析器，查询模型，目录管理器，绑定器和视图重写器以及查询分析器。解析器通过根据结构化查询语言（SQL）语法检查语句的语法并以面向语法的内部格式表示语句来解析语句。目录管理器处理转换为内部表示的数据定义SQL语句（DDL）; 将DDL的表示转换为数据库对象抽象; 将数据库对象分组到目录中。绑定器和视图重写器采用通过解析工作负载查询（数据操作SQL语句或DML）获得的内部表示，并通过其相应的View定义重写表引用; 将数据库对象引用绑定到目录中包含的实际数据库对象。查询分析器分析相关属性的查询，并将属性存储在配置文件库中。

2. 发明申请

US20100094829A1 DATABASE QUERY PROFILER 有权
标题翻译：数据库查询配置文件
公开(公告)号：US20100094829A1
公开(公告)日：2010-04-15
申请号：US12251320
申请日：2008-10-14
申请人： Maria G. Castellanos , Ivo Jose Jimenez Ramos
发明人： Maria G. Castellanos , Ivo Jose Jimenez Ramos
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30306
摘要： 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.
摘要翻译：查询分析系统和相关操作方法实现数据库查询分析器。说明性数据库系统包括解析器，查询模型，目录管理器，绑定器和视图重写器以及查询分析器。解析器通过根据结构化查询语言（SQL）语法检查语句的语法并以面向语法的内部格式表示语句来解析语句。目录管理器处理转换为内部表示的数据定义SQL语句（DDL）; 将DDL的表示转换为数据库对象抽象; 将数据库对象分组到目录中。绑定器和视图重写器采用通过解析工作负载查询（数据操作SQL语句或DML）获得的内部表示，并通过其相应的View定义重写表引用; 将数据库对象引用绑定到目录中包含的实际数据库对象。查询分析器分析相关属性的查询，并将属性存储在配置文件库中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式