Encoding insignificant whitespace of XML data
    1.
    发明授权
    Encoding insignificant whitespace of XML data 有权
    编码XML数据的微不足道的空白

    公开(公告)号:US07627566B2

    公开(公告)日:2009-12-01

    申请号:US11707730

    申请日:2007-02-16

    IPC分类号: G06F7/00 G06F17/30

    摘要: Techniques are described for preserving the original insignificant white space of XML data. The techniques may be used in combination with compact XML data storage formats, such as binary XML, to preserve the insignificant white space without requiring as much storage space as uncompressed formats. White space opcodes/operand pairs are described for representing white space characters and white space patterns. The white space opcode/operand pairs represent the white space in binary XML, are use to generate the original white space when the binary XML is decoded back to textual XML data.

    摘要翻译: 描述了保存XML数据原始无关紧要的空白空间的技术。 这些技术可以与紧凑的XML数据存储格式(例如二进制XML)结合使用,以保持无关紧要的空白空间,而不需要与未压缩格式一样多的存储空间。 描述了用于表示空白字符和空白空格的白色空间操作码/操作数对。 白色空间操作码/操作数对表示二进制XML中的空白空间,当二进制XML被解码回文本XML数据时,用于生成原始空白。

    Encoding insignificant whitespace of XML data
    2.
    发明申请
    Encoding insignificant whitespace of XML data 有权
    编码XML数据的微不足道的空白

    公开(公告)号:US20080098019A1

    公开(公告)日:2008-04-24

    申请号:US11707730

    申请日:2007-02-16

    IPC分类号: G06F17/00

    摘要: Techniques are described for preserving the original insignificant white space of XML data. The techniques may be used in combination with compact XML data storage formats, such as binary XML, to preserve the insignificant white space without requiring as much storage space as uncompressed formats. White space opcodes/operand pairs are described for representing white space characters and white space patterns. The white space opcode/operand pairs represent the white space in binary XML, are use to generate the original white space when the binary XML is decoded back to textual XML data.

    摘要翻译: 描述了保存XML数据原始无关紧要的空白空间的技术。 这些技术可以与紧凑的XML数据存储格式(例如二进制XML)结合使用,以保持无关紧要的空白空间,而不需要与未压缩格式一样多的存储空间。 描述了用于表示空白字符和空白空格的白色空间操作码/操作数对。 白色空间操作码/操作数对表示二进制XML中的空白空间,当二进制XML被解码回文本XML数据时,用于生成原始空白。

    Efficient way to evaluate uncorrelated path-based row sources with XML storage
    3.
    发明授权
    Efficient way to evaluate uncorrelated path-based row sources with XML storage 有权
    用XML存储来评估不相关的基于路径的行源的有效方式

    公开(公告)号:US08239373B2

    公开(公告)日:2012-08-07

    申请号:US12467984

    申请日:2009-05-18

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30932

    摘要: The approaches described herein provide an efficient way to process certain kinds of queries that retrieve XML data stored in an object-relational database. A technique determines whether a query comprises a plurality of iteration expressions that exhibit a particular relationship to one another, and if so, re-writes the query and produces an optimized query execution plan. The query execution plan specifies an XPath-based row source with caching enabled. A very small cache structure is used, and reference locators are stored in the cache that point into binary-encoded data rather than copying XMLType data into the cache. Row data may be cached on the first use of the path-based row source and re-used in subsequent requests for rows. Once there is a subsequent request for rows from the optimized path-based row source, the cache may be reorganized to efficiently produce the rows of the row source.

    摘要翻译: 本文描述的方法提供了处理检索存储在对象关系数据库中的XML数据的某些类型的查询的有效方式。 技术确定查询是否包括彼此具有特定关系的多个迭代表达式,如果是,则重写该查询并产生优化的查询执行计划。 查询执行计划指定启用缓存的基于XPath的行源。 使用非常小的缓存结构,参考定位器存储在缓存中,指向二进制编码数据,而不是将XMLType数据复制到缓存中。 行数据可以在首次使用基于路径的行源缓存,并在后续的行请求中重新使用。 一旦从优化的基于路径的行源中获得行的后续请求,则可以重新组织高速缓存以有效地产生行源的行。

    Document fidelity with binary XML storage
    4.
    发明授权
    Document fidelity with binary XML storage 有权
    使用二进制XML存储文件保真

    公开(公告)号:US08090731B2

    公开(公告)日:2012-01-03

    申请号:US12180760

    申请日:2008-07-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30569 G06F17/30908

    摘要: Techniques are provided for ensuring lexical fidelity when an XML document is stored in a binary format. Operations, on the XML data, that would cause the loss of lexical fidelity between the original XML document and the binary-encoded version of the XML document are not performed. Such operations include the removal of unnecessary whitespace characters, certain data type conversions, CRLF normalization, the “collapsing” of two-tag empty elements into a single tag empty element, and the replacing of entity references or numeric character references with another value. An XML schema, to which the XML document conforms, may indicate that the XML document is to be stored in a lexical fidelity mode. Additionally, or alternatively, the database statement that (when executed) causes the XML document to be stored in a binary format may so indicate.

    摘要翻译: 当XML文档以二进制格式存储时,提供了用于确保词汇保真度的技术。 不会执行对原始XML文档和XML文档的二进制编码版本之间的词法保真度的XML数据的操作。 这样的操作包括删除不必要的空白字符,某些数据类型转换,CRLF归一化,将双标签空元素“折叠”到单个标签空元素中,以及用另一个值替换实体引用或数字字符引用。 XML文档符合的XML模式可以指示XML文档将以词法保真模式存储。 另外或替代地,数据库语句(当被执行时)导致XML文档以二进制格式存储可能如此指示。

    Mechanism For Deferred Rewrite Of Multiple Xpath Evaluations Over Binary XML
    5.
    发明申请
    Mechanism For Deferred Rewrite Of Multiple Xpath Evaluations Over Binary XML 有权
    延迟重写二进制XML的Xpath评估机制

    公开(公告)号:US20100030726A1

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

    申请号:US12181725

    申请日:2008-07-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30935 G06F17/30911

    摘要: A mechanism is provided for improving the performance of particular database queries operating on a view comprising binary-encoded XML. The key to improving performance is to determine whether a XML index is available to improve the computation of XPath data before deriving an optimized execution plan for a particular query. When a XML index is not available to help expedite the computation of binary-encoded XML, then deferring the computation of the XPath data until after the view merge stage avoids unnecessary computation of XPaths that are part of the view but not needed for the particular query.

    摘要翻译: 提供了一种机制,用于提高在包含二进制编码XML的视图上操作的特定数据库查询的性能。 提高性能的关键是确定在为特定查询获得优化的执行计划之前,XML索引是否可用于改进XPath数据的计算。 当XML索引不可用以帮助加速二进制编码的XML的计算时,则推迟XPath数据的计算,直到视图合并阶段之后,避免不必要的计算XPath作为视图的一部分,但不需要特定的查询 。

    Query Optimization by Specifying Path-Based Predicate Evaluation in a Path-Based Query Operator
    8.
    发明申请
    Query Optimization by Specifying Path-Based Predicate Evaluation in a Path-Based Query Operator 有权
    通过在基于路径的查询运算符中指定基于路径的谓词评估来进行查询优化

    公开(公告)号:US20100312756A1

    公开(公告)日:2010-12-09

    申请号:US12478147

    申请日:2009-06-04

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30938 G06F17/30463

    摘要: The approaches described herein provide an efficient way for a database server to process certain kinds of queries over XML data stored in an object-relational database that require the evaluation of a predicate expression with one or more path-based operands. A predicate expression part of a XQuery or SQL WHERE clause that returns a boolean value. A database server first determines whether the query qualifies for this particular kind of optimization, then rewrites the query using an enhanced query operator syntax for specifying the predicate expression to be evaluated. The enhanced query operator subsumes the work of a second path-based query operator, resulting in the suppression of the WHERE EXISTS subquery. The rewritten query operator is used to generate a query execution plan that provides for several query execution optimizations.

    摘要翻译: 本文描述的方法为数据库服务器处理某些类型的查询提供了一种有效的方法,该XML数据存储在需要使用一个或多个基于路径的操作数的谓词表达式的对象关系数据库中。 XQuery或SQL WHERE子句的谓词表达式部分,返回一个布尔值。 数据库服务器首先确定查询是否符合此特定类型的优化,然后使用增强型查询运算符语法重写查询,以指定要评估的谓词表达式。 增强型查询操作符包含第二个基于路径的查询运算符的工作,从而抑制了WHERE EXISTS子查询。 重写的查询运算符用于生成提供多个查询执行优化的查询执行计划。

    Cache-Based Predicate Handling For Queries On XML Data Using Uncorrelated Path-Based Row Sources
    9.
    发明申请
    Cache-Based Predicate Handling For Queries On XML Data Using Uncorrelated Path-Based Row Sources 有权
    基于缓存的谓词处理使用不相关的基于路径的行源的XML数据查询

    公开(公告)号:US20100306219A1

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

    申请号:US12474124

    申请日:2009-05-28

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30935

    摘要: The approaches described herein provide an efficient way to process certain kinds of queries that retrieve XML data stored in an object-relational database. An XML query may include a predicate condition that joins two row sources. One or both of the row sources required for predicate evaluation may be path-based; that is, consume and produce rows of XMLType data. Such a path-based row source may be modified to use the predicate condition to filter the rows it generates so that only rows satisfying the predicate condition need to be further processed. A small cache structure introduced into the path-based row source may be used to optimize the evaluation of the predicate row. Once populated with row data, the cache structure may be reorganized to optimize the performance of predicate evaluation.

    摘要翻译: 本文描述的方法提供了处理检索存储在对象关系数据库中的XML数据的某些类型的查询的有效方式。 XML查询可能包括连接两个行源的谓词条件。 谓词评估所需的一个或两个行来源可能是基于路径的; 也就是消耗和生成XMLType数据行。 这样的基于路径的行源可以被修改为使用谓词条件来过滤其生成的行,使得仅需要进一步处理满足谓词条件的行。 引入基于路径的行源中的小缓存结构可用于优化谓词行的评估。 一旦填充行数据,缓存结构可能被重组,以优化谓词评估的性能。

    Efficient Way To Evaluate Uncorrelated Path-Based Row Sources With XML Storage
    10.
    发明申请
    Efficient Way To Evaluate Uncorrelated Path-Based Row Sources With XML Storage 有权
    使用XML存储评估不相关的基于路径的行源的有效方法

    公开(公告)号:US20100293199A1

    公开(公告)日:2010-11-18

    申请号:US12467984

    申请日:2009-05-18

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30932

    摘要: The approaches described herein provide an efficient way to process certain kinds of queries that retrieve XML data stored in an object-relational database. A technique determines whether a query comprises a plurality of iteration expressions that exhibit a particular relationship to one another, and if so, re-writes the query and produces an optimized query execution plan. The query execution plan specifies an XPath-based row source with caching enabled. A very small cache structure is used, and reference locators are stored in the cache that point into binary-encoded data rather than copying XMLType data into the cache. Row data may be cached on the first use of the path-based row source and re-used in subsequent requests for rows. Once there is a subsequent request for rows from the optimized path-based row source, the cache may be reorganized to efficiently produce the rows of the row source.

    摘要翻译: 本文描述的方法提供了处理检索存储在对象关系数据库中的XML数据的某些类型的查询的有效方式。 技术确定查询是否包括彼此具有特定关系的多个迭代表达式,如果是,则重写该查询并产生优化的查询执行计划。 查询执行计划指定启用缓存的基于XPath的行源。 使用非常小的缓存结构,参考定位器存储在缓存中,指向二进制编码数据,而不是将XMLType数据复制到缓存中。 行数据可以在首次使用基于路径的行源缓存,并在后续的行请求中重新使用。 一旦从优化的基于路径的行源中获得行的后续请求,则可以重新组织高速缓存以有效地产生行源的行。