专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07181476B2 Flashback database 有权
公开(公告)号：US07181476B2
公开(公告)日：2007-02-20
申请号：US10427511
申请日：2003-04-30
申请人： J. William Lee , Juan Loaiza , Michael J. Stewart , Wei-Ming Hu , William H. Bridge, Jr.
发明人： J. William Lee , Juan Loaiza , Michael J. Stewart , Wei-Ming Hu , William H. Bridge, Jr.
IPC分类号： G06F17/30
CPC分类号： G06F11/1471 , G06F11/1446 , G06F2201/80 , Y10S707/99931 , Y10S707/99953 , Y10S707/99954
摘要： Techniques are described herein for returning a repository to a prior state. The repository may be, for example a database, and the prior state may be, for example the consistent state that the database had at a particular point in time in the past. When a operator-caused error has been introduced to the database by changes made by an already-committed transaction, the techniques described herein may be used to recover from the error by returning the database to a point in time prior to the commit time of the transaction that introduced the error. The techniques involve the generation of “physical undo” information, and the use of the physical undo information in conjunction with physiological undo and physiological redo to efficiently return a repository to the prior state.

2. 发明授权

US07631018B2 Flashback database 有权
标题翻译：闪回数据库
公开(公告)号：US07631018B2
公开(公告)日：2009-12-08
申请号：US11652782
申请日：2007-01-11
申请人： J. William Lee , Juan Loaiza , Michael J. Stewart , Wei-Ming Hu , William H. Bridge, Jr.
发明人： J. William Lee , Juan Loaiza , Michael J. Stewart , Wei-Ming Hu , William H. Bridge, Jr.
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F11/1471 , G06F11/1446 , G06F2201/80 , Y10S707/99931 , Y10S707/99953 , Y10S707/99954
摘要： Techniques are described herein for returning a repository to a prior state. The repository may be, for example a database, and the prior state may be, for example the consistent state that the database had at a particular point in time in the past. When a operator-caused error has been introduced to the database by changes made by an already-committed transaction, the techniques described herein may be used to recover from the error by returning the database to a point in time prior to the commit time of the transaction that introduced the error. The techniques involve the generation of “physical undo” information, and the use of the physical undo information in conjunction with physiological undo and physiological redo to efficiently return a repository to the prior state.
摘要翻译：这里描述了将存储库返回到先前状态的技术。存储库可以是例如数据库，并且先前状态可以是例如数据库在过去的特定时间点具有的一致状态。当通过已经提交的事务所做的改变将由操作者导致的错误引入到数据库时，本文描述的技术可以用于通过将数据库返回到在提交时间之前的时间点从错误中恢复事务引入了错误。这些技术包括生成“物理撤销”信息，以及使用物理撤消信息结合生理撤消和生理重做，以有效地将存储库返回到先前状态。

3. 发明授权

US5890167A Pluggable tablespaces for database systems 失效
标题翻译：数据库系统的可插拔表空间
公开(公告)号：US5890167A
公开(公告)日：1999-03-30
申请号：US852968
申请日：1997-05-08
申请人： William H. Bridge, Jr. , Jonathan D. Klein , J. William Lee , Juan R. Loaiza , Alex Tsukerman , GianFranco Putzolu
发明人： William H. Bridge, Jr. , Jonathan D. Klein , J. William Lee , Juan R. Loaiza , Alex Tsukerman , GianFranco Putzolu
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99942 , Y10S707/99953 , Y10S707/99955
摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by exporting the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and importing the associated metadata, without patching any of the disk pointers.
摘要翻译：通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。通过导出相关联的元数据并创建表空间的二进制副本，可以插拔一组表空间。可插拔的表空间集合通过使可插入集合可访问目标数据库并导入相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

4. 发明授权

US06243702B1 Method and apparatus for propagating commit times between a plurality of database servers 失效
标题翻译：用于在多个数据库服务器之间传播提交时间的方法和装置
公开(公告)号：US06243702B1
公开(公告)日：2001-06-05
申请号：US09102724
申请日：1998-06-22
申请人： Roger J. Bamford , William H. Bridge, Jr. , J. William Lee , Alok Srivastava
发明人： Roger J. Bamford , William H. Bridge, Jr. , J. William Lee , Alok Srivastava
IPC分类号： G06F1730
CPC分类号： G06F17/30356 , G06F9/466 , G06F17/30377 , Y10S707/99938 , Y10S707/99952
摘要： A method and system for removing propagation delays between a plurality of database servers that have access to a common database is provided. According to the method, each database server is associated with a logical clock. In response to initiating a commit of a transaction executing on a database server, a commit time for the transaction is determined and broadcast to one or more other database servers. The broadcast is overlapped with a transaction log force. Upon receiving the commit time, the database servers compare the transmitted commit time to the time indicated by their logical clock. If the commit time is greater than the time indicated by their logical clock, the database server sets its logical time to reflect a time that is at least as recent as the time reflected by the transmitted commit time.
摘要翻译：提供了一种用于消除访问公共数据库的多个数据库服务器之间的传播延迟的方法和系统。根据该方法，每个数据库服务器与逻辑时钟相关联。响应于启动在数据库服务器上执行的事务的提交，确定事务的提交时间并广播到一个或多个其他数据库服务器。广播与事务日志强制重叠。在接收到提交时间后，数据库服务器将发送的提交时间与其逻辑时钟指示的时间进行比较。如果提交时间大于其逻辑时钟所指示的时间，则数据库服务器将其逻辑时间设置为反映至少与发送的提交时间反映的时间相同的时间。

5. 发明授权

US06804671B1 Pluggable tablespaces for database systems 有权
标题翻译：数据库系统的可插拔表空间
公开(公告)号：US06804671B1
公开(公告)日：2004-10-12
申请号：US10353381
申请日：2003-01-28
申请人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
发明人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/959 , Y10S707/99937 , Y10S707/99942 , Y10S707/99955
摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by generating the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and incorporating the associated metadata, without patching any of the disk pointers.
摘要翻译：通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。通过生成相关联的元数据并创建表空间的二进制副本，可以拔掉一组可插拔的表空间。可插入的表空间集合通过使可插入集合可访问目标数据库并结合相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

6. 发明授权

US06272503B1 Tablespace-relative database pointers 失效
标题翻译：表空间相对数据库指针
公开(公告)号：US06272503B1
公开(公告)日：2001-08-07
申请号：US08865693
申请日：1997-05-30
申请人： William H. Bridge, Jr. , Jonathan D. Klein , J. William Lee , Juan R. Loaiza , Alex Tsukerman , GianFranco Putzolu
发明人： William H. Bridge, Jr. , Jonathan D. Klein , J. William Lee , Juan R. Loaiza , Alex Tsukerman , GianFranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/959 , Y10S707/99937 , Y10S707/99942 , Y10S707/99955
摘要： A database containing datafiles is partitioned into a set of tablespaces. Every disk pointer pointing to a data item in a datafile refers to a tablespace-relative file number for the datafile. Data pointed to by a tablespace-relative disk pointer is retrieved by first checking the cache, and upon a cache miss, the tablespace-relative file number is translated into an absolute file number according to a latch-free look up technique.
摘要翻译：包含数据文件的数据库被分成一组表空间。指向数据文件中的数据项的每个磁盘指针是指数据文件的表空间相对文件编号。通过首先检查缓存来检索由表空间相对磁盘指针指向的数据，并且在高速缓存未命中时，根据无闩锁查询技术将表空间相对文件号转换为绝对文件号。

7. 发明授权

US6078930A Multi-node fault-tolerant timestamp generation 失效
标题翻译：多节点容错时间戳生成
公开(公告)号：US6078930A
公开(公告)日：2000-06-20
申请号：US961798
申请日：1997-10-31
申请人： J. William Lee , William H. Bridge, Jr.
发明人： J. William Lee , William H. Bridge, Jr.
IPC分类号： G06F11/14 , G06F17/00 , G06F11/00
CPC分类号： G06F11/1415 , G06F2201/835 , Y10S707/99952 , Y10S707/99953
摘要： Techniques for determining a safe recovery time value after a failure of a first node in a computer system are described. According to the techniques, every node in a multi-node parallel database system maintains a logical clock for generating timestamps. The logical clocks are synchronized by attaching a current timestamp to every message that is sent by a node. When a node receives an incoming timestamp that is greater than the value indicated by the associated logical clock, it sets the associated logical clock forward to at least the value of the timestamp. When a node fails, a recovery node calculates a "safe" logical clock value to use in recovering the crashed node. In calculating the "safe" logical clock value, the recovery node searches specific areas of the database to locate and recover a most recent timestamp value associated with the crashed node. The recovery node then compares its current logical clock time value with the most recent crash node timestamp value to determine which timestamp is most recent. If the most recent crash node timestamp value is more recent than the recovery node's current logical clock time value, the recovery node's logical clock is updated to be at least as recent as the most recent crash node timestamp value. The recovery node then recovers the crashed node as its logical clock is guaranteed to be at least as recent as any timestamp value that was previously written to the database by the crashed node prior to failure.
摘要翻译：描述用于在计算机系统中的第一节点故障之后确定安全恢复时间值的技术。根据这些技术，多节点并行数据库系统中的每个节点维护用于生成时间戳的逻辑时钟。通过将当前时间戳附加到由节点发送的每个消息来同步逻辑时钟。当节点接收到大于由相关逻辑时钟指示的值的输入时间戳时，它将关联的逻辑时钟向前设置为至少时间戳的值。当节点出现故障时，恢复节点将计算一个“安全”的逻辑时钟值，用于恢复崩溃的节点。在计算“安全”逻辑时钟值时，恢复节点搜索数据库的特定区域以查找和恢复与崩溃的节点相关联的最新时间戳值。然后，恢复节点将其当前逻辑时钟时间值与最近的崩溃节点时间戳值进行比较，以确定哪个时间戳是最近的。如果最近的崩溃节点时间戳值比恢复节点当前的逻辑时钟时间值更新，则恢复节点的逻辑时钟被更新为至少与最近的崩溃节点时间戳值一样近。然后，恢复节点恢复崩溃的节点，因为其逻辑时钟保证至少与故障之前由崩溃的节点写入数据库的任何时间戳值一样最近。

8. 发明授权

US5983015A Latch-free sequence generation for high concurrency systems 失效
标题翻译：高并发系统的无锁定序列生成
公开(公告)号：US5983015A
公开(公告)日：1999-11-09
申请号：US962534
申请日：1997-10-31
申请人： J. William Lee , William H. Bridge, Jr.
发明人： J. William Lee , William H. Bridge, Jr.
IPC分类号： G06F9/46
CPC分类号： G06F9/52
摘要： A method and apparatus for reading a software counter in a computer system that contains a plurality of processes each having access to the software counter is provided. The software counter includes a wrap portion and a base portion that cannot both be accessed in an atomic operation. The method includes the steps of reading a first value. The first value being one of the wrap or base portions. Reading a second value. The second value being the other of the wrap or base portion. Determining whether the first value might be changed during a time period that elapsed between reading the first value and reading the second value. If the first value might be changed during the time period, then obtaining a latch that covers at least the wrap portion. After obtaining the latch, reading the wrap and base portion and releasing the latch.
摘要翻译：提供了一种用于读取计算机系统中的软件计数器的方法和装置，该计算机系统包含多个具有访问软件计数器的进程。软件计数器包括在原子操作中不能同时访问的包裹部分和基部部分。该方法包括读取第一值的步骤。第一个值是包装或基部之一。读第二个值。第二个值是包装或基部中的另一个。确定在读取第一个值和读取第二个值之间经过的时间段内是否可以更改第一个值。如果在该时间段期间可以改变第一个值，则获得至少覆盖包裹部分的闩锁。在获得闩锁之后，读取包裹和基部并释放闩锁。

9. 发明授权

US06636851B1 Method and apparatus for propagating commit times between a plurality of database servers 有权
标题翻译：用于在多个数据库服务器之间传播提交时间的方法和装置
公开(公告)号：US06636851B1
公开(公告)日：2003-10-21
申请号：US09758628
申请日：2001-01-10
申请人： Roger J. Bamford , William H. Bridge, Jr. , J. William Lee , Alok Srivastava
发明人： Roger J. Bamford , William H. Bridge, Jr. , J. William Lee , Alok Srivastava
IPC分类号： G06F1730
CPC分类号： G06F17/30356 , G06F9/466 , G06F17/30377 , Y10S707/99938 , Y10S707/99952
摘要： A method and system for propagating commit times between a plurality of database servers that have access to a common database is provided. According to the method, each database server is associated with a logical clock. In response to initiating a commit of a transaction executing on a database server, a commit time for the transaction is determined and broadcast to one or more other database servers. According to one aspect, upon receiving the commit time at the one or more other database servers, the database servers compare the transmitted commit time to the time indicated by their logical clock. If the commit time is greater than the time indicated by their logical clock, the database server sets its logical time to reflect a time that is at least as recent as the time reflected by the transmitted commit time.
摘要翻译：提供了一种用于在具有访问公共数据库的多个数据库服务器之间传播提交时间的方法和系统。根据该方法，每个数据库服务器与逻辑时钟相关联。响应于启动在数据库服务器上执行的事务的提交，确定事务的提交时间并广播到一个或多个其他数据库服务器。根据一个方面，一旦在一个或多个其他数据库服务器上接收到提交时间，数据库服务器将发送的提交时间与其逻辑时钟指示的时间进行比较。如果提交时间大于其逻辑时钟所指示的时间，则数据库服务器将其逻辑时间设置为反映至少与发送的提交时间反映的时间相同的时间。

10. 发明授权

US06549901B1 Using transportable tablespaces for hosting data of multiple users 有权
标题翻译：使用可移动的表空间来托管多个用户的数据
公开(公告)号：US06549901B1
公开(公告)日：2003-04-15
申请号：US09675195
申请日：2000-09-29
申请人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
发明人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/99937
摘要： Provided are mechanisms that may be used to support efficient exportation of user data stored in a database system. According to an aspect of the present invention, a database system is configured to store data for users in separate repositories referred to as tablespaces. To store data in this manner, a database system may be configured in variety of ways.
摘要翻译：提供了可用于支持存储在数据库系统中的用户数据的有效输出的机制。根据本发明的一个方面，数据库系统被配置为将数据存储在被称为表空间的分开的存储库中。为了以这种方式存储数据，可以以各种方式配置数据库系统。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式