KR101137213B1 - 데이타베이스의 복구 유닛을 위한 시스템 및 방법 - Google Patents

데이타베이스의 복구 유닛을 위한 시스템 및 방법 Download PDF

Info

Publication number
KR101137213B1
KR101137213B1 KR1020057011141A KR20057011141A KR101137213B1 KR 101137213 B1 KR101137213 B1 KR 101137213B1 KR 1020057011141 A KR1020057011141 A KR 1020057011141A KR 20057011141 A KR20057011141 A KR 20057011141A KR 101137213 B1 KR101137213 B1 KR 101137213B1
Authority
KR
South Korea
Prior art keywords
unit
database
catalog
catalogs
recovery
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
KR1020057011141A
Other languages
English (en)
Korean (ko)
Other versions
KR20060121654A (ko
Inventor
피터 번
Original Assignee
마이크로소프트 코포레이션
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 마이크로소프트 코포레이션 filed Critical 마이크로소프트 코포레이션
Publication of KR20060121654A publication Critical patent/KR20060121654A/ko
Application granted granted Critical
Publication of KR101137213B1 publication Critical patent/KR101137213B1/ko
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Images

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 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
    • 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 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 OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/40—Data acquisition and logging
    • 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/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/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)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Quality & Reliability (AREA)
  • Computer Hardware Design (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Hardware Redundancy (AREA)
  • Exchange Systems With Centralized Control (AREA)
KR1020057011141A 2004-02-27 2004-07-29 데이타베이스의 복구 유닛을 위한 시스템 및 방법 Expired - Fee Related KR101137213B1 (ko)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US10/789,244 US7334002B2 (en) 2004-02-27 2004-02-27 System and method for recovery units in databases
US10/789,244 2004-02-27
PCT/US2004/024538 WO2005091736A2 (en) 2004-02-27 2004-07-29 System and method for recovery units in databases

Publications (2)

Publication Number Publication Date
KR20060121654A KR20060121654A (ko) 2006-11-29
KR101137213B1 true KR101137213B1 (ko) 2012-04-19

Family

ID=34887231

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020057011141A Expired - Fee Related KR101137213B1 (ko) 2004-02-27 2004-07-29 데이타베이스의 복구 유닛을 위한 시스템 및 방법

Country Status (8)

Country Link
US (1) US7334002B2 (enExample)
EP (1) EP1721261B1 (enExample)
JP (1) JP4762972B2 (enExample)
KR (1) KR101137213B1 (enExample)
CN (1) CN100461163C (enExample)
AT (1) ATE433153T1 (enExample)
DE (1) DE602004021431D1 (enExample)
WO (1) WO2005091736A2 (enExample)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2016056864A1 (ko) * 2014-10-08 2016-04-14 (주)섬엔지니어링 ＩｏＴ 가상 파일 체계를 이용한 ＩｏＴ 분석시스템

Families Citing this family (52)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6618822B1 (en) * 2000-01-03 2003-09-09 Oracle International Corporation Method and mechanism for relational access of recovery logs in a database system
US6631374B1 (en) * 2000-09-29 2003-10-07 Oracle Corp. System and method for providing fine-grained temporal database access
US7299239B1 (en) 2002-12-02 2007-11-20 Oracle International Corporation Methods for partitioning an object
US7149736B2 (en) * 2003-09-26 2006-12-12 Microsoft Corporation Maintaining time-sorted aggregation records representing aggregations of values from multiple database records using multiple partitions
US7624120B2 (en) * 2004-02-11 2009-11-24 Microsoft Corporation System and method for switching a data partition
US7499953B2 (en) * 2004-04-23 2009-03-03 Oracle International Corporation Online recovery of user tables using flashback table
JP2006004031A (ja) * 2004-06-16 2006-01-05 Hitachi Ltd データ処理方法およびシステム並びにストレージ装置方法およびその処理プログラム
US8037056B2 (en) * 2005-02-18 2011-10-11 International Business Machines Corporation Online repair of a replicated table
US8214353B2 (en) * 2005-02-18 2012-07-03 International Business Machines Corporation Support for schema evolution in a multi-node peer-to-peer replication environment
US9286346B2 (en) * 2005-02-18 2016-03-15 International Business Machines Corporation Replication-only triggers
US7376675B2 (en) * 2005-02-18 2008-05-20 International Business Machines Corporation Simulating multi-user activity while maintaining original linear request order for asynchronous transactional events
US8145653B2 (en) * 2005-04-08 2012-03-27 International Business Machines Corporation Using schemas to generate application specific business objects for use in an integration broker
US20060230048A1 (en) * 2005-04-08 2006-10-12 International Business Machines Corporation Method and apparatus for object discovery agent based mapping of application specific markup language schemas to application specific business objects in an integrated application environment
US8458201B2 (en) * 2005-04-08 2013-06-04 International Business Machines Corporation Method and apparatus for mapping structured query language schema to application specific business objects in an integrated application environment
US20080059469A1 (en) * 2006-08-31 2008-03-06 International Business Machines Corporation Replication Token Based Synchronization
US7664766B2 (en) * 2006-09-12 2010-02-16 International Business Machines Corporation System, method and computer program product for managing data
US8589357B2 (en) * 2006-10-20 2013-11-19 Oracle International Corporation Techniques for automatically tracking and archiving transactional data changes
KR100912127B1 (ko) * 2006-12-04 2009-08-13 한국전자통신연구원 메타데이터 관리 시스템 및 메타데이터 관리 방법
US8140493B2 (en) * 2007-06-15 2012-03-20 Oracle International Corporation Changing metadata without invalidating cursors
US8356014B2 (en) * 2007-06-15 2013-01-15 Oracle International Corporation Referring to partitions with for (values) clause
US8135688B2 (en) * 2007-06-15 2012-03-13 Oracle International Corporation Partition/table allocation on demand
US8209294B2 (en) * 2007-06-15 2012-06-26 Oracle International Corporation Dynamic creation of database partitions
US7984023B2 (en) * 2007-10-04 2011-07-19 International Business Machines Corporation Method and utility for copying files from a faulty disk
US8078582B2 (en) * 2009-04-06 2011-12-13 Microsoft Corporation Data change ordering in multi-log based replication
US8402071B2 (en) * 2009-06-19 2013-03-19 Aptare, Inc. Catalog that stores file system metadata in an optimized manner
US8671074B2 (en) 2010-04-12 2014-03-11 Microsoft Corporation Logical replication in clustered database system with adaptive cloning
US8954664B1 (en) 2010-10-01 2015-02-10 Western Digital Technologies, Inc. Writing metadata files on a disk
US8756361B1 (en) 2010-10-01 2014-06-17 Western Digital Technologies, Inc. Disk drive modifying metadata cached in a circular buffer when a write operation is aborted
US8762336B2 (en) 2011-05-23 2014-06-24 Microsoft Corporation Geo-verification and repair
US8756382B1 (en) 2011-06-30 2014-06-17 Western Digital Technologies, Inc. Method for file based shingled data storage utilizing multiple media types
US8798840B2 (en) 2011-09-30 2014-08-05 Irobot Corporation Adaptive mapping with spatial summaries of sensor data
US8612706B1 (en) * 2011-12-21 2013-12-17 Western Digital Technologies, Inc. Metadata recovery in a disk drive
US10860563B2 (en) 2012-01-06 2020-12-08 Microsoft Technology Licensing, Llc Distributed database with modular blocks and associated log files
US9659041B2 (en) * 2012-01-30 2017-05-23 Oracle International Corporation Model for capturing audit trail data with reduced probability of loss of critical data
US9766987B2 (en) * 2013-01-11 2017-09-19 Commvault Systems, Inc. Table level database restore in a data storage system
US9753980B1 (en) * 2013-02-25 2017-09-05 EMC IP Holding Company LLC M X N dispatching in large scale distributed system
US10963426B1 (en) 2013-02-25 2021-03-30 EMC IP Holding Company LLC Method of providing access controls and permissions over relational data stored in a hadoop file system
US9411692B2 (en) 2013-04-26 2016-08-09 Hewlett Packard Enterprise Development Lp Applying write elision
US9965497B2 (en) 2014-05-29 2018-05-08 Oracle International Corporation Moving data between partitions
KR101593184B1 (ko) * 2014-09-16 2016-02-15 한국전자통신연구원 파일시스템 메타데이터 기반 파티션 복구 방법 및 장치
CN104376091B (zh) * 2014-11-20 2017-08-01 厦门市美亚柏科信息股份有限公司 对SQLite中删除的数据进行恢复的方法及装置
CN104462261A (zh) * 2014-11-23 2015-03-25 国云科技股份有限公司 一种仅有mdf文件附加还原数据库的方法
US10114615B1 (en) * 2014-12-16 2018-10-30 United Technologies Corporation Feature based control system for multi-user CAx
US9804935B1 (en) * 2015-01-26 2017-10-31 Intel Corporation Methods for repairing a corrupted database to a new, correct state by selectively using redo and undo operations
CN106844089B (zh) * 2015-12-03 2021-01-01 阿里巴巴集团控股有限公司 一种用于恢复树形数据存储的方法与设备
US10002055B2 (en) * 2016-04-29 2018-06-19 Netapp, Inc. Efficient repair of B+ tree databases with variable-length records
CN108509518A (zh) * 2018-03-09 2018-09-07 北京小米移动软件有限公司 信息处理方法及设备
CN111124751B (zh) * 2019-11-12 2023-11-17 华为云计算技术有限公司 数据恢复方法及系统、数据存储节点、数据库管理节点
KR102888945B1 (ko) 2019-11-13 2025-11-20 서강대학교산학협력단 단일 파일의 병렬 읽기/쓰기를 위한 락킹 방법 및 이를 구현하는 컴퓨팅 장치
CN111104259B (zh) * 2019-12-23 2022-08-12 厦门市美亚柏科信息股份有限公司 一种数据库恢复方法、装置及存储介质
TWI750783B (zh) * 2020-08-27 2021-12-21 技嘉科技股份有限公司 基本輸入輸出系統的復原系統及方法
CN115599796A (zh) * 2022-10-26 2023-01-13 北京奥星贝斯科技有限公司（Cn） 日志流处理方法、装置、电子设备及存储介质

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6185663B1 (en) 1998-06-15 2001-02-06 Compaq Computer Corporation Computer method and apparatus for file system block allocation with multiple redo

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH07244604A (ja) * 1994-03-04 1995-09-19 Nippon Telegr & Teleph Corp <Ntt> データベースオンライン復旧方法および装置
US6119128A (en) * 1998-03-30 2000-09-12 International Business Machines Corporation Recovering different types of objects with one pass of the log
US7756818B1 (en) * 1999-07-07 2010-07-13 Computer Associates Think, Inc. Database table recovery system
KR100390853B1 (ko) * 2000-06-07 2003-07-10 차상균 주 메모리 트랜잭션 처리 시스템에서 병렬적 회복 연산을 위한 디퍼런셜 로깅 방법 및 장치
US7076508B2 (en) * 2002-08-12 2006-07-11 International Business Machines Corporation Method, system, and program for merging log entries from multiple recovery log files

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6185663B1 (en) 1998-06-15 2001-02-06 Compaq Computer Corporation Computer method and apparatus for file system block allocation with multiple redo

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2016056864A1 (ko) * 2014-10-08 2016-04-14 (주)섬엔지니어링 ＩｏＴ 가상 파일 체계를 이용한 ＩｏＴ 분석시스템
KR20160041528A (ko) * 2014-10-08 2016-04-18 (주)섬엔지니어링 ＩｏＴ 가상 파일 체계를 이용한 ＩｏＴ 분석시스템
KR101632389B1 (ko) 2014-10-08 2016-06-21 (주)섬엔지니어링 ＩｏＴ 가상 파일 체계를 이용한 ＩｏＴ 분석시스템

Also Published As

Publication number Publication date
WO2005091736A2 (en) 2005-10-06
DE602004021431D1 (de) 2009-07-16
ATE433153T1 (de) 2009-06-15
WO2005091736A3 (en) 2006-02-09
JP4762972B2 (ja) 2011-08-31
KR20060121654A (ko) 2006-11-29
US20050193035A1 (en) 2005-09-01
CN100461163C (zh) 2009-02-11
EP1721261A4 (en) 2007-07-04
EP1721261A2 (en) 2006-11-15
US7334002B2 (en) 2008-02-19
JP2007525765A (ja) 2007-09-06
EP1721261B1 (en) 2009-06-03
CN1809828A (zh) 2006-07-26

Similar Documents

Publication Publication Date Title
KR101137213B1 (ko) 데이타베이스의 복구 유닛을 위한 시스템 및 방법
US7676635B2 (en) Recoverable cache preload in clustered computer system based upon monitored preload state of cache
US7111194B1 (en) Mirror split brain avoidance
US7721057B2 (en) Method and system for transporting data content on a storage area network
US6871245B2 (en) File system translators and methods for implementing the same
JP2925931B2 (ja) ファイル・システムの副作用の選択的追加装置
US20030065780A1 (en) Data storage system having data restore by swapping logical units
US9229942B1 (en) Method and system for hard link handling for incremental file migration
US9575975B2 (en) Cluster-wide unique ID for object access control lists
US20070234342A1 (en) System and method for relocating running applications to topologically remotely located computing systems
US8239402B1 (en) Standard file system access to data that is initially stored and accessed via a proprietary interface
US7467266B2 (en) Snapshot management method apparatus and system
US7720884B1 (en) Automatic generation of routines and/or schemas for database management
EP3788489B1 (en) Data replication in a distributed storage system
US20080028169A1 (en) Extending non-volatile storage at a computer system
US20170262307A1 (en) Method and apparatus for conversion of virtual machine formats utilizing deduplication metadata
US7069270B1 (en) Automated method and mechanism for converting a single instance application to a multiple instance application
US11169728B2 (en) Replication configuration for multiple heterogeneous data stores
WO2020135889A1 (zh) 一种磁盘动态加载的方法和云存储系统
US7685122B1 (en) Facilitating suspension of batch application program access to shared IMS resources
Krogh et al. Pro MySQL NDB Cluster
US20250335462A1 (en) Storage failure handling and rebalance in database aware distributed data store
CN116414788A (zh) 一种数据库系统更新方法及相关装置
Tapus et al. Mojavefs: Providing sequential consistency in a distributed objects system
Hussain et al. Overview of Oracle RAC: by Kai Yu

Legal Events

Date Code Title Description
PA0105 International application

St.27 status event code: A-0-1-A10-A15-nap-PA0105

PG1501 Laying open of application

St.27 status event code: A-1-1-Q10-Q12-nap-PG1501

A201 Request for examination
E13-X000 Pre-grant limitation requested

St.27 status event code: A-2-3-E10-E13-lim-X000

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

PA0201 Request for examination

St.27 status event code: A-1-2-D10-D11-exm-PA0201

E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

St.27 status event code: A-1-2-D10-D21-exm-PE0902

T11-X000 Administrative time limit extension requested

St.27 status event code: U-3-3-T10-T11-oth-X000

T11-X000 Administrative time limit extension requested

St.27 status event code: U-3-3-T10-T11-oth-X000

T11-X000 Administrative time limit extension requested

St.27 status event code: U-3-3-T10-T11-oth-X000

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

R17-X000 Change to representative recorded

St.27 status event code: A-3-3-R10-R17-oth-X000

E701 Decision to grant or registration of patent right
PE0701 Decision of registration

St.27 status event code: A-1-2-D10-D22-exm-PE0701

GRNT Written decision to grant
PR0701 Registration of establishment

St.27 status event code: A-2-4-F10-F11-exm-PR0701

PR1002 Payment of registration fee

St.27 status event code: A-2-2-U10-U12-oth-PR1002

Fee payment year number: 1

PG1601 Publication of registration

St.27 status event code: A-4-4-Q10-Q13-nap-PG1601

PN2301 Change of applicant

St.27 status event code: A-5-5-R10-R13-asn-PN2301

St.27 status event code: A-5-5-R10-R11-asn-PN2301

PR1001 Payment of annual fee

St.27 status event code: A-4-4-U10-U11-oth-PR1001

Fee payment year number: 4

PN2301 Change of applicant

St.27 status event code: A-5-5-R10-R11-asn-PN2301

PN2301 Change of applicant

St.27 status event code: A-5-5-R10-R14-asn-PN2301

FPAY Annual fee payment

Payment date: 20160318

Year of fee payment: 5

PR1001 Payment of annual fee

St.27 status event code: A-4-4-U10-U11-oth-PR1001

Fee payment year number: 5

FPAY Annual fee payment

Payment date: 20170317

Year of fee payment: 6

PR1001 Payment of annual fee

St.27 status event code: A-4-4-U10-U11-oth-PR1001

Fee payment year number: 6

PR1001 Payment of annual fee

St.27 status event code: A-4-4-U10-U11-oth-PR1001

Fee payment year number: 7

R18-X000 Changes to party contact information recorded

St.27 status event code: A-5-5-R10-R18-oth-X000

P22-X000 Classification modified

St.27 status event code: A-4-4-P10-P22-nap-X000

PR1001 Payment of annual fee

St.27 status event code: A-4-4-U10-U11-oth-PR1001

Fee payment year number: 8

R17-X000 Change to representative recorded

St.27 status event code: A-5-5-R10-R17-oth-X000

PR1001 Payment of annual fee

St.27 status event code: A-4-4-U10-U11-oth-PR1001

Fee payment year number: 9

PC1903 Unpaid annual fee

St.27 status event code: A-4-4-U10-U13-oth-PC1903

Not in force date: 20210410

Payment event data comment text: Termination Category : DEFAULT_OF_REGISTRATION_FEE

PC1903 Unpaid annual fee

St.27 status event code: N-4-6-H10-H13-oth-PC1903

Ip right cessation event data comment text: Termination Category : DEFAULT_OF_REGISTRATION_FEE

Not in force date: 20210410