-
公开(公告)号：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.
摘要翻译： 数据库系统能够基于至少第一成本因素来处理查询并提供对查询的处理的进度指示符。 最初，为第一个成本因子设置了一个估计。 在处理查询期间，更新第一个成本因子的估计，以便对进度指标进行细化。
-
公开(公告)号：US07321898B1
公开(公告)日：2008-01-22
申请号：US10844680
申请日：2004-05-13
IPC分类号： G06F7/00
CPC分类号： G06F17/30457 , G06F17/30362 , G06F17/30383 , Y10S707/99943
摘要： A database system receives a transaction that causes a tuple to be integrated into a join view. In response to receiving the transaction, a predefined first lock is placed on at least a portion of the join view, the predefined first lock conflicting with either a shared lock or an exclusive lock placed on the join view, but not conflicting with another predefined first lock placed on the join view. Also, a latch or semaphore associated with a value of a predetermined attribute of the tuple is obtained before integrating the tuple into the join view.
摘要翻译： 数据库系统接收一个事务，导致元组被集成到连接视图中。 响应于接收到交易，预定义的第一锁定被放置在连接视图的至少一部分上，预定义的第一锁定与放置在连接视图上的共享锁或排他锁冲突，但不与另一预定义的第一锁相冲突 锁定放在连接视图上。 此外，在将元组集成到连接视图之前，获得与元组的预定属性的值相关联的锁存器或信号量。
-
公开(公告)号：US07155434B1
公开(公告)日：2006-12-26
申请号：US10117503
申请日：2002-04-04
CPC分类号： G06F17/30362 , G06F17/30383 , Y10S707/99938 , Y10S707/99939
摘要： A database system includes a locking mechanism for a materialized view defined on base relations. In response to updates of a base relation, a name lock is placed on the materialized view. The name lock is a type of exclusive lock and is associated with a data structure containing a first parameter to identify a base relation of the materialized view being updated, and a second parameter to indicate a number of transactions updating the base relation. With locking mechanisms according to some embodiments of the invention, transaction concurrency is enhanced by enabling concurrent updates of a materialized view by plural transactions in certain cases.
摘要翻译： 数据库系统包括用于在基础关系上定义的物化视图的锁定机制。 响应于基础关系的更新，物理视图上放置一个名称锁。 名称锁是一种排他锁，并且与包含用于标识被更新的物化视图的基本关系的第一参数的数据结构相关联，以及指示更新基础关系的事务数量的第二参数。 使用根据本发明的一些实施例的锁定机制，通过在某些情况下能够通过多个事务实现物化视图的并发更新来增强事务并发性。
-
4.发明授权Rescheduling of modification operations for loading data into a database system 有权重新安排将数据加载到数据库系统中的修改操作公开(公告)号：US08156110B1
公开(公告)日：2012-04-10
申请号：US10767681
申请日：2004-01-29
CPC分类号： G06F17/30345
摘要： A method or apparatus for use with a database system that stores a join view associated with plural base relations includes receiving modification operations to modify at least two of the base relations of the join view, and re-ordering the received modification operations to avoid concurrent execution of modification operations of more than one of at least two base relations.
摘要翻译： 一种与存储与多个基本关系相关联的联接视图的数据库系统一起使用的方法或装置包括接收修改操作以修改连接视图的基本关系中的至少两个，并重新排序接收到的修改操作以避免并发执行 至少两个基本关系中的一个以上的修改操作。
-
公开(公告)号：US07418706B1
公开(公告)日：2008-08-26
申请号：US10431751
申请日：2003-05-08
CPC分类号： G06F17/3046 , G06F17/30362 , G06F17/30371
摘要： A database system includes a rescheduler that performs rescheduling of transactions in a scheduling queue based on one or more criteria. One criterion is whether a first transaction in the queue can be performed as a synchronized scan of a table with a second transaction that is currently executing. This enables the first and second transactions to share a segment of a buffer storage pool.
摘要翻译： 数据库系统包括基于一个或多个标准执行调度队列中的事务的重新调度的重新调度器。 一个标准是队列中的第一个事务是否可以作为当前正在执行的第二个事务的表的同步扫描执行。 这使得第一和第二事务能够共享缓冲存储池的段。
-
公开(公告)号：US07174331B1
公开(公告)日：2007-02-06
申请号：US10349855
申请日：2003-01-23
CPC分类号： G06F17/30498 , G06F17/30362 , G06F17/30383 , Y10S707/99933 , Y10S707/99938 , Y10S707/99939
摘要： A database system includes a locking mechanism for a view defined on one or more base relations. A B-tree index is defined on the view. In response to updates of a base relation, predefined locks are placed on the view. With locking mechanisms according to some embodiments of the invention, concurrency of transactions that access the view and B-tree index is enhanced by enabling concurrent updates of the materialized view by plural transactions in certain cases, while avoiding read-write and write-read conflicts.
摘要翻译： 数据库系统包括用于在一个或多个基本关系上定义的视图的锁定机构。 视图中定义了B树索引。 响应于基础关系的更新，预定义的锁被放置在视图上。 利用根据本发明的一些实施例的锁定机制，通过在某些情况下允许通过多个事务同时更新物化视图，同时避免读写和冲突冲突，来增强访问视图和B树索引的事务的并发性 。
-
7.发明授权Locking mechanism using a predefined lock for materialized views in a database system 有权使用数据库系统中物化视图的预定义锁定的锁定机制公开(公告)号：US07149737B1
公开(公告)日：2006-12-12
申请号：US10117497
申请日：2002-04-04
CPC分类号： G06F17/30498 , G06F17/30362 , G06F17/30383 , Y10S707/99933 , Y10S707/99938 , Y10S707/99939
摘要： A database system includes a locking mechanism for a materialized view defined on base relations. In response to updates of a base relation, a predefined lock (e.g., Y lock or IY lock) is placed on the materialized view. With the locking mechanism, transaction concurrency is enhanced by enabling concurrent updates of a materialized view by plural transactions in certain cases.
摘要翻译： 数据库系统包括用于在基础关系上定义的物化视图的锁定机制。 响应于基础关系的更新，在物化视图上放置预定义的锁（例如，Y锁或IY锁）。 通过锁定机制，通过在某些情况下允许通过多个事务并行更新物化视图来增强事务并发性。
-
公开(公告)号：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.
摘要翻译： 数据库系统包括事务重新调度机制，其基于一个或多个待处理事务与已被调度执行的任何事务冲突来重新排列等待的事务。 在一种安排中，接收到的待处理事务被存储在第一队列中。 计划执行的事务存储在第二个队列中。 基于事务重新调度机制的重新排序，事务从第一个队列移动到第二个队列。
-
9.发明授权Locking mechanism using predefined locks for aggregate materialized views in a database system 有权在数据库系统中使用预定义的锁集合物化视图的锁定机制公开(公告)号：US07181452B1
公开(公告)日：2007-02-20
申请号：US10324456
申请日：2002-12-20
申请人： Gang Luo , Michael W. Watzke , Curt J. Ellmann
发明人： Gang Luo , Michael W. Watzke , Curt J. Ellmann
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99938 , Y10S707/99942
摘要： 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.
摘要翻译： 数据库系统包括用于在基础关系上定义的聚合物化视图的锁定机制。 响应于基础关系的更新，预定义的锁定放置在聚合物化视图上。 通过锁定机制，通过在某些情况下允许通过多个事务并行更新物化视图来提高事务并发性，同时避免属于同一组的多个元组作为单独的元组集成到聚合物化视图中的情况。
-
公开(公告)号：US07814080B1
公开(公告)日：2010-10-12
申请号：US10694564
申请日：2003-10-27
申请人： Gang Luo , Michael W. Watzke , Curt J. Ellmann
发明人： Gang Luo , Michael W. Watzke , Curt J. Ellmann
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语句提交到数据库系统。 可选地，或者替代地，多个事务可以一起分组成一个事务。
-
-
-
-
-
-
-
-
-
搜索结果
18 条记录 (耗时 0.05 秒)
