research-article

Cooperative update exchange in the Youtopia system

Authors:

Christoph KochAuthors Info & Claims

Proceedings of the VLDB Endowment, Volume 2, Issue 1

Pages 193 - 204

https://doi.org/10.14778/1687627.1687650

Published: 01 August 2009 Publication History

Abstract

Youtopia is a platform for collaborative management and integration of relational data. At the heart of Youtopia is an update exchange abstraction: changes to the data propagate through the system to satisfy user-specified mappings. We present a novel change propagation model that combines a deterministic chase with human intervention. The process is fundamentally cooperative and gives users significant control over how mappings are repaired. An additional advantage of our model is that mapping cycles can be permitted without compromising correctness.

We investigate potential harmful interference between updates in our model; we introduce two appropriate notions of serializability that avoid such interference if enforced. The first is very general and related to classical final-state serializability; the second is more restrictive but highly practical and related to conflict-serializability. We present an algorithm to enforce the latter notion. Our algorithm is an optimistic one, and as such may sometimes require updates to be aborted. We develop techniques for reducing the number of aborts and we test these experimentally.

References

[1]

Birn. http://www.nbirn.net.

[2]

Geon. http://www.geongrid.org.

[3]

Ravelry. http://www.ravelry.com.

[4]

A. V. Aho, Y. Sagiv, and J. D. Ullman. Efficient optimization of a class of relational expressions. ACM Trans. Database Syst., 4(4):435--454, 1979.

Digital Library

[5]

A. Calì, G. Gottlob, and M. Kifer. Taming the infinite chase: Query answering under expressive relational constraints. In KR, pages 70--80, 2008.

[6]

D. Calvanese, G. D. Giacomo, M. Lenzerini, and R. Rosati. Logical foundations of peer-to-peer data integration. In PODS, pages 241--251, 2004.

Digital Library

[7]

A. Deutsch, A. Nash, and J. B. Remmel. The chase revisited. In PODS, pages 149--158, 2008.

Digital Library

[8]

A. Deutsch, L. Popa, and V. Tannen. Physical data independence, constraints, and optimization with universal plans. In VLDB, pages 459--470, 1999.

Digital Library

[9]

A. Doan, R. Ramakrishnan, F. Chen, P. DeRose, Y. Lee, R. McCann, M. Sayyadian, and W. Shen. Community information management. IEEE Data Eng. Bull., 29(1):64--72, 2006.

[10]

K. P. Eswaran, J. Gray, R. A. Lorie, and I. L. Traiger. The notions of consistency and predicate locks in a database system. Commun. ACM, 19(11):624--633, 1976.

Digital Library

[11]

R. Fagin, P. G. Kolaitis, R. J. Miller, and L. Popa. Data exchange: semantics and query answering. Theor. Comput. Sci., 336(1):89--124, 2005.

Digital Library

[12]

C. Forbes. Ravelry unresolved issue 1481, other fiber arts. http://www.ravelry.com/issues/1481.

[13]

E. Franconi, G. Kuper, A. Lopatenko, and L. Serafini. A robust logical and computational characterisation of peer-to-peer database systems. In DBISP2P, pages 64--76, 2003.

[14]

A. Fuxman, P. G. Kolaitis, R. J. Miller, and W. C. Tan. Peer data exchange. ACM Trans. Database Syst., 31(4):1454--1498, 2006.

Digital Library

[15]

T. J. Green, G. Karvounarakis, Z. G. Ives, and V. Tannen. Update exchange with mappings and provenance. In VLDB, pages 675--686, 2007.

Digital Library

[16]

A. Y. Halevy, M. J. Franklin, and D. Maier. Principles of dataspace systems. In PODS, pages 1--9, 2006.

Digital Library

[17]

A. Y. Halevy, Z. G. Ives, D. Suciu, and I. Tatarinov. Schema mediation for large-scale semantic data sharing. VLDB J., 14(1):68--83, 2005.

Digital Library

[18]

J. R. Jordan, J. Banerjee, and R. B. Batman. Precision locks. In SIGMOD, pages 143--147, 1981.

Digital Library

[19]

Y. Katsis, A. Deutsch, and Y. Papakonstantinou. Interactive source registration in community-oriented information integration. In VLDB, 2008.

Digital Library

[20]

N. Khoussainova, M. Balazinska, W. Gatterbauer, Y. Kwon, and D. Suciu. A case for a collaborative query management system. In CIDR, 2009.

[21]

C. Koch. Query rewriting with symmetric constraints. AI Commun., 17(2):41--55, 2004.

Digital Library

[22]

J. Madhavan and A. Y. Halevy. Composing mappings among data sources. In VLDB, pages 572--583, 2003.

Digital Library

[23]

D. Maier, A. O. Mendelzon, and Y. Sagiv. Testing implications of data dependencies. ACM Trans. Database Syst., 4(4):455--469, 1979.

Digital Library

[24]

R. McCann, A. Kramnik, W. Shen, V. Varadarajan, O. Sobulo, and A. Doan. Integrating data from disparate sources: A mass collaboration approach. In ICDE, pages 487--488, 2005.

Digital Library

[25]

P. Rodríguez-Gianolli, M. Garzetti, L. Jiang, A. Kementsietsidis, I. Kiringa, M. Masud, R. J. Miller, and J. Mylopoulos. Data sharing in the Hyperion peer database system. In VLDB, pages 1291--1294, 2005.

Digital Library

[26]

A. D. Sarma, X. Dong, and A. Y. Halevy. Bootstrapping pay-as-you-go data integration systems. In SIGMOD, pages 861--874, 2008.

Digital Library

[27]

N. E. Taylor and Z. G. Ives. Reconciling while tolerating disagreement in collaborative data sharing. In SIGMOD, pages 13--24, 2006.

Digital Library

[28]

G. Weikum and G. Vossen. Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery. Morgan Kaufmann, 2002.

Digital Library

[29]

L.-L. Yan, R. J. Miller, L. M. Haas, and R. Fagin. Data-driven understanding and refinement of schema mappings. In SIGMOD, pages 485--496, 2001.

Digital Library

Cited By

Lawrence MPottinger RStaub-French S(2020)Data coordinationProceedings of the VLDB Endowment10.14778/3402707.34027224:11(831-842)Online publication date: 3-Jun-2020
https://dl.acm.org/doi/10.14778/3402707.3402722
Gatterbauer WGünnemann SKoutra DFaloutsos C(2015)Linearized and single-pass belief propagationProceedings of the VLDB Endowment10.14778/2735479.27354908:5(581-592)Online publication date: 1-Jan-2015
https://dl.acm.org/doi/10.14778/2735479.2735490
Khazalah FMalik ZRezgui A(2015)Automated conflict resolution in collaborative data sharing systems using community feedbacksInformation Sciences: an International Journal10.1016/j.ins.2014.11.029298:C(407-424)Online publication date: 20-Mar-2015
https://dl.acm.org/doi/10.1016/j.ins.2014.11.029
Show More Cited By

Index Terms

Cooperative update exchange in the Youtopia system
1. Information systems
  1. Data management systems
  2. Information systems applications

Recommendations

Safety of Deferred Update in Transactional Memory
ICDCS '13: Proceedings of the 2013 IEEE 33rd International Conference on Distributed Computing Systems

Transactional memory allows the user to declare sequences of instructions as speculative transactions that can either commit or abort. If a transaction commits, it appears to be executed sequentially, so that the committed transactions constitute a ...
Cooperative transaction hierarchies: transaction support for design applications

Traditional atomic and nested transactions are not always well-suited to cooperative applications, such as design applications. Cooperative applications place requirements on the database that may conflict with the serializability requirement. They ...
Multidatabase update issues
SIGMOD '88: Proceedings of the 1988 ACM SIGMOD international conference on Management of data

A formal model of data updates in a multidatabase environment is developed, and a theory of concurrency control in such an environment is presented. We formulate a correctness condition for the concurrency control mechanism and propose a protocol that ...

Comments

Information & Contributors

Information

Published In

cover image Proceedings of the VLDB Endowment

Proceedings of the VLDB Endowment Volume 2, Issue 1

August 2009

1293 pages

ISSN:2150-8097

Issue’s Table of Contents

Publisher

VLDB Endowment

Publication History

Published: 01 August 2009

Published in PVLDB Volume 2, Issue 1

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

10
Total Citations
View Citations
97
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 05 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Lawrence MPottinger RStaub-French S(2020)Data coordinationProceedings of the VLDB Endowment10.14778/3402707.34027224:11(831-842)Online publication date: 3-Jun-2020
https://dl.acm.org/doi/10.14778/3402707.3402722
Gatterbauer WGünnemann SKoutra DFaloutsos C(2015)Linearized and single-pass belief propagationProceedings of the VLDB Endowment10.14778/2735479.27354908:5(581-592)Online publication date: 1-Jan-2015
https://dl.acm.org/doi/10.14778/2735479.2735490
Khazalah FMalik ZRezgui A(2015)Automated conflict resolution in collaborative data sharing systems using community feedbacksInformation Sciences: an International Journal10.1016/j.ins.2014.11.029298:C(407-424)Online publication date: 20-Mar-2015
https://dl.acm.org/doi/10.1016/j.ins.2014.11.029
Serrano ODandurand LBrown SAhn GSander T(2014)On the Design of a Cyber Security Data Sharing SystemProceedings of the 2014 ACM Workshop on Information Sharing & Collaborative Security10.1145/2663876.2663882(61-69)Online publication date: 3-Nov-2014
https://dl.acm.org/doi/10.1145/2663876.2663882
Karvounarakis GGreen TIves ZTannen V(2013)Collaborative data sharing via update exchange and provenanceACM Transactions on Database Systems10.1145/250012738:3(1-42)Online publication date: 5-Sep-2013
https://dl.acm.org/doi/10.1145/2500127
Belhajjame KPaton NEmbury SFernandes AHedeler C(2013)Incrementally improving dataspaces based on user feedbackInformation Systems10.1016/j.is.2013.01.00638:5(656-687)Online publication date: 1-Jul-2013
https://dl.acm.org/doi/10.1016/j.is.2013.01.006
Hegner S(2011)A Simple Model of Negotiation for Cooperative Updates on Database Schema ComponentsProceedings of the 2011 conference on Information Modelling and Knowledge Bases XXII10.5555/1972754.1972764(154-173)Online publication date: 14-Aug-2011
https://dl.acm.org/doi/10.5555/1972754.1972764
Pichler RSkritek SMilo T(2011)The complexity of evaluating tuple generating dependenciesProceedings of the 14th International Conference on Database Theory10.1145/1938551.1938583(244-255)Online publication date: 21-Mar-2011
https://dl.acm.org/doi/10.1145/1938551.1938583
Karvounarakis GIves ZTannen VElmagarmid AAgrawal D(2010)Querying data provenanceProceedings of the 2010 ACM SIGMOD International Conference on Management of data10.1145/1807167.1807269(951-962)Online publication date: 6-Jun-2010
https://dl.acm.org/doi/10.1145/1807167.1807269
Gatterbauer WSuciu DElmagarmid AAgrawal D(2010)Data conflict resolution using trust mappingsProceedings of the 2010 ACM SIGMOD International Conference on Management of data10.1145/1807167.1807193(219-230)Online publication date: 6-Jun-2010
https://dl.acm.org/doi/10.1145/1807167.1807193

View Options

Login options

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

Full Access

Get this Article

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Issue’s Table of Contents