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

1. 发明授权

US07188124B2 Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure 失效
标题翻译：用于恢复指定一个或多个表空间的丢弃数据库表的方法，系统，计算机产品，使用丢弃的表历史数据结构恢复正在还原的表空间
公开(公告)号：US07188124B2
公开(公告)日：2007-03-06
申请号：US10718009
申请日：2003-11-19
申请人： Matthew Albert Huras , Dale M. McInnis , Effi Ofer , Michael J. Winer , Roger Luo Q. Zheng
发明人： Matthew Albert Huras , Dale M. McInnis , Effi Ofer , Michael J. Winer , Roger Luo Q. Zheng
IPC分类号： G06F17/30 , G06F7/00 , G06F11/00
CPC分类号： G06F17/30595 , Y10S707/99931 , Y10S707/99943 , Y10S707/99953
摘要： A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table definition attributes are stored for the dropped table in a data structure and the table is dropped. Upon receiving a request to restore a table space from the one or more specified table spaces, each of the one or more tables in the table space being restored is recovered using the data structure.
摘要翻译：提供了一种用于恢复丢弃表的技术。在从指定的一个或多个表空间中删除一个或多个表之前指定一个或多个表空间。当要从一个或多个指定的表空间中删除表时，会在数据结构中存储表标识符，时间戳和表定义属性，并删除表。在从一个或多个指定的表空间接收到恢复表空间的请求时，使用数据结构恢复正在还原的表空间中的一个或多个表中的每一个。

2. 发明授权

US07499954B2 Consistent reintegration of a failed primary instance 失效
标题翻译：失败的主要实例的一致重新整合
公开(公告)号：US07499954B2
公开(公告)日：2009-03-03
申请号：US10978548
申请日：2004-11-01
申请人： Kevin J. Cherkauer , Scott D. Lashley , Steven R. Pearson , Effi Ofer , Xun Xue , Roger L. Q. Zheng
发明人： Kevin J. Cherkauer , Scott D. Lashley , Steven R. Pearson , Effi Ofer , Xun Xue , Roger L. Q. Zheng
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/1662 , Y10S707/99953
摘要： A method and system are provided for providing a consistent reintegration of a failed primary instance as a new secondary instance with implementation of truncation of log records. Upon failure of a primary instance, a secondary instance may be reassigned as the new primary instance. Prior to reintegration, any portion of the database log of the failed primary that is after the log position of the new primary instance may be truncated, followed by a comparison of the log positions of both the new primary instance and the new secondary instance. In limited circumstances, the truncation of the log data generated by the failed primary instance after the point of failure is possible, and supports reintegration of the failed primary as a new secondary instance with limited overhead.
摘要翻译：提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。在主实例失败时，可以将辅助实例重新分配为新的主实例。在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的任何部分，然后比较新的主实例和新的辅助实例的日志位置。在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

3. 发明申请

US20060136686A1 Log shipping data replication with parallel log writing and log shipping at the primary site 失效
公开(公告)号：US20060136686A1
公开(公告)日：2006-06-22
申请号：US11021002
申请日：2004-12-22
申请人： Kevin Cherkauer , Scott Lashley , Dale McInnis , Effi Ofer , Steven Pearson
发明人： Kevin Cherkauer , Scott Lashley , Dale McInnis , Effi Ofer , Steven Pearson
IPC分类号： G06F12/00
CPC分类号： G06F11/2097 , G06F11/1451 , G06F11/1471 , G06F11/2028 , G06F2201/80 , Y10S707/99953 , Y10S707/99955
摘要： A log-shipping data replication system employs a primary server coupled to a standby server. In operation, the primary server concurrently flushes log data at the primary server and transmits the same log data from the primary server to the standby server. The primary server further transmits at least one buffer flush boundary indication to the standby server indicating the flushing status of the log data at the primary server. The standby server processes the log data as a function of receiving the log data from the primary server, and/or receiving the at least one buffer flush boundary indication from the primary server.

4. 发明申请

US20060095478A1 Consistent reintegration a failed primary instance 失效
标题翻译：重新整合失败的主要实例
公开(公告)号：US20060095478A1
公开(公告)日：2006-05-04
申请号：US10978548
申请日：2004-11-01
申请人： Kevin Cherkauer , Scott Lashley , Steven Pearson , Effi Ofer , Xun Xue , Roger Zheng
发明人： Kevin Cherkauer , Scott Lashley , Steven Pearson , Effi Ofer , Xun Xue , Roger Zheng
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/1662 , Y10S707/99953
摘要： A method and system are provided for providing a consistent reintegration of a failed primary instance as a new secondary instance with implementation of truncation of log records. Upon failure of a primary instance, a secondary instance may be reassigned as the new primary instance. Prior to reintegration, any portion of the database log of the failed primary that is after the log position of the new primary instance may be truncated, followed by a comparison of the log positions of both the new primary instance and the new secondary instance. In limited circumstances, the truncation of the log data generated by the failed primary instance after the point of failure is possible, and supports reintegration of the failed primary as a new secondary instance with limited overhead.
摘要翻译：提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。在主实例失败时，可以将辅助实例重新分配为新的主实例。在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的数据库日志的任何部分，然后比较新的主实例和新的辅助实例的日志位置。在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

5. 发明授权

US06684225B1 Dropped database table recovery 失效
标题翻译：删除数据库表恢复
公开(公告)号：US06684225B1
公开(公告)日：2004-01-27
申请号：US09626673
申请日：2000-07-27
申请人： Matthew Albert Huras , Dale M. McInnis , Effi Ofer , Michael J. Winer , Roger Luo Q. Zheng
发明人： Matthew Albert Huras , Dale M. McInnis , Effi Ofer , Michael J. Winer , Roger Luo Q. Zheng
IPC分类号： G06F1200
CPC分类号： G06F17/30595 , Y10S707/99931 , Y10S707/99943 , Y10S707/99953
摘要： A database management system having a dropped table recovery flag. If the dropped table recovery flag is on at the time that a table is dropped, an entry will be made in a dropped table history file. The dropped table history file contains a timestamp of the time of table drop, a unique dropped table identifier, and table definition information. The system includes a command to permit the table-space of a dropped table to be restored and rolled forward to the point of the dropped table drop. The restored and rolled forward dropped table data is written to a flat file. The flat file data is loaded into a recreated table in the current table space to recover the dropped table.
摘要翻译：具有丢弃表恢复标志的数据库管理系统。如果删除表恢复标志在表被删除的时候打开，则会在丢弃的表历史文件中创建一个条目。丢弃的表历史文件包含表删除时间的时间戳，唯一的删除表标识符和表定义信息。系统包括一个命令，用于允许恢复已删除的表的表空间并向前滚动到丢弃的表的下降点。恢复并滚动的向前丢弃的表数据将写入一个平面文件。平面文件数据被加载到当前表空间中的重新创建的表中以恢复丢弃的表。

6. 发明授权

US07529783B2 Log shipping data replication with parallel log writing and log shipping at the primary site 失效
标题翻译：在主站点上记录并行日志写入和日志传送的日志传送数据复制
公开(公告)号：US07529783B2
公开(公告)日：2009-05-05
申请号：US11021002
申请日：2004-12-22
申请人： Kevin J. Cherkauer , Scott D. Lashley , Dale M. McInnis , Effi Ofer , Steven R. Pearson
发明人： Kevin J. Cherkauer , Scott D. Lashley , Dale M. McInnis , Effi Ofer , Steven R. Pearson
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/1451 , G06F11/1471 , G06F11/2028 , G06F2201/80 , Y10S707/99953 , Y10S707/99955
摘要： A log-shipping data replication system employs a primary server coupled to a standby server. In operation, the primary server concurrently flushes log data at the primary server and transmits the same log data from the primary server to the standby server. The primary server further transmits at least one buffer flush boundary indication to the standby server indicating the flushing status of the log data at the primary server. The standby server processes the log data as a function of receiving the log data from the primary server, and/or receiving the at least one buffer flush boundary indication from the primary server.
摘要翻译：日志传送数据复制系统使用耦合到备用服务器的主服务器。在运行时，主服务器同时刷新主服务器上的日志数据，并将相同的日志数据从主服务器发送到备用服务器。主服务器还向备用服务器发送至少一个缓冲区清除边界指示，指示主服务器上日志数据的刷新状态。备用服务器将日志数据作为从主服务器接收日志数据和/或从主服务器接收至少一个缓冲区清除边界指示的功能。

7. 发明申请

US20060218204A1 Log stream validation in log shipping data replication systems 审中-公开
标题翻译：日志传送数据复制系统中的日志流验证
公开(公告)号：US20060218204A1
公开(公告)日：2006-09-28
申请号：US11089993
申请日：2005-03-25
申请人： Effi Ofer , David Mooney , Steven Pearson , Xun Xue , Kevin Cherkauer
发明人： Effi Ofer , David Mooney , Steven Pearson , Xun Xue , Kevin Cherkauer
IPC分类号： G06F17/30
CPC分类号： G06F11/202 , G06F11/1471 , G06F11/2097
摘要： A data processing implemented method and system and article of manufacture are provided for determining compatibility between a primary instance and a standby instance, the primary instance being characterized by a first log position indicator and a primary log chain fingerprint (FP-P) and the secondary instance being characterized by a second log position indicator and a secondary log chain fingerprint (FP-S); the FP-P and the FP-S each uniquely identifying a prescribed history of an associated data processing system. The method, for example, includes a series of steps comprising: comparing the first log position indicator with the second log position indicator to determine compatibility between the secondary instance and the primary instance; comparing the primary log chain fingerprint (FP-P) with the secondary log chain fingerprint (FP-S) to determine compatibility between the secondary instance and the primary instance; and indicating that the secondary instance is compatible with the primary instance when both of the above comparisons determine compatibility.
摘要翻译：提供了一种数据处理实现的方法和系统及制品，用于确定主实例和备用实例之间的兼容性，主要实例由第一对数位置指示符和主日志链指纹（FP-P）表征，次要其特征在于第二对数位置指示器和辅助对数链指纹（FP-S）; FP-P和FP-S每个唯一地标识相关联的数据处理系统的规定历史。该方法例如包括一系列步骤，包括：将第一日志位置指示符与第二日志位置指示符进行比较，以确定辅助实例与主实例之间的兼容性; 将主日志链指纹（FP-P）与辅助日志链指纹（FP-S）进行比较，以确定辅助实例与主实例之间的兼容性; 并且当上述两个比较确定兼容性时，指示辅助实例与主实例兼容。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式