-
1.发明申请Technique and Framework to Provide Diagnosability for XML Query/DML Rewrite and XML Index Selection 有权为XML查询/ DML重写和XML索引选择提供可诊断性的技术和框架公开(公告)号：US20130006964A1
公开(公告)日：2013-01-03
申请号：US13172573
申请日：2011-06-29
IPC分类号： G06F17/30
CPC分类号： G06F17/30929
摘要： A method and apparatus for automatically analyzing and providing feedback regarding the optimizability of a relational database query. A query developer's primary goal is to ensure that queries and DML operations are rewritten for the most efficient execution. Rewrite diagnosability captures metadata for each attempted query optimization including success or failure and the reasons for failure. The metadata is stored in association with the operators that were not removed through rewriting. Once all optimizations have been attempted and rewriting is complete, the metadata is selectively displayed based on the cost to perform the associated operation. The context of performing the operation may affect the cost. The cost may be based at least on the type of operation and where within the query tree the operation is located. A query developer may configure the database system not to execute the resulting query plan based on one or more criteria.
摘要翻译： 一种用于自动分析和提供关于关系数据库查询的可优化性的反馈的方法和装置。 查询开发人员的主要目标是确保查询和DML操作被重写以实现最有效的执行。 重写诊断能力捕获每个尝试的查询优化的元数据，包括成功或失败以及失败的原因。 元数据与未通过重写删除的运算符相关联存储。 一旦尝试了所有优化并重写完成后，将根据执行相关操作的成本选择性地显示元数据。 执行操作的上下文可能会影响成本。 成本可以至少基于操作类型以及操作所在查询树中的哪一个。 查询开发人员可以将数据库系统配置为不基于一个或多个标准执行生成的查询计划。
-
2.发明授权公开(公告)号：US09767214B2
公开(公告)日：2017-09-19
申请号：US13172573
申请日：2011-06-29
CPC分类号： G06F17/30929
摘要： A method and apparatus for automatically analyzing and providing feedback regarding the optimizability of a relational database query. A query developer's primary goal is to ensure that queries and DML operations are rewritten for the most efficient execution. Rewrite diagnosability captures metadata for each attempted query optimization including success or failure and the reasons for failure. The metadata is stored in association with the operators that were not removed through rewriting. Once all optimizations have been attempted and rewriting is complete, the metadata is selectively displayed based on the cost to perform the associated operation. The context of performing the operation may affect the cost. The cost may be based at least on the type of operation and where within the query tree the operation is located. A query developer may configure the database system not to execute the resulting query plan based on one or more criteria.
-
3.发明授权XPath-based creation of relational indexes and constraints over XML data stored in relational tables 有权基于XPath的关系索引和约束存储在关系表中的XML数据公开(公告)号：US09424365B2
公开(公告)日：2016-08-23
申请号：US12610164
申请日：2009-10-30
CPC分类号： G06F17/30917 , G06F17/30241 , G06F17/30327
摘要： Techniques and approaches are provided for creating indexes and column constraints on structured XML data that is stored in a relational database. Data Definition Language (DDL) Create Index and Create Constraint commands have extended syntax that allows the specification of a path-based expression instead of requiring a column and table name. A mapping created by the system when an XML Schema is registered stores the correspondence of XML data elements to automatically-created database tables and columns that are given names only useful for the internal system. When a user provides a path-based expression in a DDL when creating an index or constraint, the path-based expression is translated to the underlying database constructs using the mapping. Issues are addressed for handling path-based expressions that evaluate to more than one element. Additional index optimization is described using data type information available in the XML schema to select the optimal index type.
摘要翻译： 提供了技术和方法，用于为存储在关系数据库中的结构化XML数据创建索引和列约束。 数据定义语言（DDL）创建索引和创建约束命令具有扩展语法，允许指定基于路径的表达式，而不需要列和表名称。 在注册XML模式时由系统创建的映射将XML数据元素的对应关系存储到自动创建的数据库表和列，这些列和列仅对内部系统有用。 当用户在创建索引或约束时在DDL中提供基于路径的表达式时，基于路径的表达式将使用映射转换为底层数据库结构。 处理针对评估多个元素的基于路径的表达式的问题。 使用XML模式中可用的数据类型信息来描述附加索引优化，以选择最佳索引类型。
-
4.发明申请XPath-Based Creation Of Relational Indexes And Constraints Over XML Data Stored In Relational Tables 有权基于XPath的关系索引的创建和关系表中存储的XML数据的约束公开(公告)号：US20110106812A1
公开(公告)日：2011-05-05
申请号：US12610164
申请日：2009-10-30
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , G06F17/30241 , G06F17/30327
摘要： Techniques and approaches are provided for creating indexes and column constraints on structured XML data that is stored in a relational database. Data Definition Language (DDL) Create Index and Create Constraint commands have extended syntax that allows the specification of a path-based expression instead of requiring a column and table name. A mapping created by the system when an XML Schema is registered stores the correspondence of XML data elements to automatically-created database tables and columns that are given names only useful for the internal system. When a user provides a path-based expression in a DDL when creating an index or constraint, the path-based expression is translated to the underlying database constructs using the mapping. Issues are addressed for handling path-based expressions that evaluate to more than one element. Additional index optimization is described using data type information available in the XML schema to select the optimal index type.
摘要翻译： 提供了技术和方法，用于为存储在关系数据库中的结构化XML数据创建索引和列约束。 数据定义语言（DDL）创建索引和创建约束命令具有扩展语法，允许指定基于路径的表达式，而不需要列和表名称。 在注册XML模式时由系统创建的映射将XML数据元素的对应关系存储到自动创建的数据库表和列，这些列和列仅对内部系统有用。 当用户在创建索引或约束时在DDL中提供基于路径的表达式时，基于路径的表达式将使用映射转换为底层数据库结构。 处理针对评估多个元素的基于路径的表达式的问题。 使用XML模式中可用的数据类型信息来描述附加索引优化，以选择最佳索引类型。
-
公开(公告)号：US20110047143A1
公开(公告)日：2011-02-24
申请号：US12545737
申请日：2009-08-21
CPC分类号： G06F17/30935
摘要： Techniques for determining whether an XML query may be written are provided. In one scenario, an XML query includes an expandable path, which is a path expression that includes a wildcard character (*) or a descendant axis (//). An XML schema is used to generate multiple expanded paths (each of which is a simple path expression) from the expandable path. The XML schema is used to compare each expanded path to another expanded path and to determine whether the nodes identified by the respective expanded paths are guaranteed to occur in a particular order in XML documents that conform to the XML schema. In another scenario, an XML query includes an order operator that takes two paths as input. Similarly, an XML schema is used to compare the two paths and to determine whether the nodes identified by the two paths are guaranteed to occur in a particular order in XML documents that conform to the XML schema.
摘要翻译： 提供了用于确定是否可以写入XML查询的技术。 在一种情况下，XML查询包括可扩展路径，它是包含通配符（*）或后代轴（//）的路径表达式。 使用XML模式从可扩展路径生成多个扩展路径（每个路径都是简单的路径表达式）。 XML模式用于将每个扩展路径与另一个扩展路径进行比较，并确定由相应扩展路径标识的节点是否保证以符合XML模式的XML文档中的特定顺序发生。 在另一种情况下，XML查询包括一个订单运算符，它将两条路径作为输入。 类似地，使用XML模式来比较两个路径，并确定由两个路径标识的节点是否保证以符合XML模式的XML文档中的特定顺序发生。
-
公开(公告)号：US09477778B2
公开(公告)日：2016-10-25
申请号：US12545737
申请日：2009-08-21
IPC分类号： G06F17/30
CPC分类号： G06F17/30935
摘要： Techniques for determining whether an XML query may be written are provided. In one scenario, an XML query includes an expandable path, which is a path expression that includes a wildcard character (*) or a descendant axis (//). An XML schema is used to generate multiple expanded paths (each of which is a simple path expression) from the expandable path. The XML schema is used to compare each expanded path to another expanded path and to determine whether the nodes identified by the respective expanded paths are guaranteed to occur in a particular order in XML documents that conform to the XML schema. In another scenario, an XML query includes an order operator that takes two paths as input. Similarly, an XML schema is used to compare the two paths and to determine whether the nodes identified by the two paths are guaranteed to occur in a particular order in XML documents that conform to the XML schema.
摘要翻译： 提供了用于确定是否可以写入XML查询的技术。 在一种情况下，XML查询包括可扩展路径，它是包含通配符（*）或后代轴（//）的路径表达式。 使用XML模式从可扩展路径生成多个扩展路径（每个路径都是简单的路径表达式）。 XML模式用于将每个扩展路径与另一个扩展路径进行比较，并确定由相应扩展路径标识的节点是否保证以符合XML模式的XML文档中的特定顺序发生。 在另一种情况下，XML查询包括一个订单运算符，它将两条路径作为输入。 类似地，使用XML模式来比较两个路径，并确定由两个路径标识的节点是否保证以符合XML模式的XML文档中的特定顺序发生。
-
-
-
-
-
搜索结果
6 条记录 (耗时 0.019 秒)