-
1.发明授权公开(公告)号：US07890482B2
公开(公告)日：2011-02-15
申请号：US12117228
申请日：2008-05-08
CPC分类号： G06F17/30362 , Y10S707/99938
摘要： A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.
摘要翻译： 提供了一种用于控制数据库系统中数据访问并发性的系统。 该系统包括接收对数据库系统中的数据的访问的锁定请求，其中锁定请求是对包含数据的数据库系统中的页面锁定或对于相应行或页面的行锁的请求。 该方法还包括识别数据库系统中包含包含数据的数据库系统中的行或页面的分区; 将锁定请求与包含包含数据的数据库系统中的行或页面的分区上的分区锁相关联; 并使用分区锁访问数据。
-
公开(公告)号：US20090164468A1
公开(公告)日：2009-06-25
申请号：US12117228
申请日：2008-05-08
IPC分类号： G06F17/30
CPC分类号： G06F17/30362 , Y10S707/99938
摘要： A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.
摘要翻译： 提供了一种用于控制数据库系统中数据访问并发性的系统。 该系统包括接收对数据库系统中的数据的访问的锁定请求，其中锁定请求是对包含数据的数据库系统中的页面锁定或对于相应行或页面的行锁的请求。 该方法还包括识别数据库系统中包含包含数据的数据库系统中的行或页面的分区; 将锁定请求与包含包含数据的数据库系统中的行或页面的分区上的分区锁相关联; 并使用分区锁访问数据。
-
公开(公告)号：US07480653B2
公开(公告)日：2009-01-20
申请号：US10817205
申请日：2004-04-02
CPC分类号： G06F17/30362 , Y10S707/99938
摘要： A method and system for controlling concurrency of access to data in a database system, includes: partitioning a table in the database system into a plurality of partitions; receiving a request for access to data; determining a partition of the plurality of partitions that contains the data; determining if the data has been committed; and if so, avoiding locking the partition in response to the request. By avoiding locking the partition when the data has been committed, the number of partition locks that need to be requested from a local resource lock manager is reduced, improving performance.
摘要翻译： 一种用于控制对数据库系统中的数据访问的并发性的方法和系统，包括：将所述数据库系统中的表划分成多个分区; 接收访问数据的请求; 确定包含所述数据的所述多个分区的分区; 确定数据是否已提交; 如果是这样，则避免锁定分区以响应该请求。 通过避免在数据提交时锁定分区，减少了需要从本地资源锁管理器请求的分区锁的数量，从而提高了性能。
-
公开(公告)号：US07711730B2
公开(公告)日：2010-05-04
申请号：US10744633
申请日：2003-12-22
申请人： Margaret A. Bernal , Karelle L. Cornwell , Hsuiying Y. Cheng , Yao-Ching S. Chen , Christopher J. Crone , Fen-Ling Lin , James W. Pickel , Yumi K. Tsuji , Julie A. Watts
发明人： Margaret A. Bernal , Karelle L. Cornwell , Hsuiying Y. Cheng , Yao-Ching S. Chen , Christopher J. Crone , Fen-Ling Lin , James W. Pickel , Yumi K. Tsuji , Julie A. Watts
CPC分类号： G06F17/30595 , G06F17/30463
摘要： A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.
摘要翻译： 一种用于生成用于在单个进程中从数据库更新和检索数据的执行计划的方法包括：由服务器接收用第一组数据更新数据库的语句，并从数据库中检索第二组数据; 构建第一个执行计划，用第一组数据更新数据库; 构建第二个执行计划以从数据库中检索第二组数据; 并构建包括第一和第二执行计划的组合的单个执行计划。 单个执行计划允许通过客户端和数据库之间的接口的单个交叉来更新和检索数据。 通过以这种方式执行这两个功能，在数据库上执行这样的任务的效率显着增加。
-
公开(公告)号：US07174353B2
公开(公告)日：2007-02-06
申请号：US10693184
申请日：2003-10-24
IPC分类号： G06F17/30
CPC分类号： G06F17/30297 , G06F11/1435 , G06F17/30477 , G06F2201/80 , Y10S707/99933 , Y10S707/99954
摘要： The present invention is related to a method and system for preserving an original table schema for a table in a database system that supports dynamic table schema changes. The method and system includes storing the original table schema for the table in a designated table prior to performing a schema change on the table. By storing the original table schema in the designated table, a backup copy of the table that includes rows which are not self-describing can be used for data recovery.
摘要翻译： 本发明涉及一种用于维护支持动态表模式改变的数据库系统中的表的原始表模式的方法和系统。 所述方法和系统包括在对表进行模式更改之前将表的原始表模式存储在指定的表中。 通过将原始表模式存储在指定表中，可以使用包含不自描述行的表的备份副本进行数据恢复。
-
公开(公告)号：US07499924B2
公开(公告)日：2009-03-03
申请号：US11184619
申请日：2005-07-18
申请人： Julie A. Watts
发明人： Julie A. Watts
IPC分类号： G06F7/00
CPC分类号： G06F17/30362 , G06F11/1471 , G06F17/30371 , Y10S707/99938
摘要： A method for selectively releasing locks when rolling back to a savepoint includes: providing at least one savepoint in a transaction, where the at least one savepoint and the transaction are separate lock owners, where at least one lock is assigned to the at least one savepoint and at least one lock is assigned to the transaction; rolling back the transaction to the at least one savepoint; and releasing any locks owned by the at least one savepoint, where any locks owned by the transaction is maintained. Ownership of locks to persist until commit is assigned to the transaction. Ownership of locks to be released when rolled back to a savepoint is assigned to the savepoint. When roll back to a given savepoint occurs, locks owned by the savepoint are released while locks owned by the transaction are maintained.
摘要翻译： 一种用于在回滚到保存点时选择性地释放锁的方法包括：在事务中提供至少一个保存点，其中至少一个保存点和事务是分离的锁所有者，其中至少一个锁被分配给至少一个保存点 并且至少一个锁被分配给该事务; 将交易回滚到至少一个保存点; 并释放由至少一个保存点拥有的任何锁，其中维护由事务拥有的任何锁。 锁定的所有权持续到提交分配给事务。 将回滚到保存点时释放的锁的所有权分配给保存点。 当回滚到给定的保存点时，保存点所有的锁将被释放，同时维护事务所拥有的锁。
-
7.发明授权Method for managing distributed savepoints across multiple DBMS's within a distributed transaction 失效在分布式事务中跨多个DBMS管理分布式保存点的方法公开(公告)号：US06816873B2
公开(公告)日：2004-11-09
申请号：US09858735
申请日：2001-05-15
申请人： Curt L. Cotner , James W. Pickel , Julie A. Watts
发明人： Curt L. Cotner , James W. Pickel , Julie A. Watts
IPC分类号： G06F1200
CPC分类号： G06F11/1474 , G06F17/30353 , G06F17/30575 , G06F2201/80 , Y10S707/99938 , Y10S707/99952
摘要： System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server. A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as participants. Savepoints are assigned to the participants across the Database Management System, with at least one savepoint within a multiple step transaction. The DBMS responds to application requests to rollback to savepoint by rolling back the transaction, across the Database Management System participants, to the savepoint Further disclosed is a program product that contains code, which, either as written on the medium, or as instantiated in RAM, or both, controls the operation of a distributed database management system.
摘要翻译： 用于管理驻留在单独的参与者服务器和协调器服务器上的多个数据库管理系统上的事务的系统，方法和程序产品。 单个事务通过作为参与者的多个数据库管理系统中的多于一个的多个步骤进行。 保存点被分配给跨数据库管理系统的参与者，在多步事务中至少有一个保存点。 DBMS通过将数据库管理系统参与者的事务回滚到保存点来响应应用程序请求回滚到保存点。另外披露的是一个程序产品，其中包含代码，无论是在介质上写入还是在RAM中实例化 ，或两者都控制分布式数据库管理系统的操作。
-
8.发明授权
公开(公告)号：US4933848A
公开(公告)日：1990-06-12
申请号：US219512
申请日：1988-07-15
申请人： Donald J. Haderle , Julie A. Watts
发明人： Donald J. Haderle , Julie A. Watts
CPC分类号： G06F17/30371 , Y10S707/99952
摘要： A method is disclosed for deferring enforcement of referential constraints in large-scale data base operations such as the population or loading of relational tables 10, 12. First, the new rows are loaded in a Data Load phase 24 into the tables, and information on the new rows and their constraints is extracted and sorted 26 into a sorted key data set 68. Any primary indexes 22 required for constraint checking are then updated 28 using the sorted key data set. The new rows are then checked 70 for constraint violations, such violations are rectified 72 to restore the table's referential integrity, and a deletion data set 80 is produced. The deletion data set is merged and sorted 86 with row information 53 stored during loading, and the result is used to copy 88 the new rows violating referential constraints to a separate discard data set 48 where they can be corrected and reloaded into the table. Finally, an error summary report 36 is generated for use in correcting the discard data set.
-
公开(公告)号：US07080074B2
公开(公告)日：2006-07-18
申请号：US10010371
申请日：2001-11-05
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30362 , Y10S707/99938
摘要： According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.
摘要翻译： 根据本发明的方法，装置和计算机可读介质，通过访问关系数据库中的表的所有行来执行扫描，评估每行以确定该行是否满足数据库查询的一组谓词， 并返回该行，如果它满足一组谓词。 根据本发明的优选实施例，无论当前的锁如何，都对所有行进行评估。 如果该行不满足该组谓词，而不考虑行上的当前锁定，则继续进行扫描。 根据本发明的锁定语义的优点在于它完全消除了对不满足语句谓词的行的锁争用的问题。
-
-
-
-
-
-
-
-
搜索结果
9 条记录 (耗时 0.026 秒)
