DE68927705T2 - Verfahren zum Entfernen unbestätigter Änderungen an gespeicherten Daten durch ein Datenbankverwaltungssystem - Google Patents

Verfahren zum Entfernen unbestätigter Änderungen an gespeicherten Daten durch ein Datenbankverwaltungssystem

Info

Publication number
DE68927705T2
DE68927705T2 DE68927705T DE68927705T DE68927705T2 DE 68927705 T2 DE68927705 T2 DE 68927705T2 DE 68927705 T DE68927705 T DE 68927705T DE 68927705 T DE68927705 T DE 68927705T DE 68927705 T2 DE68927705 T2 DE 68927705T2
Authority
DE
Germany
Prior art keywords
backout
changes
failure
copy
database management
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Fee Related
Application number
DE68927705T
Other languages
English (en)
Other versions
DE68927705D1 (de
Inventor
Samuel David Borman
Arthur Jonathan Tyrrell
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
International Business Machines Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Application granted granted Critical
Publication of DE68927705D1 publication Critical patent/DE68927705D1/de
Publication of DE68927705T2 publication Critical patent/DE68927705T2/de
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14—Error detection or correction of the data by redundancy in operation
    • G06F11/1402—Saving, restoring, recovering or retrying
    • G06F11/1471—Saving, restoring, recovering or retrying involving logging of persistent data for recovery
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/22—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
    • G06F11/2205—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing using arrangements specific to the hardware being tested
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/87—Monitoring of transactions
    • G—PHYSICS
    • G11—INFORMATION STORAGE
    • G11C—STATIC STORES
    • G11C29/00—Checking stores for correct operation ; Subsequent repair; Testing stores during standby or offline operation
    • G11C29/70—Masking faults in memories by using spares or by reconfiguring
    • G11C29/74—Masking faults in memories by using spares or by reconfiguring using duplex memories, i.e. using dual copies
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users
    • Y10S707/99953—Recoverability
DE68927705T 1989-06-13 1989-06-13 Verfahren zum Entfernen unbestätigter Änderungen an gespeicherten Daten durch ein Datenbankverwaltungssystem Expired - Fee Related DE68927705T2 (de)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
EP89305987A EP0402542B1 (de) 1989-06-13 1989-06-13 Verfahren zum Entfernen unbestätigter Änderungen an gespeicherten Daten durch ein Datenbankverwaltungssystem

Publications (2)

Publication Number Publication Date
DE68927705D1 DE68927705D1 (de) 1997-03-06
DE68927705T2 true DE68927705T2 (de) 1997-07-17

Family

ID=8202715

Family Applications (1)

Application Number Title Priority Date Filing Date
DE68927705T Expired - Fee Related DE68927705T2 (de) 1989-06-13 1989-06-13 Verfahren zum Entfernen unbestätigter Änderungen an gespeicherten Daten durch ein Datenbankverwaltungssystem

Country Status (7)

Country Link
US (1) US5437026A (de)
EP (1) EP0402542B1 (de)
JP (1) JP2531835B2 (de)
AT (1) ATE148241T1 (de)
BR (1) BR9002804A (de)
CA (1) CA2018932A1 (de)
DE (1) DE68927705T2 (de)

Families Citing this family (34)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2276737A (en) * 1993-03-30 1994-10-05 Ibm Fault-tolerant transaction-oriented data processing
US6920467B1 (en) * 1993-11-26 2005-07-19 Canon Kabushiki Kaisha Avoiding unwanted side-effects in the updating of transient data
GB2301910B (en) * 1995-06-07 1999-07-21 Ibm Management of units of work on a computer system log
US5745750A (en) * 1995-12-15 1998-04-28 International Business Machines Corporation Process and article of manufacture for constructing and optimizing transaction logs for mobile file systems
US5761678A (en) * 1996-06-26 1998-06-02 International Business Machines Corporation Creation of clone storage area with identification of base storage area and deferred cloning of metadata
US5873098A (en) * 1997-04-23 1999-02-16 Oracle Corporation Dynamic snapshot set adjustment
US5951695A (en) * 1997-07-25 1999-09-14 Hewlett-Packard Company Fast database failover
US6173292B1 (en) 1998-03-04 2001-01-09 International Business Machines Corporation Data recovery in a transactional database using write-ahead logging and file caching
US6092086A (en) * 1998-03-31 2000-07-18 Bmc Software System and method for handling backout processing during capture of changed data in an enterprise computer system
GB2343020A (en) 1998-10-19 2000-04-26 Ibm Handling transaction failures in a transaction processing system
JP4237354B2 (ja) * 1999-09-29 2009-03-11 株式会社東芝 トランザクション処理方法及びトランザクション処理システム
US6587962B1 (en) * 1999-10-20 2003-07-01 Hewlett-Packard Development Company, L.P. Write request protection upon failure in a multi-computer system
GB0006413D0 (en) * 2000-03-17 2000-05-03 Ibm A dynamic shortcut to reverse autonomous computer program actions
US6990466B1 (en) * 2000-08-08 2006-01-24 International Business Machines Corporation Method and system for integrating core banking business processes
US20030088783A1 (en) * 2001-11-06 2003-05-08 Dipierro Massimo Systems, methods and devices for secure computing
US7103603B2 (en) * 2003-03-28 2006-09-05 International Business Machines Corporation Method, apparatus, and system for improved duplicate record processing in a sort utility
US7577806B2 (en) 2003-09-23 2009-08-18 Symantec Operating Corporation Systems and methods for time dependent data storage and recovery
US7730222B2 (en) 2004-08-24 2010-06-01 Symantec Operating System Processing storage-related I/O requests using binary tree data structures
US7827362B2 (en) 2004-08-24 2010-11-02 Symantec Corporation Systems, apparatus, and methods for processing I/O requests
US7577807B2 (en) 2003-09-23 2009-08-18 Symantec Operating Corporation Methods and devices for restoring a portion of a data store
US7631120B2 (en) 2004-08-24 2009-12-08 Symantec Operating Corporation Methods and apparatus for optimally selecting a storage buffer for the storage of data
US7725760B2 (en) 2003-09-23 2010-05-25 Symantec Operating Corporation Data storage system
US7409587B2 (en) * 2004-08-24 2008-08-05 Symantec Operating Corporation Recovering from storage transaction failures using checkpoints
US7991748B2 (en) 2003-09-23 2011-08-02 Symantec Corporation Virtual data store creation and use
US7904428B2 (en) 2003-09-23 2011-03-08 Symantec Corporation Methods and apparatus for recording write requests directed to a data store
US7287133B2 (en) 2004-08-24 2007-10-23 Symantec Operating Corporation Systems and methods for providing a modification history for a location within a data store
US20050125423A1 (en) * 2003-12-04 2005-06-09 Hsien-Cheng Chou Method to provide a filter for the capture program of IBM/DB2 data replication
US7756838B2 (en) * 2005-12-12 2010-07-13 Microsoft Corporation Robust end-of-log processing
US8015215B2 (en) * 2006-08-24 2011-09-06 Oracle America, Inc. Delegation in a file system with distributed components
US20090063807A1 (en) * 2007-08-29 2009-03-05 International Business Machines Corporation Data redistribution in shared nothing architecture
KR101548222B1 (ko) * 2013-10-18 2015-08-31 ㈜윈웨이시스템 데이터 백업 방법 및 이를 지원하는 시스템
CN109696902B (zh) * 2018-12-06 2022-06-10 奇瑞汽车股份有限公司 一种信号记录装置、故障点检测电路及方法
CN111221671B (zh) * 2019-11-27 2024-03-22 中国银行股份有限公司 应用程序异常退出的处理方法及装置
CN111444039B (zh) * 2019-12-30 2023-03-21 中国银联股份有限公司 缓存数据回退方法以及缓存数据回退装置

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4507751A (en) * 1982-06-21 1985-03-26 International Business Machines Corporation Method and apparatus for logging journal data using a log write ahead data set
US5155678A (en) * 1985-10-29 1992-10-13 International Business Machines Corporation Data availability in restartable data base system
US4751702A (en) * 1986-02-10 1988-06-14 International Business Machines Corporation Improving availability of a restartable staged storage data base system that uses logging facilities
US4868744A (en) * 1986-03-03 1989-09-19 International Business Machines Corporation Method for restarting a long-running, fault-tolerant operation in a transaction-oriented data base system without burdening the system log
US4878167A (en) * 1986-06-30 1989-10-31 International Business Machines Corporation Method for managing reuse of hard log space by mapping log data during state changes and discarding the log data
US4888681A (en) * 1987-10-19 1989-12-19 International Business Machines Corporation Space management system for data files having shared access
US5077658A (en) * 1987-10-19 1991-12-31 International Business Machines Corporation Data access system for a file access processor
US5043866A (en) * 1988-04-08 1991-08-27 International Business Machines Corporation Soft checkpointing system using log sequence numbers derived from stored data pages and log records for database recovery
US4945474A (en) * 1988-04-08 1990-07-31 Internatinal Business Machines Corporation Method for restoring a database after I/O error employing write-ahead logging protocols
US5123104A (en) * 1988-04-08 1992-06-16 International Business Machines Corporation Method and apparatus for concurrent modification of an index tree in a transaction processing system utilizing selective indication of structural modification operations

Also Published As

Publication number Publication date
ATE148241T1 (de) 1997-02-15
CA2018932A1 (en) 1990-12-13
EP0402542B1 (de) 1997-01-22
US5437026A (en) 1995-07-25
DE68927705D1 (de) 1997-03-06
EP0402542A1 (de) 1990-12-19
JP2531835B2 (ja) 1996-09-04
JPH0324649A (ja) 1991-02-01
BR9002804A (pt) 1991-08-20

Similar Documents

Publication Publication Date Title
ATE148241T1 (de) Verfahren zum entfernen unbestätigter änderungen an gespeicherten daten durch ein datenbankverwaltungssystem
DE3788444T2 (de) Verfahren zum Wiederanlauf einer langlaufenden fehlertoleranten Operation in einem transaktionsorientierten Datenbasissystem.
CN108959400B (zh) 银行系统历史数据清理方法及装置
US5278982A (en) Log archive filtering method for transaction-consistent forward recovery from catastrophic media failures
DE68926693D1 (de) System und Verfahren zur einem Systemfehler nachfolgenden Datenerholung in einer Datenbank eines Rechnersystems
US20070022146A1 (en) Unobtrusive Point-In-Time Consistent Copies
JPH06168169A (ja) ログフォースなしに仮定コミットを持つ２相コミットプロトコルを使用する分散トランザクション処理
PH27313A (en) Method and apparatus for concurrent modification of an index tree in a transaction processing system utilizing selective indication of structural modification operations
US20110145193A1 (en) Apparatus and method for creating a real time database replica
JPH05108448A (ja) データのバツクアツプ及び回復
CA2550003A1 (en) Geographically distributed clusters
DE3889254T2 (de) Verfahren zur Steuerung von gleichzeitigen Zugriffen innerhalb einer Seite sowie Teilwiederholung von Transaktionen in einem transaktionsorientierten System des Vorausschreibaufzeichnungstyps.
EP3789880B1 (de) System und verfahren zum konsistenten backup von verteilten, transaktionalen datenbanken
US6473776B2 (en) Automatic prunning for log-based replication
CN110543485B (zh) 一种基于快照的区块链预约归档方法
Schlageter Problems of optimistic concurrency control in distributed database systems
CN111831455A (zh) 工业物联网下分布式事务处理系统及方法
EP0834128B1 (de) Datensatzsicherung in einer gemeinsam genutzten umgebung
JPH1153239A (ja) データベースのロールバック処理方法及び前記ロールバック処理方法の手順を記録した記録媒体
CN117093649A (zh) 增量数据实时比对修复方法、装置、计算机设备及存储介质
JPH02211557A (ja) データベースの退避方式
EP3622414A1 (de) Datenbank mit feldbezogenen zeitstempeln
Shin et al. An efficient log-based crash recovery scheme for nested transactions
JPH05233546A (ja) 論理リカバリ方法
JPS6013496B2 (ja) エクステント単位の復旧開始点制御方式

Legal Events

Date Code Title Description
8364 No opposition during term of opposition
8339 Ceased/non-payment of the annual fee