Flexible handling of datetime XML datatype in a database system
    13.
    发明申请
    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
    14.
    发明授权
    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文档中的一个或多个节点的集合,其中当需要在集合中显示节点时,可显示可加载单元中的其他节点。 可加载单元可以但不一定与存储节点的内容结构相关联。 可装载单元可以是其行为中包含内容的节点。

    Query modes for translation-enabled XML documents
    16.
    发明授权
    Query modes for translation-enabled XML documents 有权
    支持翻译的XML文档的查询模式

    公开(公告)号:US08078611B2

    公开(公告)日:2011-12-13

    申请号:US11648950

    申请日:2007-01-03

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30938 G06F17/30932

    摘要: Systems, methods, and other embodiments associated with providing query modes for translation-enabled XML documents are described. One method embodiment includes receiving an XPath query to an XML document that may store a translation for a data element. The method embodiment may also include automatically selecting a query mode for the XPath query. The method embodiment may also include querying the XML document using the XPath query and the selected query mode. The query mode may control, at least in part, the operation of an XML database logic.

    摘要翻译: 描述了与为支持翻译的XML文档提供查询模式相关联的系统,方法和其他实施例。 一种方法实施例包括:向可能存储数据元素的翻译的XML文档接收XPath查询。 方法实施例还可以包括自动选择XPath查询的查询模式。 方法实施例还可以包括使用XPath查询和所选择的查询模式查询XML文档。 至少部分地,查询模式可以控制XML数据库逻辑的操作。

    Method and mechanism for loading XML documents into memory
    18.
    发明授权
    Method and mechanism for loading XML documents into memory 有权
    将XML文档加载到内存中的方法和机制

    公开(公告)号:US07933928B2

    公开(公告)日:2011-04-26

    申请号:US11317101

    申请日:2005-12-22

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

    CPC分类号: G06F17/2247 G06F17/30908

    摘要: A method and apparatus for loading an XML document into memory is provided. A client loads one or more array elements into a first partition of an array that is maintained in memory. Each array element represents an XML element of an XML document. Upon determining that an amount of data maintained in the first partition exceeds a first threshold, the client subsequently loads array elements into a new partition of the array. Upon determining that an amount of data maintained in the memory of the client exceeds a second threshold, the array elements of the least recently used partition are persistently stored in a database without persistently storing the entire XML document. When the last XML element of the XML document is loaded into a partition of the array, that partition is persistently stored in the database, thereby causing the entire XML document to be stored in the database.

    摘要翻译: 提供了一种将XML文档加载到存储器中的方法和装置。 客户端将一个或多个数组元素加载到内存中维护的数组的第一个分区中。 每个数组元素表示XML文档的XML元素。 在确定在第一分区中维护的数据量超过第一阈值时,客户端随后将数组元素加载到阵列的新分区中。 在确定在客户端的存储器中维护的数据量超过第二阈值时,最近最少使用的分区的数组元素被持久地存储在数据库中,而不会持续存储整个XML文档。 当XML文档的最后一个XML元素加载到数组的分区中时,该分区将永久存储在数据库中,从而使整个XML文档存储在数据库中。

    Using sibling-count in XML indexes to optimize single-path queries
    19.
    发明授权
    Using sibling-count in XML indexes to optimize single-path queries 有权
    在XML索引中使用sibling-count来优化单路径查询

    公开(公告)号:US07840609B2

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

    申请号:US11888415

    申请日:2007-07-31

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30935 G06F17/30442

    摘要: A method and apparatus are provided for using sibling-counts in XML indices to optimize single-path queries. Using a b-tree XML index with a SQL query logarithmically reduces the number of disk accesses by passing over index entries where it is determined that a match will not be found. However, because certain index entries are passed over, it is impossible to ascertain if a path expression occurs more than once in the XML index, as certain queries sometimes require. This hurdle can be overcome by maintaining a sibling count with each node entry in the XML index. Because the sibling count is stored with the index entry, the index will reveal whether the matching node is single or has other siblings. In additional to re-writing the original query for optimization by use of an XML index, it will be re-written to check for a single-path condition in the index.

    摘要翻译: 提供了一种方法和装置,用于在XML索引中使用同级计数来优化单路径查询。 在SQL查询中使用b-tree XML索引对数地减少了通过传递索引条目的磁盘访问次数,确定不会找到匹配项。 但是,由于某些索引条目被传递,因此某些查询有时需要,无法确定路径表达式是否在XML索引中多次出现。 通过维护XML索引中每个节点条目的兄弟数量,可以克服这个障碍。 由于兄弟计数与索引条目一起存储,索引将显示匹配节点是单个节点还是具有其他兄弟节点。 除了通过使用XML索引重新编写原始查询进行优化外,还将重新编写索引中的单路径条件。