JP5286090B2 - 回復ログを用いたデータベース事象の検出 - Google Patents

回復ログを用いたデータベース事象の検出 Download PDF

Info

Publication number
JP5286090B2
JP5286090B2 JP2008558316A JP2008558316A JP5286090B2 JP 5286090 B2 JP5286090 B2 JP 5286090B2 JP 2008558316 A JP2008558316 A JP 2008558316A JP 2008558316 A JP2008558316 A JP 2008558316A JP 5286090 B2 JP5286090 B2 JP 5286090B2
Authority
JP
Japan
Prior art keywords
database
query
event
time
detecting
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.)
Active
Application number
JP2008558316A
Other languages
English (en)
Japanese (ja)
Other versions
JP2009529729A (ja
JP2009529729A5 (https=
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 JP2009529729A publication Critical patent/JP2009529729A/ja
Publication of JP2009529729A5 publication Critical patent/JP2009529729A5/ja
Application granted granted Critical
Publication of JP5286090B2 publication Critical patent/JP5286090B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2358—Change logging, detection, and notification
    • 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)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2008558316A 2006-03-10 2007-03-02 回復ログを用いたデータベース事象の検出 Active JP5286090B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US11/372,968 2006-03-10
US11/372,968 US7555502B2 (en) 2006-03-10 2006-03-10 Detecting database events using recovery logs
PCT/US2007/005351 WO2007106331A1 (en) 2006-03-10 2007-03-02 Detecting database events using recovery logs

Publications (3)

Publication Number Publication Date
JP2009529729A JP2009529729A (ja) 2009-08-20
JP2009529729A5 JP2009529729A5 (https=) 2010-04-08
JP5286090B2 true JP5286090B2 (ja) 2013-09-11

Family

ID=38199210

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2008558316A Active JP5286090B2 (ja) 2006-03-10 2007-03-02 回復ログを用いたデータベース事象の検出

Country Status (7)

Country Link
US (1) US7555502B2 (https=)
EP (1) EP1938228B1 (https=)
JP (1) JP5286090B2 (https=)
CN (2) CN103745016B (https=)
AU (1) AU2007225350B2 (https=)
CA (1) CA2644779C (https=)
WO (1) WO2007106331A1 (https=)

Families Citing this family (34)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8108429B2 (en) 2004-05-07 2012-01-31 Quest Software, Inc. System for moving real-time data events across a plurality of devices in a network for simultaneous data protection, replication, and access services
US7565661B2 (en) * 2004-05-10 2009-07-21 Siew Yong Sim-Tang Method and system for real-time event journaling to provide enterprise data services
US7979404B2 (en) 2004-09-17 2011-07-12 Quest Software, Inc. Extracting data changes and storing data history to allow for instantaneous access to and reconstruction of any point-in-time data
US7904913B2 (en) 2004-11-02 2011-03-08 Bakbone Software, Inc. Management interface for a system that provides automated, real-time, continuous data protection
US7689602B1 (en) 2005-07-20 2010-03-30 Bakbone Software, Inc. Method of creating hierarchical indices for a distributed object system
US7788521B1 (en) 2005-07-20 2010-08-31 Bakbone Software, Inc. Method and system for virtual on-demand recovery for real-time, continuous data protection
US8024439B2 (en) * 2006-03-17 2011-09-20 Microsoft Corporation Server session management application program interface and schema
US8458725B2 (en) * 2006-04-10 2013-06-04 Oracle International Corporation Computer implemented method for removing an event registration within an event notification infrastructure
US9390118B2 (en) * 2006-04-19 2016-07-12 Oracle International Corporation Computer implemented method for transforming an event notification within a database notification infrastructure
US7895600B2 (en) 2006-05-10 2011-02-22 Oracle International Corporation Method of optimizing propagation of non-persistent messages from a source database management system to a destination database management system
US8464275B2 (en) * 2006-05-10 2013-06-11 Oracle International Corporation Method of using a plurality of subscriber types in managing a message queue of a database management system
US7761413B2 (en) * 2006-05-10 2010-07-20 Oracle International Corporation Method of ensuring availability of event notification registrations of a database management system
US20090248744A1 (en) * 2006-07-17 2009-10-01 Kika Medical Transactional storage system for healthcare information
US20080091637A1 (en) * 2006-10-17 2008-04-17 Terry Dwain Escamilla Temporal association between assets in a knowledge system
US8131723B2 (en) 2007-03-30 2012-03-06 Quest Software, Inc. Recovering a file system to any point-in-time in the past with guaranteed structure, content consistency and integrity
US8364648B1 (en) 2007-04-09 2013-01-29 Quest Software, Inc. Recovering a database to any point-in-time in the past with guaranteed data consistency
US7739547B2 (en) * 2007-06-07 2010-06-15 International Business Machines Corporation Failure recovery and error correction techniques for data loading in information warehouses
US8290966B2 (en) * 2007-11-29 2012-10-16 Sap Aktiengesellschaft System and method for implementing a non-destructive tree filter
US7996370B2 (en) * 2007-12-13 2011-08-09 International Business Machines Corporation System restoration apparatus and method for management of dependencies, ordering sensitivities, and database index rebuilds
US9501368B2 (en) * 2008-09-30 2016-11-22 Veritas Technologies Llc Backing up and restoring selected versioned objects from a monolithic database backup
US8065278B2 (en) * 2008-09-30 2011-11-22 Symantec Operating Corporation Restoring selected objects from a monolithic database backup
US8380702B2 (en) * 2009-03-10 2013-02-19 Oracle International Corporation Loading an index with minimal effect on availability of applications using the corresponding table
US8392359B2 (en) 2009-08-11 2013-03-05 Business Objects Software Ltd. Trend analysis based upon derived state tables
JP5039891B2 (ja) 2009-10-19 2012-10-03 インターナショナル・ビジネス・マシーンズ・コーポレーション データベースの複製を生成する装置及び方法
US8306959B2 (en) * 2010-08-06 2012-11-06 Ianywhere Solutions, Inc. Incremental maintenance of immediate materialized views with outerjoins
US10073844B1 (en) * 2010-11-24 2018-09-11 Federal Home Loan Mortgage Corporation (Freddie Mac) Accelerated system and method for providing data correction
CN103793514B (zh) * 2014-02-11 2017-09-19 华为技术有限公司 数据库同步方法及数据库
WO2016053313A1 (en) * 2014-09-30 2016-04-07 Hewlett Packard Enterprise Development Lp Page modification
CN105677876B (zh) * 2016-01-12 2018-04-03 国家电网公司 一种基于物理级的数据库日志挖掘方法
CN105868078B (zh) * 2016-04-14 2019-03-08 国家电网公司 基于动态视图监控的Oracle RAC数据库SQL流捕获方法及系统
US10474668B2 (en) * 2016-11-17 2019-11-12 Sap Se Database systems architecture incorporating distributed log
US11399096B2 (en) 2017-11-29 2022-07-26 Afiniti, Ltd. Techniques for data matching in a contact center system
US11138182B2 (en) * 2018-11-28 2021-10-05 Salesforce.Com, Inc. Compensating data corruption causing actions at runtime
CN113760608B (zh) * 2021-09-08 2024-09-17 北京金山云网络技术有限公司 数据恢复方法和装置、电子设备和存储介质

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6353835B1 (en) * 1998-08-03 2002-03-05 Lucent Technologies Inc. Technique for effectively maintaining materialized views in a data warehouse
US6427146B1 (en) * 2000-03-31 2002-07-30 Wesley W. Chu Database event detection and notification system using type abstraction hierarchy (TAH)
KR100390853B1 (ko) * 2000-06-07 2003-07-10 차상균 주 메모리 트랜잭션 처리 시스템에서 병렬적 회복 연산을 위한 디퍼런셜 로깅 방법 및 장치
US8799225B2 (en) * 2003-11-05 2014-08-05 Lumigent Technologies, Inc. Process and system for auditing database activity
US20050203881A1 (en) * 2004-03-09 2005-09-15 Akio Sakamoto Database user behavior monitor system and method
US20050289187A1 (en) * 2004-06-29 2005-12-29 Oracle International Corporation System and method for investigating a data operation performed on a database
US20060004794A1 (en) * 2004-06-30 2006-01-05 Microsoft Corporation Rich application view system and method
US8386440B2 (en) * 2005-05-10 2013-02-26 Microsoft Corporation Database corruption recovery systems and methods
US8156083B2 (en) * 2005-12-01 2012-04-10 Oracle International Corporation Database system that provides for history-enabled tables

Also Published As

Publication number Publication date
JP2009529729A (ja) 2009-08-20
US7555502B2 (en) 2009-06-30
CN101401097A (zh) 2009-04-01
EP1938228B1 (en) 2017-06-07
EP1938228A1 (en) 2008-07-02
CA2644779C (en) 2016-07-26
WO2007106331A1 (en) 2007-09-20
AU2007225350B2 (en) 2011-06-09
US20070214191A1 (en) 2007-09-13
CA2644779A1 (en) 2007-09-20
CN103745016B (zh) 2018-03-06
AU2007225350A1 (en) 2007-09-20
CN103745016A (zh) 2014-04-23

Similar Documents

Publication Publication Date Title
JP5286090B2 (ja) 回復ログを用いたデータベース事象の検出
US8244716B2 (en) Data pattern for storing information, including associated version and audit information for use in data management
US6728719B1 (en) Method and mechanism for dependency tracking for unique constraints
US8078588B2 (en) Recoverable execution
US7769718B2 (en) Unobtrusive point-in-time consistent copies
EP0723238B1 (en) Relational database system and method with high data availability during table data restructuring
US9384222B2 (en) Database system that provides for history-enabled tables
US7933927B2 (en) Method and apparatus for building index of source data
US6119128A (en) Recovering different types of objects with one pass of the log
US7277900B1 (en) Method and mechanism for rolling back a transaction on a row of data
US6804672B1 (en) Method and mechanism for dependency tracking
US6442543B1 (en) Method and apparatus for changing temporal database information
US5553279A (en) Lossless distribution of time series data in a relational data base network
US5317730A (en) System for modifying persistent database based upon set of data elements formed after selective insertion or deletion
US8589357B2 (en) Techniques for automatically tracking and archiving transactional data changes
US20060106889A1 (en) Method, system, and program for managing revisions to a file
US20120041926A1 (en) Techniques for increasing the usefulness of transaction logs
KR20040088397A (ko) 트랜잭션적으로 일관성있는 트리거 기반 데이터베이스변경 추적 방법 및 시스템
US8650169B1 (en) Method and mechanism for identifying transaction on a row of data
US7107292B1 (en) Fast system level recovery
KR101024494B1 (ko) 메타데이타를 이용한 변경 데이타 추출방법
KR102900465B1 (ko) 데이터베이스 로그 파일 기반의 데이터베이스 운영 관리 시스템 및 방법
EP1896991A1 (en) Method for preserving access to deleted and overwritten documents
US20070130195A1 (en) Modeling enumeration tables for relational databases
Johnson et al. Oracle and PostreSQL Databases

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20100218

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20100218

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20120426

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20120508

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20120725

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20130122

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20130313

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20130415

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20130507

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20130603

R150 Certificate of patent or registration of utility model

Ref document number: 5286090

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250