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

1. 发明授权

US06535870B1 Method of estimating an amount of changed data over plurality of intervals of time measurements 失效
标题翻译：在多个时间测量间隔中估计改变数据量的方法
公开(公告)号：US06535870B1
公开(公告)日：2003-03-18
申请号：US09501486
申请日：2000-02-09
申请人： Craig Alan Friske , John Marland Garth , James Alan Ruddy
发明人： Craig Alan Friske , John Marland Garth , James Alan Ruddy
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.
摘要翻译：用于识别连接到计算机的数据存储器中的变化的技术。最初，测量一个或多个间隔变化。每个间隔变化以间隔表示数据存储中的变化量。接下来，估计数据存储改变，其指示使用每个间隔变化的所有间隔的数据存储中的变化量。

2. 发明授权

US07058952B1 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
申请人： John Marland Garth , James Alan Ruddy , Akira Shibamiya
发明人： John Marland Garth , James Alan Ruddy , Akira Shibamiya
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.
摘要翻译：计算机实现的并行数据库加载系统的方法，装置和制造。通过识别系统的存储器约束，通过识别可用的处理能力以及通过基于所识别的存储器约束确定要并行启动的负载和排序过程的数量来确定系统要处理的最佳数量的任务;以及处理能力。优化加载和分类过程的数量会增加整体系统处理速度。

3. 发明授权

US06678701B1 Technique for establishing a point of consistency in a parallel database loading system 失效
标题翻译：在并行数据库加载系统中建立一致性点的技术
公开(公告)号：US06678701B1
公开(公告)日：2004-01-13
申请号：US09477922
申请日：2000-01-05
申请人： John Marland Garth , James Alan Ruddy
发明人： John Marland Garth , James Alan Ruddy
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.
摘要翻译：将数据加载到连接到计算机的数据存储中的一种技术。在主流程的控制下，启动多个代理负载进程并行加载数据。主流程等待从每个代理加载过程接收到检查点信号。然后，在从每个加载处理接收到检查点信号时，主进程执行检查点。

4. 发明授权

US06272486B1 Determining the optimal number of tasks for building a database index 失效
标题翻译：确定构建数据库索引的最佳任务数
公开(公告)号：US06272486B1
公开(公告)日：2001-08-07
申请号：US09061596
申请日：1998-04-16
申请人： John Marland Garth , James Alan Ruddy
发明人： John Marland Garth , James Alan Ruddy
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.
摘要翻译：一种用于计算机实现的建筑物索引系统的方法，装置和制品。索引是为存储在耦合到计算机的数据存储设备中的数据库构建的。确定可用内存量。确定用于在提取，分类和索引构建任务之间传输数据的存储器量。然后，基于所确定的可用内存量，用于在任务之间传送数据的确定的存储量以及任务存储器需求来确定要用于构建索引的多个排序任务。

5. 发明授权

US6125370A Repartitioning data 失效
标题翻译：重新分配数据
公开(公告)号：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
IPC分类号： G06F17/00 , G06F17/30
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.
摘要翻译：一种用于计算机实现的重新分配系统的方法，装置和制品。数据在存储在连接到计算机的数据存储设备上的数据库中重新分区。首先，检测到数据的分割方案已被改变。接下来，将识别受改变的分区方案影响的分区。然后，基于改变的分区方案重新组织识别的分区。

6. 发明授权

US5873091A System for data structure loading with concurrent statistical analysis 失效
标题翻译：数据结构加载系统，并行统计分析
公开(公告)号：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.
摘要翻译：多处理系统通过加载重组或恢复来形成数据结构，同时收集有关数据结构的各种统计信息。数据结构可以包括例如表和/或索引。第一处理单元通过将来自一个或多个数据源的数据同化为数据行来形成数据结构，将行存储在缓冲器中，并将行从缓冲器复制到数据结构。与形成步骤同时，相同或第二处理单元从缓冲器检索行并对行进行预定分析以制定关于数据结构的统计。

7. 发明授权

US5842208A High performance recover/build index system by unloading database files in parallel 失效
标题翻译：高性能恢复/构建索引系统通过并行卸载数据库文件
公开(公告)号：US5842208A
公开(公告)日：1998-11-24
申请号：US838647
申请日：1997-04-09
申请人： Ted E. Blank , John Marland Garth , James Alan Ruddy , Bryan Frederick Smith
发明人： Ted E. Blank , John Marland Garth , James Alan Ruddy , Bryan Frederick Smith
IPC分类号： G06F17/30 , G06F7/00
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系统通过并行扫描数据库文件的分区来检索数据库文件的数据库索引，以检索密钥值及其关联的记录标识符（删除）值。然后，恢复/构建索引系统并行排列每个分区的扫描密钥/排除值。接下来，恢复/构建索引系统对来自所有分区的排序的关键点/排除值执行一个或多个合并以生成单个关键点/排除值流。最后，恢复/构建索引系统使用单个键/值返回值构建索引。

8. 发明授权

US07181481B2 System and method for concurrently reorganizing logically related LOB table spaces 有权
标题翻译：用于同时重组逻辑相关的LOB表空间的系统和方法
公开(公告)号：US07181481B2
公开(公告)日：2007-02-20
申请号：US10687597
申请日：2003-10-20
申请人： Julie Chen , William James Franklin , John Marland Garth , Li-Mey Lee , John Richard Lyle , Frances Hwa Villafuerte , Jay A. Yothers
发明人： Julie Chen , William James Franklin , John Marland Garth , Li-Mey Lee , John Richard Lyle , Frances Hwa Villafuerte , Jay A. Yothers
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F17/30318 , Y10S707/99956
摘要： A base table and related auxiliary table spaces are reorganized concurrently via a database utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets. The original data sets are switched with the newly built shadow data sets including the LOB shadows.
摘要翻译：通过数据库实用程序同时重组基表和相关辅助表空间。数据库实用程序确定哪些辅助表与基表相关，并在实用程序的相同调用中自动包括其各自的辅助表。重组是通过分配的阴影数据集执行的。原始数据集与新建的阴影数据集（包括LOB阴影）切换。

9. 发明授权

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.
摘要翻译：一个或多个索引基于数据（与数据的操纵并发），其中完成索引构建操作而不限制数据的操纵。使索引与基于处理恢复日志记录的数据保持一致，以模拟数据插入，更新或删除操作期间的索引操作。

10. 发明授权

US6038569A System for data structure loading with concurrent image copy 失效
标题翻译：用于并行映像副本的数据结构加载系统
公开(公告)号：US6038569A
公开(公告)日：2000-03-14
申请号：US798532
申请日：1997-02-10
申请人： Thomas Abel Beavin , John Marland Garth , Laura Michiko Kunioka-Weis , James Zu-Chia Teng
发明人： Thomas Abel Beavin , John Marland Garth , Laura Michiko Kunioka-Weis , James Zu-Chia Teng
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , Y10S707/915 , Y10S707/99937 , Y10S707/99943 , Y10S707/99945 , Y10S707/99954
摘要： Data is loaded to a data structure while an image copy of the data structure is concurrently formed. After data records are obtained from one or more data sources, each of the data records is associated with one of multiple pages. As each page is completed, it is written to a primary data structure. Also upon completion of each page in the primary data structure, concurrently with storage of the page in the primary data structure, an image copy of the page is made in an image copy data set. Partially or completely failed primary data structures may also be restored using image copies made according to the invention. Timestamps mark the time at which each page are made; image copy pages include the same timestamp as their respective primary pages. Upon detecting a data structure failure, each page of the image copy is sequentially reviewed. For each image page being reviewed, the page's timestamp is compared with the timestamp of the corresponding page from the primary data structure. The page is copied from the image copy to the primary data structure only if the timestamp comparison indicates that the image page is more recent than the page from the primary data structure.
摘要翻译：数据被加载到数据结构，同时形成数据结构的图像副本。在从一个或多个数据源获得数据记录之后，每个数据记录与多个页面之一相关联。当每个页面完成时，它被写入主数据结构。此外，在主数据结构中的每个页面完成时，与主数据结构中的页面的存储同时，在图像复制数据集中进行页面的图像副本。也可以使用根据本发明制造的图像副本来恢复部分或完全失败的主数据结构。时间戳标记每个页面的时间; 图像复制页面包含与其各自的主页面相同的时间戳。在检测到数据结构故障时，依次审查图像副本的每一页。对于正在审核的每个图像页面，将页面的时间戳与主数据结构中相应页面的时间戳进行比较。只有当时间戳比较指示图像页面比主数据结构中的页面更新时，页面才从图像副本复制到主数据结构。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式