AU2007225350B2 - Detecting database events using recovery logs - Google Patents

Detecting database events using recovery logs Download PDF

Info

Publication number
AU2007225350B2
AU2007225350B2 AU2007225350A AU2007225350A AU2007225350B2 AU 2007225350 B2 AU2007225350 B2 AU 2007225350B2 AU 2007225350 A AU2007225350 A AU 2007225350A AU 2007225350 A AU2007225350 A AU 2007225350A AU 2007225350 B2 AU2007225350 B2 AU 2007225350B2
Authority
AU
Australia
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
AU2007225350A
Other languages
English (en)
Other versions
AU2007225350A1 (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 AU2007225350A1 publication Critical patent/AU2007225350A1/en
Application granted granted Critical
Publication of AU2007225350B2 publication Critical patent/AU2007225350B2/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)
AU2007225350A 2006-03-10 2007-03-02 Detecting database events using recovery logs Active AU2007225350B2 (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
AU2007225350A1 AU2007225350A1 (en) 2007-09-20
AU2007225350B2 true AU2007225350B2 (en) 2011-06-09

Family

ID=38199210

Family Applications (1)

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

Citations (3)

* 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
US20050097149A1 (en) * 2003-11-05 2005-05-05 Lumigent Technologies, Inc. Data audit system
US20050289187A1 (en) * 2004-06-29 2005-12-29 Oracle International Corporation System and method for investigating a data operation performed on a database

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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 차상균 주 메모리 트랜잭션 처리 시스템에서 병렬적 회복 연산을 위한 디퍼런셜 로깅 방법 및 장치
US20050203881A1 (en) * 2004-03-09 2005-09-15 Akio Sakamoto Database user behavior monitor system and method
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 (3)

* 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
US20050097149A1 (en) * 2003-11-05 2005-05-05 Lumigent Technologies, Inc. Data audit system
US20050289187A1 (en) * 2004-06-29 2005-12-29 Oracle International Corporation System and method for investigating a data operation performed on a database

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
SNODGRASS, R.T., 'Developing Time-Oriented Database Application in SQL', Morgan Kaufmann Publishers, 2000. *

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
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
AU2007225350B2 (en) Detecting database events using recovery logs
EP0723238B1 (en) Relational database system and method with high data availability during table data restructuring
US6714943B1 (en) Method and mechanism for tracking dependencies for referential integrity constrained tables
US8762395B2 (en) Evaluating event-generated data using append-only tables
US8131696B2 (en) Sequence event processing using append-only tables
US8407180B1 (en) Eliminating inner joins based on a temporal relationship constraint
US6898608B2 (en) Techniques for managing what-if analysis of data managed by a relational database system
US6728719B1 (en) Method and mechanism for dependency tracking for unique constraints
US8589357B2 (en) Techniques for automatically tracking and archiving transactional data changes
JP6325246B2 (ja) インメモリデータベース処理のためのシステムおよび方法
US8244716B2 (en) Data pattern for storing information, including associated version and audit information for use in data management
US6804672B1 (en) Method and mechanism for dependency tracking
US20140172794A1 (en) Replication Mechanisms for Database Environments
EP3493050A1 (en) System for metadata management
CA2359296A1 (en) Method of cardinality estimation using statistical soft constraints
US7840575B2 (en) Evaluating event-generated data using append-only tables
Campbell et al. Efficient answering of historical what-if queries
EP2544104A1 (en) Database consistent sample data extraction
Akidau et al. Continuous data ingestion and transformation in Snowflake
US8799266B2 (en) Method and system for managing operation of a user-defined function on a partitioned database
US8725720B1 (en) Eliminating inner joins based on a contained predicate and a temporal relationship constraint
US12079174B2 (en) Data retrieval from archived data storage
Merkle et al. Modelling database lock-contention in architecture-level performance simulation
US20070130195A1 (en) Modeling enumeration tables for relational databases
HK40009607A (en) System for metadata management

Legal Events

Date Code Title Description
FGA Letters patent sealed or granted (standard patent)