Patents by Inventor Effi Ofar

Effi Ofar 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).

  • System and method for discriminatory replaying of log files during tablespace recovery in a database management system
    Patent number: 7099897
    Abstract: A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered.
    Type: Grant
    Filed: April 29, 2003
    Date of Patent: August 29, 2006
    Assignee: International Business Machines Corporation
    Inventors: Matthew Albert Huras, Dale Murray McInnis, Effi Ofar, Michael Jeffrey Winer, Roger LQ. Zheng
  • System and method for discriminatory replaying of log files during tablespace recovery in a database management system
    Publication number: 20050278393
    Abstract: A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered.
    Type: Application
    Filed: April 29, 2003
    Publication date: December 15, 2005
    Applicant: International Business Machines Corporation
    Inventors: Matthew Huras, Dale McInnis, Effi Ofar, Michael Winer, Roger Zheng