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

1. 发明申请

US20050091233A1 Method and system for preserving an original table schema 失效
标题翻译：用于保留原始表模式的方法和系统
公开(公告)号：US20050091233A1
公开(公告)日：2005-04-28
申请号：US10693184
申请日：2003-10-24
申请人： Craig Friske , Regina Liu , James Ruddy , James Teng , Julie Watts
发明人： Craig Friske , Regina Liu , James Ruddy , James Teng , Julie Watts
IPC分类号： G06F7/00 , 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.
摘要翻译：本发明涉及一种用于维护支持动态表模式改变的数据库系统中的表的原始表模式的方法和系统。所述方法和系统包括在对表进行模式更改之前将表的原始表模式存储在指定的表中。通过将原始表模式存储在指定表中，可以使用包含不自描述行的表的备份副本进行数据恢复。

2. 发明申请

US20060173922A1 Method, apparatus and program storage device for managing buffers during online reorganization 有权
标题翻译：用于在线重组期间管理缓冲区的方法，装置和程序存储装置
公开(公告)号：US20060173922A1
公开(公告)日：2006-08-03
申请号：US11048341
申请日：2005-01-31
申请人： Arnold Banzon , Craig Friske , John Garth , Ka Ng , James Ruddy , Bituin Vizconde
发明人： Arnold Banzon , Craig Friske , John Garth , Ka Ng , James Ruddy , Bituin Vizconde
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： A method, apparatus and program storage device for managing buffers during online reorganization. An adaptive buffer is provided having a dynamically adjustable boundary, the adaptive buffer processes log records and pointers associated with the log records during online reorganization of a database. Adaptive switching is provided between a first and a second task during the processing of data log records and index log records during the online reorganization of the database.
摘要翻译：一种用于在线重组期间管理缓冲器的方法，装置和程序存储装置。提供具有动态可调节边界的自适应缓冲器，在数据库的在线重组期间，自适应缓冲器处理与日志记录相关联的日志记录和指针。在数据库的在线重组期间处理数据日志记录和索引日志记录期间，在第一和第二任务之间提供自适应切换。

3. 发明申请

US20060173938A1 Method, apparatus and program stroage device for determining an optimal number of tasks during reorganization of a database system with memory and processor constraints 有权
标题翻译：用于在具有存储器和处理器约束的数据库系统重组期间确定任务的最佳数量的方法，装置和程序选通装置
公开(公告)号：US20060173938A1
公开(公告)日：2006-08-03
申请号：US11047955
申请日：2005-01-31
申请人： Arnold Banzon , Craig Friske , John Garth , Ka Ng , James Ruddy , Bituin Vizconde
发明人： Arnold Banzon , Craig Friske , John Garth , Ka Ng , James Ruddy , Bituin Vizconde
IPC分类号： G06F12/00
CPC分类号： G06F9/5066
摘要： A method, apparatus and program storage device for determining an optimal number of tasks during reorganization of a database system with memory and processor constraints. The reorganization system identifies memory constraints, identifies processing capabilities and determines a number of reorganization processes and a combination of reorganization processes that provides a minimum reorganization time based upon the identified memory and processing constraints. The identified memory and processing capabilities identify a domain representing a set of rules applicable to the identified memory and processing capabilities. The set of rules of the identified domain are applied to determine an optimal number and combination of reorganization processes that minimizes a reorganization time.
摘要翻译：一种用于在具有存储器和处理器约束的数据库系统重组期间确定任务的最佳数量的方法，装置和程序存储装置。重组系统识别内存约束，识别处理能力，并确定重组过程的数量以及根据所识别的内存和处理约束提供最小重组时间的重组流程的组合。所识别的存储器和处理能力标识表示适用于所识别的存储器和处理能力的一组规则的域。应用所识别域的一组规则来确定最小化重组时间的最优数量和重组过程的组合。

4. 发明授权

US07308456B2 Method and apparatus for building one or more indexes on data concurrent with manipulation of data 失效
标题翻译：用于在数据操作同时构建一个或多个数据索引的方法和装置
公开(公告)号：US07308456B2
公开(公告)日：2007-12-11
申请号：US10248131
申请日：2002-12-19
申请人： Craig Alan Friske , John Marland Garth , Christina Marie Lee , James Ruddy
发明人： Craig Alan Friske , John Marland Garth , Christina Marie Lee , James Ruddy
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , G06F17/30368 , Y10S707/99943
摘要： One or more indexes are built on data (concurrent with manipulation of data) wherein the index build operation is done without restricting the manipulation of data. The index is brought to consistency with the data based upon processing recovery log records to simulate index manipulations during data insert, update, or delete operations.
摘要翻译：一个或多个索引基于数据（与数据的操纵并发），其中完成索引构建操作而不限制数据的操纵。使索引与基于处理恢复日志记录的数据保持一致，以模拟数据插入，更新或删除操作期间的索引操作。

5. 发明申请

US20070143313A1 Peephole DBMS reorganization allowing concurrent data manipulation 失效
标题翻译： Peephole DBMS重组允许并发数据操作
公开(公告)号：US20070143313A1
公开(公告)日：2007-06-21
申请号：US11313117
申请日：2005-12-19
申请人： Curt Cotner , James Ruddy
发明人： Curt Cotner , James Ruddy
IPC分类号： G06F7/00
CPC分类号： G06F17/30339 , Y10S707/99931 , Y10S707/99942
摘要： A method, apparatus and program storage device readable by a computer tangibly embodying a program of instructions executable by the computer is provided for reorganization of database data. The computer database reorganization method reorganizes one set of database data blocks at a time, allowing concurrent data manipulation. Method identifies a set of data blocks for reorganization in a sliding peephole mode, re-orders the set of data blocks and replaces the original set of data blocks with the re-ordered set of data blocks, if possible. Preferred embodiments include an overlapping peephole method, which chooses, for each set of data block to be reorganized, a next succeeding set of data blocks plus an overlap segment, wherein the overlap segment includes a set of empty pages other than intentionally specified free pages, and the overlap segment is a subset of the preceding set of data blocks.
摘要翻译：提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。方法识别一组用于在滑动窥视模式中进行重组的数据块，如果可能，重新命令该组数据块并用重新排序的数据块集替换原始数据块集合。优选实施例包括重叠窥视孔方法，其对于要重新组织的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页，并且重叠段是前面的数据块集合的子集。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式