Patents by Inventor Gary Howard Sockut

Gary Howard Sockut has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 6519613
    Abstract: A method and apparatus for online reorganization of a database which does not prevent a process from accessing the database during the data reorganization. The invention uses a non-blocking drain to lock on a database, unloads a copy of the data contained in the database, reorganizes the copied data, loads the reorganized data into a shadow location, applies log records to the shadow location data so that the reorganized data may be adjusted for any changes to the database after the data was copied and reorganized, and then replaces the data in the database with the reorganized data. The non-blocking drain does not prevent other requests on the database from being processed while the reorganization lock is in place, except briefly when the reorganized data replaces the data in the database.
    Type: Grant
    Filed: March 16, 2000
    Date of Patent: February 11, 2003
    Assignee: International Business Machines Corporation
    Inventors: Craig Alan Friske, Gary Howard Sockut, James Zu-Chia Teng, Stephen Walter Turnbaugh
  • Publication number: 20020143743
    Abstract: An in-place reorganization of a database achieves reasonably accurate results for users during high-throughput concurrent usage of the database. The reorganization's movement of records across a user transaction's position within a scan of the database is tracked. The behavior of the user transaction is corrected to account for the movement of the records.
    Type: Application
    Filed: May 20, 2002
    Publication date: October 3, 2002
    Inventors: Balakrishna Raghavendra Iyer, Gary Howard Sockut
  • Patent number: 6411964
    Abstract: An in-place reorganization of a database achieves reasonably accurate results for users during high-throughput concurrent usage of the database. The reorganization's movement of records across a user transaction's position within a scan of the database is tracked. The behavior of the user transaction is corrected to account for the movement of the records.
    Type: Grant
    Filed: December 23, 1998
    Date of Patent: June 25, 2002
    Assignee: International Business Machines Corporation
    Inventors: Balakrishna Raghavendra Iyer, Gary Howard Sockut
  • Patent number: 6070170
    Abstract: A method and apparatus for online reorganization of a database which does not prevent a process from accessing the database during the data reorganization. The invention uses a non-blocking drain to lock on a database, unloads a copy of the data contained in the database, reorganizes the copied data, loads the reorganized data into a shadow location, applies log records to the shadow location data so that the reorganized data may be adjusted for any changes to the database after the data was copied and reorganized, and then replaces the data in the database with the reorganized data. The non-blocking drain does not prevent other requests on the database from being processed while the reorganization lock is in place, except briefly when the reorganized data replaces the data in the database.
    Type: Grant
    Filed: October 1, 1997
    Date of Patent: May 30, 2000
    Assignee: International Business Machines Corporation
    Inventors: Craig Alan Friske, Gary Howard Sockut, James Zu-Chia Teng, Stephen Walter Turnbaugh
  • Patent number: 6026412
    Abstract: The present invention includes reorganization of a Database Management System (DBMS). The reorganization of the present invention is implemented by recording a first current Relative Byte Address (RBA). Then, data is copied from the old area in the table space to a new area in the table space in reorganized form. In the present invention, throughout most of reorganization a user maintains access to the DBMS's normal facilities to read and write to the old area. The DBMS uses its normal facilities to record writing, which occurs during reorganization, in a log. The reorganization in accordance with the present invention reads the log (that has been written to during reorganization) and processes the log to the new area to bring the new area up to date. This process is performed with the use of a RID mapping table. Finally, at the end of reorganization, the user's access is switched from the old area to the new area.
    Type: Grant
    Filed: June 30, 1997
    Date of Patent: February 15, 2000
    Assignee: International Business Machines Corporation
    Inventors: Gary Howard Sockut, Thomas Abel Beavin
  • Patent number: 5721915
    Abstract: The present invention includes reorganization of a Database Management System (DBMS) The reorganization of the present invention is implemented by recording a first current Relative Byte Address (RBA) Then, data is copied from the old area in the table space to a new area in the table space in reorganized form. In the present invention, throughout most of reorganization a user maintains access to the DBMS's normal facilities to read and write to the old area. The DBMS uses its normal facilities to record writing, which occurs during reorganization, in,a log. The reorganization in accordance with the present invention reads the log (that has been written to during reorganization) and processes the log to the new area to bring the new area up to date. This process is performed with the use of a RID mapping table. Finally, at the end of reorganization, the user's access is switched from the old area to the new area.
    Type: Grant
    Filed: June 1, 1995
    Date of Patent: February 24, 1998
    Assignee: International Business Machines Corporation
    Inventors: Gary Howard Sockut, Thomas Abel Beavin