公开(公告)号：JPS62293461A

公开(公告)日：1987-12-21

申请号：JP9216087

申请日：1987-04-16

Applicant: IBM

Inventor： HORN GARY RANDALL ,  MIKELAIT ROBERT CHARLES

IPC: G06F17/21

公开(公告)号：BR8901646A

公开(公告)日：1989-11-21

申请号：BR8901646

申请日：1989-04-07

Applicant: IBM

Inventor： HORN GARY RANDALL ,  SHIH CHENG-FONG

IPC: G06F9/46 ,  G06F9/445 ,  H01L29/201 ,  G06F15/40

公开(公告)号：DE68926693T2

公开(公告)日：1997-01-23

申请号：DE68926693

申请日：1989-02-24

Applicant: IBM

Inventor： ELLIOTT LINDA CAROLYN ,  HORN GARY RANDALL ,  JODAN LLOYD EUGENE ,  LEVINE FRANK ELIOT ,  SHIH GENG-FONG ,  MYRE WILLIAM WALTER

IPC: G06F11/14 ,  G06F12/00 ,  G06F7/22

Abstract: System and method for reducing data loss in a database system during I/O errors and power failure during non-atomic writes to media in a transaction management system using write-ahead logging protocol. A recovery log is written during forward processing. On system restart processing, the log is traversed and a REDO executed. Recovery is effected from detected incomplete log writes or log write failures and uncommitted transactions are undone. A technique is provided in which files having I/O errors are identified, whereby subsequent restart operations are prevented from accessing these files. In one embodiment index files with such error are renamed, serving to indicate that corresponding original files contain errors, and the error index files are automatically rebuilt whereby I/O error on the files causes no data loss. The index file rebuild does not invalidate access plans related to the failed index.

公开(公告)号：DE3274911D1

公开(公告)日：1987-02-05

申请号：DE3274911

申请日：1982-09-02

Applicant: IBM

Inventor： HORN GARY RANDALL ,  SHIPP KENNETH OSBORN

IPC: G06K15/00 ,  B41J21/08 ,  G06F3/12 ,  G06F3/153 ,  G06F17/21 ,  G06F40/189 ,  G06F15/20

Abstract: A method for the automatic center tab insertion within a column example line in which the machine given the example width information determines and marks the centering point.

公开(公告)号：DE69030282T2

公开(公告)日：1997-09-18

申请号：DE69030282

申请日：1990-05-21

Applicant: IBM

Inventor： HORN GARY RANDALL ,  MALKEMUS TIMOTHY RAY

IPC: G06F17/30 ,  G06F20060101 ,  G06F12/00

Abstract: The invention relates to a method for determining the validity of a new referential constraint brought about by the creation or alteration of a selected data table within a relational data base, in a data processing system, having a plurality of related data tables. According to the invention the method is characterised by the steps of identifying which of the plurality of related data tables will be affected by the existence of the new referential constraint, and verifying the validity of the new referential constraint only upon the identified related data tables. The invention also relates to apparatus for determining the validity of a new referential constraint brought about by the creation or alteration of a selected data table within a relational database (14), in a data processing system (8), having a plurality of related data tables. According to the invention the apparatus comprises means (14, 18) for identifying which of the plurality of related data tables will be affected by the existence of the new referential constraint, and means for verifying the validity of the new referential constraint only upon the identified related tables.

公开(公告)号：DE68926693D1

公开(公告)日：1996-07-25

申请号：DE68926693

申请日：1989-02-24

Applicant: IBM

Inventor： ELLIOTT LINDA CAROLYN ,  HORN GARY RANDALL ,  JODAN LLOYD EUGENE ,  LEVINE FRANK ELIOT ,  SHIH GENG-FONG ,  MYRE WILLIAM WALTER

IPC: G06F11/14 ,  G06F12/00 ,  G06F7/22

Abstract: System and method for reducing data loss in a database system during I/O errors and power failure during non-atomic writes to media in a transaction management system using write-ahead logging protocol. A recovery log is written during forward processing. On system restart processing, the log is traversed and a REDO executed. Recovery is effected from detected incomplete log writes or log write failures and uncommitted transactions are undone. A technique is provided in which files having I/O errors are identified, whereby subsequent restart operations are prevented from accessing these files. In one embodiment index files with such error are renamed, serving to indicate that corresponding original files contain errors, and the error index files are automatically rebuilt whereby I/O error on the files causes no data loss. The index file rebuild does not invalidate access plans related to the failed index.

公开(公告)号：DE3277940D1

公开(公告)日：1988-02-11

申请号：DE3277940

申请日：1982-09-02

Applicant: IBM

Inventor： HORN GARY RANDALL ,  SHIPP KENNETH OSBORN

IPC: G09G5/32 ,  G06F17/21 ,  G06F17/24 ,  G09G5/08 ,  G06F15/20

Abstract: The automatic tab insertion in those null-entry positions in a tab-stopped positioned multicolumn table having row lines which include text right adjacent the null entries so as to inhibit right-to-left, text-to-null-entry migration in the same row.

公开(公告)号：SG41966A1

公开(公告)日：1997-08-15

申请号：SG1995002313

申请日：1990-05-21

Applicant: IBM

Inventor： HORN GARY RANDALL ,  MALKEMUS TIMOTHY RAY

IPC: G06F17/30 ,  G06F20060101 ,  G06F12/00 ,  G06F15/40

Abstract: The invention relates to a method for determining the validity of a new referential constraint brought about by the creation or alteration of a selected data table within a relational data base, in a data processing system, having a plurality of related data tables. According to the invention the method is characterised by the steps of identifying which of the plurality of related data tables will be affected by the existence of the new referential constraint, and verifying the validity of the new referential constraint only upon the identified related data tables. The invention also relates to apparatus for determining the validity of a new referential constraint brought about by the creation or alteration of a selected data table within a relational database (14), in a data processing system (8), having a plurality of related data tables. According to the invention the apparatus comprises means (14, 18) for identifying which of the plurality of related data tables will be affected by the existence of the new referential constraint, and means for verifying the validity of the new referential constraint only upon the identified related tables.

公开(公告)号：DE69030282D1

公开(公告)日：1997-04-30

申请号：DE69030282

申请日：1990-05-21

Applicant: IBM

Inventor： HORN GARY RANDALL ,  MALKEMUS TIMOTHY RAY

IPC: G06F17/30 ,  G06F20060101 ,  G06F12/00

Abstract: The invention relates to a method for determining the validity of a new referential constraint brought about by the creation or alteration of a selected data table within a relational data base, in a data processing system, having a plurality of related data tables. According to the invention the method is characterised by the steps of identifying which of the plurality of related data tables will be affected by the existence of the new referential constraint, and verifying the validity of the new referential constraint only upon the identified related data tables. The invention also relates to apparatus for determining the validity of a new referential constraint brought about by the creation or alteration of a selected data table within a relational database (14), in a data processing system (8), having a plurality of related data tables. According to the invention the apparatus comprises means (14, 18) for identifying which of the plurality of related data tables will be affected by the existence of the new referential constraint, and means for verifying the validity of the new referential constraint only upon the identified related tables.

公开(公告)号：DE3774504D1

公开(公告)日：1991-12-19

申请号：DE3774504

申请日：1987-05-26

Applicant: IBM

Inventor： HORN GARY RANDALL ,  MIKELAIT ROBERT CHARLES

IPC: G06F17/21 ,  G06F15/20