CA2644779C - Detecting database events using recovery logs - Google Patents

Detecting database events using recovery logs Download PDF

Info

Publication number
CA2644779C
CA2644779C CA2644779A CA2644779A CA2644779C CA 2644779 C CA2644779 C CA 2644779C CA 2644779 A CA2644779 A CA 2644779A CA 2644779 A CA2644779 A CA 2644779A CA 2644779 C CA2644779 C CA 2644779C
Authority
CA
Canada
Prior art keywords
database
query
event
temporal
statements
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
CA2644779A
Other languages
English (en)
French (fr)
Other versions
CA2644779A1 (en
Inventor
Sashikanth Chandrasekaran
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 CA2644779A1 publication Critical patent/CA2644779A1/en
Application granted granted Critical
Publication of CA2644779C publication Critical patent/CA2644779C/en
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)
CA2644779A 2006-03-10 2007-03-02 Detecting database events using recovery logs Active CA2644779C (en)

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 (2)

Publication Number Publication Date
CA2644779A1 CA2644779A1 (en) 2007-09-20
CA2644779C true CA2644779C (en) 2016-07-26

Family

ID=38199210

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2644779A Active CA2644779C (en) 2006-03-10 2007-03-02 Detecting database events using recovery logs

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
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
CN103745016B (zh) 2018-03-06
AU2007225350A1 (en) 2007-09-20
CN103745016A (zh) 2014-04-23

Similar Documents

Publication Publication Date Title
CA2644779C (en) Detecting database events using recovery logs
US6714943B1 (en) Method and mechanism for tracking dependencies for referential integrity constrained tables
EP0723238B1 (en) Relational database system and method with high data availability during table data restructuring
US6728719B1 (en) Method and mechanism for dependency tracking for unique constraints
US6898608B2 (en) Techniques for managing what-if analysis of data managed by a relational database system
US8589357B2 (en) Techniques for automatically tracking and archiving transactional data changes
US8407180B1 (en) Eliminating inner joins based on a temporal relationship constraint
US8762395B2 (en) Evaluating event-generated data using append-only tables
US8131696B2 (en) Sequence event processing using append-only tables
US9411866B2 (en) Replication mechanisms for database environments
JP6325246B2 (ja) インメモリデータベース処理のためのシステムおよび方法
US6804672B1 (en) Method and mechanism for dependency tracking
CA2359296A1 (en) Method of cardinality estimation using statistical soft constraints
AU2014233672A1 (en) System for metadata management
US7840575B2 (en) Evaluating event-generated data using append-only tables
Widom et al. A syntax and semantics for set-oriented production rules in relational database systems
US20140081907A1 (en) Client-Side Handling Of Transient Duplicates For Row-Level Replication
Morris Relational database design and implementation for biodiversity informatics
EP2544104A1 (en) Database consistent sample data extraction
US8725720B1 (en) Eliminating inner joins based on a contained predicate and a temporal relationship constraint
US12339852B2 (en) Execution of programs after import for configuration changes
US20230350859A1 (en) Data retrieval from archived data storage
US20070130195A1 (en) Modeling enumeration tables for relational databases
Boggiano et al. Query Store for SQL Server 2019
HK40009607A (en) System for metadata management

Legal Events

Date Code Title Description
EEER Examination request
MPN Maintenance fee for patent paid

Free format text: FEE DESCRIPTION TEXT: MF (PATENT, 18TH ANNIV.) - STANDARD

Year of fee payment: 18

U00 Fee paid

Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U00-U101 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE REQUEST RECEIVED

Effective date: 20241217

U11 Full renewal or maintenance fee paid

Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U11-U102 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE FEE PAYMENT DETERMINED COMPLIANT

Effective date: 20241217

Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U11-U102 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE FEE PAYMENT PAID IN FULL

Effective date: 20241217

MPN Maintenance fee for patent paid

Free format text: FEE DESCRIPTION TEXT: MF (PATENT, 19TH ANNIV.) - STANDARD

Year of fee payment: 19

U00 Fee paid

Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U00-U101 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE REQUEST RECEIVED

Effective date: 20260203

U11 Full renewal or maintenance fee paid

Free format text: ST27 STATUS EVENT CODE: A-4-4-U10-U11-U102 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: MAINTENANCE FEE PAYMENT PAID IN FULL

Effective date: 20260203