CA2060886A1 - Recoverability in mass storage data base systems - Google Patents
Recoverability in mass storage data base systemsInfo
- Publication number
- CA2060886A1 CA2060886A1 CA002060886A CA2060886A CA2060886A1 CA 2060886 A1 CA2060886 A1 CA 2060886A1 CA 002060886 A CA002060886 A CA 002060886A CA 2060886 A CA2060886 A CA 2060886A CA 2060886 A1 CA2060886 A1 CA 2060886A1
- Authority
- CA
- Canada
- Prior art keywords
- data base
- flat file
- message
- recovery information
- data
- 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.)
- Granted
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/1446—Point-in-time backing up or restoration of persistent data
-
- 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/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04M—TELEPHONIC COMMUNICATION
- H04M3/00—Automatic or semi-automatic exchanges
- H04M3/42—Systems providing special services or facilities to subscribers
- H04M3/50—Centralised arrangements for answering calls; Centralised arrangements for recording messages for absent or busy subscribers ; Centralised arrangements for recording messages
- H04M3/53—Centralised arrangements for recording incoming messages, i.e. mailbox systems
- H04M3/533—Voice mail systems
-
- 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/80—Database-specific techniques
Abstract
The message management system utilizes a flat file (20) on mirrored disk for storing fixed-length Message Segments (MS) of variable-length Messages to be managed by the system. Inconsistencies between mirrored copies of data are tolerated and cor-rected. Message Management includes Storing, Retrieving and Deleting Messages in response to commands from clients. Each Message Segment in the flat file is stored in a record containing the Message Segment data and Recovery Information (RI). A
data base (21) for accessing the Message Segments in the flat file is maintained on system disk. The Recovery Information is such as to permit recovery of the data base from the Recovery Information in the flat file if the data base is obsolete, lost or corrupted.
TNAUDIT file is utilized to determine that the data base is synchronized with the flat file. If data base inconsistency is detected, the data base is rebuilt from the Recovery Information.
data base (21) for accessing the Message Segments in the flat file is maintained on system disk. The Recovery Information is such as to permit recovery of the data base from the Recovery Information in the flat file if the data base is obsolete, lost or corrupted.
TNAUDIT file is utilized to determine that the data base is synchronized with the flat file. If data base inconsistency is detected, the data base is rebuilt from the Recovery Information.
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US07/514,783 | 1990-04-25 | ||
US07/514,783 US5138710A (en) | 1990-04-25 | 1990-04-25 | Apparatus and method for providing recoverability in mass storage data base systems without audit trail mechanisms |
PCT/US1991/002845 WO1991016677A1 (en) | 1990-04-25 | 1991-04-24 | Recoverability in mass storage data base systems |
Publications (2)
Publication Number | Publication Date |
---|---|
CA2060886A1 true CA2060886A1 (en) | 1991-10-26 |
CA2060886C CA2060886C (en) | 2004-03-23 |
Family
ID=24048674
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CA002060886A Expired - Fee Related CA2060886C (en) | 1990-04-25 | 1991-04-24 | Recoverability in mass storage data base systems |
Country Status (6)
Country | Link |
---|---|
US (1) | US5138710A (en) |
EP (1) | EP0480009B1 (en) |
JP (1) | JPH05502747A (en) |
CA (1) | CA2060886C (en) |
DE (1) | DE69116065T2 (en) |
WO (1) | WO1991016677A1 (en) |
Families Citing this family (40)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5065311A (en) * | 1987-04-20 | 1991-11-12 | Hitachi, Ltd. | Distributed data base system of composite subsystem type, and method fault recovery for the system |
US5325519A (en) * | 1991-10-18 | 1994-06-28 | Texas Microsystems, Inc. | Fault tolerant computer with archival rollback capabilities |
EP0551009B1 (en) * | 1992-01-08 | 2001-06-13 | Emc Corporation | Method for synchronizing reserved areas in a redundant storage array |
JP3213766B2 (en) * | 1992-03-16 | 2001-10-02 | 株式会社日立製作所 | Replicate file update system |
EP0593062A3 (en) * | 1992-10-16 | 1995-08-30 | Siemens Ind Automation Inc | Redundant networked database system |
US5404508A (en) * | 1992-12-03 | 1995-04-04 | Unisys Corporation | Data base backup and recovery system and method |
US5504883A (en) * | 1993-02-01 | 1996-04-02 | Lsc, Inc. | Method and apparatus for insuring recovery of file control information for secondary storage systems |
US5515502A (en) * | 1993-09-30 | 1996-05-07 | Sybase, Inc. | Data backup system with methods for stripe affinity backup to multiple archive devices |
CA2137167C (en) * | 1993-12-22 | 1999-09-21 | Tony J. Brice | Data management method and architecture |
US5778167A (en) * | 1994-06-14 | 1998-07-07 | Emc Corporation | System and method for reassigning a storage location for reconstructed data on a persistent medium storage system |
US5592618A (en) * | 1994-10-03 | 1997-01-07 | International Business Machines Corporation | Remote copy secondary data copy validation-audit function |
US5734817A (en) * | 1995-03-01 | 1998-03-31 | Unisys Corporation | Method for making a data base available to a user program during data base recovery |
US5644696A (en) * | 1995-06-06 | 1997-07-01 | International Business Machines Corporation | Recovering multi-volume data sets during volume recovery |
US5771276A (en) * | 1995-10-10 | 1998-06-23 | Ast Research, Inc. | Voice templates for interactive voice mail and voice response system |
US6453345B2 (en) | 1996-11-06 | 2002-09-17 | Datadirect Networks, Inc. | Network security and surveillance system |
US5953352A (en) | 1997-06-23 | 1999-09-14 | Micron Electronics, Inc. | Method of checking data integrity for a raid 1 system |
US6061822A (en) * | 1997-06-23 | 2000-05-09 | Micron Electronics, Inc. | System and method for providing a fast and efficient comparison of cyclic redundancy check (CRC/checks sum) values of two mirrored disks |
US6058166A (en) * | 1997-10-06 | 2000-05-02 | Unisys Corporation | Enhanced multi-lingual prompt management in a voice messaging system with support for speech recognition |
US6317485B1 (en) * | 1998-06-09 | 2001-11-13 | Unisys Corporation | System and method for integrating notification functions of two messaging systems in a universal messaging system |
US6430177B1 (en) | 1998-06-09 | 2002-08-06 | Unisys Corporation | Universal messaging system providing integrated voice, data and fax messaging services to pc/web-based clients, including a content manager for receiving information from content providers and formatting the same into multimedia containers for distribution to web-based clients |
US6148329A (en) * | 1998-07-20 | 2000-11-14 | Unisys Corporation | Method and system for maintaining the format of messages in a messaging system database |
US6504915B1 (en) * | 1998-09-25 | 2003-01-07 | Unisys Corporation | Multiple node messaging system wherein nodes have shared access to message stores of other nodes |
US6408310B1 (en) * | 1999-10-08 | 2002-06-18 | Unisys Corporation | System and method for expediting transfer of sectioned audit files from a primary host to a secondary host |
US7116764B1 (en) | 2000-08-11 | 2006-10-03 | Unisys Corporation | Network interface unit having an embedded services processor |
US7095828B1 (en) | 2000-08-11 | 2006-08-22 | Unisys Corporation | Distributed network applications platform architecture |
US7327832B1 (en) | 2000-08-11 | 2008-02-05 | Unisys Corporation | Adjunct processing of multi-media functions in a messaging system |
US6977927B1 (en) | 2000-09-18 | 2005-12-20 | Hewlett-Packard Development Company, L.P. | Method and system of allocating storage resources in a storage area network |
US6804819B1 (en) | 2000-09-18 | 2004-10-12 | Hewlett-Packard Development Company, L.P. | Method, system, and computer program product for a data propagation platform and applications of same |
US7386610B1 (en) | 2000-09-18 | 2008-06-10 | Hewlett-Packard Development Company, L.P. | Internet protocol data mirroring |
JP2002189607A (en) * | 2000-12-22 | 2002-07-05 | Nec Corp | Memory managing method and information processor |
US6606690B2 (en) | 2001-02-20 | 2003-08-12 | Hewlett-Packard Development Company, L.P. | System and method for accessing a storage area network as network attached storage |
US6629108B2 (en) * | 2001-03-09 | 2003-09-30 | Hewlett-Packard Development Company, Lp. | Method for insuring data integrity for mirrored independently accessible memory devices |
US20030154271A1 (en) * | 2001-10-05 | 2003-08-14 | Baldwin Duane Mark | Storage area network methods and apparatus with centralized management |
US7028156B1 (en) | 2003-07-01 | 2006-04-11 | Veritas Operating Corporation | Use of read data tracking and caching to recover from data corruption |
US7028139B1 (en) | 2003-07-03 | 2006-04-11 | Veritas Operating Corporation | Application-assisted recovery from data corruption in parity RAID storage using successive re-reads |
US7472129B2 (en) * | 2004-06-29 | 2008-12-30 | Microsoft Corporation | Lossless recovery for computer systems with map assisted state transfer |
US7360111B2 (en) * | 2004-06-29 | 2008-04-15 | Microsoft Corporation | Lossless recovery for computer systems with remotely dependent data recovery |
GB2529403A (en) | 2014-08-18 | 2016-02-24 | Ibm | A Method of operating a shared nothing cluster system |
CN107864135A (en) * | 2017-11-07 | 2018-03-30 | 山东网智物联网科技有限公司 | The realization device of Internet of Things communication means, device and Internet of Things Network Communication |
CN112052120B (en) * | 2020-08-27 | 2022-08-05 | 厦门市美亚柏科信息股份有限公司 | Database deleted data recovery method and device |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
FR1510481A (en) * | 1966-02-21 | 1968-01-19 | Western Electric Co | Information transfer arrangement |
US3840862A (en) * | 1973-09-27 | 1974-10-08 | Honeywell Inf Systems | Status indicator apparatus for tag directory in associative stores |
US4148098A (en) * | 1976-10-18 | 1979-04-03 | Xerox Corporation | Data transfer system with disk command verification apparatus |
US4419725A (en) * | 1980-11-14 | 1983-12-06 | Sperry Corporation | Cache/disk subsystem with tagalong copy |
US4637024A (en) * | 1984-11-02 | 1987-01-13 | International Business Machines Corporation | Redundant page identification for a catalogued memory |
US4785473A (en) * | 1984-11-27 | 1988-11-15 | Genesis Electronics Corporation | Interactive audio telecommunications message storage, forwarding and retrieval system |
JPH01261745A (en) * | 1988-04-08 | 1989-10-18 | Internatl Business Mach Corp <Ibm> | Recovery of transaction of data base record |
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 |
-
1990
- 1990-04-25 US US07/514,783 patent/US5138710A/en not_active Expired - Lifetime
-
1991
- 1991-04-24 EP EP91908879A patent/EP0480009B1/en not_active Expired - Lifetime
- 1991-04-24 CA CA002060886A patent/CA2060886C/en not_active Expired - Fee Related
- 1991-04-24 WO PCT/US1991/002845 patent/WO1991016677A1/en active IP Right Grant
- 1991-04-24 JP JP3508679A patent/JPH05502747A/en active Pending
- 1991-04-24 DE DE69116065T patent/DE69116065T2/en not_active Expired - Fee Related
Also Published As
Publication number | Publication date |
---|---|
US5138710A (en) | 1992-08-11 |
EP0480009A1 (en) | 1992-04-15 |
WO1991016677A1 (en) | 1991-10-31 |
EP0480009B1 (en) | 1996-01-03 |
JPH05502747A (en) | 1993-05-13 |
CA2060886C (en) | 2004-03-23 |
DE69116065T2 (en) | 1996-06-13 |
DE69116065D1 (en) | 1996-02-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CA2060886A1 (en) | Recoverability in mass storage data base systems | |
US8667274B2 (en) | System and method for WORM data storage | |
EP0351387A3 (en) | Minimizing locking and reading in a segmented storage space | |
CN101937377B (en) | Data recovery method and device | |
WO2005050381B1 (en) | Systems and methods for performing storage operations using network attached storage | |
CA2207735A1 (en) | Storage of computer data | |
EP0314292A3 (en) | Concurrent record access database system using an index tree structure and method therefor | |
DE69613594T2 (en) | Computer security system with open files | |
EP0918284A3 (en) | Log based data architecture for a transactional message queuing system | |
EP0397404A3 (en) | A system and method for reading and writing disks formatted for an operating system foreign to the host computer | |
EP1049089A3 (en) | Data structure for control information on rewriteable data storage media | |
EP0323890A3 (en) | Data storage method | |
MY110229A (en) | Data file directories and methods. | |
CA2279028A1 (en) | Dropped database table recovery | |
EP0336548A3 (en) | Supporting long fields of recoverable database records in a computer system | |
US5321558A (en) | Method of storing data on a magnetic tape | |
EP1079298A3 (en) | Digital data storage subsystem including directory for efficiently providing formatting information for stored records | |
EP0354645A3 (en) | Retrieving files from disk storage | |
JPH04315232A (en) | Disk device and file managing method therefor | |
JPH03125238A (en) | Information control system | |
JPS6087044U (en) | Logical sequence file management device | |
JPH04145548A (en) | File controlling system | |
Owens | Systems integration and networking on the rise. | |
Ruffin | Issues in Logging Techniques through a Study of Four Systems | |
Collins | Automating records management. |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
EEER | Examination request | ||
MKLA | Lapsed |