Document level indexes for efficient processing in multiple tiers of a computer system
    41.
    发明申请
    Document level indexes for efficient processing in multiple tiers of a computer system 有权
    用于计算机系统多层次高效处理的文档级索引

    公开(公告)号:US20070016604A1

    公开(公告)日:2007-01-18

    申请号:US11184301

    申请日:2005-07-18

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30911

    摘要: To improve performance of performing XML operations on an XML document in by a client tier, the client generates an index that indexes the nodes of an XML document. The index may be generated, for example, by and during parsing of the XML document. The index contains similar structures to those maintained by a database server to perform XML operations on collections of XML documents. In lieu of parsing XML document to generate an index, the client may generate indexes based on data retrieved from the indexes at the database server.

    摘要翻译: 为了提高在客户端层对XML文档执行XML操作的性能,客户机生成一个索引,以索引XML文档的节点。 索引可以例如由XML文档解析期间和解析时生成。 该索引包含与由数据库服务器维护的对XML文档集合执行XML操作的类似结构。 代替解析XML文档来生成索引,客户端可以基于从数据库服务器上的索引检索的数据生成索引。

    Techniques for managing hierarchical data with link attributes in a relational database
    43.
    发明授权
    Techniques for managing hierarchical data with link attributes in a relational database 有权
    用于使用关系数据库中的链接属性来管理分层数据的技术

    公开(公告)号:US06965903B1

    公开(公告)日:2005-11-15

    申请号:US10306485

    申请日:2002-11-26

    IPC分类号: G06F17/30

    摘要: Techniques for managing hierarchical data include managing a link table in a relational database. The hierarchical data includes data about a hierarchy of nodes related by multiple links. The link table includes first information, second information and link information, for each link. First information indicates a first node in the hierarchical data. Second information indicates a second node that is associated with the first node by the link. Link information indicates values for link attributes of the link between the first node and the second node, and does not indicate a value for any attribute of the first node alone or any attribute of the second node alone. The techniques support directing a single SQL statement to a path database object, constructed based on the link table, in order to obtain paths that satisfy a search on link attributes.

    摘要翻译: 用于管理分级数据的技术包括管理关系数据库中的链接表。 层次数据包括关于多个链路相关节点的层次结构的数据。 链路表包括每个链路的第一信息,第二信息和链路信息。 第一信息表示层次数据中的第一节点。 第二信息指示通过链路与第一节点相关联的第二节点。 链接信息指示第一节点和第二节点之间的链接的链接属性的值,并且不指示单独的第一节点的任何属性或仅第二节点的任何属性的值。 这些技术支持将单个SQL语句定向到基于链接表构建的路径数据库对象,以便获得满足链接属性搜索的路径。

    Cost-based optimizer for an XML data repository within a database
    44.
    发明申请
    Cost-based optimizer for an XML data repository within a database 有权
    数据库中XML数据存储库的基于成本的优化器

    公开(公告)号:US20050240624A1

    公开(公告)日:2005-10-27

    申请号:US10830211

    申请日:2004-04-21

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30935

    摘要: Cost-based optimizer functionality for an XML database repository provides means for optimizing the execution of database queries that access XML resources in the database repository. Statistics about XML resources that are stored in the database repository are gathered, stored and utilized by a query optimizer to compute computational costs associated with each of multiple methods of accessing particular XML resources requested in a database query. Hence, the optimizer is able to select the most efficient query execution plan based on the costs of possible access paths. In one embodiment, specific statistics about the hierarchical structure of XML resources stored in the XML database repository are gathered, stored in a relational table in the database management system, and used to compute the selectivity of query predicates and the index cost associated with traversing one or more indexes to access requested XML resources.

    摘要翻译: 用于XML数据库的基于成本的优化器功能提供了优化访问数据库存储库中的XML资源的数据库查询的执行的方法。 存储在数据库存储库中的关于XML资源的统计信息由查询优化器收集,存储和利用,以计算与访问数据库查询中请求的特定XML资源的多种方法中的每一种相关联的计算成本。 因此,优化器能够基于可能的访问路径的成本来选择最有效的查询执行计划。 在一个实施例中,收集存储在XML数据库存储库中的XML资源的层次结构的具体统计信息,存储在数据库管理系统中的关系表中,并用于计算查询谓词的选择性和与遍历一个相关联的索引成本 或更多的索引来访问所请求的XML资源。

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

    公开(公告)号:US07406478B2

    公开(公告)日:2008-07-29

    申请号:US11202463

    申请日:2005-08-11

    IPC分类号: G06F17/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日期时间类型的声明映射到数据库表示的构造。

    Techniques for scalably accessing data in an arbitrarily large document by a device with limited resources
    49.
    发明授权
    Techniques for scalably accessing data in an arbitrarily large document by a device with limited resources 有权
    用于通过有限资源的设备可扩展访问任意大文档中的数据的技术

    公开(公告)号:US07308474B2

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

    申请号:US10306130

    申请日:2002-11-26

    IPC分类号: G06F15/16

    CPC分类号: G06F12/126 G06F17/30917

    摘要: Techniques for accessing data that resides in a document on a computer-readable medium by a device with device resources of limited resource amount include determining usage for each portion of the document that consumes the device resources of a plurality of portions of the document. Each portion may be accessed independently of a different portion of the document. Based on the usage, a particular portion of the document is selected to cease consuming the device resources. The device resources consumed by the particular portion are released. The techniques allow a document-processing device with limited resources to scale up to process a large document that would otherwise exceed the available resources. This capability is an advantage when first inserting a large XML document, which cannot be fully manifested in available memory, as multiple loadable units into a database or other persistent store.

    摘要翻译: 用于通过具有有限资源量的设备资源的设备访问驻留在计算机可读介质上的文档中的数据的技术包括确定消耗文档的多个部分的设备资源的文档的每个部分的使用。 可以独立于文档的不同部分访问每个部分。 基于使用,选择文档的特定部分以停止消耗设备资源。 特定部分消耗的设备资源被释放。 这些技术允许具有有限资源的文档处理设备扩展以处理否则将超过可用资源的大文档。 当将多个可加载单元插入到数据库或其他持久存储中时,首次插入不能充分显示在可用内存中的大型XML文档时,此功能是一个优点。