CN103745016B - 利用恢复日志检测数据库事件 - Google Patents

利用恢复日志检测数据库事件 Download PDF

Info

Publication number
CN103745016B
CN103745016B CN201410045335.5A CN201410045335A CN103745016B CN 103745016 B CN103745016 B CN 103745016B CN 201410045335 A CN201410045335 A CN 201410045335A CN 103745016 B CN103745016 B CN 103745016B
Authority
CN
China
Prior art keywords
database
timeliness
event
inquiry
sentence
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
CN201410045335.5A
Other languages
English (en)
Chinese (zh)
Other versions
CN103745016A (zh
Inventor
萨史堪斯·查卓瑟卡兰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Oracle International Corp
Original Assignee
Oracle International Corp
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 Oracle International Corp filed Critical Oracle International Corp
Publication of CN103745016A publication Critical patent/CN103745016A/zh
Application granted granted Critical
Publication of CN103745016B publication Critical patent/CN103745016B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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)
CN201410045335.5A 2006-03-10 2007-03-02 利用恢复日志检测数据库事件 Active CN103745016B (zh)

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
CNA2007800084895A CN101401097A (zh) 2006-03-10 2007-03-02 利用恢复日志检测数据库事件

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
CNA2007800084895A Division CN101401097A (zh) 2006-03-10 2007-03-02 利用恢复日志检测数据库事件

Publications (2)

Publication Number Publication Date
CN103745016A CN103745016A (zh) 2014-04-23
CN103745016B true CN103745016B (zh) 2018-03-06

Family

ID=38199210

Family Applications (2)

Application Number Title Priority Date Filing Date
CN201410045335.5A Active CN103745016B (zh) 2006-03-10 2007-03-02 利用恢复日志检测数据库事件
CNA2007800084895A Pending CN101401097A (zh) 2006-03-10 2007-03-02 利用恢复日志检测数据库事件

Family Applications After (1)

Application Number Title Priority Date Filing Date
CNA2007800084895A Pending CN101401097A (zh) 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 北京金山云网络技术有限公司 数据恢复方法和装置、电子设备和存储介质

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1454349A (zh) * 2000-06-07 2003-11-05 处理存储器有限公司 主存储器事务处理系统中的高度并行日志和恢复操作的方法和系统

Family Cites Families (8)

* 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)
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

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1454349A (zh) * 2000-06-07 2003-11-05 处理存储器有限公司 主存储器事务处理系统中的高度并行日志和恢复操作的方法和系统

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
continuous queries over append-only databases;douglas terry 等;《ACM SIGMOD》;19921231;第321-330页 *

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
JP5286090B2 (ja) 2013-09-11
WO2007106331A1 (en) 2007-09-20
AU2007225350B2 (en) 2011-06-09
US20070214191A1 (en) 2007-09-13
CA2644779A1 (en) 2007-09-20
AU2007225350A1 (en) 2007-09-20
CN103745016A (zh) 2014-04-23

Similar Documents

Publication Publication Date Title
CN103745016B (zh) 利用恢复日志检测数据库事件
US20120136839A1 (en) User-Driven Conflict Resolution Of Concurrent Updates In Snapshot Isolation
US10733057B2 (en) Techniques for application undo and redo using SQL patchsets or changesets
US20040267751A1 (en) Performing a data analysis process
CN1784677A (zh) 用于数据库备份的一致性检验的系统和方法
Hogan A practical guide to database design
US9378260B2 (en) Methods and apparatus for synchronizing closed heterogenous systems
US20120143926A1 (en) External evaluation processes
CA3223528A1 (en) Data governance systems and methods
Acharya Automobile Management System Project Report.
Norton Knowledge discovery in databases
Shahbaz Data mapping for data warehouse design
US9053143B2 (en) Allowing updates to database objects
JP5029118B2 (ja) ソフトウェア開発支援システム、開発支援方法および開発支援プログラム
Walters et al. Beginning SQL Server 2012 Administration
US12079174B2 (en) Data retrieval from archived data storage
US20250342010A1 (en) Managing feature evolution
Chen et al. Probe-then-Plan: Environment-Aware Planning for Industrial E-commerce Search
Fischer Aris process performance manager
Atri et al. Evaluating Temporal Consistency in Multi-Turn Language Models
KR20150119749A (ko) 데이터베이스의 데이터 변경 이력 관리를 위한 시스템 및 방법
CN117033452A (zh) 数据库处理方法、装置、计算机设备和存储介质
Menninger And now, introducing the data warehouse....
Slater Controlling the System
Root et al. Additional Cube and Dimension Configurations

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant