Invention Grant
- Patent Title: Point in time recovery support for pending schema definition changes
- Patent Title (中): 对待定模式定义更改的及时恢复支持
-
Application No.: US14634065Application Date: 2015-02-27
-
Publication No.: US09588996B2Publication Date: 2017-03-07
- Inventor: Szu-Huey Chuang , Craig A. Friske , Laura M. Kunioka-Weis , Regina J. Liu , Ka C. Ng , James Z. Teng , Binghui Zhong
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Mollborn Patents, Inc.
- Agent Fredrik Mollborn
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F11/14

Abstract:
Recovering data to a point in time before pending definition changes are materialized in a relational database management system. One or more definition changes to a database schema are received. Original data base schema attributes are saved and maintained as point in time metadata in a catalog table until the one or more definition changes have been materialized. During recovery processing, it is determined for each object being recovered whether the object is being recovered to a point in time prior to which the one or more definition changes were materialized. In response to determining that an object is being recovered to a point in time prior to which the one or more definition changes were materialized, the saved point in time metadata is used for the object in the recovery process.
Public/Granted literature
- US20150286532A1 POINT IN TIME RECOVERY SUPPORT FOR PENDING SCHEMA DEFINITION CHANGES Public/Granted day:2015-10-08
Information query