Article

Free access

Concurrency control and recovery of multidatabase work flows in telecommunication applications

Authors:

W. Woody Jin,

Marek Rusinkiewicz,

Linda Ness,

Amit ShethAuthors Info & Claims

SIGMOD '93: Proceedings of the 1993 ACM SIGMOD international conference on Management of data

Pages 456 - 459

https://doi.org/10.1145/170035.170133

Published: 01 June 1993 Publication History

PDF eReader

Abstract

In a research and technology application project at Bellcore, we used multidatabase transactions to model multisystem work flows of telecommunication applications. During the project a prototype scheduler for executing multi-database transactions was developed. Two of the issues addressed in this project were concurrent execution of multi-database transactions and their failure recovery. This paper discusses our use of properties of the application and the telecommunication systems to develop simple and efficient solutions to the concurrency control and recovery problems.

References

[1]

R. Alonso and H. Garcia-Molina and K. Salem, Concurrency Control and Recovery for Global Procedures in Federated Database Systems, A quarterly bulletin of the Computer Society of the IEEE technical committee on Data Engineering, Vol. 10, No. 3, September 1987.

Google Scholar

[2]

Mansoor Ansari, Marek Rusinkiewicz, LiMa Ness and Amit Sheth, Executing Multidatabase Transactions, Technical Memorandum TM-TSV-019450, July 1991.

Google Scholar

[3]

Mansoor Ansari, Linda Ness, Marek Rusinkiewicz, and Amit Sheth, Using Flexible Transactions to Support Multi-system Telecommunication Applications, Proceedings of the 18th VLDB Conference, Vancouver, British Columbia, Canada 1992.

Digital Library

Google Scholar

[4]

Y. Breitbart, D. Georgakopoulos, M. Rusinkiewicz, and A. Silberschatz. On Rigorous Transaction Scheduling, IEEE Transactions on Software Engineering, 17, September 1991.

Digital Library

Google Scholar

[5]

Yuri Breitbart, Hector Garcia-Molina and Avi Silberschatz, Overview of Multidatabase Transaction Management, Tech Report No. STAN-CS-92-1432, Stanford University, 1992.

Digital Library

Google Scholar

[6]

Y. Breitbart and A. Silberschatz, Multidatabase Update Issues, ProceeAings of ACM SIGMOD International Conference on Management of Data, June, 1988.

Digital Library

Google Scholar

[7]

A. Elmagarmid, Y. Leu, W. Litwin, and M. Rusinkiewicz A Multidatabase Transaction Model for lnterbase, ProceeAings of the 16th VLDB, August 1990.

Digital Library

Google Scholar

[8]

J.N. Gray, The Transaction Concept Virtues and Limitations, Proceedings of 7th International Conference on VLDB, September 1981.

Google Scholar

[9]

K. Salem and H. Garcia-Molina, Altruistic Locking: A strategy for coping with long-lived transactions, Procee.Aings of the 2nd International Workshop on High Performanco Transaction Systems (September 1991), Amdalai Corporation, IBM Corporation.

Digital Library

Google Scholar

[10]

M. Rusinkiewicz, A. Elmagarmid, Y. Leu, and W. Litwin, Extending the Transaction Model to Capture More Meaning, SIGMOD Record, March 1990.

Digital Library

Google Scholar

Cited By

View all

Antunes PMourão H(2011)Resilient Business Process ManagementExpert Systems with Applications: An International Journal10.1016/j.eswa.2010.05.01738:2(1241-1254)Online publication date: 1-Feb-2011
https://dl.acm.org/doi/10.1016/j.eswa.2010.05.017
Gaaloul WGaaloul KBhiri SHaller AHauswirth M(2009)Log-based transactional workflow miningDistributed and Parallel Databases10.1007/s10619-009-7040-025:3(193-240)Online publication date: 1-Jun-2009
https://dl.acm.org/doi/10.1007/s10619-009-7040-0
Gaaloul WBhiri SHaller A(2007)Mining and re-engineering transactional workflows for reliable executionsProceedings of the 26th international conference on Conceptual modeling10.5555/1784489.1784532(485-501)Online publication date: 5-Nov-2007
https://dl.acm.org/doi/10.5555/1784489.1784532
Show More Cited By

Index Terms

Concurrency control and recovery of multidatabase work flows in telecommunication applications

Recommendations

Concurrency control and recovery of multidatabase work flows in telecommunication applications

In a research and technology application project at Bellcore, we used multidatabase transactions to model multisystem work flows of telecommunication applications. During the project a prototype scheduler for executing multi-database transactions was ...
Semantics-based concurrency control: beyond commutativity

The concurrency of transactions executing on atomic data types can be enhanced through the use of semantic information about operations defined on these types. Hitherto, commutativity of operations has been exploited to provide enchanced concurrency ...
A theory of global concurrency control in multidatabase systems
Parallelism in database systems

This article presents a theoretical basis for global concurrency control to maintain global serializability in multidatabase systems. Three correctness criteria are formulated that utilize the intrinsic characteristics of global transactions to ...

Comments

Information & Contributors

Information

Published In

SIGMOD '93: Proceedings of the 1993 ACM SIGMOD international conference on Management of data

June 1993

566 pages

ISBN:0897915925

DOI:10.1145/170035

Editors:
Peter Buneman
Univ. of Pennsylvania
,
Sushil Jajodia

ACM SIGMOD Record Volume 22, Issue 2
June 1, 1993
558 pages
ISSN:0163-5808
DOI:10.1145/170036
Editors:
Peter Buneman
Univ. of Pennsylvania
,
Sushil Jajodia,
Won Kim
UniSQL, Inc., Austin, TX
Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1993

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGMOD/PODS93

Sponsor:

SIGMOD/PODS93: Joint ACM SIGMOD International Conference on Management of Data and ACM SIGMOD

May 25 - 28, 1993

D.C., Washington, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

11
Total Citations
View Citations
326
Total Downloads

Downloads (Last 12 months)25
Downloads (Last 6 weeks)9

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Antunes PMourão H(2011)Resilient Business Process ManagementExpert Systems with Applications: An International Journal10.1016/j.eswa.2010.05.01738:2(1241-1254)Online publication date: 1-Feb-2011
https://dl.acm.org/doi/10.1016/j.eswa.2010.05.017
Gaaloul WGaaloul KBhiri SHaller AHauswirth M(2009)Log-based transactional workflow miningDistributed and Parallel Databases10.1007/s10619-009-7040-025:3(193-240)Online publication date: 1-Jun-2009
https://dl.acm.org/doi/10.1007/s10619-009-7040-0
Gaaloul WBhiri SHaller A(2007)Mining and re-engineering transactional workflows for reliable executionsProceedings of the 26th international conference on Conceptual modeling10.5555/1784489.1784532(485-501)Online publication date: 5-Nov-2007
https://dl.acm.org/doi/10.5555/1784489.1784532
Gaaloul WBhiri SHaller A(2007)Mining and Re-engineering Transactional Workflows for Reliable ExecutionsConceptual Modeling - ER 200710.1007/978-3-540-75563-0_33(485-501)Online publication date: 2007
https://doi.org/10.1007/978-3-540-75563-0_33
Gaaloul WGodart C(2005)Mining workflow recovery from event based logsProceedings of the 3rd international conference on Business Process Management10.1007/11538394_12(169-185)Online publication date: 5-Sep-2005
https://dl.acm.org/doi/10.1007/11538394_12
Miller JSheth AKochut K(1999)Perspectives in ModelingSelected Papers from the Symposium on Conceptual Modeling, Current Issues and Future Directions10.5555/647528.726249(154-167)Online publication date: 1-Jan-1999
https://dl.acm.org/doi/10.5555/647528.726249
Miller JSheth AKochut K(1999)Perspectives in Modeling: Simulation, Database, and WorkflowConceptual Modeling10.1007/3-540-48854-5_13(154-167)Online publication date: 30-Apr-1999
https://doi.org/10.1007/3-540-48854-5_13
Ben-Shaul IKaiser G(1998)Federating Process-Centered EnvironmentsAutomated Software Engineering10.1023/A:10086104262075:1(97-132)Online publication date: 1-Jan-1998
https://dl.acm.org/doi/10.1023/A%3A1008610426207
Sheth AKochut KMiller JWorah DDas SLin CPalaniswami DLynch JShevchenko I(1996)Supporting State-Wide Immunisation Tracking Using Multi-Paradigm Workflow TechnologyProceedings of the 22th International Conference on Very Large Data Bases10.5555/645922.673468(263-273)Online publication date: 3-Sep-1996
https://dl.acm.org/doi/10.5555/645922.673468
Eder JLiebhart W(1996)Workflow recoveryProceedings First IFCIS International Conference on Cooperative Information Systems10.1109/COOPIS.1996.555004(124-134)Online publication date: 1996
https://doi.org/10.1109/COOPIS.1996.555004
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Concurrency control and recovery of multidatabase work flows in telecommunication applications

Semantics-based concurrency control: beyond commutativity

A theory of global concurrency control in multidatabase systems