WO2004031897A3 - Method and system for managing a distributed transaction process - Google Patents

Method and system for managing a distributed transaction process Download PDF

Info

Publication number
WO2004031897A3
WO2004031897A3 PCT/US2003/029982 US0329982W WO2004031897A3 WO 2004031897 A3 WO2004031897 A3 WO 2004031897A3 US 0329982 W US0329982 W US 0329982W WO 2004031897 A3 WO2004031897 A3 WO 2004031897A3
Authority
WO
WIPO (PCT)
Prior art keywords
transactions
database
active
transaction
merge
Prior art date
Application number
PCT/US2003/029982
Other languages
French (fr)
Other versions
WO2004031897A2 (en
Inventor
Kevin Zou
Josh A Wiles
Pasquale Solitro
Zheng Zhu
Original Assignee
Acs State & Local Solutions In
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 Acs State & Local Solutions In filed Critical Acs State & Local Solutions In
Priority to AU2003267320A priority Critical patent/AU2003267320A1/en
Publication of WO2004031897A2 publication Critical patent/WO2004031897A2/en
Publication of WO2004031897A3 publication Critical patent/WO2004031897A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • YGENERAL 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
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99951File or database maintenance
    • Y10S707/99952Coherency, e.g. same view to multiple users
    • Y10S707/99955Archiving or backup

Abstract

Systems and methods for managing a distributed transaction process include an active transaction manager (236) that manages transactions with an active database (238), a transaction latent transaction manager (234) that manages transactions with a merge database, a transaction log (233) that reflects the set of transactions in the active database that are not affiliated with the transactions in the merge database, and a merge manager that uses the transaction log to determine whether to transfer control of the merge database to the active transaction manager. Systems and methods may further instruct the active transaction manager to halt transactions with the active database while the merge database is updated to reflect a set of transactions affiliated with the set of transactions in the transaction log, and instruct the active transaction manager to subsequently manage transactions to the active database and the merge database.
PCT/US2003/029982 2002-10-01 2003-09-25 Method and system for managing a distributed transaction process WO2004031897A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2003267320A AU2003267320A1 (en) 2002-10-01 2003-09-25 Method and system for managing a distributed transaction process

Applications Claiming Priority (6)

Application Number Priority Date Filing Date Title
US41464502P 2002-10-01 2002-10-01
US60/414,645 2002-10-01
US43094102P 2002-12-05 2002-12-05
US60/430,941 2002-12-05
US10/650,994 US7587434B2 (en) 2002-10-01 2003-08-29 Method and system for managing a distributed transaction process
US10/650,994 2003-08-29

Publications (2)

Publication Number Publication Date
WO2004031897A2 WO2004031897A2 (en) 2004-04-15
WO2004031897A3 true WO2004031897A3 (en) 2004-08-05

Family

ID=32074368

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2003/029982 WO2004031897A2 (en) 2002-10-01 2003-09-25 Method and system for managing a distributed transaction process

Country Status (3)

Country Link
US (2) US7587434B2 (en)
AU (1) AU2003267320A1 (en)
WO (1) WO2004031897A2 (en)

Families Citing this family (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020107837A1 (en) * 1998-03-31 2002-08-08 Brian Osborne Method and apparatus for logically reconstructing incomplete records in a database using a transaction log
US8655755B2 (en) * 2003-10-22 2014-02-18 Scottrade, Inc. System and method for the automated brokerage of financial instruments
US7796523B2 (en) 2005-03-02 2010-09-14 International Business Machines Corporation Network usage optimization with respect to a virtual circuit network
JP2008282321A (en) * 2007-05-14 2008-11-20 Casio Comput Co Ltd Information server device, settlement system, and program
US20100049715A1 (en) * 2008-08-20 2010-02-25 Yahoo! Inc. Controlled parallel propagation of view table updates in distributed database systems
US8682842B2 (en) * 2008-12-09 2014-03-25 Yahoo! Inc. System and method for logging operations
US8386431B2 (en) * 2010-06-14 2013-02-26 Sap Ag Method and system for determining database object associated with tenant-independent or tenant-specific data, configured to store data partition, current version of the respective convertor
US8380757B1 (en) * 2011-03-25 2013-02-19 Emc Corporation Techniques for providing a consolidated system configuration view using database change tracking and configuration files
US9767268B2 (en) 2011-04-20 2017-09-19 International Business Machines Corporation Optimizing a compiled access control table in a content management system
US8682855B2 (en) 2011-06-06 2014-03-25 International Business Machines Corporation Methods, systems, and physical computer storage media for backing up a database
US8660861B2 (en) 2012-01-24 2014-02-25 Fmr Llc Allocation of financial incentives for employee wellness programs
US9244775B2 (en) 2013-03-14 2016-01-26 International Business Machines Corporation Reducing reading of database logs by persisting long-running transaction data
US9384257B2 (en) 2013-06-24 2016-07-05 International Business Machines Corporation Providing multiple concurrent transactions on a single database schema using a single concurrent transaction database infrastructure
US9898501B2 (en) * 2013-09-12 2018-02-20 Neustar, Inc. Method and system for performing transactional updates in a key-value store
US20150120645A1 (en) * 2013-10-31 2015-04-30 Futurewei Technologies, Inc. System and Method for Creating a Distributed Transaction Manager Supporting Repeatable Read Isolation level in a MPP Database
CN108897641B (en) * 2018-06-21 2020-08-18 武汉达梦数据库有限公司 Log analysis service real-time synchronization system under database master-slave environment
CN110333935B (en) * 2019-06-05 2022-12-02 创新先进技术有限公司 Transaction request processing method and device
US11409605B2 (en) * 2020-10-20 2022-08-09 Sap Se Failover system for database unavailability

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6233617B1 (en) * 1997-02-26 2001-05-15 Siebel Systems, Inc. Determining the visibility to a remote database client
US6446089B1 (en) * 1997-02-26 2002-09-03 Siebel Systems, Inc. Method of using a cache to determine the visibility to a remote database client of a plurality of database transactions

Family Cites Families (104)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US101136A (en) * 1870-03-22 Improvement in broadcast seeder
US74234A (en) * 1868-02-11 Samuel harden
US9355A (en) * 1852-10-26 Machine for making bags op paper
US10679A (en) * 1854-03-21 Shoe-last
US93283A (en) * 1869-08-03 Improved car-starter
US4341951A (en) 1980-07-02 1982-07-27 Benton William M Electronic funds transfer and voucher issue system
US4439636A (en) 1982-03-09 1984-03-27 Martha Newkirk Credit card actuated telecommunication access network
GB8522427D0 (en) 1985-09-10 1985-10-16 Plessey Co Plc Credit transaction arrangments
CA2055171C (en) 1990-12-31 1995-09-05 Nandakishore Anant Albal Telephone network credit card calling apparatus and method of operation
JP3272777B2 (en) 1992-07-14 2002-04-08 芝浦メカトロニクス株式会社 Prepaid card issuance method and intermediate prepaid card making device
US5530855A (en) * 1992-10-13 1996-06-25 International Business Machines Corporation Replicating a database by the sequential application of hierarchically sorted log records
US5434919A (en) 1994-01-11 1995-07-18 Chaum; David Compact endorsement signature systems
US5457747A (en) 1994-01-14 1995-10-10 Drexler Technology Corporation Anti-fraud verification system using a data card
US5461217A (en) 1994-02-08 1995-10-24 At&T Ipm Corp. Secure money transfer techniques using smart cards
US5577121A (en) 1994-06-09 1996-11-19 Electronic Payment Services, Inc. Transaction system for integrated circuit cards
US5559887A (en) 1994-09-30 1996-09-24 Electronic Payment Service Collection of value from stored value systems
US5737539A (en) 1994-10-28 1998-04-07 Advanced Health Med-E-Systems Corp. Prescription creation system
US5479510A (en) 1994-11-15 1995-12-26 Olsen; Kurt B. Automated data card payment verification method
US5536045A (en) 1994-12-28 1996-07-16 Adams; Thomas W. Debit/credit card system having primary utility in replacing food stamps
US5866889A (en) 1995-06-07 1999-02-02 Citibank, N.A. Integrated full service consumer banking system and system and method for opening an account
AU6970096A (en) 1995-09-14 1997-04-01 Cybermark, Inc. Stored value transaction system and method using anonymous account numbers
US5762376A (en) 1995-11-07 1998-06-09 American Express Travel Relate Methods and apparatus for providing a prepaid, remote entry transaction instrument having multiple language capability
US6129275A (en) 1995-12-20 2000-10-10 The Eastern Company Smart card transaction system and encoder-dispenser
US6112182A (en) 1996-01-16 2000-08-29 Healthcare Computer Corporation Method and apparatus for integrated management of pharmaceutical and healthcare services
CA2217764C (en) 1996-02-15 2002-01-22 Catalina Marketing International, Inc. Method and apparatus for generating personal identification numbers for use in consumer promotions
US6067522A (en) 1996-03-01 2000-05-23 Warady; Arthur D. Health and welfare benefit enrollment and billing system and method
US5873096A (en) 1997-10-08 1999-02-16 Siebel Systems, Inc. Method of maintaining a network of partially replicated database system
US5889941A (en) 1996-04-15 1999-03-30 Ubiq Inc. System and apparatus for smart card personalization
US6044360A (en) 1996-04-16 2000-03-28 Picciallo; Michael J. Third party credit card
WO1997041541A1 (en) 1996-04-26 1997-11-06 Verifone, Inc. A system, method and article of manufacture for network electronic payment and credit collection utilizing a payment instrument holder
US5930759A (en) 1996-04-30 1999-07-27 Symbol Technologies, Inc. Method and system for processing health care electronic data transactions
US5991742A (en) 1996-05-20 1999-11-23 Tran; Bao Q. Time and expense logging system
US5864822A (en) 1996-06-25 1999-01-26 Baker, Iii; Bernard R. Benefits tracking and correlation system for use with third-party enabling organization
EP0923769A2 (en) 1996-07-31 1999-06-23 Verifone, Inc. A system, method and article of manufacture for secure, stored value transactions over an open communication network utilizing an extensible, flexible architecture
US5924094A (en) * 1996-11-01 1999-07-13 Current Network Technologies Corporation Independent distributed database system
US6446092B1 (en) * 1996-11-01 2002-09-03 Peerdirect Company Independent distributed database system
JP3325195B2 (en) 1997-03-10 2002-09-17 信隆 吉田 Non-life insurance prepaid card
US6282522B1 (en) 1997-04-30 2001-08-28 Visa International Service Association Internet payment system using smart card
US20010047286A1 (en) 1997-05-02 2001-11-29 Walker Cedric F. Task and personnel verification and tracking system and method
US6999936B2 (en) 1997-05-06 2006-02-14 Sehr Richard P Electronic ticketing system and methods utilizing multi-service visitor cards
WO1999006967A2 (en) 1997-08-01 1999-02-11 Rossides Michael T Expected value payment systems for refunding balances on stored value cards
US6094644A (en) 1997-09-12 2000-07-25 Nortel Networks Corporation Method and apparatus for recording actual time used by a service which makes requests for data
US5953719A (en) * 1997-09-15 1999-09-14 International Business Machines Corporation Heterogeneous database system with dynamic commit procedure control
US6199074B1 (en) * 1997-10-09 2001-03-06 International Business Machines Corporation Database backup system ensuring consistency between primary and mirrored backup database copies despite backup interruption
US6061660A (en) 1997-10-20 2000-05-09 York Eggleston System and method for incentive programs and award fulfillment
US6915265B1 (en) 1997-10-29 2005-07-05 Janice Johnson Method and system for consolidating and distributing information
US6014635A (en) 1997-12-08 2000-01-11 Shc Direct, Inc. System and method for providing a discount credit transaction network
US5953709A (en) 1998-02-19 1999-09-14 Labor Ready, Inc. Automated voucher cash-out system and method
US6636833B1 (en) 1998-03-25 2003-10-21 Obis Patents Ltd. Credit card system and method
US6615189B1 (en) 1998-06-22 2003-09-02 Bank One, Delaware, National Association Debit purchasing of stored value card for use by and/or delivery to others
US6115715A (en) * 1998-06-29 2000-09-05 Sun Microsystems, Inc. Transaction management in a configuration database
US6343271B1 (en) 1998-07-17 2002-01-29 P5 E.Health Services, Inc. Electronic creation, submission, adjudication, and payment of health insurance claims
US6808111B2 (en) 1998-08-06 2004-10-26 Visa International Service Association Terminal software architecture for use with smart cards
KR100358426B1 (en) 1998-08-18 2003-01-29 한국전자통신연구원 Electronic Cash Transaction Method
US6169974B1 (en) 1998-10-08 2001-01-02 Paymentech, Inc. Method for closed loop processing of transactions utilizing bank card association
US6230145B1 (en) 1998-11-03 2001-05-08 First Data Corporation Method for providing bank card transaction data
US7010512B1 (en) 1998-11-09 2006-03-07 C/Base, Inc. Transfer instrument
US6766302B2 (en) 1998-11-09 2004-07-20 Joseph Bach Method and apparatus for advertisement
US7194442B1 (en) 1998-11-16 2007-03-20 Sky Technologies, Llc System and method for automated, iterative development negotiations
AU6500400A (en) 1999-07-29 2001-02-19 Privacash.Com, Inc. Method and system for transacting an anoymous purchase over the internet
US6575361B1 (en) 1999-08-19 2003-06-10 E-2 Interactive, Inc. System and method for managing stored-value card data
US7206805B1 (en) * 1999-09-09 2007-04-17 Oracle International Corporation Asynchronous transcription object management system
US7290056B1 (en) * 1999-09-09 2007-10-30 Oracle International Corporation Monitoring latency of a network to manage termination of distributed transactions
US7319986B2 (en) 1999-09-28 2008-01-15 Bank Of America Corporation Dynamic payment cards and related management systems and associated methods
US6401079B1 (en) 1999-10-01 2002-06-04 Inleague, Inc. System for web-based payroll and benefits administration
US20020049631A1 (en) 1999-10-12 2002-04-25 Eric Williams Process, system and computer readable medium for providing purchasing incentives to a plurality of retail store environments
EP1226520A4 (en) 1999-10-15 2005-01-12 Biosciences Corp Internet-based matching service for expert consultants and customers with matching of qualifications and times of availability
US20070061251A1 (en) 1999-10-29 2007-03-15 E-Duction, Inc. System and method for payroll system and benefits administration
US7222097B2 (en) 2000-01-18 2007-05-22 Bellosguardo Philippe A Anonymous credit card
US20010034702A1 (en) 2000-02-04 2001-10-25 Mockett Gregory P. System and method for dynamically issuing and processing transaction specific digital credit or debit cards
US6615190B1 (en) 2000-02-09 2003-09-02 Bank One, Delaware, National Association Sponsor funded stored value card
US9576293B2 (en) 2000-04-12 2017-02-21 Steve Morsa Method and apparatus for the furnishing of benefits information and benefits
US8140357B1 (en) 2000-04-26 2012-03-20 Boesen Peter V Point of service billing and records system
JP2001338171A (en) 2000-05-29 2001-12-07 Nec Corp System and method for mediating service transaction and recording medium
US6347739B1 (en) 2000-06-08 2002-02-19 Amos Tamam System for credit card acceptance in taxicabs
AU7182701A (en) 2000-07-06 2002-01-21 David Paul Felsher Information record infrastructure, system and method
US6915266B1 (en) 2000-07-31 2005-07-05 Aysha Saeed Method and system for providing evaluation data from tracked, formatted administrative data of a service provider
US6789189B2 (en) 2000-08-04 2004-09-07 First Data Corporation Managing account database in ABDS system
US20030069750A1 (en) 2000-08-11 2003-04-10 Sony Corporation System for automatic device registration
JP2002073822A (en) 2000-08-30 2002-03-12 Fujitsu Ltd Medical information system
US7383223B1 (en) 2000-09-20 2008-06-03 Cashedge, Inc. Method and apparatus for managing multiple accounts
US6694447B1 (en) * 2000-09-29 2004-02-17 Sun Microsystems, Inc. Apparatus and method for increasing application availability during a disaster fail-back
US20020107849A1 (en) 2000-11-01 2002-08-08 Hickey Matthew W. Scholarship search method and system
US7072842B2 (en) 2001-01-08 2006-07-04 P5, Inc. Payment of health care insurance claims using short-term loans
KR20020066614A (en) * 2001-02-13 2002-08-21 엘지전자주식회사 A Color CRT Having The Improved Funnel Structure
US7493266B2 (en) 2001-03-21 2009-02-17 Gupta Amit K System and method for management of health care services
US20020156676A1 (en) 2001-04-17 2002-10-24 Ahrens John C. System, method, and apparatus for creating and securely managing accounts holding cash equivalents
DE50106784D1 (en) 2001-05-04 2005-08-25 Siemens Ag Method and arrangement for charging a service
US6616189B2 (en) 2001-06-08 2003-09-09 Premier Print & Services Group, Inc. Sequentially placed shipping and packing label system
US6896618B2 (en) 2001-09-20 2005-05-24 Igt Point of play registration on a gaming machine
US20030069760A1 (en) 2001-10-04 2003-04-10 Arthur Gelber System and method for processing and pre-adjudicating patient benefit claims
US20030083903A1 (en) 2001-10-30 2003-05-01 Myers Gene E. Method and apparatus for contemporaneous billing and documenting with rendered services
US20030074234A1 (en) 2002-02-06 2003-04-17 Stasny Jeanne Ann Customer-centered pharmaceutical product and information distribution system
US7152181B2 (en) * 2002-02-22 2006-12-19 Bea Systems, Inc. Method for highly available transaction recovery for transaction processing systems
US7178050B2 (en) * 2002-02-22 2007-02-13 Bea Systems, Inc. System for highly available transaction recovery for transaction processing systems
US20030191669A1 (en) 2002-04-09 2003-10-09 Fitzgerald David System for providing consumer access to healthcare related information
US7925518B2 (en) 2002-04-19 2011-04-12 Visa U.S.A. Inc. System and method for payment of medical claims
US6873995B2 (en) * 2002-04-23 2005-03-29 International Business Machines Corporation Method, system, and program product for transaction management in a distributed content management application
US6978396B2 (en) * 2002-05-30 2005-12-20 Solid Information Technology Oy Method and system for processing replicated transactions parallel in secondary server
US7039593B2 (en) 2002-06-20 2006-05-02 Robert David Sager Payment convergence system and method
US20040006489A1 (en) 2002-07-03 2004-01-08 Bynon Douglas B. Benefits services payment and credit system
US7774273B2 (en) 2002-07-30 2010-08-10 Acs State & Local Solutions, Inc. Systems and methods for processing benefits
US7076508B2 (en) * 2002-08-12 2006-07-11 International Business Machines Corporation Method, system, and program for merging log entries from multiple recovery log files
EP1411482A1 (en) 2002-10-14 2004-04-21 Lucheon Vouchers Ltd trading as Accor Services Improved token-management system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6233617B1 (en) * 1997-02-26 2001-05-15 Siebel Systems, Inc. Determining the visibility to a remote database client
US6446089B1 (en) * 1997-02-26 2002-09-03 Siebel Systems, Inc. Method of using a cache to determine the visibility to a remote database client of a plurality of database transactions

Also Published As

Publication number Publication date
WO2004031897A2 (en) 2004-04-15
AU2003267320A1 (en) 2004-04-23
US8554728B2 (en) 2013-10-08
US20090177709A1 (en) 2009-07-09
US20040088298A1 (en) 2004-05-06
US7587434B2 (en) 2009-09-08
AU2003267320A8 (en) 2004-04-23

Similar Documents

Publication Publication Date Title
WO2004031897A3 (en) Method and system for managing a distributed transaction process
CA2189307A1 (en) Method of commitment in a distributed database transaction
WO2001082260A3 (en) System and method for managing uninterruptible power supply systems
WO1998038564A3 (en) Partially replicated distributed database with multiple levels of remote clients
EP1079301A3 (en) Method and system for software distribution
WO2006001924A3 (en) Method and apparatus for implementing a file system
WO2004027550A3 (en) Architecture for presenting and managing information in an automated parking and storage facility
CA2227431A1 (en) Transaction log management in a disconnectable computer and network
WO2000077685A3 (en) System and method for electronic data delivery
AU2001268436A1 (en) System and method for simplifying and managing complex transactions in a distributed high-availability computer system
WO2003013155A3 (en) Method for managing a plurality of rental facilities
EP0774720A3 (en) Computer apparatus and method for merging a sequential plurality of delta streams
EP1313034A3 (en) Storage system having means for acquiring execution information of a database management system
WO2002021236A3 (en) Client-side last-element cache network architecture
WO2001009721A3 (en) A system, method and article of manufacture for providing an interface between a first server and a second server.
WO2007016412A3 (en) Revenue management system and method
EP0943997A3 (en) System and method for providing hot spare redundancy and recovery for a very large database management system
WO2005111870A3 (en) Method and system for real-time event journaling to provide enterprise data services
MY125125A (en) Method and system for ordering priority commands on a commodity disk drive
WO2004059428A3 (en) Environment integrity assured transactions
WO2003094485A3 (en) Managing power in a line powered network element
WO2002079924A3 (en) System and method for tracking a product
CA2417625A1 (en) Method and system of automating internet interactions
WO2002050685A3 (en) A system and method for ensuring data coherency for mirrored and striped disk writes
WO2005048086A3 (en) Command processing systems and methods

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP