ZA200200123B - Database table recovery system. - Google Patents
Database table recovery system. Download PDFInfo
- Publication number
- ZA200200123B ZA200200123B ZA200200123A ZA200200123A ZA200200123B ZA 200200123 B ZA200200123 B ZA 200200123B ZA 200200123 A ZA200200123 A ZA 200200123A ZA 200200123 A ZA200200123 A ZA 200200123A ZA 200200123 B ZA200200123 B ZA 200200123B
- Authority
- ZA
- South Africa
- Prior art keywords
- tablespace
- backup copy
- data
- records
- access
- Prior art date
Links
- 238000011084 recovery Methods 0.000 title claims description 26
- 238000000034 method Methods 0.000 claims abstract description 32
- 230000001419 dependent effect Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 238000013500 data storage Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000007423 decrease Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 239000000284 extract Substances 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
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
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- 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/99941—Database schema or data structure
- Y10S707/99948—Application of database or data structure, e.g. distributed, multimedia, or image
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)
- Information Transfer Between Computers (AREA)
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/349,198 US7756818B1 (en) | 1999-07-07 | 1999-07-07 | Database table recovery system |
Publications (1)
Publication Number | Publication Date |
---|---|
ZA200200123B true ZA200200123B (en) | 2003-06-25 |
Family
ID=23371304
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
ZA200200123A ZA200200123B (en) | 1999-07-07 | 2002-01-07 | Database table recovery system. |
Country Status (14)
Country | Link |
---|---|
US (1) | US7756818B1 (de) |
EP (1) | EP1200907B1 (de) |
JP (1) | JP2003532167A (de) |
KR (1) | KR20020035093A (de) |
CN (1) | CN1205577C (de) |
AT (1) | ATE460707T1 (de) |
AU (1) | AU779735B2 (de) |
BR (1) | BR0012237A (de) |
CA (1) | CA2378514A1 (de) |
DE (1) | DE60043984D1 (de) |
HK (1) | HK1047168A1 (de) |
IL (2) | IL147491A0 (de) |
WO (1) | WO2001004797A1 (de) |
ZA (1) | ZA200200123B (de) |
Families Citing this family (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR100936390B1 (ko) | 2002-11-26 | 2010-01-14 | 삼성전자주식회사 | 데이터 백업 및 복원 방법 |
CN100373385C (zh) * | 2003-01-17 | 2008-03-05 | 中兴通讯股分有限公司 | 一种备份和恢复重要数据的方法 |
US7334002B2 (en) * | 2004-02-27 | 2008-02-19 | Microsoft Corporation | System and method for recovery units in databases |
JP4143611B2 (ja) | 2005-02-04 | 2008-09-03 | インターナショナル・ビジネス・マシーンズ・コーポレーション | バックアップ生成装置、リカバリ処理装置、バックアップ生成方法、リカバリ処理方法、及びプログラム |
US7769719B2 (en) * | 2006-01-05 | 2010-08-03 | International Business Machines Corporation | File system dump/restore by node numbering |
US8112396B2 (en) * | 2006-06-07 | 2012-02-07 | Emc Corporation | Backup and recovery of integrated linked databases |
US8452730B2 (en) * | 2007-12-12 | 2013-05-28 | Teradata Us, Inc. | Archiving method and system |
US9256599B1 (en) | 2008-12-23 | 2016-02-09 | Symantec Corporation | Programmatically receiving and storing transaction information in support of a database recovery engine |
CN101908064A (zh) * | 2010-07-20 | 2010-12-08 | 中兴通讯股份有限公司 | 数据库备份恢复方法和装置 |
CN103034636A (zh) * | 2011-09-29 | 2013-04-10 | 盛乐信息技术(上海)有限公司 | 一种非关系型数据库的回滚方法、装置及系统 |
CN104376073A (zh) * | 2014-11-14 | 2015-02-25 | 北京锐安科技有限公司 | 一种数据库恢复方法及装置 |
Family Cites Families (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
US4961134A (en) * | 1988-07-15 | 1990-10-02 | International Business Machines Corporation | Method for minimizing locking and reading in a segmented storage space |
US5222235A (en) * | 1990-02-01 | 1993-06-22 | Bmc Software, Inc. | Databases system for permitting concurrent indexing and reloading of data by early simulating the reload process to determine final locations of the data |
US5517641A (en) * | 1992-05-27 | 1996-05-14 | Cdb Software, Inc. | Restartable method to reorganize DB2 tablespace records by determining new physical positions for the records prior to moving using a non sorting technic |
US5430871A (en) | 1992-10-27 | 1995-07-04 | Bmc Software, Inc. | Method of dynamically adding and removing DB2 active logs |
US5404508A (en) | 1992-12-03 | 1995-04-04 | Unisys Corporation | Data base backup and recovery system and method |
GB2276739A (en) | 1993-03-30 | 1994-10-05 | Ibm | System for storing persistent and non-persistent queued data. |
US5721915A (en) | 1994-12-30 | 1998-02-24 | International Business Machines Corporation | Interaction between application of a log and maintenance of a table that maps record identifiers during online reorganization of a database |
US5778390A (en) * | 1996-06-07 | 1998-07-07 | Electronic Data Systems Corporation | Method and systems for creating duplicating, and archiving database files |
US5873091A (en) * | 1997-04-28 | 1999-02-16 | International Business Machines Corporation | System for data structure loading with concurrent statistical analysis |
US6138106A (en) | 1997-05-19 | 2000-10-24 | Walker Asset Management Limited Partnership | Dynamically changing system for fulfilling concealed value gift certificate obligations |
US6272503B1 (en) * | 1997-05-30 | 2001-08-07 | Oracle Corporation | Tablespace-relative database pointers |
US5991772A (en) * | 1997-10-31 | 1999-11-23 | Oracle Corporation | Method and apparatus for restoring a portion of a database |
US6119128A (en) * | 1998-03-30 | 2000-09-12 | International Business Machines Corporation | Recovering different types of objects with one pass of the log |
US6189010B1 (en) * | 1998-06-10 | 2001-02-13 | Platinum Technology, Inc. | Method for repairing constraint violations in a database management system |
US6175823B1 (en) | 1998-09-15 | 2001-01-16 | Amazon.Com, Inc. | Electronic gift certificate system |
US6289355B1 (en) * | 1998-09-16 | 2001-09-11 | International Business Machines Corp. | Fast log apply |
US6122640A (en) * | 1998-09-22 | 2000-09-19 | Platinum Technology Ip, Inc. | Method and apparatus for reorganizing an active DBMS table |
US6606617B1 (en) * | 1998-09-24 | 2003-08-12 | International Business Machines Corporation | Optimized technique for prefetching LOB table space pages |
US6173269B1 (en) | 1998-12-16 | 2001-01-09 | Zowi.Com, Inc | Method and apparatus for executing electronic commercial transactions with minors |
-
1999
- 1999-07-07 US US09/349,198 patent/US7756818B1/en not_active Expired - Fee Related
-
2000
- 2000-06-23 CA CA002378514A patent/CA2378514A1/en not_active Abandoned
- 2000-06-23 BR BR0012237-8A patent/BR0012237A/pt not_active IP Right Cessation
- 2000-06-23 AT AT00943108T patent/ATE460707T1/de not_active IP Right Cessation
- 2000-06-23 DE DE60043984T patent/DE60043984D1/de not_active Expired - Lifetime
- 2000-06-23 WO PCT/US2000/017350 patent/WO2001004797A1/en not_active Application Discontinuation
- 2000-06-23 JP JP2001510132A patent/JP2003532167A/ja active Pending
- 2000-06-23 AU AU57626/00A patent/AU779735B2/en not_active Ceased
- 2000-06-23 EP EP00943108A patent/EP1200907B1/de not_active Expired - Lifetime
- 2000-06-23 KR KR1020027000214A patent/KR20020035093A/ko not_active Application Discontinuation
- 2000-06-23 IL IL14749100A patent/IL147491A0/xx active IP Right Grant
- 2000-06-23 CN CNB008100039A patent/CN1205577C/zh not_active Expired - Fee Related
-
2002
- 2002-01-06 IL IL147491A patent/IL147491A/en not_active IP Right Cessation
- 2002-01-07 ZA ZA200200123A patent/ZA200200123B/en unknown
- 2002-09-27 HK HK02107176.9A patent/HK1047168A1/zh unknown
Also Published As
Publication number | Publication date |
---|---|
IL147491A0 (en) | 2002-08-14 |
AU779735B2 (en) | 2005-02-10 |
IL147491A (en) | 2008-04-13 |
AU5762600A (en) | 2001-01-30 |
BR0012237A (pt) | 2003-07-15 |
KR20020035093A (ko) | 2002-05-09 |
JP2003532167A (ja) | 2003-10-28 |
EP1200907B1 (de) | 2010-03-10 |
US7756818B1 (en) | 2010-07-13 |
CN1421010A (zh) | 2003-05-28 |
ATE460707T1 (de) | 2010-03-15 |
EP1200907A1 (de) | 2002-05-02 |
CN1205577C (zh) | 2005-06-08 |
WO2001004797A1 (en) | 2001-01-18 |
DE60043984D1 (de) | 2010-04-22 |
HK1047168A1 (zh) | 2003-02-07 |
EP1200907A4 (de) | 2003-09-17 |
CA2378514A1 (en) | 2001-01-18 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7308456B2 (en) | Method and apparatus for building one or more indexes on data concurrent with manipulation of data | |
US10146643B2 (en) | Database recovery and index rebuilds | |
US6161109A (en) | Accumulating changes in a database management system by copying the data object to the image copy if the data object identifier of the data object is greater than the image identifier of the image copy | |
US6119128A (en) | Recovering different types of objects with one pass of the log | |
US5613113A (en) | Consistent recreation of events from activity logs | |
US5553279A (en) | Lossless distribution of time series data in a relational data base network | |
US5842208A (en) | High performance recover/build index system by unloading database files in parallel | |
EP1480132B1 (de) | System und Verfahren zur Erkennung und Speicherung der Änderungen, vorgenommen an einer Tabelle | |
US5873091A (en) | System for data structure loading with concurrent statistical analysis | |
US6901418B2 (en) | Data archive recovery | |
US7756818B1 (en) | Database table recovery system | |
US7225206B2 (en) | System and method for reorganizing stored data | |
US6457014B1 (en) | System and method for extracting index key data fields | |
AU2004240204B2 (en) | Database table recovery system | |
CN112612648B (zh) | 一种SQL Server数据库恢复方法、终端设备及存储介质 | |
US20020169780A1 (en) | Method and data processing system for providing disaster recovery file synchronization | |
JPH09305449A (ja) | データベース管理システム | |
AU2002256151A1 (en) | System and method for reorganizing stored data |