Rescheduling transactions in a database system
    12.
    发明授权
    Rescheduling transactions in a database system 有权
    在数据库系统中重新安排事务

    公开(公告)号:US06990503B1

    公开(公告)日:2006-01-24

    申请号:US10121190

    申请日:2002-04-12

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30362 G06F17/30371

    摘要: A database system includes a transaction rescheduling mechanism that reorders pending transactions based on whether one or more of the pending transactions conflict with any transactions that have been scheduled for execution. In one arrangement, the received pending transactions are stored in a first queue. The transactions that are scheduled for execution are stored in a second queue. The transactions are moved from the first queue to the second queue based on the reordering by the transaction rescheduling mechanism.

    摘要翻译: 数据库系统包括事务重新调度机制,其基于一个或多个待处理事务与已被调度执行的任何事务冲突来重新排列等待的事务。 在一种安排中,接收到的待处理事务被存储在第一队列中。 计划执行的事务存储在第二个队列中。 基于事务重新调度机制的重新排序,事务从第一个队列移动到第二个队列。

    Providing a progress indicator in a database system
    13.
    发明授权
    Providing a progress indicator in a database system 有权
    在数据库系统中提供进度指示器

    公开(公告)号:US08255388B1

    公开(公告)日:2012-08-28

    申请号:US10837414

    申请日:2004-04-30

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30306 G06F17/30463

    摘要: A database system is capable of processing a query and providing a progress indicator of the processing of the query based on at least a first cost factor. Initially, an estimate is set for the first cost factor. During processing of the query, the estimate of the first cost factor is updated to enable refinement of the progress indicator.

    摘要翻译: 数据库系统能够基于至少第一成本因素来处理查询并提供对查询的处理的进度指示符。 最初,为第一个成本因子设置了一个估计。 在处理查询期间,更新第一个成本因子的估计,以便对进度指标进行细化。

    Auxiliary relation for materialized view
    14.
    发明授权
    Auxiliary relation for materialized view 有权
    物化视图的辅助关系

    公开(公告)号:US07092951B1

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

    申请号:US09900280

    申请日:2001-07-06

    IPC分类号: G06F17/30

    摘要: Auxiliary relations are used to maintain a materialized view. The materialized view comprises results of some operation performed between two or more base relations of a parallel database management system comprising a plurality of nodes. The two or more base relations are distributed to the nodes according to some partitioning strategy. Each auxiliary relation is partitioned according to the join attribute in the materialized view definition. During join or other operations involving the relations, the auxiliary relations, not the base relations, are used to construct join results and to maintain the materialized view.

    摘要翻译: 辅助关系用于维护物化视图。 物化视图包括在包括多个节点的并行数据库管理系统的两个或多个基本关系之间执行的一些操作的结果。 根据一些划分策略,将两个或多个基本关系分配给节点。 每个辅助关系根据物化视图定义中的连接属性进行分区。 在涉及关系的连接或其他操作过程中,辅助关系而不是基础关系被用于构建连接结果并维护物化视图。

    Locking mechanism using predefined locks for aggregate materialized views in a database system
    15.
    发明授权
    Locking mechanism using predefined locks for aggregate materialized views in a database system 有权
    在数据库系统中使用预定义的锁集合物化视图的锁定机制

    公开(公告)号:US07181452B1

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

    申请号:US10324456

    申请日:2002-12-20

    IPC分类号: G06F17/30

    摘要: A database system includes a locking mechanism for an aggregate materialized view defined on base relations. In response to updates of a base relation, predefined locks are placed on the aggregate materialized view. With locking mechanisms, transaction concurrency is enhanced by enabling concurrent updates of the materialized view by plural transactions in certain cases, while avoiding the situation in which multiple tuples belonging to the same group are integrated as separate tuples into the aggregate materialized view.

    摘要翻译: 数据库系统包括用于在基础关系上定义的聚合物化视图的锁定机制。 响应于基础关系的更新,预定义的锁定放置在聚合物化视图上。 通过锁定机制,通过在某些情况下允许通过多个事务并行更新物化视图来提高事务并发性,同时避免属于同一组的多个元组作为单独的元组集成到聚合物化视图中的情况。

    Grouping database queries and/or transactions
    16.
    发明授权
    Grouping database queries and/or transactions 有权
    分组数据库查询和/或事务

    公开(公告)号:US07814080B1

    公开(公告)日:2010-10-12

    申请号:US10694564

    申请日:2003-10-27

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

    CPC分类号: G06F17/30474 G06F17/30463

    摘要: A method and apparatus identifies SQL statements in a first transaction that specify modification operations that are commutative and associative. The SQL statements are combined into one SQL statement, and the one SQL statement is submitted to a database system. Optionally, or alternatively, multiple transactions can be grouped together into one transaction.

    摘要翻译: 一种方法和装置识别第一个事务中指定可交换和关联的修改操作的SQL语句。 SQL语句组合成一个SQL语句,并将一个SQL语句提交到数据库系统。 可选地,或者替代地,多个事务可以一起分组成一个事务。

    PCI and PCI express virtual hot plug systems and methods
    17.
    发明授权
    PCI and PCI express virtual hot plug systems and methods 有权
    PCI和PCI Express虚拟热插拔系统和方法

    公开(公告)号:US09262363B2

    公开(公告)日:2016-02-16

    申请号:US13690018

    申请日:2012-11-30

    IPC分类号: G06F13/00 G06F13/40

    CPC分类号: G06F13/4081

    摘要: Virtual hot plug systems and methods are described for Peripheral Component Interconnect (PCI), PCI Express (PCIe), and variants thereof. Specifically, the virtual hot plug systems and methods enable PCI related devices to support a hot plug configuration with such devices lacking hot plug controller hardware. The virtual hot plug systems and methods include intelligent polling logic for discovering the new PCI/PCIe devices with proper logic to access the hardware and avoid hanging or locking up the operating system.

    摘要翻译: 对于外围组件互连(PCI),PCI Express(PCIe)及其变体描述了虚拟热插拔系统和方法。 具体来说,虚拟热插拔系统和方法使PCI相关设备支持热插拔配置,而这些设备缺少热插拔控制器硬件。 虚拟热插拔系统和方法包括智能轮询逻辑,用于发现具有适当逻辑的新PCI / PCIe设备来访问硬件,并避免挂起或锁定操作系统。

    AUTOMATED SOCIAL NETWORKING GRAPH MINING AND VISUALIZATION
    18.
    发明申请
    AUTOMATED SOCIAL NETWORKING GRAPH MINING AND VISUALIZATION 有权
    自动化社会网络采矿与可视化

    公开(公告)号:US20110283205A1

    公开(公告)日:2011-11-17

    申请号:US12780522

    申请日:2010-05-14

    IPC分类号: G06F3/048 G06F17/30 G06F15/16

    CPC分类号: G06F17/30867

    摘要: The automated social networking graph mining and visualization technique described herein mines social connections and allows creation of a social networking graph from general (not necessarily social-application specific) Web pages. The technique uses the distances between a person's/entity's name and related people's/entities names on one or more Web pages to determine connections between people/entities and the strengths of the connections. In one embodiment, the technique lays out these connections, and then clusters them, in a 2-D layout of a social networking graph that represents the Web connection strengths among the related people's or entities' names, by using a force-directed model.

    摘要翻译: 本文描述的自动化社交网络图挖掘和可视化技术挖掘社会关系,并允许从通用(不一定是社交应用专用)网页创建社交网络图。 该技术使用个人/实体的名称与一个或多个网页上的相关人员/实体名称之间的距离来确定人员/实体之间的连接以及连接的优势。 在一个实施例中,该技术设置了这些连接,然后通过使用力导向模型将它们聚类在代表相关人或实体名称中的Web连接强度的社交网络图的二维布局中。