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

11. 发明授权

US07571173B2 Cross-platform transportable database 有权
标题翻译：跨平台可移植数据库
公开(公告)号：US07571173B2
公开(公告)日：2009-08-04
申请号：US10966961
申请日：2004-10-15
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
IPC分类号： G06F7/00
CPC分类号： G06F17/30569 , Y10S707/99942
摘要： A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.
摘要翻译：提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。可以在源数据库或目标数据库执行数据和元数据的转换。源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

12. 发明授权

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.
摘要翻译：描述用于在计算机系统中的第一节点故障之后确定安全恢复时间值的技术。根据这些技术，多节点并行数据库系统中的每个节点维护用于生成时间戳的逻辑时钟。通过将当前时间戳附加到由节点发送的每个消息来同步逻辑时钟。当节点接收到大于由相关逻辑时钟指示的值的输入时间戳时，它将关联的逻辑时钟向前设置为至少时间戳的值。当节点出现故障时，恢复节点将计算一个“安全”的逻辑时钟值，用于恢复崩溃的节点。在计算“安全”逻辑时钟值时，恢复节点搜索数据库的特定区域以查找和恢复与崩溃的节点相关联的最新时间戳值。然后，恢复节点将其当前逻辑时钟时间值与最近的崩溃节点时间戳值进行比较，以确定哪个时间戳是最近的。如果最近的崩溃节点时间戳值比恢复节点当前的逻辑时钟时间值更新，则恢复节点的逻辑时钟被更新为至少与最近的崩溃节点时间戳值一样近。然后，恢复节点恢复崩溃的节点，因为其逻辑时钟保证至少与故障之前由崩溃的节点写入数据库的任何时间戳值一样最近。

13. 发明授权

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.
摘要翻译：提供了一种用于读取计算机系统中的软件计数器的方法和装置，该计算机系统包含多个具有访问软件计数器的进程。软件计数器包括在原子操作中不能同时访问的包裹部分和基部部分。该方法包括读取第一值的步骤。第一个值是包装或基部之一。读第二个值。第二个值是包装或基部中的另一个。确定在读取第一个值和读取第二个值之间经过的时间段内是否可以更改第一个值。如果在该时间段期间可以改变第一个值，则获得至少覆盖包裹部分的闩锁。在获得闩锁之后，读取包裹和基部并释放闩锁。

14. 发明授权

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.

15. 发明授权

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.
摘要翻译：这里描述了将存储库返回到先前状态的技术。存储库可以是例如数据库，并且先前状态可以是例如数据库在过去的特定时间点具有的一致状态。当通过已经提交的事务所做的改变将由操作者导致的错误引入到数据库时，本文描述的技术可以用于通过将数据库返回到在提交时间之前的时间点从错误中恢复事务引入了错误。这些技术包括生成“物理撤销”信息，以及使用物理撤消信息结合生理撤消和生理重做，以有效地将存储库返回到先前状态。

16. 发明授权

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.
摘要翻译：提供了一种用于消除访问公共数据库的多个数据库服务器之间的传播延迟的方法和系统。根据该方法，每个数据库服务器与逻辑时钟相关联。响应于启动在数据库服务器上执行的事务的提交，确定事务的提交时间并广播到一个或多个其他数据库服务器。广播与事务日志强制重叠。在接收到提交时间后，数据库服务器将发送的提交时间与其逻辑时钟指示的时间进行比较。如果提交时间大于其逻辑时钟所指示的时间，则数据库服务器将其逻辑时间设置为反映至少与发送的提交时间反映的时间相同的时间。

17. 发明授权

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.
摘要翻译：提供了一种用于在具有访问公共数据库的多个数据库服务器之间传播提交时间的方法和系统。根据该方法，每个数据库服务器与逻辑时钟相关联。响应于启动在数据库服务器上执行的事务的提交，确定事务的提交时间并广播到一个或多个其他数据库服务器。根据一个方面，一旦在一个或多个其他数据库服务器上接收到提交时间，数据库服务器将发送的提交时间与其逻辑时钟指示的时间进行比较。如果提交时间大于其逻辑时钟所指示的时间，则数据库服务器将其逻辑时间设置为反映至少与发送的提交时间反映的时间相同的时间。

18. 发明授权

US07734580B2 Readable physical storage replica and standby database system 有权
标题翻译：可读物理存储副本和备用数据库系统
公开(公告)号：US07734580B2
公开(公告)日：2010-06-08
申请号：US11818975
申请日：2007-01-29
申请人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
发明人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2035 , G06F11/2048 , G06F12/0815
摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.
摘要翻译：备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。

19. 发明申请

US20080235291A1 Readable physical storage replica and standby database system 有权
标题翻译：可读物理存储副本和备用数据库系统
公开(公告)号：US20080235291A1
公开(公告)日：2008-09-25
申请号：US11818975
申请日：2007-01-29
申请人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
发明人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2035 , G06F11/2048 , G06F12/0815
摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.
摘要翻译：备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式