ODDI - A Framework for Semi-automatic Data Integration

Paolo Ceravolo, Ernesto Damiani, Marcello Leida, Zhan Cui, Alex Gusmini

2008

Abstract

Recent works on Business Intelligence do highlight the need of on-time, trustable and sound data access systems. Moreover the application of these systems in a flexible and dynamic environment requires for an approach based on automatic procedures that can provide reliable results. A crucial factor for any automatic data integration system is the matching process. Different categories of matching operators carry different semantics. For this reason combining them in a single algorithm is a non trivial process that have to take into account a variety of options. This paper proposes a solution based on a categorization of matching operators that allow to group similar attributes on a semantic rich form. This way we define all the information need in order to create a mapping. Then Mapping Generation is activated only on those set of elements that can be queried without violating any integrity constraints on data.

References

  1. Abiteboul, S. and Duschka, O. M. (1998). Complexity of answering queries using materialized views. pages 254-263.
  2. Braun, P., Lötzbeyer, H., Schätz, B., and Slotosch, O. (2000). Consistent integration of formal methods. In TACAS 7800: Proceedings of the 6th International Conference on Tools and Algorithms for Construction and Analysis of Systems, pages 48-62, London, UK. Springer-Verlag.
  3. Calvanese, D., Lenzerini, M., and Nardi, D. (1998). Description logics for conceptual data modeling. In Logics for Databases and Information Systems, pages 229-263.
  4. Cui, Z., Damiani, E., and Leida, M. (2007). Benefits of ontologies in real time data access. In Digital EcoSystems and Technologies Conference, 2007. DEST 7807. Inaugural IEEE-IES , vol., no., pp.392-397, 21-23 Feb. 2007.
  5. Duschka, O. M., Genesereth, M. R., and Levy, A. Y. (2000). Recursive query plans for data integration. Journal of Logic Programming, 43(1):49-73.
  6. Euzenat, J. and Shvaiko, P. (2007). Ontology matching. Springer-Verlag, Heidelberg (DE).
  7. Ganter, B., Stumme, G., and Wille, R., editors (2005). Formal Concept Analysis, Foundations and Applications, volume 3626 of Lecture Notes in Computer Science. Springer.
  8. Grahne, G. and Mendelzon, A. O. (1999). Tableau techniques for querying information sources through global schemas. Lecture Notes in Computer Science, 1540:332-347.
  9. Hakimpour, F. and Geppert, A. (2002). Global schema generation using formal ontologies.
  10. Halevy, A. Y. (2001). Answering queries using views: A survey. VLDB Journal: Very Large Data Bases, 10(4):270-294.
  11. Hammer, J., Garcia-Molina, H., Widom, J., Labio, W., and Zhuge, Y. (1995). The stanford data warehousing project. IEEE Quarterly Bulletin on Data Engineering; Special Issue on Materialized Views and Data Warehousing, 18(2):41-48.
  12. Lenzerini, M. (2002). Data integration: a theoretical perspective. In PODS 7802: Proceedings of the twentyfirst ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, pages 233-246, New York, NY, USA. ACM Press.
  13. Parent, C. and Spaccapietra, S. (1998). Issues and approaches of database integration. Commun. ACM, 41(5es):166-178.
  14. Rahm, E. and Bernstein, P. A. (2001). A survey of approaches to automatic schema matching. VLDB Journal: Very Large Data Bases, 10(4):334-350.
  15. Yager, R. R. (1988). On ordered weighted averaging aggregation operators in multicriteria decisionmaking. IEEE Trans. Syst. Man Cybern., 18(1):183-190.
Download


Paper Citation


in Harvard Style

Ceravolo P., Damiani E., Leida M., Cui Z. and Gusmini A. (2008). ODDI - A Framework for Semi-automatic Data Integration . In Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8111-36-4, pages 15-24. DOI: 10.5220/0001678000150024


in Bibtex Style

@conference{iceis08,
author={Paolo Ceravolo and Ernesto Damiani and Marcello Leida and Zhan Cui and Alex Gusmini},
title={ODDI - A Framework for Semi-automatic Data Integration},
booktitle={Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2008},
pages={15-24},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001678000150024},
isbn={978-989-8111-36-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ODDI - A Framework for Semi-automatic Data Integration
SN - 978-989-8111-36-4
AU - Ceravolo P.
AU - Damiani E.
AU - Leida M.
AU - Cui Z.
AU - Gusmini A.
PY - 2008
SP - 15
EP - 24
DO - 10.5220/0001678000150024