ATE148241T1 - 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
ATE148241T1
ATE148241T1 AT89305987T AT89305987T ATE148241T1 AT E148241 T1 ATE148241 T1 AT E148241T1 AT 89305987 T AT89305987 T AT 89305987T AT 89305987 T AT89305987 T AT 89305987T AT E148241 T1 ATE148241 T1 AT E148241T1
Authority
AT
Austria
Prior art keywords
backout
changes
failure
copy
database management
Prior art date
Application number
AT89305987T
Other languages
English (en)
Inventor
Samuel David Borman
Arthur Jonathan Tyrrell
Original Assignee
Ibm
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 Ibm filed Critical Ibm
Application granted granted Critical
Publication of ATE148241T1 publication Critical patent/ATE148241T1/de

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 operations
    • G06F11/1471—Error detection or correction of the data by redundancy in operations involving logging of persistent data for recovery
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
AT89305987T 1989-06-13 1989-06-13 Verfahren zum entfernen unbestätigter änderungen an gespeicherten daten durch ein datenbankverwaltungssystem ATE148241T1 (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 (1)

Publication Number Publication Date
ATE148241T1 true ATE148241T1 (de) 1997-02-15

Family

ID=8202715

Family Applications (1)

Application Number Title Priority Date Filing Date
AT89305987T ATE148241T1 (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
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
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
US7577807B2 (en) 2003-09-23 2009-08-18 Symantec Operating Corporation Methods and devices for restoring a portion of a data store
US7730222B2 (en) 2004-08-24 2010-06-01 Symantec Operating System Processing storage-related I/O requests using binary tree data structures
US7904428B2 (en) 2003-09-23 2011-03-08 Symantec Corporation Methods and apparatus for recording write requests directed to a data store
US7725760B2 (en) 2003-09-23 2010-05-25 Symantec Operating Corporation Data storage system
US7577806B2 (en) 2003-09-23 2009-08-18 Symantec Operating Corporation Systems and methods for time dependent data storage and recovery
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
US7827362B2 (en) 2004-08-24 2010-11-02 Symantec Corporation Systems, apparatus, and methods for processing I/O requests
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
US5077658A (en) * 1987-10-19 1991-12-31 International Business Machines Corporation Data access system for a file access processor
US4888681A (en) * 1987-10-19 1989-12-19 International Business Machines Corporation Space management system for data files having shared access
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
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
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
BR9002804A (pt) 1991-08-20
US5437026A (en) 1995-07-25
EP0402542A1 (de) 1990-12-19
EP0402542B1 (de) 1997-01-22
JPH0324649A (ja) 1991-02-01
JP2531835B2 (ja) 1996-09-04
CA2018932A1 (en) 1990-12-13
DE68927705T2 (de) 1997-07-17
DE68927705D1 (de) 1997-03-06

Similar Documents

Publication Publication Date Title
ATE148241T1 (de) Verfahren zum entfernen unbestätigter änderungen an gespeicherten daten durch ein datenbankverwaltungssystem
DE3788444D1 (de) Verfahren zum Wiederanlauf einer langlaufenden fehlertoleranten Operation in einem transaktionsorientierten Datenbasissystem.
CN108959400B (zh) 银行系统历史数据清理方法及装置
US7890466B2 (en) Techniques for increasing the usefulness of transaction logs
DE69502125T2 (de) Synchrone Datenfernduplizierung
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
DE69325719T2 (de) Datenbanksicherungssystem
DE69112694T2 (de) Verfahren zum Betrieb eines Datenverarbeitungssystems zur Ausführung von Datenbanktransaktionen.
US5701457A (en) Method of designated time interval reservation access process of online updating and backing up of large database versions without reserving exclusive control
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
EP3789880B1 (de) System und verfahren zum konsistenten backup von verteilten, transaktionalen datenbanken
CA2483039A1 (en) Method and apparatus for change data capture in a database system
DE3781486D1 (de) Verfahren zur stossfreien umschaltung von aktiven einheiten zu ersatzeinheiten in datenverarbeitungsanlagen und datenverarbeitungsanlage zur durchfuehrung dieses verfahrens.
JPH05108448A (ja) データのバツクアツプ及び回復
DE3889254T2 (de) Verfahren zur Steuerung von gleichzeitigen Zugriffen innerhalb einer Seite sowie Teilwiederholung von Transaktionen in einem transaktionsorientierten System des Vorausschreibaufzeichnungstyps.
EP3622414A1 (de) Datenbank mit feldbezogenen zeitstempeln
DE69614009T2 (de) Ferndatenbankverdopplungsvorrichtung mit Unterstützung zur Datenbankvervielfältigung für Online-DDL-Operationen
US6473776B2 (en) Automatic prunning for log-based replication
US6792435B1 (en) Method and apparatus for recovering the definitions of dropped database objects
CN117093649A (zh) 增量数据实时比对修复方法、装置、计算机设备及存储介质
Schlageter Problems of optimistic concurrency control in distributed database systems
EP0834128B1 (de) Datensatzsicherung in einer gemeinsam genutzten umgebung

Legal Events

Date Code Title Description
RER Ceased as to paragraph 5 lit. 3 law introducing patent treaties