公开(公告)号：US08892515B2

公开(公告)日：2014-11-18

申请号：US13249973

申请日：2011-09-30

申请人： Robert W. Lyle ,  Ping Wang

发明人： Robert W. Lyle ,  Ping Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30371 ,  G06F17/30 ,  G06F17/30321 ,  G06F17/30551

摘要： Techniques are described for identifying conflicts between a prospective temporal key and an index of temporal keys, the index sorted based on a time value associated with each of the temporal keys. Embodiments determine whether a first temporal key within the index of temporal keys conflicts with the prospective temporal key. Here, the keys within the index may be sorted based upon a respective time value associated with each of the keys. Upon determining that the first temporal key conflicts with the prospective temporal key, the prospective temporal key is designated as conflicting with at least one existing temporal key in the index of temporal keys.

摘要翻译： 描述了用于识别预期时间密钥和时间密钥索引之间的冲突的技术，该索引基于与每个时间密钥相关联的时间值排序。 实施例确定时间键索引内的第一时间密钥是否与预期时间密钥冲突。 这里，可以基于与每个键相关联的相应时间值来对索引内的键进行排序。 在确定第一时间密钥与预期时间密钥冲突时，预期时间密钥被指定为与时间密钥索引中的至少一个现有时间密钥冲突。

公开(公告)号：US20120179724A1

公开(公告)日：2012-07-12

申请号：US13421935

申请日：2012-03-16

申请人： Robert W. Lyle ,  Ping Wang

发明人： Robert W. Lyle ,  Ping Wang

IPC分类号： G06F7/00

CPC分类号： G06F17/30336 ,  G06F17/30345

摘要： Database elements are inserted into a database object by processing each of a plurality of operations in a sequential order within a first processing round to insert the database elements into the database objects, where processing for at least one operation in the order becomes suspended due to a resource request, and where at least one successive operation is initiated in response to suspension of one or more prior operations to enable prefetching of information for processing the operations. Each suspended operation is re-processed with the prefetched information in one or more additional processing rounds until processing of the operations is completed.

摘要翻译： 数据库元素通过在第一处理循环内以顺序的顺序处理多个操作中的每一个来插入到数据库对象中，以将数据库元素插入到数据库对象中，其中由于一个 资源请求，以及响应于一个或多个先前操作的暂停而启动至少一个连续操作，以使得能够预取用于处理操作的信息。 每个挂起的操作在一个或多个附加处理轮中用预取的信息进行重新处理，直到操作的处理完成。

公开(公告)号：US20120096039A1

公开(公告)日：2012-04-19

申请号：US12906456

申请日：2010-10-18

申请人： Robert W. Lyle ,  Ping Wang

发明人： Robert W. Lyle ,  Ping Wang

IPC分类号： G06F17/30 ,  G06F9/30

CPC分类号： G06F17/30336 ,  G06F17/30345

摘要： Database elements are inserted into a database object by processing each of a plurality of operations in a sequential order within a first processing round to insert the database elements into the database objects, where processing for at least one operation in the order becomes suspended due to a resource request, and where at least one successive operation is initiated in response to suspension of one or more prior operations to enable prefetching of information for processing the operations. Each suspended operation is re-processed with the prefetched information in one or more additional processing rounds until processing of the operations is completed.

公开(公告)号：US07890482B2

公开(公告)日：2011-02-15

申请号：US12117228

申请日：2008-05-08

申请人： Karelle L. Cornwell ,  Tanya Couch ,  Robert W. Lyle ,  James Z. Teng ,  Julie A. Watts

发明人： Karelle L. Cornwell ,  Tanya Couch ,  Robert W. Lyle ,  James Z. Teng ,  Julie A. Watts

IPC分类号： G06F7/00 ,  G06F17/00

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.

摘要翻译： 提供了一种用于控制数据库系统中数据访问并发性的系统。 该系统包括接收对数据库系统中的数据的访问的锁定请求，其中锁定请求是对包含数据的数据库系统中的页面锁定或对于相应行或页面的行锁的请求。 该方法还包括识别数据库系统中包含包含数据的数据库系统中的行或页面的分区; 将锁定请求与包含包含数据的数据库系统中的行或页面的分区上的分区锁相关联; 并使用分区锁访问数据。

公开(公告)号：US20090077088A1

公开(公告)日：2009-03-19

申请号：US12274257

申请日：2008-11-19

申请人： Robert W. LYLE ,  Michael J. WINER

发明人： Robert W. LYLE ,  Michael J. WINER

IPC分类号： G06F17/30

CPC分类号： G06F16/2308 ,  Y10S707/99932

摘要： A system and a computer readable medium for estimating the first access time of a plurality of currently active transactions accessing at least one database object is disclosed. According to varying embodiments of the system and computer readable medium disclosed herein, the present invention may provide an efficient mechanism for tracking the earliest first access time of the set of all currently active transactions accessing an object in a database system.

摘要翻译： 公开了一种用于估计访问至少一个数据库对象的多个当前活动事务的第一访问时间的系统和计算机可读介质。 根据本文公开的系统和计算机可读介质的不同实施例，本发明可以提供用于跟踪访问数据库系统中的对象的所有当前活动事务的集合的最早的第一访问时间的有效机制。

公开(公告)号：US20090063400A1

公开(公告)日：2009-03-05

申请号：US11850443

申请日：2007-09-05

申请人： Dipti D. Borkar ,  Christina M. Lee ,  Robert W. Lyle

发明人： Dipti D. Borkar ,  Christina M. Lee ,  Robert W. Lyle

IPC分类号： G06F17/30

CPC分类号： G06F16/81 ,  G06F16/2272

摘要： An apparatus, system, and method are disclosed for updating database indexes on complex data types. Instead of deleting all the index keys for an old indexable entity, only the old index keys which are not in the set of new index keys associated with a replacement indexable entity will be deleted. In addition, only new index keys which are not in the set of old index keys are inserted into the index. In this manner, performance is greatly improved by elimination unnecessary deletions and insertions to an index.

摘要翻译： 公开了一种用于更新复杂数据类型上的数据库索引的装置，系统和方法。 而不是删除旧可索引实体的所有索引键，只有与替换可索引实体相关联的新索引键集中的旧索引键才会被删除。 另外，只有不在旧索引键集中的新的索引键被插入到索引中。 以这种方式，通过消除对索引的不必要的删除和插入，大大提高了性能。

公开(公告)号：US07480653B2

公开(公告)日：2009-01-20

申请号：US10817205

申请日：2004-04-02

申请人： Karelle L. Cornwell ,  Tanya Couch ,  Robert W. Lyle ,  James Zu-Chia Teng ,  Julie A. Watts

发明人： Karelle L. Cornwell ,  Tanya Couch ,  Robert W. Lyle ,  James Zu-Chia Teng ,  Julie A. Watts

IPC分类号： G06F7/00 ,  G06F17/30 ,  G06F12/00 ,  G06F13/00 ,  G06F13/28

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.

摘要翻译： 一种用于控制对数据库系统中的数据访问的并发性的方法和系统，包括：将所述数据库系统中的表划分成多个分区; 接收访问数据的请求; 确定包含所述数据的所述多个分区的分区; 确定数据是否已提交; 如果是这样，则避免锁定分区以响应该请求。 通过避免在数据提交时锁定分区，减少了需要从本地资源锁管理器请求的分区锁的数量，从而提高了性能。

公开(公告)号：US763434A

公开(公告)日：1904-06-28

申请号：US1903159061

申请日：1903-05-28

申请人： ROBERT W LYLE

发明人： SLATER FREDERICK R

CPC分类号： B60M1/307

公开(公告)号：US20110295909A1

公开(公告)日：2011-12-01

申请号：US12790584

申请日：2010-05-28

申请人： CURT L. COTNER ,  BALAKRISHNA R. IYER ,  KRISHNARAO G. KULKARNI ,  ROBERT W. LYLE

发明人： CURT L. COTNER ,  BALAKRISHNA R. IYER ,  KRISHNARAO G. KULKARNI ,  ROBERT W. LYLE

IPC分类号： G06F17/30

CPC分类号： G06F17/30595

摘要： A row property provides a mechanism for implementing advanced functional behavior in a relational database management system (RDBMS) without introducing new data types. A row property is part of a table definition, such that, when a table is defined in the RDBMS, at least one row property is specified for one or more associated columns of rows of the table, wherein the row property has an associated functional behavior that is predefined within the RDBMS. The columns associated with the row property are generally of existing data types supported by an RDBMS. A row property may be invoked when the RDBMS processes a language statement that references the row property. When the row property is invoked, the RDBMS executes programming logic associated with the row property, in order to perform the advanced functional behavior using data stored in the associated columns.

摘要翻译： 行属性提供了在关系数据库管理系统（RDBMS）中实现高级功能行为而不引入新数据类型的机制。 行属性是表定义的一部分，使得当在RDBMS中定义表时，为表的一个或多个相关联的列指定至少一个行属性，其中行属性具有关联的功能行为 这是在RDBMS中预定义的。 与行属性相关联的列通常是RDBMS支持的现有数据类型。 当RDBMS处理引用row属性的语言语句时，可以调用row属性。 当调用row属性时，RDBMS执行与行属性相关联的编程逻辑，以便使用存储在关联列中的数据执行高级功能行为。

公开(公告)号：US06651073B1

公开(公告)日：2003-11-18

申请号：US09576667

申请日：2000-05-23

申请人： Robert W. Lyle ,  James Z. Teng ,  Jay A. Yothers

发明人： Robert W. Lyle ,  James Z. Teng ,  Jay A. Yothers

IPC分类号： G06F1730

CPC分类号： G06F11/1471 ,  G06F2201/80 ,  G06F2201/82 ,  Y10S707/99931 ,  Y10S707/99938 ,  Y10S707/99953

摘要： Database tables which are to be loaded with large data objects are defined with a special logging attribute that causes the associated database management system to suspend recovery logging for the databases so defined, but to continue with logging control information, such as space management changes. During a two-phase commit operation for a database transaction in a distributed system, at each database all modified data pages are written to disk before the end of the phase 1 commit, if the pages have not been previously written. This and other write operations are monitored for errors. If any of the changed data pages cannot be written to disk successfully before the end the phase 1 commit operation, then the transaction is rolled back at all databases.

摘要翻译： 要加载大数据对象的数据库表将使用特殊的日志记录属性进行定义，这会使相关联的数据库管理系统挂起对所定义的数据库的恢复日志记录，但要继续记录控制信息，例如空间管理更改。 在分布式系统中的数据库事务的两阶段提交操作期间，如果页面未被写入，则在每个数据库中，所有修改的数据页都将在阶段1提交结束之前写入磁盘。 监视这个和其他写操作的错误。 如果在第一阶段提交操作结束之前，任何已更改的数据页面都无法成功写入磁盘，则事务将在所有数据库中回滚。