Techniques for managing XML data associated with multiple execution units
    11.
    发明授权
    Techniques for managing XML data associated with multiple execution units 有权
    用于管理与多个执行单元相关联的XML数据的技术

    公开(公告)号:US08949220B2

    公开(公告)日:2015-02-03

    申请号:US10810152

    申请日:2004-03-26

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/3092

    摘要: Techniques for managing XML data associated with multiple execution units ensure that execution units are able to use XML data coming from other execution units. Such techniques are applicable when, but for the technique, an XML type value is produced in a particular form by one execution unit and is supposed to be consumed by another execution unit that is unable to process data in the particular form, and involves detecting that the foregoing situation exists and annotating information sent to an XML producer execution unit to cause the XML type value to be transformed into a canonical form that can be shared by all relevant execution units.

    摘要翻译: 用于管理与多个执行单元相关联的XML数据的技术确保执行单元能够使用来自其他执行单元的XML数据。 这种技术适用于但是对于技术而言,XML类型值由一个执行单元以特定形式产生并且被假定由不能处理特定形式的数据的另一执行单元消耗,并且涉及检测该 存在上述情况并且向XML生成器执行单元注释信息,以使XML类型值被转换成可由所有相关执行单元共享的规范形式。

    Technique of using XMLType tree as the type infrastructure for XML
    13.
    发明申请
    Technique of using XMLType tree as the type infrastructure for XML 有权
    使用XMLType树作为XML类型基础设施的技术

    公开(公告)号:US20060031233A1

    公开(公告)日:2006-02-09

    申请号:US11044472

    申请日:2005-01-26

    IPC分类号: G06F7/00

    CPC分类号: G06F17/2247

    摘要: A universal format is used to create a type representation of XMLType instances that are generated in various ways from various sources. An XMLType Type Tree is represented as a hierarchy of nodes, including leaf item node, composite item node, operator node, aggregate node, referred to herein as an XMLType Type Tree. An XMLType Type Tree serves as a digest of the type structure of XMLType, no matter the source of the XMLType instance or its manner of its generation and it creates one uniform abstraction of the type structure of XMLType for the data-typing analysis of XPath and XQuery during query compile time.

    摘要翻译: 通用格式用于创建以各种方式生成的XMLType实例的类型表示形式。 XMLType类型树被表示为节点的层次结构,包括叶项目节点,复合项目节点,运营商节点,聚合节点,这里称为XMLType类型树。 XMLType类型树作为XMLType的类型结构的摘要,无论XMLType实例的来源或其生成方式如何,它都会为XPath的数据类型分析创建XMLType类型结构的一个统一抽象, 查询编译期间的XQuery。

    Method and mechanism for handling arbitrarily-sized XML in SQL operator tree
    14.
    发明授权
    Method and mechanism for handling arbitrarily-sized XML in SQL operator tree 有权
    在SQL运算符树中处理任意大小的XML的方法和机制

    公开(公告)号:US07873645B2

    公开(公告)日:2011-01-18

    申请号:US10656800

    申请日:2003-09-05

    IPC分类号: G06F7/00 G06F17/30

    摘要: Disclosed is a method and mechanism for processing expressions and operator trees. An approach is particularly useful to optimize processing of XML statements with respect to SQL operators. A top-down processing approach can be taken to directly output data from operators to a data stream. In addition, multiple processing approaches can be taken within a single expression tree, with some operators processed using the top-down approach and other operators processed with the bottom-up approach. Even data that can not be streamed is copied fewer times using this approach, intermediate values from bottom-up processing may still be streamed if it is used by an operator that is eligible for top-down processing.

    摘要翻译: 公开了一种处理表达式和运算符树的方法和机制。 一种方法对于优化与SQL操作符相关的XML语句的处理特别有用。 可以采用自上而下的处理方式将数据从运算符直接输出到数据流。 此外,可以在单个表达式树中采用多种处理方法,一些运算符使用自上而下的方法进行处理,其他运算符也使用自下而上的方法进行处理。 即使不能流式传输的数据也可以使用这种方法被复制较少次,如果由符合自上而下处理的操作符使用,则自下而上处理的中间值可能仍然被流式传输。

    Processing queries against one or more markup language sources
    15.
    发明授权
    Processing queries against one or more markup language sources 有权
    处理针对一个或多个标记语言源的查询

    公开(公告)号:US07668806B2

    公开(公告)日:2010-02-23

    申请号:US10948536

    申请日:2004-09-22

    IPC分类号: G06F17/30

    摘要: Techniques are provided for processing a query, including receiving the query, where the query specifies certain operations to be performed, including (a) a first set of one or more operations that are to be performed on a markup language data source and (b) a second set of one or more operations that are to be performed on a second data source. Then it is determined that a first server that manages the markup language data source is capable of performing the first set of operations. A request is sent to the first server to perform the first set of operations. A response is received, where the response contains results of performing the first set of operations on the markup language data source. Finally, results are generated for the query based at least in part on the results of performing the first set of operations.

    摘要翻译: 提供了用于处理查询的技术,包括接收查询,其中查询指定要执行的某些操作,包括(a)要在标记语言数据源上执行的一个或多个操作的第一组,以及(b) 要在第二数据源上执行的一个或多个操作的第二组。 然后,确定管理标记语言数据源的第一服务器能够执行第一组操作。 发送请求到第一台服务器执行第一组操作。 收到响应,其中响应包含对标记语言数据源执行第一组操作的结果。 最后,至少部分地基于执行第一组操作的结果为查询生成结果。

    Techniques for efficient integration of text searching with queries over XML data
    17.
    发明授权
    Techniques for efficient integration of text searching with queries over XML data 有权
    通过XML数据高效集成文本搜索与查询的技术

    公开(公告)号:US07305414B2

    公开(公告)日:2007-12-04

    申请号:US11099918

    申请日:2005-04-05

    IPC分类号: G06F17/30

    摘要: A method and apparatus for rewriting a database command containing an embedded XML expression such that the rewritten database command recites a text function, in lieu of the embedded XML expression, is provided. Advantageously, a DBMS may take advantage of the efficiencies in storing XML data within the database, while avoiding the generation of unnecessary XML elements in processing the query when the XML elements contribute nothing to the outcome of the query. Cost-base or rule-based analysis may be performed to determine how to rewrite a received database command. The database server may functionally evaluate the text function or may use an index defined on a column of the database. The text function may function as a primary filter or may reference a column upon which an index is defined, wherein the index operates at the same or higher level than a column being referenced in the embedded XML expression.

    摘要翻译: 提供一种用于重写包含嵌入式XML表达式的数据库命令的方法和装置,使得重写的数据库命令背景文本功能代替嵌入的XML表达。 有利地,DBMS可以利用在数据库中存储XML数据的效率,同时避免在XML元素对查询的结果没有贡献时在处理查询时生成不必要的XML元素。 可以执行基于成本或基于规则的分析来确定如何重写接收到的数据库命令。 数据库服务器可以在功能上评估文本功能,或者可以使用在数据库的列上定义的索引。 文本函数可以用作主过滤器,或者可以引用定义索引的列,其中索引在与嵌入式XML表达式中引用的列相同或更高的级别上操作。

    Techniques for rewriting XML queries directed to relational database constructs
    18.
    发明授权
    Techniques for rewriting XML queries directed to relational database constructs 有权
    重写针对关系数据库结构的XML查询的技术

    公开(公告)号:US07120645B2

    公开(公告)日:2006-10-10

    申请号:US10428878

    申请日:2003-05-01

    IPC分类号: G06F17/30

    摘要: Techniques for executing database commands include receiving a database command that includes an XML component operation that operates on an XML construct that is based on a first set of one or more relational database constructs. It is determined whether the XML component operation can be transformed to a relational database operation on a particular set of one or more relational database constructs of the first set, which does not involve the XML component operation. If it is determined that the XML component operation can be transformed, then the XML component operation is rewritten as a particular relational database operation that operates on the particular set and that does not involve the XML component operation. The particular relational database operation is evaluated. In another aspect, techniques include determining a primitive set of XML generation operations and replacing non-primitive XML generation operations with one or more operations from the primitive set.

    摘要翻译: 用于执行数据库命令的技术包括接收包括对基于第一组一个或多个关系数据库构造的XML构造进行操作的XML组件操作的数据库命令。 确定XML组件操作是否可以被转换为第一组的一个或多个关系数据库构造的特定集合上的关系数据库操作,其不涉及XML组件操作。 如果确定可以转换XML组件操作,则将XML组件操作重写为在特定集合上操作且不涉及XML组件操作的特定关系数据库操作。 评估特定的关系数据库操作。 在另一方面,技术包括确定XML生成操作的原始集合并且用来自原语集合的一个或多个操作来替换非原始XML生成操作。

    Techniques for retaining hierarchical information in mapping between XML documents and relational data
    19.
    发明授权
    Techniques for retaining hierarchical information in mapping between XML documents and relational data 有权
    在XML文档和关系数据之间的映射中保留分层信息的技术

    公开(公告)号:US07103611B2

    公开(公告)日:2006-09-05

    申请号:US10428443

    申请日:2003-05-01

    IPC分类号: G06F17/30

    摘要: Techniques for managing XML data in an SQL compliant DBMS include receiving an SQL statement. The SQL statement includes a particular operator that operates on a first instance of XML type that represents a first set of XML elements. During execution of the SQL statement, the particular operator is evaluated by generating an ordered collection of instances of XML type. Each different instance in the ordered collection is based on a different XML element from the first set; and there is an instance in the ordered collection for every XML element from either the first set or from the first set and its descendents. When descendents are included, each entry in the ordered collection indicates a level in the XML tree. In another aspect, an aggregate operator in the SQL statement operates on a collection of instances, with associated levels, to generate a single instance of XML type.

    摘要翻译: 在SQL兼容DBMS中管理XML数据的技术包括接收SQL语句。 SQL语句包括一个特定的操作符,它在代表第一组XML元素的XML类型的第一个实例上运行。 在执行SQL语句期间,通过生成XML类型的实例的有序集合来评估特定的操作符。 有序集合中的每个不同实例都基于与第一个集合不同的XML元素; 并且有序集合中的第一个集合或第一个集合及其后代的每个XML元素都有一个实例。 当包含后代时,有序集合中的每个条目指示XML树中的一个级别。 另一方面,SQL语句中的聚合运算符对具有关联级别的实例集合进行操作,以生成单个XML类型的实例。