CN100489800C - 在数据库系统中处理报告事务的方法和机构 - Google Patents

在数据库系统中处理报告事务的方法和机构 Download PDF

Info

Publication number
CN100489800C
CN100489800C CNB2006800053587A CN200680005358A CN100489800C CN 100489800 C CN100489800 C CN 100489800C CN B2006800053587 A CNB2006800053587 A CN B2006800053587A CN 200680005358 A CN200680005358 A CN 200680005358A CN 100489800 C CN100489800 C CN 100489800C
Authority
CN
China
Prior art keywords
failover
database
reporting
reporting transactions
transactions
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
CNB2006800053587A
Other languages
English (en)
Chinese (zh)
Other versions
CN101124546A (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 CN101124546A publication Critical patent/CN101124546A/zh
Application granted granted Critical
Publication of CN100489800C publication Critical patent/CN100489800C/zh
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
    • 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/1474—Saving, restoring, recovering or retrying in transactions
    • 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
    • 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/84—Using snapshots, i.e. a logical point-in-time copy of the data

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)
  • Hardware Redundancy (AREA)
CNB2006800053587A 2005-02-18 2006-02-17 在数据库系统中处理报告事务的方法和机构 Active CN100489800C (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/061,152 US20060190460A1 (en) 2005-02-18 2005-02-18 Method and mechanism of handling reporting transactions in database systems
US11/061,152 2005-02-18

Publications (2)

Publication Number Publication Date
CN101124546A CN101124546A (zh) 2008-02-13
CN100489800C true CN100489800C (zh) 2009-05-20

Family

ID=36914050

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2006800053587A Active CN100489800C (zh) 2005-02-18 2006-02-17 在数据库系统中处理报告事务的方法和机构

Country Status (7)

Country Link
US (1) US20060190460A1 (enExample)
EP (1) EP1849075A2 (enExample)
JP (1) JP4939440B2 (enExample)
CN (1) CN100489800C (enExample)
AU (1) AU2006214063A1 (enExample)
CA (1) CA2598021A1 (enExample)
WO (1) WO2006089263A2 (enExample)

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8959299B2 (en) 2004-11-15 2015-02-17 Commvault Systems, Inc. Using a snapshot as a data source
US20070162512A1 (en) * 2006-01-10 2007-07-12 Microsoft Corporation Providing reporting database functionality using copy-on-write technology
US7743155B2 (en) * 2007-04-20 2010-06-22 Array Networks, Inc. Active-active operation for a cluster of SSL virtual private network (VPN) devices with load distribution
US20090248631A1 (en) * 2008-03-31 2009-10-01 International Business Machines Corporation System and Method for Balancing Workload of a Database Based Application by Partitioning Database Queries
CN101996214B (zh) * 2009-08-27 2013-10-23 国际商业机器公司 用于处理数据库操作请求的方法和装置
WO2011082132A1 (en) * 2009-12-31 2011-07-07 Commvault Systems, Inc. Systems and methods for analyzing snapshots
GB2493242A (en) 2010-05-18 2013-01-30 Ibm Transaction processing system
CN103064860A (zh) * 2011-10-21 2013-04-24 阿里巴巴集团控股有限公司 数据库高可用实现方法及其装置
US9613083B2 (en) * 2012-04-26 2017-04-04 Hewlett Packard Enterprise Development Lp Nesting level
US20140236898A1 (en) * 2013-02-18 2014-08-21 Compellent Technologies System and method for facilitating electronic discovery
US9817742B2 (en) * 2013-06-25 2017-11-14 Dell International L.L.C. Detecting hardware and software problems in remote systems
US11080257B2 (en) * 2019-05-13 2021-08-03 Snowflake Inc. Journaled tables in database systems
CN115552391B (zh) * 2020-05-12 2023-08-25 谷歌有限责任公司 Select*查询的零拷贝优化
US11921878B2 (en) * 2021-01-21 2024-03-05 Servicenow, Inc. Database security through obfuscation

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5951695A (en) * 1997-07-25 1999-09-14 Hewlett-Packard Company Fast database failover
CN1481534A (zh) * 2000-12-21 2004-03-10 ���ܿ���ϵͳ���޹�˾ 主系统和备份系统之间数据的恢复

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5835953A (en) * 1994-10-13 1998-11-10 Vinca Corporation Backup system that takes a snapshot of the locations in a mass storage device that has been identified for updating prior to updating
US5860137A (en) * 1995-07-21 1999-01-12 Emc Corporation Dynamic load balancing
JP2001159985A (ja) * 1999-12-02 2001-06-12 Sun Corp 二重化装置
US6460055B1 (en) * 1999-12-16 2002-10-01 Livevault Corporation Systems and methods for backing up data files
US6553391B1 (en) * 2000-06-08 2003-04-22 International Business Machines Corporation System and method for replicating external files and database metadata pertaining thereto
US6658478B1 (en) * 2000-08-04 2003-12-02 3Pardata, Inc. Data storage system
US6529917B1 (en) * 2000-08-14 2003-03-04 Divine Technology Ventures System and method of synchronizing replicated data
EP1324229A3 (en) * 2001-12-27 2006-02-01 Ncr International Inc. Using point-in-time views to provide varying levels of data freshness
US7072915B2 (en) * 2002-01-22 2006-07-04 International Business Machines Corporation Copy method supplementing outboard data copy with previously instituted copy-on-write logical snapshot to create duplicate consistent with source data as of designated time
US20030220948A1 (en) * 2002-01-22 2003-11-27 Columbia Data Products, Inc. Managing snapshot/backup collections in finite data storage
AU2003282361A1 (en) * 2002-11-20 2004-06-15 Filesx Ltd. Fast backup storage and fast recovery of data (fbsrd)
US20040220947A1 (en) * 2003-05-02 2004-11-04 International Business Machines Corporation Method and apparatus for real-time intelligent workload reporting in a heterogeneous environment
JP4581518B2 (ja) * 2003-12-19 2010-11-17 株式会社日立製作所 スナップショット取得方法
US7389314B2 (en) * 2004-08-30 2008-06-17 Corio, Inc. Database backup, refresh and cloning system and method

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5951695A (en) * 1997-07-25 1999-09-14 Hewlett-Packard Company Fast database failover
CN1481534A (zh) * 2000-12-21 2004-03-10 ���ܿ���ϵͳ���޹�˾ 主系统和备份系统之间数据的恢复

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
Oracle8 Replication Manual. Bobrowski ET AL.Oracle8 Replication, Release 8.0 Part No. A58245-01. 1997 *

Also Published As

Publication number Publication date
AU2006214063A1 (en) 2006-08-24
JP4939440B2 (ja) 2012-05-23
AU2006214063A2 (en) 2008-02-21
WO2006089263A3 (en) 2007-08-02
CA2598021A1 (en) 2006-08-24
CN101124546A (zh) 2008-02-13
JP2008530716A (ja) 2008-08-07
US20060190460A1 (en) 2006-08-24
WO2006089263A2 (en) 2006-08-24
EP1849075A2 (en) 2007-10-31

Similar Documents

Publication Publication Date Title
US10846277B1 (en) Journaled tables in database systems
US10657008B2 (en) Managing a redundant computerized database using a replicated database cache
Baker et al. Megastore: Providing scalable, highly available storage for interactive services.
US8156082B2 (en) System and methods for temporary data management in shared disk cluster
JP5008991B2 (ja) データのリカバリを制御する装置及び方法
CN103026355B (zh) 数据库管理系统
US7480643B2 (en) System and method for migrating databases
JP5047806B2 (ja) データ・ウェアハウジングのための装置および方法
JP5411250B2 (ja) 冗長データ記憶システムへの指示に従ってのデータ配置
US20130110873A1 (en) Method and system for data storage and management
US8856079B1 (en) Application programming interface for efficient object information gathering and listing
US7610314B2 (en) Online tablespace recovery for export
CN100489800C (zh) 在数据库系统中处理报告事务的方法和机构
CN113396407A (zh) 用于利用区块链技术扩充数据库应用的系统和方法
CN112534419A (zh) 到备用数据库的自动查询卸载
Plattner et al. Extending DBMSs with satellite databases
US9323791B2 (en) Apparatus and method for expanding a shared-nothing system
US7720884B1 (en) Automatic generation of routines and/or schemas for database management
Delaney et al. Microsoft SQL Server 2012 Internals
US20250061026A1 (en) Data replication with cross replication group references
US7698319B2 (en) Database system management method, database system, database device, and backup program
Delaney et al. Microsoft SQL Server 2008 Internals
CN104035952A (zh) 硬件支持的存储临时拷贝
CN104035838A (zh) 硬件支持的存储日志记录
Simmons et al. Pro SQL Server 2012 Administration

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant