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

1. 发明授权

US5881379A System, method, and program for using duplicated direct pointer sets in keyed database records to enhance data recoverability without logging 失效
标题翻译：在密钥数据库记录中使用重复的直接指针集的系统，方法和程序，以增强数据可恢复性而不进行日志记录
公开(公告)号：US5881379A
公开(公告)日：1999-03-09
申请号：US650702
申请日：1996-05-20
申请人： Harley Al Beier , Sidney Kornelis , Vern L. Watts
发明人： Harley Al Beier , Sidney Kornelis , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30952 , Y10S707/99942 , Y10S707/99953
摘要： The system, method, and program product of this invention allows a database management system to internally use direct and indirect pointing to locate targeted data elements that are logically related to another data element or are a target of a secondary index. By using direct and indirect pointing, the number of steps involved in a reorganization of the database can be reduced. After a reorganization, the database management system does not go back, in a separate process, to update all of the direct pointers that have pointed to segments that have moved as a result of the reorganization. Instead, the direct pointer is updated, by using the indirect pointer, only upon a first reference to the targeted data element that has moved. Each targeted data element has an entry in an indirect index where a unique identifier of the targeted data element is the key into the index. The indirect index has two direct pointer slots. Which pointer slot is used by the DBMS is determined by the odd/even reorganization number. For each reorganization, the DBMS alternates between the two portions of the indirect index to update the appropriate one of the two pointers with a new location whenever the targeted data element is moved. As a result, the indirect index contains the most recent update and the most recent previous update. If the reorganization fails, the most recent previous pointer is used to find the location of the targeted data element. Consequently, as the reorganization process is proceeding, the update to the assigned slot for the new reorganization number can be made without logging and without involving unnecessary overhead associated with maintaining direct recoverability of the keyed data records.
摘要翻译：本发明的系统，方法和程序产品允许数据库管理系统在内部使用直接和间接指向来定位与另一个数据元素逻辑相关的目标数据元素或者是次要索引的目标。通过使用直接和间接指向，可以减少重组数据库所涉及的步骤数量。重组后，数据库管理系统不会在单独的过程中返回，以更新指向由于重组而移动的段的所有直接指针。而是通过使用间接指针来更新直接指针，只有对已移动的目标数据元素的第一个引用。每个目标数据元素具有间接索引中的条目，其中目标数据元素的唯一标识符是索引中的关键字。间接索引有两个直接指针插槽。 DBMS使用哪个指针槽由奇数/偶数重组号决定。对于每次重组，DBMS在间接索引的两个部分之间交替，每当移动目标数据元素时，用新位置更新两个指针中的适当的一个。因此，间接索引包含最新的更新和最新的更新。如果重组失败，则使用最近的上一个指针来查找目标数据元素的位置。因此，随着重组过程的进行，可以在不进行记录的情况下对新的重组号码的分配时隙进行更新，而不会涉及与维护密钥数据记录的直接可恢复性相关的不必要的开销。

2. 发明授权

US07146373B2 Data-space tracking with index data-spaces and data data-spaces 失效
标题翻译：具有索引数据空间和数据数据空间的数据空间跟踪
公开(公告)号：US07146373B2
公开(公告)日：2006-12-05
申请号：US10198151
申请日：2002-07-19
申请人： Harley A. Beier , Vern L. Watts
发明人： Harley A. Beier , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F17/30289 , Y10S707/918 , Y10S707/99942 , Y10S707/99944
摘要： Methods and apparatuses are described that use index data-spaces that point to other data-spaces referred to as data data-spaces to efficiently associate temporary information with data-elements in a data-space. An original data-space is divided into data-elements of fixed size, based upon application requirements for the resolution at which temporary information is to be associated with data in the original data-space. The relative base address of data-elements in an index data-space can be ascertained from the relative base address of their corresponding data-element in an original data-space, and vice versa. Each index data-space data-element can be populated with a pointer to a data data-space data-element that can be populated with information relevant to the associated original data-space data-element. Index data-space and data data-space memory requirements are optimized to meet application requirements.
摘要翻译：描述了使用指向称为数据数据空间的其他数据空间的索引数据空间来有效地将临时信息与数据空间中的数据元素相关联的方法和装置。根据临时信息与原始数据空间中的数据相关联的分辨率的应用要求，将原始数据空间分为固定大小的数据元素。索引数据空间中数据元素的相对基址可以从原始数据空间中相应数据元素的相对基址确定，反之亦然。每个索引数据空间数据元素可以用指向可以用相关联的原始数据空间数据元素相关信息填充的数据数据空间数据元素的指针来填充。索引数据空间和数据数据空间内存要求进行了优化，以满足应用需求。

3. 发明授权

US5933820A System, method, and program for using direct and indirect pointers to logically related data and targets of indexes 失效
公开(公告)号：US5933820A
公开(公告)日：1999-08-03
申请号：US650701
申请日：1996-05-20
申请人： Harley Al Beier , Sidney Kornelis , Vern L. Watts
发明人： Harley Al Beier , Sidney Kornelis , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99931
摘要： The system, method, and program product of this invention allows a database management system to internally use direct and indirect pointing to locate targeted data elements that are logically related to another data element or are a target of a secondary index. By using direct and indirect pointing, the number of steps involved in a reorganization of the database can be reduced. After a reorganization, the database management system does not go back, in a separate process, to update all of the direct pointers that have pointed to segments that have moved as a result of the reorganization. Instead, the direct pointer is updated, by using the indirect pointer, only upon a first reference to the targeted data element that has moved. As such, each data element, that points to a targeted data element, has a direct pointer associated with it having a unique identifier of the targeted data element, assigned by the DBMS at the time a data element is created, a partition id of the targeted segment, a reorganization number, and a pointer to a location of the targeted data element. Each targeted data element has an entry in an indirect index where the unique identifier is the key into the index. Each entry is updated, with a new location, whenever the targeted data element is moved. The DBMS also maintains, in memory, a current reorganization number for each partition. Upon reference to a targeted element, the reorganization number in memory is compared with the reorganization number in the direct pointer. If they match, the direct pointer is used to locate the targeted element. If they do not match, the indirect index is used by indexing into it by using the unique id in the direct pointer. The current location and current reorg number from the indirect index are used to update the direct pointer. The direct pointer can then be used, directly, to locate the targeted data element on subsequent references until a next reorganization involves the targeted data segment.

4. 发明授权

US4399504A Method and means for the sharing of data resources in a multiprocessing, multiprogramming environment 失效
标题翻译：用于在多处理，多重编程环境中共享数据资源的方法和装置
公开(公告)号：US4399504A
公开(公告)日：1983-08-16
申请号：US194483
申请日：1980-10-06
申请人： Ronald L. Obermarck , Jimmy P. Strickland , Vern L. Watts
发明人： Ronald L. Obermarck , Jimmy P. Strickland , Vern L. Watts
IPC分类号： G06F13/14 , G06F9/46 , G06F9/52 , G06F12/00 , G06F15/16 , G06F15/177
CPC分类号： G06F9/52
摘要： Data resources are shared by applications executing on a plurality of central electronic complexes. Each complex of a pair includes a resource lock manager (IRLM) which maintains the hold and wait locks for applications executing on the complex and selected wait locks for the other complex. Selective communication of lock request information is controlled by hash tables maintained in synchronization in each IRLM, which denote the interest of each complex in each hash class of data resources.
摘要翻译：数据资源由在多个中央电子综合体上执行的应用共享。一对中的每一个复合体都包含一个资源锁管理器（IRLM），该管理器维护对另一个复合体的复杂和选择的等待锁执行的应用程序的保持和等待锁。锁定请求信息的选择性通信由在每个IRLM中同步维护的哈希表控制，这表示每个哈希类数据资源中每个复合体的兴趣。

5. 发明授权

US08200664B2 Program for capturing data changes utilizing data-space tracking 失效
标题翻译：使用数据空间跟踪捕获数据变化的程序
公开(公告)号：US08200664B2
公开(公告)日：2012-06-12
申请号：US12260565
申请日：2008-10-29
申请人： Harley A. Beier , Vern L. Watts
发明人： Harley A. Beier , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99943 , Y10S707/99944 , Y10S707/99953 , Y10S707/99955
摘要： A program for reorganizing information in a computer system while concurrently providing access to the information for updates. In an exemplary embodiment of the invention, an on-line reorganization facility (ORF) uses index data-spaces that point to other data-spaces, referred to as data data-spaces, to efficiently track and coordinate information about the data-elements in an original data-space operated upon by a reorganization process. A relative base address of a data-element in an index data-space can be derived from a relative base address of a data-element in an original data-space, and vice versa. An index data-space data-element contains a location of a data-element in a data data-space that tracks change information related to a corresponding data-element in the original data-space. Tracked changes are later applied to the newly reorganized data-space to assure consistency and integrity of the data. Tracked changes include the location in the original data-space where the change occurred and a flag indicting the type of change.
摘要翻译：用于在计算机系统中重组信息的同时提供对更新信息的访问的程序。在本发明的示例性实施例中，在线重组设施（ORF）使用指向称为数据数据空间的其他数据空间的索引数据空间来有效地跟踪和协调关于数据元素的信息由重组过程操作的原始数据空间。索引数据空间中的数据元素的相对基址可以从原始数据空间中的数据元素的相对基址导出，反之亦然。索引数据空间数据元素包含数据数据空间中的数据元素的位置，该数据元素跟踪与原始数据空间中的相应数据元素相关的变更信息。跟踪的更改随后应用于新重组的数据空间，以确保数据的一致性和完整性。跟踪的更改包括发生更改的原始数据空间中的位置和指示更改类型的标志。

6. 发明授权

US08200665B2 Method, apparatus, and program for capturing data changes utilizing data-space tracking 失效
标题翻译：利用数据空间跟踪捕获数据变化的方法，装置和程序
公开(公告)号：US08200665B2
公开(公告)日：2012-06-12
申请号：US12260599
申请日：2008-10-29
申请人： Harley A. Beier , Vern L. Watts
发明人： Harley A. Beier , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99943 , Y10S707/99944 , Y10S707/99953 , Y10S707/99955
摘要： A method, apparatus, and program for reorganizing a database while concurrently providing access to the database for updates. In an exemplary embodiment of the invention, an on-line reorganization facility (ORF) uses index data-spaces that point to other data-spaces, referred to as data data-spaces, to efficiently track and coordinate information about the data-elements in an original data-space operated upon by a reorganization process. A relative base address of a data-element in an index data-space can be derived from a relative base address of a data-element in an original data-space, and vice versa. An index data-space data-element contains a location of a data-element in a data data-space that tracks change information related to a corresponding data-element in the original data-space. Tracked changes are later applied to the newly reorganized data-space to assure consistency and integrity of the data. Tracked changes include the location in the original data-space where the change occurred and a flag indicting the type of change.
摘要翻译：一种用于重组数据库同时提供数据库访问以进行更新的方法，装置和程序。在本发明的示例性实施例中，在线重组设施（ORF）使用指向称为数据数据空间的其他数据空间的索引数据空间来有效地跟踪和协调关于数据元素的信息由重组过程操作的原始数据空间。索引数据空间中的数据元素的相对基址可以从原始数据空间中的数据元素的相对基址导出，反之亦然。索引数据空间数据元素包含数据数据空间中的数据元素的位置，该数据元素跟踪与原始数据空间中的相应数据元素相关的变更信息。跟踪的更改随后应用于新重组的数据空间，以确保数据的一致性和完整性。跟踪的更改包括发生更改的原始数据空间中的位置和指示更改类型的标志。

7. 发明申请

US20090055448A1 METHOD, APPARATUS, AND PROGRAM FOR CAPTURING DATA CHANGES UTILIZING DATA-SPACE TRACKING 失效
标题翻译：采用数据空间跟踪的数据更改方法，装置和程序
公开(公告)号：US20090055448A1
公开(公告)日：2009-02-26
申请号：US12260599
申请日：2008-10-29
申请人： Harley A. Beier , Vern L. Watts
发明人： Harley A. Beier , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99943 , Y10S707/99944 , Y10S707/99953 , Y10S707/99955
摘要： A method, apparatus, and program for reorganizing a database while concurrently providing access to the database for updates. In an exemplary embodiment of the invention, an on-line reorganization facility (ORF) uses index data-spaces that point to other data-spaces, referred to as data data-spaces, to efficiently track and coordinate information about the data-elements in an original data-space operated upon by a reorganization process. A relative base address of a data-element in an index data-space can be derived from a relative base address of a data-element in an original data-space, and vice versa. An index data-space data-element contains a location of a data-element in a data data-space that tracks change information related to a corresponding data-element in the original data-space. Tracked changes are later applied to the newly reorganized data-space to assure consistency and integrity of the data. Tracked changes include the location in the original data-space where the change occurred and a flag indicting the type of change.
摘要翻译：一种用于重组数据库同时提供数据库访问以进行更新的方法，装置和程序。在本发明的示例性实施例中，在线重组设施（ORF）使用指向称为数据数据空间的其他数据空间的索引数据空间来有效地跟踪和协调关于数据元素的信息由重组过程操作的原始数据空间。索引数据空间中的数据元素的相对基址可以从原始数据空间中的数据元素的相对基址导出，反之亦然。索引数据空间数据元素包含数据数据空间中的数据元素的位置，该数据元素跟踪与原始数据空间中的相应数据元素相关的变更信息。跟踪的更改随后应用于新重组的数据空间，以确保数据的一致性和完整性。跟踪的更改包括发生更改的原始数据空间中的位置和指示更改类型的标志。

8. 发明授权

US07085787B2 Capturing data changes utilizing data-space tracking 失效
标题翻译：利用数据空间跟踪捕获数据变化
公开(公告)号：US07085787B2
公开(公告)日：2006-08-01
申请号：US10197810
申请日：2002-07-19
申请人： Harley A. Beier , Vern L. Watts
发明人： Harley A. Beier , Vern L. Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99943 , Y10S707/99944 , Y10S707/99953 , Y10S707/99955
摘要： An on-line reorganization facility (ORF) uses index data-spaces that point to other data-spaces, referred to as data data-spaces, to efficiently track and coordinate information about the data-elements in an original data-space operated upon by a reorganization process. A relative base address of a data-element in an index data-space can be derived from a relative base address of a data-element in an original data-space, and vice versa. An index data-space data-element contains a location of a data-element in a data data-space that tracks change information related to a corresponding data-element in the original data-space. Tracked changes are later applied to the newly reorganized data-space to assure consistency and integrity of the data. Tracked changes include the location in the original data-space where the change occurred and a flag indicting the type of change.
摘要翻译：在线重组设施（ORF）使用指向其他数据空间（称为数据数据空间）的索引数据空间，以有效地跟踪和协调原始数据空间中的数据元素信息，原始数据空间由重组过程。索引数据空间中的数据元素的相对基址可以从原始数据空间中的数据元素的相对基址导出，反之亦然。索引数据空间数据元素包含数据数据空间中的数据元素的位置，该数据元素跟踪与原始数据空间中的相应数据元素相关的变更信息。跟踪的更改随后应用于新重组的数据空间，以确保数据的一致性和完整性。跟踪的更改包括发生更改的原始数据空间中的位置和指示更改类型的标志。

9. 发明授权

US07502800B2 Method of capturing data changes utilizing data-space tracking 失效
标题翻译：利用数据空间跟踪捕获数据变化的方法
公开(公告)号：US07502800B2
公开(公告)日：2009-03-10
申请号：US11295476
申请日：2005-12-07
申请人： Harley A. Beier , Vern L. Watts
发明人： Harley A. Beier , Vern L. Watts
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
CPC分类号： G06F17/30339 , Y10S707/99943 , Y10S707/99944 , Y10S707/99953 , Y10S707/99955
摘要： A method of reorganizing a database while concurrently providing access to the database for updates. In an exemplary embodiment of the method, an on-line reorganization facility (ORF) uses index data-spaces that point to other data-spaces, referred to as data data-spaces, to efficiently track and coordinate information about the data-elements in an original data-space operated upon by a reorganization process. A relative base address of a data-element in an index data-space can be derived from a relative base address of a data-element in an original data-space, and vice versa. An index data-space data-element contains a location of a data-element in a data data-space that tracks change information related to a corresponding data-element in the original data-space. Tracked changes are later applied to the newly reorganized data-space to assure consistency and integrity of the data. Tracked changes include the location in the original data-space where the change occurred and a flag indicting the type of change.
摘要翻译：一种重组数据库同时提供对数据库进行更新的方法。在该方法的示例性实施例中，在线重组设施（ORF）使用指向称为数据数据空间的其他数据空间的索引数据空间，以有效地跟踪和协调关于数据元素的信息由重组过程操作的原始数据空间。索引数据空间中的数据元素的相对基址可以从原始数据空间中的数据元素的相对基址导出，反之亦然。索引数据空间数据元素包含数据数据空间中的数据元素的位置，该数据元素跟踪与原始数据空间中的相应数据元素相关的变更信息。跟踪的更改随后应用于新重组的数据空间，以确保数据的一致性和完整性。跟踪的更改包括发生更改的原始数据空间中的位置和指示更改类型的标志。

10. 发明申请

US20090063553A1 PROGRAM FOR CAPTURING DATA CHANGES UTILIZING DATA-SPACE TRACKING 失效
标题翻译：使用数据空间跟踪来获取数据更改的程序
公开(公告)号：US20090063553A1
公开(公告)日：2009-03-05
申请号：US12260565
申请日：2008-10-29
申请人： Harley A. BEIER , Vern L. Watts
发明人： Harley A. BEIER , Vern L. Watts
IPC分类号： G06F12/16 , G06F7/00 , G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99943 , Y10S707/99944 , Y10S707/99953 , Y10S707/99955
摘要： A program for reorganizing information in a computer system while concurrently providing access to the information for updates. In an exemplary embodiment of the invention, an on-line reorganization facility (ORF) uses index data-spaces that point to other data-spaces, referred to as data data-spaces, to efficiently track and coordinate information about the data-elements in an original data-space operated upon by a reorganization process. A relative base address of a data-element in an index data-space can be derived from a relative base address of a data-element in an original data-space, and vice versa. An index data-space data-element contains a location of a data-element in a data data-space that tracks change information related to a corresponding data-element in the original data-space. Tracked changes are later applied to the newly reorganized data-space to assure consistency and integrity of the data. Tracked changes include the location in the original data-space where the change occurred and a flag indicting the type of change.
摘要翻译：用于在计算机系统中重组信息的同时提供对更新信息的访问的程序。在本发明的示例性实施例中，在线重组设施（ORF）使用指向称为数据数据空间的其他数据空间的索引数据空间来有效地跟踪和协调关于数据元素的信息由重组过程操作的原始数据空间。索引数据空间中的数据元素的相对基址可以从原始数据空间中的数据元素的相对基址导出，反之亦然。索引数据空间数据元素包含数据数据空间中的数据元素的位置，该数据元素跟踪与原始数据空间中的相应数据元素相关的变更信息。跟踪的更改随后应用于新重组的数据空间，以确保数据的一致性和完整性。跟踪的更改包括发生更改的原始数据空间中的位置和指示更改类型的标志。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式