-
1.发明授权High performance recover/build index system by unloading database files in parallel 失效高性能恢复/构建索引系统通过并行卸载数据库文件
公开(公告)号：US5842208A
公开(公告)日：1998-11-24
申请号：US838647
申请日：1997-04-09
CPC分类号： G06F17/30321 , G06F17/3061 , Y10S707/99932 , Y10S707/99933 , Y10S707/99937 , Y10S707/99942
摘要： A method, apparatus, and article of manufacture for a computer implemented recover/build index system. The recover/build index system builds a database index for a database file by scanning partitions of the database file in parallel to retrieve key values and their associated record identifier (rid) values. The recover/build index system then sorts the scanned key/rid values for each partition in parallel. Next, the recover/build index system performs one or more merges on the sorted key/rid values from all of the partitions to generate a single key/rid value stream. Finally, the recover/build index system builds the index using the single key/rid value stream.
摘要翻译： 计算机实现的恢复/构建索引系统的方法，装置和制品。 recover / build index系统通过并行扫描数据库文件的分区来检索数据库文件的数据库索引，以检索密钥值及其关联的记录标识符（删除）值。 然后，恢复/构建索引系统并行排列每个分区的扫描密钥/排除值。 接下来，恢复/构建索引系统对来自所有分区的排序的关键点/排除值执行一个或多个合并以生成单个关键点/排除值流。 最后，恢复/构建索引系统使用单个键/值返回值构建索引。
-
公开(公告)号：US5873091A
公开(公告)日：1999-02-16
申请号：US848006
申请日：1997-04-28
申请人： John Marland Garth , Koshy John , James Alan Ruddy , David Ray Schwartz , Bryan Frederick Smith
发明人： John Marland Garth , Koshy John , James Alan Ruddy , David Ray Schwartz , Bryan Frederick Smith
IPC分类号： G06F17/30 , G06P15/163
CPC分类号： G06F17/30569 , Y10S707/99937 , Y10S707/99938 , Y10S707/99942 , Y10S707/99943 , Y10S707/99953
摘要： A multiprocessing system forms a data structure, such as by loading reorganizing, or recovering, while concurrently collecting various statistics about the data structure. The data structure may comprise tables and/or indices, for example. A first processing unit forms the data structure by assimilating data from one or more data sources into data rows, storing the rows in a buffer, and copying the rows from the buffer to the data structure. Concurrently with the forming step, the same or a second processing unit retrieves the rows from the buffer and applies a predetermined analysis to the rows to formulate statistics regarding the data structure.
摘要翻译： 多处理系统通过加载重组或恢复来形成数据结构，同时收集有关数据结构的各种统计信息。 数据结构可以包括例如表和/或索引。 第一处理单元通过将来自一个或多个数据源的数据同化为数据行来形成数据结构，将行存储在缓冲器中，并将行从缓冲器复制到数据结构。 与形成步骤同时，相同或第二处理单元从缓冲器检索行并对行进行预定分析以制定关于数据结构的统计。
-
3.发明授权Method of estimating an amount of changed data over plurality of intervals of time measurements 失效在多个时间测量间隔中估计改变数据量的方法公开(公告)号：US06535870B1
公开(公告)日：2003-03-18
申请号：US09501486
申请日：2000-02-09
IPC分类号： G06F1730
CPC分类号： G06F17/30368 , Y10S707/99932 , Y10S707/99933 , Y10S707/99936
摘要： A technique for identifying changes in a data store connected to a computer. Initially, one or more interval changes are measured. Each interval change indicates an amount of change in the data store at an interval. Next, a data store change is estimated that indicates an amount of change in the data store across all of the intervals using each interval change.
摘要翻译： 用于识别连接到计算机的数据存储器中的变化的技术。 最初，测量一个或多个间隔变化。 每个间隔变化以间隔表示数据存储中的变化量。 接下来，估计数据存储改变，其指示使用每个间隔变化的所有间隔的数据存储中的变化量。
-
4.发明授权Technique for determining an optimal number of tasks in a parallel database loading system with memory constraints 失效用于确定具有存储器约束的并行数据库加载系统中任务的最佳数量的技术公开(公告)号：US07058952B1
公开(公告)日：2006-06-06
申请号：US09501493
申请日：2000-02-09
IPC分类号： G06F9/46
CPC分类号： G06F17/30321 , G06F9/5016 , Y10S707/99931 , Y10S707/99932 , Y10S707/99937 , Y10S707/99953
摘要： A method, apparatus, and article of manufacture of a computer-implemented parallel database loading system. The optimum number of tasks to be processed by the system is determined by identifying the memory constraints of the system, by identifying available processing capabilities, and by determining a number of load and sort processes to be started in parallel based on the identified memory constraints and processing capabilities. Optimizing the number of load and sort processes increases overall system processing speed.
摘要翻译： 计算机实现的并行数据库加载系统的方法，装置和制造。 通过识别系统的存储器约束，通过识别可用的处理能力以及通过基于所识别的存储器约束确定要并行启动的负载和排序过程的数量来确定系统要处理的最佳数量的任务;以及 处理能力。 优化加载和分类过程的数量会增加整体系统处理速度。
-
5.发明授权Technique for establishing a point of consistency in a parallel database loading system 失效在并行数据库加载系统中建立一致性点的技术公开(公告)号：US06678701B1
公开(公告)日：2004-01-13
申请号：US09477922
申请日：2000-01-05
IPC分类号： G06F1730
CPC分类号： G06F17/30371 , G06F17/30445 , G06F2201/80 , G06F2201/82 , Y10S707/99938 , Y10S707/99952
摘要： A technique for loading data into a data store connected to a computer. Under control of a main process, multiple agent load processes are started for loading data in parallel. The main process awaits receipt of a checkpoint signal from each agent load process. Then, upon receiving the checkpoint signal from each load process, the main process performs a checkpoint.
摘要翻译： 将数据加载到连接到计算机的数据存储中的一种技术。 在主流程的控制下，启动多个代理负载进程并行加载数据。 主流程等待从每个代理加载过程接收到检查点信号。 然后，在从每个加载处理接收到检查点信号时，主进程执行检查点。
-
公开(公告)号：US06272486B1
公开(公告)日：2001-08-07
申请号：US09061596
申请日：1998-04-16
IPC分类号： G06F1730
CPC分类号： G06F17/30321 , G06F9/5016 , Y10S707/99931 , Y10S707/99932 , Y10S707/99937 , Y10S707/99953
摘要： A method, apparatus, and article of manufacture for a computer-implemented building indexes system. Indexes are built for a database that is stored in a data storage device coupled to a computer. An amount of available memory is determined. An amount of memory for use in transmitting data between extract, sort, and index build tasks is determined. Then, a number of sort tasks to be used to build indexes is determined based on the determined amount of available memory, the determined amount of memory for use in transmitting data between tasks, and task memory requirements.
摘要翻译： 一种用于计算机实现的建筑物索引系统的方法，装置和制品。 索引是为存储在耦合到计算机的数据存储设备中的数据库构建的。 确定可用内存量。 确定用于在提取，分类和索引构建任务之间传输数据的存储器量。 然后，基于所确定的可用内存量，用于在任务之间传送数据的确定的存储量以及任务存储器需求来确定要用于构建索引的多个排序任务。
-
公开(公告)号：US6125370A
公开(公告)日：2000-09-26
申请号：US53246
申请日：1998-04-01
申请人： Daniel Keith Courter , Paramesh Sampatrai Desai , Craig Alan Friske , John Marland Garth , Kevin Daniel Gougherty , Laura Michiko Kunioka-Weis , David Elmer Raiman , James Alan Ruddy , Julie Ann Watts , Kathryn Ruth Zeidenstein
发明人： Daniel Keith Courter , Paramesh Sampatrai Desai , Craig Alan Friske , John Marland Garth , Kevin Daniel Gougherty , Laura Michiko Kunioka-Weis , David Elmer Raiman , James Alan Ruddy , Julie Ann Watts , Kathryn Ruth Zeidenstein
CPC分类号： G06F17/30336 , G06F17/30312 , G06F17/30584 , Y10S707/99933 , Y10S707/99935 , Y10S707/99938 , Y10S707/99943 , Y10S707/99953
摘要： A method, apparatus, and article of manufacture for a computer-implemented repartitioning system. Data is repartitioned in a database stored on a data storage device connected to a computer. First, it is detected that a partitioning scheme for the data has been altered. Next, partitions that would be affected by the altered partitioning scheme are identified. Then, the identified partitions are reorganized based on the altered partitioning scheme.
摘要翻译： 一种用于计算机实现的重新分配系统的方法，装置和制品。 数据在存储在连接到计算机的数据存储设备上的数据库中重新分区。 首先，检测到数据的分割方案已被改变。 接下来，将识别受改变的分区方案影响的分区。 然后，基于改变的分区方案重新组织识别的分区。
-
公开(公告)号：US06269375B1
公开(公告)日：2001-07-31
申请号：US09053356
申请日：1998-04-01
IPC分类号： G06F1130
CPC分类号： G06F17/30339 , Y10S707/99942
摘要： A method, apparatus, and article of manufacture for a computer implemented rebalancing system. Partitioned data is rebalanced in a database stored on a data storage device connected to a computer. Range values are redefined for each partition. Next, the data is reordered into the redefined ranges for the partitions.
摘要翻译： 一种用于计算机实现的重新平衡系统的方法，装置和制品。 分割的数据在存储在连接到计算机的数据存储设备上的数据库中重新平衡。 为每个分区重新定义范围值。 接下来，将数据重新排序到分区的重新定义的范围内。
-
9.发明授权公开(公告)号：US07603336B2
公开(公告)日：2009-10-13
申请号：US11313117
申请日：2005-12-19
申请人： Curt Lee Cotner , James Alan Ruddy
发明人： Curt Lee Cotner , James Alan 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. The method 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.
摘要翻译： 提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。 计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。 方法识别用于在滑动窥视孔模式中进行重组的一组数据块，重新命令该组数据块，并用重新排列的数据块集替换原始数据块集合。 该方法包括重叠窥视孔方法，其针对要重组的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页， 并且重叠段是前面的数据块集合的子集。
-
10.发明授权System to delegate virtual storage access method related file operations to a storage server using an in-band RPC mechanism 有权系统将使用带内RPC机制的虚拟存储访问方法相关文件操作委派给存储服务器公开(公告)号：US07882202B2
公开(公告)日：2011-02-01
申请号：US12060501
申请日：2008-04-01
申请人： Guillermo Alejandro Alvarez , David Darden Chambliss , Prashant Pandey , Vijayshankar Raman , James Alan Ruddy , Garret Frederick Swart , Harry Morris Yudenfriend
发明人： Guillermo Alejandro Alvarez , David Darden Chambliss , Prashant Pandey , Vijayshankar Raman , James Alan Ruddy , Garret Frederick Swart , Harry Morris Yudenfriend
IPC分类号： G06F15/16
CPC分类号： H04L63/102 , H04L67/1097
摘要： A method is disclosed that places data-intensive subprocesses in close physical and logical proximity to the facility responsible for storing the data, so that high efficiencies at reduced cost are achieved. In one specific example, new computer programs, termed adjuncts, are added and placed in a logical partition on a storage facility so that they can be invoked using appropriate commands issued on the I/O channel. Further, programs or changes are added to existing programs on the host machine, wherein such programs or changes discover the function extensions and invoke them to perform data processing.
摘要翻译： 公开了一种将数据密集型子处理器紧密地物理和逻辑地接近负责存储数据的设施的方法，从而实现了降低成本的高效率。 在一个具体示例中，称为附件的新计算机程序被添加并放置在存储设备上的逻辑分区中，使得可以使用在I / O通道上发出的适当命令来调用它们。 此外，将程序或更改添加到主机上的现有程序，其中这些程序或改变发现功能扩展并调用它们来执行数据处理。
-
-
-
-
-
-
-
-
-
搜索结果
17 条记录 (耗时 0.03 秒)
