JP4939440B2 - データベースシステムにおいて報告トランザクションを処理する方法およびメカニズム - Google Patents

データベースシステムにおいて報告トランザクションを処理する方法およびメカニズム Download PDF

Info

Publication number
JP4939440B2
JP4939440B2 JP2007556381A JP2007556381A JP4939440B2 JP 4939440 B2 JP4939440 B2 JP 4939440B2 JP 2007556381 A JP2007556381 A JP 2007556381A JP 2007556381 A JP2007556381 A JP 2007556381A JP 4939440 B2 JP4939440 B2 JP 4939440B2
Authority
JP
Japan
Prior art keywords
database
computer
reporting
node
implemented method
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
JP2007556381A
Other languages
English (en)
Japanese (ja)
Other versions
JP2008530716A (ja
JP2008530716A5 (enExample
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 JP2008530716A publication Critical patent/JP2008530716A/ja
Publication of JP2008530716A5 publication Critical patent/JP2008530716A5/ja
Application granted granted Critical
Publication of JP4939440B2 publication Critical patent/JP4939440B2/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
    • 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)
JP2007556381A 2005-02-18 2006-02-17 データベースシステムにおいて報告トランザクションを処理する方法およびメカニズム Active JP4939440B2 (ja)

Applications Claiming Priority (3)

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
PCT/US2006/005909 WO2006089263A2 (en) 2005-02-18 2006-02-17 Method and mechanism of handling reporting transactions in database systems

Publications (3)

Publication Number Publication Date
JP2008530716A JP2008530716A (ja) 2008-08-07
JP2008530716A5 JP2008530716A5 (enExample) 2009-03-19
JP4939440B2 true JP4939440B2 (ja) 2012-05-23

Family

ID=36914050

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2007556381A Active JP4939440B2 (ja) 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 (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001159985A (ja) * 1999-12-02 2001-06-12 Sun Corp 二重化装置
US6529917B1 (en) * 2000-08-14 2003-03-04 Divine Technology Ventures System and method of synchronizing replicated data
US20050138312A1 (en) * 2003-12-19 2005-06-23 Kei Kubo Method for acquiring snapshot

Family Cites Families (13)

* 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
US5951695A (en) * 1997-07-25 1999-09-14 Hewlett-Packard Company Fast database failover
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
US6941490B2 (en) * 2000-12-21 2005-09-06 Emc Corporation Dual channel restoration of data between primary and backup servers
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
US7389314B2 (en) * 2004-08-30 2008-06-17 Corio, Inc. Database backup, refresh and cloning system and method

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001159985A (ja) * 1999-12-02 2001-06-12 Sun Corp 二重化装置
US6529917B1 (en) * 2000-08-14 2003-03-04 Divine Technology Ventures System and method of synchronizing replicated data
US20050138312A1 (en) * 2003-12-19 2005-06-23 Kei Kubo Method for acquiring snapshot
JP2005202915A (ja) * 2003-12-19 2005-07-28 Hitachi Ltd スナップショット取得方法

Also Published As

Publication number Publication date
AU2006214063A1 (en) 2006-08-24
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
CN100489800C (zh) 2009-05-20
WO2006089263A2 (en) 2006-08-24
EP1849075A2 (en) 2007-10-31

Similar Documents

Publication Publication Date Title
KR102307371B1 (ko) 데이터베이스 시스템 내의 데이터 복제 및 데이터 장애 조치
CA2578666C (en) Method and system for load balancing a distributed database
EP4064067B1 (en) Automatic query offloading to a standby database
US8209699B2 (en) System and method for subunit operations in a database
US8856079B1 (en) Application programming interface for efficient object information gathering and listing
CN101305365B (zh) 用于进行数据仓储的设备和方法
JP4939440B2 (ja) データベースシステムにおいて報告トランザクションを処理する方法およびメカニズム
CN103026355B (zh) 数据库管理系统
US20130110873A1 (en) Method and system for data storage and management
US20080098048A1 (en) Migrating temporary data of a session
KR20170060036A (ko) 멀티테넌트 어플리케이션 서버 환경에서 트랜잭션 복구를 위한 시스템 및 방법
US7720884B1 (en) Automatic generation of routines and/or schemas for database management
WO2008143855A2 (en) Network-attached storage devices
US12124474B2 (en) Real-time masking in a standby database
US7987206B2 (en) File-sharing system and method of using file-sharing system to generate single logical directory structure
US20220121523A1 (en) Identifying database backup copy chaining
US20250061026A1 (en) Data replication with cross replication group references
Varga et al. Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
Plattner et al. Dbfarm: A scalable cluster for multiple databases
CN104035952A (zh) 硬件支持的存储临时拷贝
CN104035838A (zh) 硬件支持的存储日志记录
Krogh et al. Pro MySQL NDB Cluster
US20230418711A1 (en) Repairing unresolved dangling references after failover
Panpaliya Benchmarking MongoDB multi-document transactions in a sharded cluster
Kirby et al. Ibm websphere extreme scale v7: Solutions architecture

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20090127

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20090127

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20110705

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20111004

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: 20120221

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20120224

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20150302

Year of fee payment: 3

R150 Certificate of patent or registration of utility model

Ref document number: 4939440

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

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

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250