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

1. 发明申请

US20050165798A1 Shared scans utilizing query monitor during query execution to improve buffer cache utilization across multi-stream query environments 失效
标题翻译：在查询执行期间使用查询监视器进行共享扫描，以提高多流查询环境中的缓冲区缓存利用率
公开(公告)号：US20050165798A1
公开(公告)日：2005-07-28
申请号：US10763752
申请日：2004-01-22
申请人： Kevin Cherkauer , Scott Lashley , Jason Young
发明人： Kevin Cherkauer , Scott Lashley , Jason Young
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30457 , G06F17/3046 , Y10S707/99933
摘要： A system for data base management using memory devices holding a database containing tables of data occupying extents. A database engine reviews each query to determine an extents list of extents containing the data needed by that said query. A query monitor then re-orders the extents lists so that extents are retreived and stored in a buffer cache for more efficient use when executing the queries. The database engine retreives needed extents from the memory devices, as ordered in the extents lists, and stores those extents in the buffer cache. The database engine then executes one or more queries on the data in the extents in the buffer cache to determine respective results.
摘要翻译：一种使用存储设备进行数据库管理的系统，该系统包含占用范围的数据库数据库。数据库引擎审查每个查询以确定包含所述查询所需的数据的区段的区域列表。然后，查询监视器重新命令扩展区列表，以便在访问缓冲区缓存区域并将其存储在缓冲区缓存中，以便在执行查询时更有效地使用。数据库引擎根据扩展区列表中的顺序从内存设备检索所需的扩展数据块，并将这些扩展区存储在缓冲区高速缓存中。数据库引擎然后对缓冲区高速缓存中的区段中的数据执行一个或多个查询，以确定相应的结果。

2. 发明申请

US20070033159A1 Query plan editor with integrated optimizer 审中-公开
标题翻译：具有集成优化器的查询计划编辑器
公开(公告)号：US20070033159A1
公开(公告)日：2007-02-08
申请号：US11195957
申请日：2005-08-03
申请人： Kevin Cherkauer
发明人： Kevin Cherkauer
IPC分类号： G06F17/30
CPC分类号： G06F16/28 , G06F16/217 , G06F16/2453
摘要： A tool and method for integrating manual instructions of a database query plan with a database optimizer. The tool may be in the form of an editor to receive manual instructions associated with selection of database objects such as tables and operations associated with the objects. The editor may consult with the database optimizer prior to submitting query plan execution instructions. The consultation may result in the optimizer providing alternatively available selections to the editor and/or a cost estimate for selected operations and/or automatic selection of operators to complete a plan that has been partially constructed or edited manually. Following completion of the query plan, the editor may submit the query plan to the optimizer for execution and/or save the plan for use in future execution(s) of the query.
摘要翻译：用于将数据库查询计划的手动指令与数据库优化器集成的工具和方法。该工具可以是编辑器的形式，以接收与数据库对象的选择相关联的手动指令，例如与对象相关联的表和操作。在提交查询计划执行指令之前，编辑器可以咨询数据库优化器。咨询可以导致优化器向编辑者提供可选择的选择和/或所选操作的成本估计和/或操作者的自动选择以完成已手动部分构建或编辑的计划。完成查询计划后，编辑者可以将查询计划提交给优化程序执行和/或保存计划以供将来执行查询。

3. 发明申请

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）进行比较，以确定辅助实例与主实例之间的兼容性; 并且当上述两个比较确定兼容性时，指示辅助实例与主实例兼容。

4. 发明申请

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.

5. 发明申请

US20060047684A1 Sending log records directly from log buffer 有权
公开(公告)号：US20060047684A1
公开(公告)日：2006-03-02
申请号：US10930556
申请日：2004-08-31
申请人： Kevin Cherkauer
发明人： Kevin Cherkauer
IPC分类号： G06F7/00
CPC分类号： G06F17/30368 , G06F11/2097 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944
摘要： Sending log records from a first system instance's log buffer to a second system instance is disclosed. Both instances may be instances of a database system. A method may create a log record within the buffer. The record contains actual log information, such as descriptions of transactions. A flag corresponding to the record is set in memory other than the buffer. The flag indicates whether the record has been sent to the second instance, and/or whether the second instance has received the record. The method may further embed non-log information within a simulated log record having a format identical to the log record's format. The non-log information, which may not include actual transactions to be committed, is embedded in a body section of the simulated record. At least one otherwise unused bit of a metadata section of the simulated record is set, indicating that the simulated record is simulated.

6. 发明申请

US20070294219A1 SHARED SCANS UTILIZING QUERY MONITOR DURING QUERY EXECUTION TO IMPROVE BUFFER CACHE UTILIZATION ACROSS MULTI-STREAM QUERY ENVIRONMENTS 失效
标题翻译：共享扫描器在查询执行期间使用查询监视器，以提高缓冲区高速缓存在多流道查询环境中的使用
公开(公告)号：US20070294219A1
公开(公告)日：2007-12-20
申请号：US11846161
申请日：2007-08-28
申请人： Kevin Cherkauer , Scott Lashley , Jason Young
发明人： Kevin Cherkauer , Scott Lashley , Jason Young
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , G06F17/3046 , Y10S707/99933
摘要： A system for data base management using memory devices holding a database containing tables of data occupying extents. A database engine reviews each query to determine an extents list of extents containing the data needed by that said query. A query monitor then re-orders the extents lists so that extents are retrieved and stored in a buffer cache for more efficient use when executing the queries. The database engine retrieves needed extents from the memory devices, as ordered in the extents lists, and stores those extents in the buffer cache. The database engine then executes one or more queries on the data in the extents in the buffer cache to determine respective results.
摘要翻译：一种使用存储设备进行数据库管理的系统，该系统包含占用范围的数据库数据库。数据库引擎审查每个查询以确定包含所述查询所需的数据的区段的区域列表。然后，查询监视器重新命令扩展区列表，以便检索区域并将其存储在缓冲区高速缓存中，以便在执行查询时更有效地使用。数据库引擎从存储器设备中检索所需的扩展区，按区段列表中的顺序进行检索，并将这些扩展区存储在缓冲区高速缓存中。数据库引擎然后对缓冲区高速缓存中的区段中的数据执行一个或多个查询，以确定相应的结果。

7. 发明申请

US20060101083A1 System for deterministic database recovery time 有权
标题翻译：确定性数据库恢复时间的系统
公开(公告)号：US20060101083A1
公开(公告)日：2006-05-11
申请号：US10972160
申请日：2004-10-21
申请人： Kevin Cherkauer , Scott Lashley , Roger Raphael , Jason Young
发明人： Kevin Cherkauer , Scott Lashley , Roger Raphael , Jason Young
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F11/3419 , G06F11/3452 , G06F17/30371 , G06F2201/80
摘要： A system for limiting the amount of time for a database server to perform a crash recovery process. A maximum recovery time for the database server to perform the crash recovery process is specified. An estimated recovery time for the crash recovery process that is less than the maximum recovery time is calculated, based on at least one of a deterministic analysis of cost accumulation during prior instances of the crash recovery process or an empirical analysis of cost accumulation during regular transaction processing in the database server. The crash recovery process is then conformed to the estimated recovery time.
摘要翻译：用于限制数据库服务器执行崩溃恢复过程的时间量的系统。指定数据库服务器执行崩溃恢复过程的最大恢复时间。基于在崩溃恢复过程的先前实例期间的成本累积的确定性分析或在正常交易期间的成本累积的经验分析中的至少一个来计算小于最大恢复时间的崩溃恢复过程的估计恢复时间在数据库服务器中进行处理。然后，崩溃恢复过程符合估计的恢复时间。

8. 发明申请

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.
摘要翻译：提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。在主实例失败时，可以将辅助实例重新分配为新的主实例。在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的数据库日志的任何部分，然后比较新的主实例和新的辅助实例的日志位置。在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式