公开(公告)号：US20080288561A1

公开(公告)日：2008-11-20

申请号：US11749658

申请日：2007-05-16

申请人： RamanaKumari M. Croisettier ,  Paramesh S. Desai ,  James Z. Teng

发明人： RamanaKumari M. Croisettier ,  Paramesh S. Desai ,  James Z. Teng

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30551 ,  Y10S707/955 ,  Y10S707/96

摘要： A computer system and a relational database management system (RDMS) computer program product are described for interfacing a number of concurrently running database sessions with a large database in which a plurality of local temporary object database descriptors are used in lieu of a single global temporary object database descriptor where the global and each of the local temporary object database descriptors include identifiers for temporary objects, each of the local temporary object database descriptors is associated with a single database session and each of the global database descriptors is shared among multiple database sessions.

摘要翻译： 描述了计算机系统和关系数据库管理系统（RDMS）计算机程序产品，用于将多个并行运行的数据库会话与大数据库进行接口，其中使用多个本地临时对象数据库描述符来代替单个全局临时对象 数据库描述符，其中全局和每个本地临时对象数据库描述符包括临时对象的标识符，每个本地临时对象数据库描述符与单个数据库会话相关联，并且每个全局数据库描述符在多个数据库会话之间共享。

公开(公告)号：US5581750A

公开(公告)日：1996-12-03

申请号：US31791

申请日：1993-03-15

申请人： Donald J. Haderle ,  James Z. Teng

发明人： Donald J. Haderle ,  James Z. Teng

IPC分类号： G06F11/14 ,  G06F17/30

CPC分类号： G06F11/1471 ,  Y10S707/99953

摘要： A system and method are provided for recovering a computerized database. During transaction processing of a database, at least one log range is tracked comprising update transaction log records. The log range has a begin value and an end value. The begin value corresponds to a log RBA location of a first access of the database by an updating transaction. The end value corresponds to a log RBA location at a commit or abort of a last updating transaction. The end value corresponds to a point when the database is designated as being read only (called pseudo open). During recovery of the database, the update transaction log records in the log range are applied to a version of the database stored in non-volatile memory.

摘要翻译： 提供了一种用于恢复计算机化数据库的系统和方法。 在数据库的事务处理期间，跟踪包括更新事务日志记录的至少一个日志范围。 日志范围具有开始值和结束值。 开始值对应于更新事务对数据库的第一次访问的日志RBA位置。 结束值对应于上次更新事务的提交或中止时的日志RBA位置。 结束值对应于数据库被指定为只读（称为伪打开）的点。 在恢复数据库期间，日志范围内的更新事务日志记录应用于存储在非易失性存储器中的数据库版本。

公开(公告)号：US4961134A

公开(公告)日：1990-10-02

申请号：US219514

申请日：1988-07-15

申请人： Richard A. Crus ,  Donald J. Haderle ,  James Z. Teng

发明人： Richard A. Crus ,  Donald J. Haderle ,  James Z. Teng

IPC分类号： G06F7/22 ,  G06F12/00 ,  G06F12/02

CPC分类号： G06F17/30339 ,  G06F12/0238 ,  Y10S707/99938 ,  Y10S707/99953

摘要： A page-accessing method in a segmented tablespace 10 which eliminates unnecessary reading and locking. The tablespace comprises data pages 18 grouped into identically-sized segments 16, each segment storing data for a single table. A status indicator 26 for each data page of a segment is kept in a separate segment control block 20 stored on a space map page 14. Five data page status indicator values are maintained: (1) FULL (26a) - entirely full of current data; (2) PARTIALLY FULL (26b) - partially full of current data; (3) UNFORMATTED (26c) - empty; contains no data; (4) MASS DELETE (26d) - contains only obsolete data because of an unqualified deletion (mass delete) of data; or (5) QUALIFIED DELETE (26e) - contains only obsolete data because of a qualified deletion of data.When scanning over the data in a segment, UNFORMATTED and MASS DELETE pages are skipped. QUALIFIED DELETE pages are locked, and then skipped if they still contain only obsolete data when the lock is obtained. When inserting data into pages, preliminary reads of UNFORMATTED and MASS DELETE pages are avoided. Data integrity is ensured by placing integrity checking bits at the beginning and end of each page. If the bits contain the same value, the page's data integrity is intact. If the bits are different, the page's previous consistent contents are recovered from the log records.

公开(公告)号：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提交结束之前写入磁盘。 监视这个和其他写操作的错误。 如果在第一阶段提交操作结束之前，任何已更改的数据页面都无法成功写入磁盘，则事务将在所有数据库中回滚。

公开(公告)号：US06567928B1

公开(公告)日：2003-05-20

申请号：US09576303

申请日：2000-05-23

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

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

IPC分类号： G06F1100

CPC分类号： G06F11/1471 ,  G06F11/1461 ,  G06F11/1469 ,  G06F2201/80 ,  Y10S707/99953

摘要： Database tables which are to be loaded with large data objects (LOBs) are defined with a special logging attribute value. This attribute value causes the database management system to suspend recovery logging for the databases so defined, but to continue with the logging of control information, such as space management changes. Certain control information recovery log entries have a special status indicator. For LOBs, this status indicator is set to cause the associated LOB entry to be marked as invalid when the log entry is reapplied, for example, during a recovery operation from a media failure. Rather than invalidating the entire table, the database management system will only prevent access to the entries which have been invalidated during the recovery process.

摘要翻译： 要加载大数据对象（LOB）的数据库表将使用特殊的日志记录属性值进行定义。 此属性值导致数据库管理系统挂起对所定义的数据库的恢复日志记录，但继续记录控制信息，例如空间管理更改。 某些控制信息恢复日志条目具有特殊的状态指示符。 对于LOB，当状态指示符被设置为使得当重新应用日志条目时，例如在从介质故障的恢复操作期间，关联的LOB条目被标记为无效。 数据库管理系统不会使整个表无效，而只会阻止对恢复过程中已被无效的条目的访问。

公开(公告)号：US10452629B2

公开(公告)日：2019-10-22

申请号：US13082174

申请日：2011-04-07

申请人： Namik Hrle ,  Johannes Schuetzner ,  James Z. Teng

发明人： Namik Hrle ,  Johannes Schuetzner ,  James Z. Teng

IPC分类号： G06F16/22

摘要： Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.

公开(公告)号：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.

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

公开(公告)号：US07266552B2

公开(公告)日：2007-09-04

申请号：US10821717

申请日：2004-04-09

申请人： David R. Schwartz ,  Bryan Frederick Smith ,  James Z. Teng ,  David Warner

发明人： David R. Schwartz ,  Bryan Frederick Smith ,  James Z. Teng ,  David Warner

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

CPC分类号： G06F17/30557 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99942

摘要： A method, apparatus, and article of manufacture accesses a dataset using an unsupported access method. A first request to access a dataset is intercepted. The first request is associated with a first data structure that specifies a first access method. The first data structure is replaced with a second data structure that specifies a second access method which is different from the first access method. The dataset is accessed in accordance with the second access method of the second data structure.In another particular embodiment, the first access method is the basic direct access method, and the second access method is any of the basic sequential access method and the queued sequential access method. In yet another embodiment, the dataset is an extended format physical sequential dataset.

摘要翻译： 方法，装置和制品使用不受支持的访问方法访问数据集。 第一个访问数据集的请求被截获。 第一请求与指定第一访问方法的第一数据结构相关联。 第一数据结构被替换为指定与第一访问方法不同的第二访问方法的第二数据结构。 根据第二数据结构的第二访问方法访问数据集。 在另一特定实施例中，第一访问方法是基本直接访问方法，第二访问方法是基本顺序访问方法和排队顺序访问方法中的任何一种。 在另一个实施例中，数据集是扩展格式物理顺序数据集。

公开(公告)号：US07174353B2

公开(公告)日：2007-02-06

申请号：US10693184

申请日：2003-10-24

申请人： Craig A. Friske ,  Regina J. Liu ,  James A. Ruddy ,  James Z. Teng ,  Julie A. Watts

发明人： Craig A. Friske ,  Regina J. Liu ,  James A. Ruddy ,  James Z. Teng ,  Julie A. Watts

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.

摘要翻译： 本发明涉及一种用于维护支持动态表模式改变的数据库系统中的表的原始表模式的方法和系统。 所述方法和系统包括在对表进行模式更改之前将表的原始表模式存储在指定的表中。 通过将原始表模式存储在指定表中，可以使用包含不自描述行的表的备份副本进行数据恢复。

公开(公告)号：US06775676B1

公开(公告)日：2004-08-10

申请号：US09659252

申请日：2000-09-11

申请人： Guenter Briam ,  Namik Hrle ,  James Z. Teng

发明人： Guenter Briam ,  Namik Hrle ,  James Z. Teng

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A defer dataset creation system creates database objects at a computer connected to a data storage device. Initially, a command to create a database object is received. A database object definition for that database object is recorded. When the database object is accessed, a dataset for the database object is created from its database object definition.

摘要翻译： 延迟数据集创建系统在连接到数据存储设备的计算机上创建数据库对象。 最初，接收到创建数据库对象的命令。 记录该数据库对象的数据库对象定义。 访问数据库对象时，将从其数据库对象定义创建数据库对象的数据集。