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

1. 发明授权

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阴影）切换。

2. 发明授权

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.
摘要翻译：用于识别连接到计算机的数据存储器中的变化的技术。最初，测量一个或多个间隔变化。每个间隔变化以间隔表示数据存储中的变化量。接下来，估计数据存储改变，其指示使用每个间隔变化的所有间隔的数据存储中的变化量。

3. 发明授权

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

4. 发明授权

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.
摘要翻译：将数据加载到连接到计算机的数据存储中的一种技术。在主流程的控制下，启动多个代理负载进程并行加载数据。主流程等待从每个代理加载过程接收到检查点信号。然后，在从每个加载处理接收到检查点信号时，主进程执行检查点。

5. 发明授权

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

6. 发明授权

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.
摘要翻译：数据被加载到数据结构，同时形成数据结构的图像副本。在从一个或多个数据源获得数据记录之后，每个数据记录与多个页面之一相关联。当每个页面完成时，它被写入主数据结构。此外，在主数据结构中的每个页面完成时，与主数据结构中的页面的存储同时，在图像复制数据集中进行页面的图像副本。也可以使用根据本发明制造的图像副本来恢复部分或完全失败的主数据结构。时间戳标记每个页面的时间; 图像复制页面包含与其各自的主页面相同的时间戳。在检测到数据结构故障时，依次审查图像副本的每一页。对于正在审核的每个图像页面，将页面的时间戳与主数据结构中相应页面的时间戳进行比较。只有当时间戳比较指示图像页面比主数据结构中的页面更新时，页面才从图像副本复制到主数据结构。

7. 发明授权

US5890166A Versioned-database management system in which tasks are associated with promote groups which comprise a set of parts whose changes are to be promoted 失效
标题翻译：版本化数据库管理系统，其中任务与促进组相关联，该组包括要改变其变化的一组部件
公开(公告)号：US5890166A
公开(公告)日：1999-03-30
申请号：US378311
申请日：1995-01-25
申请人： Neal Richard Eisenberg , Robert Louis Huddleston , John Marland Garth , Mary Claire Lehner , Charles Siegfried Tribolet
发明人： Neal Richard Eisenberg , Robert Louis Huddleston , John Marland Garth , Mary Claire Lehner , Charles Siegfried Tribolet
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30309 , Y10S707/99954
摘要： A versioned-data management system (VDMSMS) is provided with a method for determining candidates for promotion in association with a user task. The VDMS maintains a list of parts changed as a result of a user task, referred to as a promote group. Before performing any changes the user informs the VDMS which user task is to be associated with the changes. All parts subsequently changed are automatically placed by the VDMS in the promote group associated with the given user task. When the parts associated with a user task for a given variant level are promoted, an iterative process is performed to determine the complete set of parts that must be promoted in support of the requested promote. Initially the set includes those parts in the promote group at the given variant level. Then all the other promote groups are searched to determine whether they contain any of the parts at the given variant level that are already in this set. For any that do, the parts in those promote groups for the given variant level are added to the set of parts to be promoted.
摘要翻译：版本化数据管理系统（VDMSMS）具有与用户任务相关联的用于确定促销候选者的方法。 VDMS维护由于用户任务（被称为促销组）而更改的部件的列表。在执行任何更改之前，用户通知VDMS哪个用户任务将与更改相关联。随后更改的所有部件由VDMS自动放置在与给定用户任务相关联的促销组中。当促进与给定变体级别的用户任务相关联的部分时，执行迭代过程以确定必须被促进以支持所请求的促销的部分的完整集合。最初，该集合包括在给定变体级别的促销组中的那些部分。然后搜索所有其他促销组，以确定它们是否包含已在此组中的给定变体级别的任何部件。对于任何这样做，那些促销组中针对给定变体级别的部分被添加到要提升的部分集合中。

8. 发明授权

US06567816B1 Method, system, and program for extracting data from database records using dynamic code 失效
标题翻译：使用动态代码从数据库记录中提取数据的方法，系统和程序
公开(公告)号：US06567816B1
公开(公告)日：2003-05-20
申请号：US09520121
申请日：2000-03-07
申请人： Paramesh Sampatrai Desai , John Marland Garth
发明人： Paramesh Sampatrai Desai , John Marland Garth
IPC分类号： G06F1730
CPC分类号： G06F17/30569 , Y10S707/99942 , Y10S707/99943
摘要： Disclosed is a system, method, and program for extracting data from a record in a first format and inserting data into a record in a second format during an insert operation. A determination is made of location information for data in at least one record in at least one column in the first format involved in the insert operation from which data will be extracted and of location information for data in at least one record in at least one column in the second format involved in the insert operation into which the data extracted from a corresponding column in the first format will be inserted. For each column from which data will be extracted, the determined location information is used to generate at least one instruction to move the data in each column in the record in the first format to each corresponding column of one record in the second format. The location information of the columns in records in the first and second formats involved in the data movement operations is encoded in the at least one instruction. The instruction may be repeated for multiple records in the first format from which data will be extracted into multiple records in the second format.
摘要翻译：公开了一种用于在插入操作期间从第一格式的记录中提取数据并以第二格式将数据插入到记录中的系统，方法和程序。确定在将从其中提取数据的插入操作中涉及的第一格式的至少一列中的至少一个记录中的数据的位置信息和用于至少一列中的至少一个记录中的数据的位置信息在插入操作中涉及的第二格式中，将插入从第一格式的相应列提取的数据。对于从其提取数据的每列，使用确定的位置信息来生成至少一个指令，以将第一格式的记录中的每列中的数据移动到第二格式的一个记录的每个相应列。在数据移动操作中涉及的第一和第二格式的记录中的列的位置信息被编码在至少一个指令中。可以以第一格式的多个记录重复该指令，从而从第二格式将数据提取到多个记录中。

9. 发明授权

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.
摘要翻译：一种用于计算机实现的建筑物索引系统的方法，装置和制品。索引是为存储在耦合到计算机的数据存储设备中的数据库构建的。确定可用内存量。确定用于在提取，分类和索引构建任务之间传输数据的存储器量。然后，基于所确定的可用内存量，用于在任务之间传送数据的确定的存储量以及任务存储器需求来确定要用于构建索引的多个排序任务。

10. 发明授权

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.
摘要翻译：一种用于计算机实现的重新分配系统的方法，装置和制品。数据在存储在连接到计算机的数据存储设备上的数据库中重新分区。首先，检测到数据的分割方案已被改变。接下来，将识别受改变的分区方案影响的分区。然后，基于改变的分区方案重新组织识别的分区。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式