AU2003228754B2 - Providing a useable version of the data item - Google Patents

Providing a useable version of the data item Download PDF

Info

Publication number
AU2003228754B2
AU2003228754B2 AU2003228754A AU2003228754A AU2003228754B2 AU 2003228754 B2 AU2003228754 B2 AU 2003228754B2 AU 2003228754 A AU2003228754 A AU 2003228754A AU 2003228754 A AU2003228754 A AU 2003228754A AU 2003228754 B2 AU2003228754 B2 AU 2003228754B2
Authority
AU
Australia
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
Application number
AU2003228754A
Other languages
English (en)
Other versions
AU2003228754A1 (en
Inventor
Roger J. Bamford
Amit Ganesh
Srinivas S. Vemuri
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 AU2003228754A1 publication Critical patent/AU2003228754A1/en
Application granted granted Critical
Publication of AU2003228754B2 publication Critical patent/AU2003228754B2/en
Anticipated expiration legal-status Critical
Expired legal-status Critical Current

Links

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)
AU2003228754A 2002-05-10 2003-04-29 Providing a useable version of the data item Expired AU2003228754B2 (en)

Applications Claiming Priority (5)

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

Publications (2)

Publication Number Publication Date
AU2003228754A1 AU2003228754A1 (en) 2003-11-11
AU2003228754B2 true AU2003228754B2 (en) 2008-09-11

Family

ID=29423229

Family Applications (1)

Application Number Title Priority Date Filing Date
AU2003228754A Expired AU2003228754B2 (en) 2002-05-10 2003-04-29 Providing a useable version of the data item

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

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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

Family Cites Families (10)

* 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
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
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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

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
JP4340226B2 (ja) 2009-10-07
DE60326835D1 (de) 2009-05-07
JP2005532615A (ja) 2005-10-27
EP1504375A1 (en) 2005-02-09
AU2003228754A1 (en) 2003-11-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
AU2003228754B2 (en) Providing a useable version of the data item
US6192377B1 (en) Method and apparatus for determing whether a transaction can use a version of a data item
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
US7552149B2 (en) Querying past versions of data in a distributed database
US6295610B1 (en) Recovering resources in parallel
US9146934B2 (en) Reduced disk space standby
EP0723238B1 (en) Relational database system and method with high data availability during table data restructuring
US7953749B2 (en) Providing the timing of the last committed change to a row in a database table
US7533136B2 (en) Efficient implementation of multiple work areas in a file system like repository that supports file versioning
US20070185912A1 (en) Off-loading I/O and computationally intensive operations to secondary systems
AU2002303900A1 (en) Consistent read in a distributed database environment
WO2006127402A1 (en) Version-controlled cached data store
US7437525B2 (en) Guaranteed undo retention
US7251660B2 (en) Providing mappings between logical time values and real time values in a multinode system
US10459810B2 (en) Technique for higher availability in a multi-node system using replicated lock information to determine a set of data blocks for recovery
Faria et al. Totally-ordered prefix parallel snapshot isolation
HK1069644B (en) Providing a useable version of the data item
EP4660830A1 (en) Query language representations of constraints useable to cause query failure
US20080243913A1 (en) Partial sub-lock for delta object management
EP1788496A2 (en) Consistent read in a distributed database environment
HK1059491B (en) Consistent read in a distributed database environment
HK1100096A (en) Consistent read in a distributed database environment

Legal Events

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

Free format text: IN VOL 18, NO 2, PAGE(S) 564 UNDER THE HEADING APPLICATIONS OPI NAME INDEX UNDER THE NAME ORACLE INTERNATIONAL CORPORATION, APPLICATION NO. 2003228754, UNDER INID (43) CORRECT THE PUBLICATION DATE TO READ 24 NOVEMBER 2003.

MK14 Patent ceased section 143(a) (annual fees not paid) or expired