CA2119221A1 - Method for Synchronizing Transaction Processing in a Distributed Heterogeneous System - Google Patents

Method for Synchronizing Transaction Processing in a Distributed Heterogeneous System

Info

Publication number
CA2119221A1
CA2119221A1 CA2119221A CA2119221A CA2119221A1 CA 2119221 A1 CA2119221 A1 CA 2119221A1 CA 2119221 A CA2119221 A CA 2119221A CA 2119221 A CA2119221 A CA 2119221A CA 2119221 A1 CA2119221 A1 CA 2119221A1
Authority
CA
Canada
Prior art keywords
transaction processing
heterogeneous system
distributed heterogeneous
resources
phase commit
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.)
Granted
Application number
CA2119221A
Other languages
French (fr)
Other versions
CA2119221C (en
Inventor
Robert Alan Gilles
Robert Joseph Grafe
Robert Dean Jackson
Roger Alan Reinsch
Richard Rolland Sanders
Jacob Slonim
Melvin Richard Zimowski
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.)
International Business Machines Corp
Original Assignee
Individual
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 Individual filed Critical Individual
Publication of CA2119221A1 publication Critical patent/CA2119221A1/en
Application granted granted Critical
Publication of CA2119221C publication Critical patent/CA2119221C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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
    • 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

Abstract

The invention provides transaction synchronization in the form of COMMIT processing in a distributed, heterogeneous database system wherein some resources are synchronized to a transaction by a single-phase commit procedures while other resources synchronize by multi-phase commit procedures. The invention invests an application requestor at an application site with authority to represent all single-phase commit resources in multi-phase commit processing.
CA002119221A 1993-03-16 1994-03-16 Method for synchronizing transaction processing in a distributed heterogeneous system Expired - Fee Related CA2119221C (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US08/031,774 US5455944A (en) 1993-03-16 1993-03-16 Method for managing logging and locking of page free space information in a transaction processing system
US031,774 1993-03-16

Publications (2)

Publication Number Publication Date
CA2119221A1 true CA2119221A1 (en) 1994-09-17
CA2119221C CA2119221C (en) 1998-09-15

Family

ID=21861317

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002119221A Expired - Fee Related CA2119221C (en) 1993-03-16 1994-03-16 Method for synchronizing transaction processing in a distributed heterogeneous system

Country Status (2)

Country Link
US (1) US5455944A (en)
CA (1) CA2119221C (en)

Families Citing this family (72)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH07143170A (en) * 1993-11-19 1995-06-02 Fujitsu Ltd Information delivery system
JPH07175700A (en) * 1993-12-20 1995-07-14 Fujitsu Ltd Database management system
JPH11500548A (en) * 1995-01-23 1999-01-12 タンデム コンピューターズ インコーポレイテッド Database integrity maintenance system
US6647510B1 (en) * 1996-03-19 2003-11-11 Oracle International Corporation Method and apparatus for making available data that was locked by a dead transaction before rolling back the entire dead transaction
US5857204A (en) * 1996-07-02 1999-01-05 Ab Initio Software Corporation Restoring the state of a set of files
US5974425A (en) 1996-12-17 1999-10-26 Oracle Corporation Method and apparatus for reapplying changes to a database
US5832516A (en) * 1997-01-21 1998-11-03 Oracle Corporation Caching data in recoverable objects
US5790851A (en) * 1997-04-15 1998-08-04 Oracle Corporation Method of sequencing lock call requests to an O/S to avoid spinlock contention within a multi-processor environment
US5951695A (en) * 1997-07-25 1999-09-14 Hewlett-Packard Company Fast database failover
JP3113841B2 (en) * 1997-07-30 2000-12-04 インターナショナル・ビジネス・マシーンズ・コーポレ−ション Parallel transaction processing system
US6185699B1 (en) 1998-01-05 2001-02-06 International Business Machines Corporation Method and apparatus providing system availability during DBMS restart recovery
US6119128A (en) * 1998-03-30 2000-09-12 International Business Machines Corporation Recovering different types of objects with one pass of the log
US6161109A (en) * 1998-04-16 2000-12-12 International Business Machines Corporation Accumulating changes in a database management system by copying the data object to the image copy if the data object identifier of the data object is greater than the image identifier of the image copy
US6334134B1 (en) 1998-08-18 2001-12-25 International Business Machines Corporation Insert performance on a multi-system transaction environment
US6363389B1 (en) 1998-09-24 2002-03-26 International Business Machines Corporation Technique for creating a unique quasi-random row identifier
US6144970A (en) * 1998-09-24 2000-11-07 International Business Machines Corporation Technique for inplace reorganization of a LOB table space
US6606617B1 (en) 1998-09-24 2003-08-12 International Business Machines Corporation Optimized technique for prefetching LOB table space pages
US6343286B1 (en) 1998-09-24 2002-01-29 International Business Machines Corporation Efficient technique to defer large object access with intermediate results
US6694340B1 (en) 1998-09-24 2004-02-17 International Business Machines Corporation Technique for determining the age of the oldest reading transaction with a database object
US6470359B1 (en) 1998-09-24 2002-10-22 International Business Machines Corporation Fast technique for recovering an index on an auxiliary table
US6631366B1 (en) * 1998-10-20 2003-10-07 Sybase, Inc. Database system providing methodology for optimizing latching/copying costs in index scans on data-only locked tables
JP3004008B1 (en) * 1998-10-20 2000-01-31 三菱電機株式会社 Update history management device and update history management method
US6470330B1 (en) * 1998-11-05 2002-10-22 Sybase, Inc. Database system with methods for estimation and usage of index page cluster ratio (IPCR) and data page cluster ratio (DPCR)
US6411964B1 (en) * 1998-12-23 2002-06-25 International Business Machines Corporation Methods for in-place online reorganization of a database
US6370528B1 (en) * 1999-05-28 2002-04-09 Unisys Corporation High speed method for flushing data buffers and updating database structure control information
JP4237354B2 (en) * 1999-09-29 2009-03-11 株式会社東芝 Transaction processing method and transaction processing system
US6553466B1 (en) * 1999-10-01 2003-04-22 Infraworks Corporation Shared memory blocking method and system
CA2306968C (en) * 2000-04-28 2004-11-30 Ibm Canada Limited-Ibm Canada Limitee Efficient index-data fetch via callback for a table data
US6598041B1 (en) * 2000-09-07 2003-07-22 International Business Machines Corporation Method, system, and program for processing modifications to data in tables in a database system
US6633884B2 (en) * 2001-04-03 2003-10-14 Bmc Software, Inc. System and method for analyzing a database for on-line reorganization
US6807541B2 (en) * 2002-02-28 2004-10-19 International Business Machines Corporation Weak record locks in database query read processing
US7058664B1 (en) * 2002-04-29 2006-06-06 Sprint Communications Company L.P. Method and system for data recovery
US7484216B2 (en) * 2002-06-18 2009-01-27 Microsoft Corporation System and method for decoupling space reservation in transactional logging systems
US6842825B2 (en) 2002-08-07 2005-01-11 International Business Machines Corporation Adjusting timestamps to preserve update timing information for cached data objects
US7003695B2 (en) * 2002-10-03 2006-02-21 Seiko Epson Corporation Undo/redo algorithm for a computer program
CA2422176C (en) * 2003-03-14 2009-07-21 Ibm Canada Limited - Ibm Canada Limitee Method and apparatus for interrupting updates to a database to provide read-only access
US7032090B2 (en) * 2003-04-08 2006-04-18 International Business Machines Corporation Method, system, and apparatus for releasing storage in a fast replication environment
US7069402B2 (en) * 2003-06-02 2006-06-27 International Business Machines Corporation Host-independent incremental backup method, apparatus, and system
CA2433254A1 (en) 2003-06-25 2004-12-25 Ibm Canada Limited - Ibm Canada Limitee System and method for warm shutdown and restart of a buffer pool
US7047379B2 (en) * 2003-07-11 2006-05-16 International Business Machines Corporation Autonomic link optimization through elimination of unnecessary transfers
GB2405228B8 (en) * 2003-08-19 2007-09-13 Ibm A method, apparatus and computer program for verifying the order of a queue of work items
CA2438366A1 (en) * 2003-08-26 2005-02-26 Ibm Canada Limited - Ibm Canada Limitee System and method for starting a buffer pool
US7631010B2 (en) * 2004-04-16 2009-12-08 Microsoft Corporation Systems and methods in support of data base page synchronization
US7707195B2 (en) * 2004-06-29 2010-04-27 Microsoft Corporation Allocation locks and their use
US20060095685A1 (en) * 2004-11-03 2006-05-04 Bonola Thomas J System and method to coordinate access to a sharable data structure using deferred cycles
US7617180B1 (en) * 2005-06-06 2009-11-10 Infoblox Inc. Efficient lock management
US7673105B2 (en) * 2005-06-27 2010-03-02 Ab Inition Technology LLC Managing memory pages
US7865684B2 (en) * 2005-06-27 2011-01-04 Ab Initio Technology Llc Managing message queues
US20070005874A1 (en) * 2005-07-01 2007-01-04 Dan Dodge File system storing transaction records in flash-like media
US7873683B2 (en) 2005-07-01 2011-01-18 Qnx Software Systems Gmbh & Co. Kg File system having transaction record coalescing
US7707480B2 (en) * 2005-07-01 2010-04-27 Qnx Software Systems Gmbh & Co. Kg System employing data verification operations of differing computational costs
US8959125B2 (en) * 2005-07-01 2015-02-17 226008 Ontario Inc. File system having inverted hierarchical structure
US7970803B2 (en) 2005-07-01 2011-06-28 Qnx Software Systems Gmbh & Co. Kg Optimized startup verification of file system integrity
US7698495B2 (en) * 2005-07-01 2010-04-13 QNZ Software Systems GmbH & Co. KG Computer system having logically ordered cache management
US7809777B2 (en) * 2005-07-01 2010-10-05 Qnx Software Systems Gmbh & Co. Kg File system having deferred verification of data integrity
US7636829B2 (en) 2006-05-02 2009-12-22 Intel Corporation System and method for allocating and deallocating memory within transactional code
US7599972B2 (en) * 2006-08-25 2009-10-06 Qnx Software Systems Gmbh & Co. Kg File system having variable logical storage block size
US8566503B2 (en) * 2006-08-25 2013-10-22 Qnx Software Systems Limited Multimedia filesystem having unified representation of content on diverse multimedia devices
US7908276B2 (en) * 2006-08-25 2011-03-15 Qnx Software Systems Gmbh & Co. Kg Filesystem having a filename cache
US8682863B2 (en) 2006-10-04 2014-03-25 Salesforce.Com, Inc. Methods and systems for bulk row save logic in an object relational mapping layer and application framework
US8161010B2 (en) 2006-10-04 2012-04-17 Salesforce.Com, Inc. Methods and systems for providing fault recovery to side effects occurring during data processing
US8548942B2 (en) 2006-10-04 2013-10-01 Salesforce.Com, Inc. Methods and systems for recursive saving of hierarchical objects to a database
US8589357B2 (en) * 2006-10-20 2013-11-19 Oracle International Corporation Techniques for automatically tracking and archiving transactional data changes
JP2008146574A (en) 2006-12-13 2008-06-26 Hitachi Ltd Storage controller and storage control method
US20080243966A1 (en) * 2007-04-02 2008-10-02 Croisettier Ramanakumari M System and method for managing temporary storage space of a database management system
US9672237B2 (en) * 2013-03-15 2017-06-06 Amazon Technologies, Inc. System-wide checkpoint avoidance for distributed database systems
US9558229B2 (en) * 2013-11-26 2017-01-31 Sap Se Transaction private log buffering for high performance of transaction processing
US20150222679A1 (en) * 2014-01-31 2015-08-06 Wal-Mart Stores, Inc. Data streaming framework from database to multiple targets by leveraging cached database connections and cursors
US20160055257A1 (en) * 2014-08-20 2016-02-25 Sachin Sinha Method and system for adaptive pre-fetching of pages into a buffer pool
FR3046267B1 (en) * 2015-12-28 2018-02-16 Proton World International N.V. STORING DATA IN A FLASH MEMORY
US10749921B2 (en) * 2016-06-01 2020-08-18 Netflix, Inc. Techniques for warming up a node in a distributed data store
US10565070B2 (en) * 2017-11-29 2020-02-18 Bmc Software, Inc. Systems and methods for recovery of consistent database indexes

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4507751A (en) * 1982-06-21 1985-03-26 International Business Machines Corporation Method and apparatus for logging journal data using a log write ahead data set
US4604694A (en) * 1983-12-14 1986-08-05 International Business Machines Corporation Shared and exclusive access control
DE68913629T2 (en) * 1988-03-14 1994-06-16 Unisys Corp BLOCK LOCKING PROCESSOR FOR MULTIPLE PROCESSING DATA SYSTEM.
US4961134A (en) * 1988-07-15 1990-10-02 International Business Machines Corporation Method for minimizing locking and reading in a segmented storage space
US5193162A (en) * 1989-11-06 1993-03-09 Unisys Corporation Cache memory with data compaction for use in the audit trail of a data processing system having record locking capabilities
US5222235A (en) * 1990-02-01 1993-06-22 Bmc Software, Inc. Databases system for permitting concurrent indexing and reloading of data by early simulating the reload process to determine final locations of the data
US5247672A (en) * 1990-02-15 1993-09-21 International Business Machines Corporation Transaction processing system and method with reduced locking
US5280612A (en) * 1991-11-26 1994-01-18 International Business Machines Corporation Multiple version database concurrency control system

Also Published As

Publication number Publication date
US5455944A (en) 1995-10-03
CA2119221C (en) 1998-09-15

Similar Documents

Publication Publication Date Title
CA2119221A1 (en) Method for Synchronizing Transaction Processing in a Distributed Heterogeneous System
HK1044835A1 (en) A database system having at least two host database, and a method of synchronizing such databases.
WO2000005903A3 (en) Method and apparatus for synchronizing information browsing among multiple systems
CA2343580A1 (en) System and method for synchronizing data records between multiple databases
SE9503284D0 (en) Method and apparatus for providing a synchronous communication environment
DE69419524D1 (en) LOCK SYNCHRONIZATION FOR DISTRIBUTED MASSIVE PARALLEL COMPUTERS
EP0765062A3 (en) Synchronization between dissimilar computer server environments
PH25306A (en) Laminated tile product, method for producing the same, method for installing the same
CA2182791A1 (en) Method and Apparatus to Secure Distributed Digital Directory Object Changes
AU8087191A (en) Field synchronization system maintaining interlace integrity
GR3018340T3 (en) Method for producing composite cheeses.
YU45074B (en) Process for waterless hydroforming, using easy evaporating phosphinic ligands
HUP9802233A3 (en) Telecommunications system and method for operating thereof, as well as, synchronous data transmission multipexer
DE3486257T2 (en) Synchronous decentralized processing system.
AU6607494A (en) High ending, locked tie-in construction
EP0233089A3 (en) Method for aligning first and second objects relative to each other, and apparatus for practicing this method
FI890748A (en) SYSTEM SOM ANVAENDER SYNCHRONIZER SECONDARY AGER AV LINE MOTOR FOR BIAXIELL DRAGNING AV PLASTFILMER.
EP0660141A3 (en) Process for producing phase retarder film.
BR9808879A (en) Synchronization system and method for digital communication systems
FR2700401B1 (en) System for synchronizing responding tasks.
AU8258087A (en) Method for producing galactooligosaccharide
SG67961A1 (en) Clock synchronization scheme for fractional multiplication systems
EP0635816A3 (en) A system including a synchronous DRAM.
AU3742595A (en) Process for producing oligoamines or polyamines
CA2021847A1 (en) Radiotelephone system

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed