JP4340226B2 - データ項目の使用可能バージョンの提供 - Google Patents

データ項目の使用可能バージョンの提供 Download PDF

Info

Publication number
JP4340226B2
JP4340226B2 JP2004504144A JP2004504144A JP4340226B2 JP 4340226 B2 JP4340226 B2 JP 4340226B2 JP 2004504144 A JP2004504144 A JP 2004504144A JP 2004504144 A JP2004504144 A JP 2004504144A JP 4340226 B2 JP4340226 B2 JP 4340226B2
Authority
JP
Japan
Prior art keywords
transaction
version
data item
data
time
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.)
Expired - Lifetime
Application number
JP2004504144A
Other languages
English (en)
Japanese (ja)
Other versions
JP2005532615A5 (enExample
JP2005532615A (ja
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 JP2005532615A publication Critical patent/JP2005532615A/ja
Publication of JP2005532615A5 publication Critical patent/JP2005532615A5/ja
Application granted granted Critical
Publication of JP4340226B2 publication Critical patent/JP4340226B2/ja
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/466—Transaction processing
    • 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/2308—Concurrency control
    • G06F16/2336—Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
    • G06F16/2343—Locking methods, e.g. distributed locking or locking implementation details
    • 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/99955—Archiving or backup

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2004504144A 2002-05-10 2003-04-29 データ項目の使用可能バージョンの提供 Expired - Lifetime JP4340226B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US37989902P 2002-05-10 2002-05-10
US10/263,493 US6957236B1 (en) 2002-05-10 2002-10-02 Providing a useable version of a data item
PCT/US2003/013326 WO2003096226A1 (en) 2002-05-10 2003-04-29 Providing a useable version of the data item

Publications (3)

Publication Number Publication Date
JP2005532615A JP2005532615A (ja) 2005-10-27
JP2005532615A5 JP2005532615A5 (enExample) 2006-06-01
JP4340226B2 true JP4340226B2 (ja) 2009-10-07

Family

ID=29423229

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2004504144A Expired - Lifetime JP4340226B2 (ja) 2002-05-10 2003-04-29 データ項目の使用可能バージョンの提供

Country Status (8)

Country Link
US (1) US6957236B1 (enExample)
EP (1) EP1504375B1 (enExample)
JP (1) JP4340226B2 (enExample)
CN (1) CN100410930C (enExample)
AU (1) AU2003228754B2 (enExample)
CA (1) CA2484007C (enExample)
DE (1) DE60326835D1 (enExample)
WO (1) WO2003096226A1 (enExample)

Families Citing this family (29)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7305386B2 (en) * 2002-09-13 2007-12-04 Netezza Corporation Controlling visibility in multi-version database systems
EP1546928A4 (en) 2002-09-18 2008-07-09 Netezza Corp Field-Oriented Pipeline Architecture for a Programmable Data Streaming Processor
US7987209B2 (en) * 2002-12-27 2011-07-26 Honda Motor Co., Ltd. Enhanced trade compliance system: mass amendment
US7272609B1 (en) * 2004-01-12 2007-09-18 Hyperion Solutions Corporation In a distributed hierarchical cache, using a dependency to determine if a version of the first member stored in a database matches the version of the first member returned
US8117170B2 (en) * 2004-10-06 2012-02-14 International Business Machines Corporation Transient range versioning based on redirection
US7418544B2 (en) * 2005-10-05 2008-08-26 Oracle International Corporation Method and system for log structured relational database objects
US8051405B2 (en) * 2006-01-11 2011-11-01 Oracle International Corporation System and method for build script generation in a software development environment
US7548919B2 (en) * 2006-09-22 2009-06-16 International Business Machines Corporation Computer program product for conducting a lock free read
US8635194B2 (en) * 2006-10-19 2014-01-21 Oracle International Corporation System and method for data compression
US9465823B2 (en) * 2006-10-19 2016-10-11 Oracle International Corporation System and method for data de-duplication
US7920700B2 (en) * 2006-10-19 2011-04-05 Oracle International Corporation System and method for data encryption
US9697253B2 (en) * 2006-10-20 2017-07-04 Oracle International Corporation Consistent client-side cache
US10296629B2 (en) * 2006-10-20 2019-05-21 Oracle International Corporation Server supporting a consistent client-side cache
US7739547B2 (en) * 2007-06-07 2010-06-15 International Business Machines Corporation Failure recovery and error correction techniques for data loading in information warehouses
US7886124B2 (en) * 2007-07-30 2011-02-08 Oracle International Corporation Method and mechanism for implementing dynamic space management for large objects
US7870108B2 (en) 2007-09-25 2011-01-11 Amadeus S.A.S. Method and apparatus for version management of a data entity
US8422967B2 (en) * 2009-06-09 2013-04-16 Broadcom Corporation Method and system for amplitude modulation utilizing a leaky wave antenna
CN102737028A (zh) * 2011-04-01 2012-10-17 深圳市赛格导航科技股份有限公司 一种数据库的同步方法及系统
JP5772458B2 (ja) * 2011-09-29 2015-09-02 富士通株式会社 データ管理プログラム、ノード、および分散データベースシステム
US9514007B2 (en) * 2013-03-15 2016-12-06 Amazon Technologies, Inc. Database system with database engine and separate distributed storage service
US9760596B2 (en) * 2013-05-13 2017-09-12 Amazon Technologies, Inc. Transaction ordering
US20150006466A1 (en) * 2013-06-27 2015-01-01 Andreas Tonder Multiversion concurrency control for columnar database and mixed OLTP/OLAP workload
JP6289883B2 (ja) * 2013-11-27 2018-03-07 株式会社東芝 ストレージ装置
CN103761324B (zh) * 2014-01-28 2017-02-15 宇龙计算机通信科技(深圳)有限公司 一种卫星地图的气象遮挡消除方法及系统
FR3046267B1 (fr) 2015-12-28 2018-02-16 Proton World International N.V. Stockage de donnees dans une memoire flash
US11567934B2 (en) 2018-04-20 2023-01-31 Oracle International Corporation Consistent client-side caching for fine grained invalidations
CN109558086B (zh) * 2018-12-03 2019-10-18 浪潮电子信息产业股份有限公司 一种数据读取方法、系统及相关组件
US11347713B2 (en) * 2019-09-27 2022-05-31 Salesforce.Com, Inc. Version-based table locking
US20230093254A1 (en) * 2021-09-23 2023-03-23 Nvidia Corporation Application programming interface to set up graph resources

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5794229A (en) * 1993-04-16 1998-08-11 Sybase, Inc. Database system with methodology for storing a database table by vertically partitioning all columns of the table
US5794228A (en) * 1993-04-16 1998-08-11 Sybase, Inc. Database system with buffer manager providing per page native data compression and decompression
US5870764A (en) * 1993-05-12 1999-02-09 Apple Computer, Inc. Method of managing a data structure for concurrent serial and parallel revision of a work
US5806076A (en) 1996-10-29 1998-09-08 Oracle Corporation Tracking dependencies between transactions in a database
US5873098A (en) 1997-04-23 1999-02-16 Oracle Corporation Dynamic snapshot set adjustment
US5956731A (en) * 1997-04-23 1999-09-21 Oracle Corporation Sharing snapshots for consistent reads
US6237001B1 (en) 1997-04-23 2001-05-22 Oracle Corporation Managing access to data in a distributed database environment
FR2762695B1 (fr) * 1997-04-29 1999-05-28 Bull Sa Procede et dispositif de connexion de l'unite centrale d'un systeme de traitement de donnees a un sous-systeme de stockage de donnees a redondance
US6192377B1 (en) 1998-05-13 2001-02-20 Oracle Corporation Method and apparatus for determing whether a transaction can use a version of a data item
US6606660B1 (en) * 1999-08-31 2003-08-12 Accenture Llp Stream-based communication in a communication services patterns environment
US6564215B1 (en) * 1999-12-16 2003-05-13 International Business Machines Corporation Update support in database content management
US6772155B1 (en) * 2001-04-04 2004-08-03 Ncr Corporation Looking data in a database system
US6845384B2 (en) * 2003-08-01 2005-01-18 Oracle International Corporation One-phase commit in a shared-nothing database system

Also Published As

Publication number Publication date
HK1069644A1 (en) 2005-05-27
CN100410930C (zh) 2008-08-13
EP1504375B1 (en) 2009-03-25
CA2484007A1 (en) 2003-11-20
DE60326835D1 (de) 2009-05-07
JP2005532615A (ja) 2005-10-27
EP1504375A1 (en) 2005-02-09
AU2003228754A1 (en) 2003-11-11
AU2003228754B2 (en) 2008-09-11
CN1653451A (zh) 2005-08-10
US6957236B1 (en) 2005-10-18
CA2484007C (en) 2010-04-20
WO2003096226A1 (en) 2003-11-20

Similar Documents

Publication Publication Date Title
JP4340226B2 (ja) データ項目の使用可能バージョンの提供
AU2002303900B2 (en) Consistent read in a distributed database environment
US7237147B2 (en) Method and apparatus for making available data that was locked by a dead transaction before rolling back the entire dead transaction
US6237001B1 (en) Managing access to data in a distributed database environment
US6192377B1 (en) Method and apparatus for determing whether a transaction can use a version of a data item
US8429134B2 (en) Distributed database recovery
AU2002303900A1 (en) Consistent read in a distributed database environment
US8380663B2 (en) Data integrity in a database environment through background synchronization
US20050256897A1 (en) Providing the timing of the last committed change to a row in a database table
WO2006127402A1 (en) Version-controlled cached data store
US7693882B2 (en) Replicating data across the nodes in a cluster environment
US11599504B2 (en) Executing a conditional command on an object stored in a storage system
US7251660B2 (en) Providing mappings between logical time values and real time values in a multinode system
EP1788496A2 (en) Consistent read in a distributed database environment
HK1069644B (en) Providing a useable version of the data item
US20170116300A1 (en) Efficient mirror data re-sync
HK1059491B (en) Consistent read in a distributed database environment
HK1100096A (en) Consistent read in a distributed database environment

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20060410

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20060410

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20090203

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20090428

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

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

R150 Certificate of patent or registration of utility model

Ref document number: 4340226

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

Free format text: JAPANESE INTERMEDIATE CODE: R150

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

Free format text: PAYMENT UNTIL: 20120710

Year of fee payment: 3

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

Free format text: PAYMENT UNTIL: 20120710

Year of fee payment: 3

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

Free format text: PAYMENT UNTIL: 20130710

Year of fee payment: 4

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

EXPY Cancellation because of completion of term