-
公开(公告)号：US08090731B2
公开(公告)日：2012-01-03
申请号：US12180760
申请日：2008-07-28
申请人： Balasubramanyam Sthanikam , Sivasankaran Chandrasekar , Nipun Agarwal , Sam Idicula , Vijay Medi
发明人： Balasubramanyam Sthanikam , Sivasankaran Chandrasekar , Nipun Agarwal , Sam Idicula , Vijay Medi
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文档以二进制格式存储可能如此指示。
-
2.发明申请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作为视图的一部分，但不需要特定的查询 。
-
3.发明授权Cache-based predicate handling for queries on XML data using uncorrelated path-based row sources 有权基于缓存的谓词处理，使用不相关的基于路径的行源查询XML数据公开(公告)号：US08745031B2
公开(公告)日：2014-06-03
申请号：US12474124
申请日：2009-05-28
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数据行。 这样的基于路径的行源可以被修改为使用谓词条件来过滤其生成的行，使得仅需要进一步处理满足谓词条件的行。 引入基于路径的行源中的小缓存结构可用于优化谓词行的评估。 一旦填充行数据，缓存结构可能被重组，以优化谓词评估的性能。
-
4.发明授权Mechanism for deferred rewrite of multiple XPath evaluations over binary XML 有权对二进制XML进行多个XPath评估的延迟重写的机制公开(公告)号：US08073843B2
公开(公告)日：2011-12-06
申请号：US12181725
申请日：2008-07-29
IPC分类号： G06F7/00
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. A determination is made about 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作为视图的一部分，但不需要特定的查询 。
-
5.发明申请Cache-Based Predicate Handling For Queries On XML Data Using Uncorrelated Path-Based Row Sources 有权基于缓存的谓词处理使用不相关的基于路径的行源的XML数据查询公开(公告)号：US20100306219A1
公开(公告)日：2010-12-02
申请号：US12474124
申请日：2009-05-28
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数据行。 这样的基于路径的行源可以被修改为使用谓词条件来过滤其生成的行，使得仅需要进一步处理满足谓词条件的行。 引入基于路径的行源中的小缓存结构可用于优化谓词行的评估。 一旦填充行数据，缓存结构可能被重组，以优化谓词评估的性能。
-
公开(公告)号：US20090112902A1
公开(公告)日：2009-04-30
申请号：US12180760
申请日：2008-07-28
申请人： Balasubramanyam Sthanikam , Sivasankaran Chandrasekar , Nipun Agarwal , Sam Idicula , Vijay Medi
发明人： Balasubramanyam Sthanikam , Sivasankaran Chandrasekar , Nipun Agarwal , Sam Idicula , Vijay Medi
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文档以二进制格式存储可以这样表示。
-
公开(公告)号：US20080098020A1
公开(公告)日：2008-04-24
申请号：US11715603
申请日：2007-03-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30911 , G06F17/30569
摘要： Techniques are provided for incrementally maintaining an XML index built to access XML data that is encoded in binary XML form. Rather than delete and reinsert index entries of all the nodes of a modified XML document, only the index entries of the affected nodes are modified. Consequently, the order key values stored in the index may become inconsistent with the current hierarchical locations of the nodes to which the order key values correspond. Techniques are described for resolving the inconsistencies, and for addressing additional problems that result when the XML index is path-subsetted.
摘要翻译： 提供了用于增量维护构建以访问以二进制XML形式编码的XML数据的XML索引的技术。 修改的XML文档的所有节点的删除和重新插入索引条目，而不是修改受影响的节点的索引条目。 因此，存储在索引中的订单键值可能与订单键值对应的节点的当前分层位置变得不一致。 描述了解决不一致的技术，以及解决当XML索引是路径子集化时产生的其他问题。
-
公开(公告)号：US20080091714A1
公开(公告)日：2008-04-17
申请号：US11716074
申请日：2007-03-08
IPC分类号： G06F17/00
CPC分类号： G06F17/30923
摘要： A method is provided to efficiently evaluate an expression to determine the partition key for an XML document stored in a database without the entire XML document first being stored in temporary memory storage. The partition key is determined using streaming evaluation or incrementally using a DOM node tree as a portion of the document is read and stored in the buffer. The XML document is stored in the partition using the read portion of the document stored in the buffer and the remaining portion from the original source.
摘要翻译： 提供了一种方法来有效地评估表达式以确定存储在数据库中的XML文档的分区密钥，而不将整个XML文档首先存储在临时存储器存储器中。 当文档的一部分被读取并存储在缓冲器中时，使用流式评估或递增地使用DOM节点树来确定分区密钥。 使用存储在缓冲区中的文档的读取部分和原始源的剩余部分将XML文档存储在分区中。
-
公开(公告)号：US20050050105A1
公开(公告)日：2005-03-03
申请号：US10648749
申请日：2003-08-25
CPC分类号： G06F17/30297 , G06F17/30908
摘要： A method and system for the in-place evolution of XML schemas is disclosed. To automatically evolve an existing XML schema, a schema evolver receives both an existing XML schema and an XML document as input. The XML document indicates changes to be made to the existing XML schema. Based on the existing XML schema and the XML document, the schema evolver evolves the existing XML schema into a new XML schema that incorporates the changes indicated in the XML document. According to one aspect, the schema evolver generates one or more SQL statements based on the new XML schema. The SQL statements, when executed by a database server, cause the database server to evolve database structures that were based on the formerly existing XML schema so that the database structures conform to the new XML schema. This is accomplished “in place,” without copying the data in the database structures.
摘要翻译： 公开了一种用于XML模式的就地演化的方法和系统。 为了自动演进现有的XML模式，模式演进器接收现有的XML模式和XML文档作为输入。 XML文档指示对现有XML模式进行的更改。 基于现有的XML架构和XML文档，架构演进者将现有的XML架构演变为新的XML架构，其中包含XML文档中指示的更改。 根据一个方面，模式演进者基于新的XML模式生成一个或多个SQL语句。 SQL语句在由数据库服务器执行时，会导致数据库服务器发展基于以前存在的XML模式的数据库结构，以便数据库结构符合新的XML模式。 这完成了“到位”，而不复制数据库结构中的数据。
-
10.发明申请公开(公告)号：US20120066271A1
公开(公告)日：2012-03-15
申请号：US13301690
申请日：2011-11-21
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , G06F17/30451 , Y10S707/99945
摘要： A modular repository is described, where operational features may be implemented without the need to scan every resource included in the modular repository. A modular repository includes a dedicated set of database objects containing all information needed to access the resources in the repository. For example, the database objects of a modular repository may include those user identifier mappings and ACL mappings, etc., to which metadata in the modular repository refers. A database system may also include a mechanism through which a modular repository may be mounted under a subdirectory of a common directory in the database system. The resources of a modular repository that are mounted under the common directory may be accessed through the common directory. Further, a client may query the resources of any modular repository mounted under the common directory by making the federated repository, represented by the common directory, the context of the query.
摘要翻译： 描述了模块化存储库，其中可以实现操作特征，而不需要扫描模块化存储库中包括的每个资源。 模块化存储库包括一组专用的数据库对象，其中包含访问存储库中资源所需的所有信息。 例如，模块化存储库的数据库对象可以包括模块化存储库中的元数据引用的那些用户标识符映射和ACL映射等。 数据库系统还可以包括机构，模块化存储库可以通过该机制安装在数据库系统中的公用目录的子目录下。 安装在公共目录下的模块化存储库的资源可以通过公共目录访问。 此外，客户端可以通过使由共同目录表示的联合存储库，查询的上下文来查询安装在公用目录下的任何模块化存储库的资源。
-
-
-
-
-
-
-
-
-
搜索结果
115 条记录 (耗时 0.024 秒)
