EDEX: Entity Preserving Data Exchange

Yoones A. Sekhavat, Jeffrey Parsons

Abstract

Data Exchange creates an instance of a target schema from an instance of a source such that source data is reflected in the target instance. The prevailing approach for data exchange is based on generating and using schema mapping expressions representing high level relations between source and target. We show such class level schema mappings cannot resolve some ambiguous cases. We propose an Entity Preserving Data Exchange (EDEX) method that reflects source entities in the target independent of classification of entities. We show EDEX can reconcile such ambiguities while generates a core solution as an efficient solution.

References

  1. Alexe, B., Chiticariu, L., Miller, R. J., & Tan, W., 2008. Muse: Mapping understanding and design by example. In ICDE'08, IEEE International Conference on Data Engineering.
  2. Alexe, B., ten Cate, B., Kolaitis, P. G., & Tan, W., 2011. Eirene: Interactive design and refinement of schema mappings via data examples. VLDB Endowment.
  3. Bonifati, A., Mecca, G., Papotti, P., & Velegrakis, Y., 2011. Discovery and correctness of schema mapping transformations. Schema Matching and Mapping.
  4. Bonifati, A., Chang, E. Q., Lakshmanan, A. V. S., Ho, T., & Pottinger, R., 2005. HePToX: Marrying XML and heterogeneity in your P2P databases. In VLDB'05, International Conference on Very Large Data Bases.
  5. Bunge, M., 1977. Treatise on basic philosophy: Vol. 3: Ontology I: The furniture of the world.
  6. Chen, P. P., 1976. The entity-relationship model-toward a unified view of data. ACM Transactions on Database Systems.
  7. Fagin, R., Haas, L. M., Hernández, M., Miller, R. J., Popa, L., & Velegrakis, Y., 2009. Clio: Schema mapping creation and data exchange. Conceptual Modeling: Foundations and Applications.
  8. Fagin, R., Kolaitis, P. G., & Popa, L., 2005. Data exchange: Getting to the core. ACM Transactions on Database Systems.
  9. Gottlob, G., & Nash, A., 2008. Efficient core computation in data exchange. Journal of the ACM.
  10. Haas, L. M., Hentschel, M., Kossmann, D., & Miller, R. J., 2009. Schema and data: A holistic approach to mapping, resolution and fusion in information integration. In ER'09, International Conference on Conceptual Modeling.
  11. Marnette, B., Mecca, G., Papotti, P., Raunich, S., & Santoro, D., 2011. ++Spicy: An open-source tool for second-generation schema mapping and data exchange. In VLDB'11, International Conference on Very Large Data Bases.
  12. Parsons, J., & Wand, Y., 2000. Emancipating instances from the tyranny of classes in information modeling. ACM Transactions on Database Systems.
  13. Popa, L., Velegrakis, Y., Hernández, M. A., Miller, R. J., & Fagin, R., 2002. Translating web data. In VLDB'02, International Conference on Very Large Data Bases.
  14. Qian, L., Cafarella, M. J., & Jagadish, H., 2012. Sampledriven schema mapping. In SIDMOD'12, International Conference on Management of Data.
  15. Sekhavat, Y. A., & Parsons, J., 2013. SESM: Semantic enrichment of schema mappings. In DESWEB'13, Data Engineering Meets the Semantic Web.
  16. Talburt, J. R., 2011. Entity resolution and information quality Morgan Kaufmann.
Download


Paper Citation


in Harvard Style

Sekhavat Y. and Parsons J. (2013). EDEX: Entity Preserving Data Exchange . In Proceedings of the 2nd International Conference on Data Technologies and Applications - Volume 1: DATA, ISBN 978-989-8565-67-9, pages 221-229. DOI: 10.5220/0004433902210229


in Bibtex Style

@conference{data13,
author={Yoones A. Sekhavat and Jeffrey Parsons},
title={EDEX: Entity Preserving Data Exchange},
booktitle={Proceedings of the 2nd International Conference on Data Technologies and Applications - Volume 1: DATA,},
year={2013},
pages={221-229},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004433902210229},
isbn={978-989-8565-67-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 2nd International Conference on Data Technologies and Applications - Volume 1: DATA,
TI - EDEX: Entity Preserving Data Exchange
SN - 978-989-8565-67-9
AU - Sekhavat Y.
AU - Parsons J.
PY - 2013
SP - 221
EP - 229
DO - 10.5220/0004433902210229