Patents by Inventor William J. Franklin

William J. Franklin 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: 9916211
    Abstract: A database recovery and index rebuilding method involves reading data pages for a database to be recovered as recovery bases; retrieving all log records from stored post-backup updates and sorting the retrieved log records; as the data pages to be recovered are read, applying the sorted log records to their respective data pages; as the applying completes for individual data pages, extracting and sorting index keys from the individual data pages for which the applying is complete, until all index keys have been extracted from all individual data pages and sorted; on an individual recovered page basis, writing the recovered individual data pages into the database; and when all index keys have been extracted and sorted from all of the recovered individual data pages, rebuilding indexes of the database using the sorted index keys and writing the rebuilt indexes to the non-transitory storage.
    Type: Grant
    Filed: September 15, 2017
    Date of Patent: March 13, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Jeffrey Berger, William J. Franklin, Laura M. Kunioka-Weis, Thomas Majithia, Haakon P. Roberts
  • Publication number: 20170371751
    Abstract: A database recovery and index rebuilding method involves reading data pages for a database to be recovered as recovery bases; retrieving all log records from stored post-backup updates and sorting the retrieved log records; as the data pages to be recovered are read, applying the sorted log records to their respective data pages; as the applying completes for individual data pages, extracting and sorting index keys from the individual data pages for which the applying is complete, until all index keys have been extracted from all individual data pages and sorted; on an individual recovered page basis, writing the recovered individual data pages into the database; and when all index keys have been extracted and sorted from all of the recovered individual data pages, rebuilding indexes of the database using the sorted index keys and writing the rebuilt indexes to the non-transitory storage.
    Type: Application
    Filed: September 15, 2017
    Publication date: December 28, 2017
    Inventors: Jeffrey Berger, William J. Franklin, Laura M. Kunioka-Weis, Thomas Majithia, Haakon P. Roberts
  • Patent number: 9804936
    Abstract: A database recovery and index rebuilding system involves at least one processor coupled to memory, storage, a database, and sets of image copies and post-backup updates. When database reconstruction is required, the processor will i) access the image copies; ii) access post-backup updates to be re-applied; iii) without regard to “ii)”, read data pages to be recovered into objects; iv) concurrently with “iii)”, retrieve and sort log records from the post-backup updates; v) as the data pages to be recovered are read in “iii)”, apply the sorted log records; vi) as “e)” completes and concurrently with “v)”, extract and sort index keys; vii) concurrently with “vi)” and on an individual recovered page basis, write the recovered data pages into the database; viii) when all index keys have been extracted and sorted, initiate database index rebuilds; and ix) when rebuilt, store the rebuilt indexes without regard to whether “vii)” has completed.
    Type: Grant
    Filed: November 29, 2016
    Date of Patent: October 31, 2017
    Assignee: International Business Machines Corporation
    Inventors: Jeffrey Berger, William J Franklin, Laura M. Kunioka-Weis, Thomas Majithia, Haakon P. Roberts
  • Patent number: 9558077
    Abstract: A database recovery method involves: a) accessing image copies; b) accessing updates to be re-applied to reconstruct the database; c) reading into objects, from the image copies, data pages to be recovered; d) concurrently with “c)” retrieving and sorting log records from the updates; e) as the data pages are read into the objects in “c)”, applying the sorted log records, in timestamp order; f) as “e)” completes for individual pages, and concurrently with “e)” with respect to pages for which applying is not complete, extracting and sorting index keys, from pages for which the applying is complete, until all index keys have been extracted and sorted; g) concurrently with “f)”, writing recovered pages into the database; h) initiating a rebuild of database indexes using the extracted and sorted index keys; and i) when the database indexes have been rebuilt, writing them to storage without regard to whether “g)” completed.
    Type: Grant
    Filed: June 16, 2016
    Date of Patent: January 31, 2017
    Assignee: International Business Machines Corporation
    Inventors: Jeffrey Berger, William J Franklin, Laura M. Kunioka-Weis, Thomas Majithia, Haakon P. Roberts
  • Publication number: 20140003998
    Abstract: An improved system relating to sterilizing the surfaces of objects using a dual-frequency plasma-based process.
    Type: Application
    Filed: December 19, 2012
    Publication date: January 2, 2014
    Inventors: Mark A. Franklin, William J. Franklin
  • Publication number: 20140000810
    Abstract: Improved systems relating to modifying the surface properties of at least one material using plasma-based processes. Application of methods and apparatus of the system are particularly useful in semiconductor processing.
    Type: Application
    Filed: December 19, 2012
    Publication date: January 2, 2014
    Inventors: Mark A. Franklin, William J. Franklin
  • Patent number: 6780759
    Abstract: A method and technique for achieving a high strength bond between two substrates includes igniting a plasma using a source RF signal. The substrates are biased with a bias RF signal during surface treatment by the plasma. The treated surfaces are brought into contact. The resulting bonded substrates show an improvement over bonds attained using conventional bonding techniques.
    Type: Grant
    Filed: October 1, 2001
    Date of Patent: August 24, 2004
    Assignee: Silicon Genesis Corporation
    Inventors: Shari N. Farrens, Mark A. Franklin, William J. Franklin, Wei Liu
  • Publication number: 20030003684
    Abstract: A method and apparatus for achieving a high strength bond between two substrates includes igniting a plasma using a source RF signal. The substrates are biased with a bias RF signal during surface treatment by the plasma. The treated surfaces are brought into contact. The resulting bonded substrates show an improvement over bonds attained using conventional bonding techniques.
    Type: Application
    Filed: October 1, 2001
    Publication date: January 2, 2003
    Applicant: Silicon Genesis Corporation
    Inventors: Shari N. Farrens, Mark A. Franklin, William J. Franklin, Wei Liu