Mechanism for improving performance on XML over XML data using path subsetting
    24.
    发明授权
    Mechanism for improving performance on XML over XML data using path subsetting 有权
    使用路径子集提高XML数据的性能的机制

    公开(公告)号:US07885980B2

    公开(公告)日:2011-02-08

    申请号:US11401613

    申请日:2006-04-10

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30938 G06F17/30321

    摘要: Techniques are provided for indexing XML documents using path subsetting. According to one embodiment, a PATH table created for storing one row for each indexed node of the XML documents using user-defined criteria. The user-defined criteria are used to determine which nodes of XML documents to included in The PATH TABLE. The PATH table row for a node includes (1) information for locating the XML document that contains the node, (2) information that identifies the path of the node, and (3) information that identifies the position of the node within the hierarchical structure of the XML document that contains the node. Use of the user defined criteria is transparent to any query improves DML indexes overhead costs.

    摘要翻译: 提供了使用路径子集对XML文档进行索引的技术。 根据一个实施例,创建用于使用用户定义的标准为XML文档的每个索引节点存储一行的PATH表。 用户定义的标准用于确定要包含在PATH TABLE中的XML文档的哪些节点。 节点的PATH表行包括(1)用于定位包含节点的XML文档的信息,(2)标识节点路径的信息,以及(3)标识分层结构中节点位置的信息 的包含节点的XML文档。 使用用户定义的条件对任何查询都是透明的,改善了DML索引的开销成本。

    Technique For Using Occurrence Constraints To Optimize XML Index Access
    25.
    发明申请
    Technique For Using Occurrence Constraints To Optimize XML Index Access 审中-公开
    使用发生约束优化XML索引访问的技术

    公开(公告)号:US20100030727A1

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

    申请号:US12181745

    申请日:2008-07-29

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F16/81 G06F16/8365

    摘要: Approaches are provided for improving the performance of certain database queries that operate on binary-encoded XML. In particular, the approach uses occurrence and type constraint information about XML data stored in the database for optimizing the relational rewrite of a query. Constraint information can be obtained in several different ways including through a formal language specification such as an XML Schema or DTD, through discovery of a user-provided secondary index on a an XML path table, or through a structural summary that is derived from statistical analysis on a set of XML documents stored in the database.

    摘要翻译: 提供了一些方法来提高对二进制编码的XML进行操作的某些数据库查询的性能。 特别地,该方法使用关于存储在数据库中的XML数据的出现和类型约束信息来优化查询的关系重写。 约束信息可以通过几种不同的方式获得,包括通过诸如XML模式或DTD的形式语言规范,通过在XML路径表上发现用户提供的辅助索引,或通过从统计分析得出的结构性摘要来获得约束信息 在一组存储在数据库中的XML文档中。

    Loadable units for lazy manifestation of XML documents
    26.
    发明授权
    Loadable units for lazy manifestation of XML documents 有权
    用于懒惰表现XML文档的可加载单元

    公开(公告)号:US07092967B1

    公开(公告)日:2006-08-15

    申请号:US10256777

    申请日:2002-09-27

    IPC分类号: G06F17/30

    摘要: Described herein is a system for “lazy” manifestation of XML documents. In lazy manifestation, only portions of an XML document that contain data of interest (e.g., a particular element or attribute requested by an application) are manifested. The term “manifesting a portion of an XML document” refers to creating an in-memory representation of the portion and incorporating it into existing in-memory representation of an XML document, if any. These portions are referred to herein as a loadable unit. A loadable unit is a set of one or more nodes in an XML document, where when there is need to manifest a node in the set, other nodes in the loadable unit are manifested too. Loadable units may, but not necessarily, correlate to content structures that store the nodes. A loadable unit may be the nodes whose content is contained in a row.

    摘要翻译: 这里描述了一种用于“懒惰”显示XML文档的系统。 在懒惰表现中,仅显示包含感兴趣的数据的XML文档的部分(例如,应用所请求的特定元素或属性)。 术语“呈现XML文档的一部分”是指创建该部分的内存中表示,并将其并入XML文档的现有内存中表示(如果有的话)。 这些部分在这里被称为可装载单元。 可加载单元是XML文档中的一个或多个节点的集合,其中当需要在集合中显示节点时,可显示可加载单元中的其他节点。 可加载单元可以但不一定与存储节点的内容结构相关联。 可装载单元可以是其行为中包含内容的节点。

    Isolation for applications working on shared XML data
    27.
    发明授权
    Isolation for applications working on shared XML data 有权
    用于共享XML数据的应用程序的隔离

    公开(公告)号:US08510292B2

    公开(公告)日:2013-08-13

    申请号:US11442106

    申请日:2006-05-25

    IPC分类号: G06F7/00 G06F17/30

    摘要: A mechanism is provided for detecting and disregarding application specific nodes contained in shared XML documents. The techniques described involve determining one or more application specific nodes within XML documents and performing path expression evaluations of the XML documents as if the nodes are not present. In one embodiment, a mechanism is provided by which a user may specify the criterion that determines which subset of nodes in XML documents are to be ignored from path expression evaluations. A query that specifies a path operation based on a path is evaluated ignoring said identified nodes when evaluating said path operation.

    摘要翻译: 提供了一种用于检测和忽略包含在共享XML文档中的应用程序特定节点的机制。 所描述的技术涉及确定XML文档内的一个或多个应用特定节点,并且如同节点不存在一样执行XML文档的路径表达式评估。 在一个实施例中,提供了一种机制,用户可以通过该机制指定确定XML文档中的节点的哪个子集将被从路径表达式评估中被忽略的标准。 在评估所述路径操作时,忽略指定基于路径的路径操作的查询,忽略所述标识的节点。

    Global query normalization to improve XML index based rewrites for path subsetted index
    28.
    发明授权
    Global query normalization to improve XML index based rewrites for path subsetted index 有权
    全局查询规范化,以改进路径子集索引的基于XML索引的重写

    公开(公告)号:US07991768B2

    公开(公告)日:2011-08-02

    申请号:US11937268

    申请日:2007-11-08

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30911 G06F17/30935

    摘要: Techniques for processing a query that includes a path expression are provided. A query processor determines whether an XML index may be used to execute the query instead of having to scan multiple XML documents. The query is parsed and normalized, which results in multiple normalized path expressions that are based on the original path expression. If the XML index is a path-subsetted index, then the query processor generates annotated path expressions based on the normalized path expressions. The query processor determines whether each of the annotated path expressions is satisfiable by the path-subsetted XML index. If so, then the XML index is used to process the query.

    摘要翻译: 提供了处理包含路径表达式的查询的技术。 查询处理器确定是否可以使用XML索引来执行查询,而不必扫描多个XML文档。 查询被解析和归一化,这导致基于原始路径表达式的多个标准化路径表达式。 如果XML索引是路径子集索引,则查询处理器将根据归一化的路径表达式生成带注释的路径表达式。 查询处理器确定每个注释路径表达式是否由路径子集的XML索引满足。 如果是这样,则使用XML索引来处理查询。

    Accelerating value-based lookup of XML document in XQuery
    29.
    发明申请
    Accelerating value-based lookup of XML document in XQuery 有权
    在XQuery中加速基于价值的XML文档查找

    公开(公告)号:US20090019077A1

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

    申请号:US11827801

    申请日:2007-07-13

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30938

    摘要: A method and apparatus for accelerating value-based lookups of XML documents in XQuery is provided. XML indices can help to optimize SQL queries of XML documents stored in object-relational databases. Certain SQL/XML functions such as XMLTABLE( ) use XQuery expressions to query XML documents. Previously, such queries could not use the XML index because the PATH table of the XML index was not defined for XQuery semantics. Techniques described herein extend the XML index for use with queries that require evaluation of XQuery expressions. Consequently, techniques described herein accelerate value-based lookups of XML documents in XQuery by introducing the possibility of an index-assisted evaluation of XQuery expressions.

    摘要翻译: 提供了一种用于在XQuery中加速基于价值的XML文档查找的方法和装置。 XML索引可以帮助优化存储在对象关系数据库中的XML文档的SQL查询。 某些SQL / XML函数(如XMLTABLE())使用XQuery表达式来查询XML文档。 以前,这样的查询无法使用XML索引,因为XML索引的PATH表未针对XQuery语义进行定义。 本文中描述的技术扩展了XML索引,以便与需要评估XQuery表达式的查询一起使用。 因此,本文描述的技术通过引入XQuery表达式的索引辅助评估的可能性来加速XQuery中的XML文档的基于值的查找。

    Isolation for applications working on shared XML data
    30.
    发明申请
    Isolation for applications working on shared XML data 有权
    用于共享XML数据的应用程序的隔离

    公开(公告)号:US20070276792A1

    公开(公告)日:2007-11-29

    申请号:US11442106

    申请日:2006-05-25

    IPC分类号: G06F17/30 G06F7/00 G06F17/00

    摘要: A mechanism is provided for detecting and disregarding application specific nodes contained in shared XML documents. The techniques described involve determining one or more application specific nodes within XML documents and performing path expression evaluations of the XML documents as if the nodes are not present. In one embodiment, a mechanism is provided by which a user may specify the criterion that determine which subset of node in XML documents are to be ignored from path expression evaluations and evaluating a query that specifies a path operation based on a path and ignoring said identified nodes when evaluating said path operation.

    摘要翻译: 提供了一种用于检测和忽略包含在共享XML文档中的应用程序特定节点的机制。 所描述的技术涉及确定XML文档内的一个或多个应用特定节点,并且如同节点不存在一样执行XML文档的路径表达式评估。 在一个实施例中,提供了一种机制,用户可以通过该机制指定确定XML文档中的节点的哪个子集将被从路径表达式评估中忽略的标准,并且基于路径评估指定路径操作的查询,并忽略所述标识的 节点在评估所述路径操作时。