Flexible storage of XML collections within an object-relational database
    42.
    发明授权
    Flexible storage of XML collections within an object-relational database 有权
    将XML集合灵活存储在对象关系数据库中

    公开(公告)号:US09367642B2

    公开(公告)日:2016-06-14

    申请号:US11246039

    申请日:2005-10-07

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30923 G06F7/00

    摘要: A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.

    摘要翻译: 数据库服务器根据粒度级别确定使用什么形式的VARRAY存储来映射由XML模式定义的元素集合。 集合元素可以被映射到串联的VARRAY或者行外的VARRAY。 确定可以基于各种因素,包括映射到集合元素的数据库类型,限制某些数据库类型的表单存储的数据库限制,以及嵌入在指定数据库类型的XML模式中的注释(“映射注释”) 用于收集元素或VARRAY存储的形式的数据库表示。

    Mechanism for efficiently evaluating operator trees
    43.
    发明授权
    Mechanism for efficiently evaluating operator trees 有权
    有效评估操作树的机制

    公开(公告)号:US07603347B2

    公开(公告)日:2009-10-13

    申请号:US10944171

    申请日:2004-09-16

    IPC分类号: G06F17/30

    摘要: An XPath expression is converted into a tree-based representation where each node represents an operation to be performed and the links between nodes in the tree represent the flow of data between operations. The conversion may involve creating a parse tree for the XPath expression, and then converting the parse tree into an operator tree. The operator tree is constructed in such a way that execution of the XPath expression begins at the leaf nodes of the operator tree, and the results are then passed up the tree. After each node is executed, the results are either (1) passed to a filter that filters the results with a predicate statement or (2) passed to another node to be operated upon. This occurs until no nodes remain to be executed.

    摘要翻译: XPath表达式被转换为基于树的表示,其中每个节点表示要执行的操作,并且树中的节点之间的链接表示操作之间的数据流。 转换可能涉及为XPath表达式创建解析树,然后将解析树转换为运算符树。 运算符树的构造方式是在运算符树的叶节点处开始执行XPath表达式,然后将结果传递给树。 在执行每个节点后,结果将被传递给过滤器的过滤器,该过滤器使用谓词语句或(2)传递给另一个要运行的节点的结果。 直到没有节点保持执行才发生。

    Incremental maintenance of an XML index on binary XML data
    46.
    发明申请
    Incremental maintenance of an XML index on binary XML data 有权
    对二进制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索引是路径子集化时产生的其他问题。

    Efficient partitioning technique while managing large XML documents
    47.
    发明申请
    Efficient partitioning technique while managing large XML documents 有权
    管理大型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文档存储在分区中。

    Flexible handling of datetime XML datatype in a database system
    49.
    发明申请
    Flexible handling of datetime XML datatype in a database system 有权
    在数据库系统中灵活处理datetime XML数据类型

    公开(公告)号:US20070038649A1

    公开(公告)日:2007-02-15

    申请号:US11202463

    申请日:2005-08-11

    IPC分类号: G06F7/00

    摘要: A database server registers an XML schema and determines a database representation for the XML schema and mapping information, determining what database types should be used to represent an XML schema and/or how instances of the XML schema are stored by a database system. The mapping information indicates the mapping between the constructs declared in the XML schema and the constructs included in the appropriate database representation. The XML schema may contain annotations that describe one or more properties of a database representation of an XML date-time type. Based on the annotations, the database determines an appropriate database representation and generates mapping information mapping the declaration of the XML date-time type of the XML schema to the constructs of the database representation.

    摘要翻译: 数据库服务器注册XML模式并确定XML模式和映射信息的数据库表示,确定应使用什么数据库类型来表示XML模式和/或数据库系统如何存储XML模式的实例。 映射信息指示在XML模式中声明的结构与包含在适当的数据库表示中的构造之间的映射。 XML模式可能包含描述XML日期时间类型的数据库表示形式的一个或多个属性的注释。 基于注释,数据库确定适当的数据库表示,并生成映射信息,将XML模式的XML日期时间类型的声明映射到数据库表示的构造。

    Loadable units for lazy manifestation of XML documents
    50.
    发明授权
    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文档中的一个或多个节点的集合,其中当需要在集合中显示节点时,可显示可加载单元中的其他节点。 可加载单元可以但不一定与存储节点的内容结构相关联。 可装载单元可以是其行为中包含内容的节点。