Abstract
This paper describes the AutoMed repository and some associated tools, which provide the first implementation of the both as view (BAV) approach to data integration. Apart from being a highly expressive data integration approach, BAV in additional provides a method to support a wide range of data modelling languages, and describes transformations between those data modelling languages. This paper documents how BAV has been implemented in the AutoMed repository, and how several practical problems in data integration between heterogeneous data sources have been solved. We illustrate the implementation with examples in the relational, ER, and semi-structured data models.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Boyd, M., McBrien, P.J.: Towards a semi-automated approach to intermodel transformations. Technical Report No. 29, AutoMed (2004)
Cluet, S., Delobel, C., Siméon, J., Smaga, K.: Your mediators need data conversion! SIGMOD Record 27(2), 177–188 (1998)
Doan, A., Madhavan, J., Domingos, P., Halevy, A.: Learning to map ontologies on the Semantic Web. In: Proceedings of the World-Wide Web Conference (WWW 2002), pp. 662–673 (2002)
Fan, H., Poulovassilis, A.: Using AutoMed metadata in data warehousing environments. In: Proc. DOLAP 2003, New Orleans, pp. 86–93 (2003)
Jasper, E., Poulovassilis, A., Zamboulis, L.: Processing IQL queries and migrating data in the AutoMed toolkit. Technical Report No. 20, AutoMed (2003)
Kashyap, V., Sheth, A.: Semantic and schematic similarities between database objects: a context-based approach. VLDB Journal 5(4), 276–304 (1996)
Larson, J.A., Navathe, S.B., Elmasri, R.: A theory of attribute equivalence in databases with application to schema integration. IEEE Transactions on Software Engineering 15(4), 449–463 (1989)
Lazanitis, C.: Template transformations in AutoMed. Technical Report 25, AutoMed (2004)
Lenzerini, M.: Data integration: A theoretical perspective. In: Proc. PODS 2002, pp. 233–246. ACM, New York (2002)
Li, W.-S., Clifton, C.: SEMINT: A tool for identifying attribute correspondences in heterogeneous databases using neural networks. Data and Knowledge Engineering 33, 49–84 (2000)
Xu, L., Embley, D.W.: Discovering direct and indirect matches for schema elements. In: 8th International Conference on Database Systems for Advanced Applications (DASFAA 2003), Kyoto, Japan, March 26–28, pp. 39–46 (2003)
Madhavan, J., Bernstein, P.A., Rahm, E.: Generic schema matching with Cupid. In: Proc. 27th VLDB Conference, pp. 49–58 (2001)
Madhavan, J., Halevy, A.Y.: Composing mappings among data sources. In: Proc. VLDB 2003, pp. 572–583 (2003)
McBrien, P.J., Poulovassilis, A.: A formalisation of semantic schema integration. Information Systems 23(5), 307–334 (1998)
McBrien, P.J., Poulovassilis, A.: A uniform approach to inter-model transformations. In: Jarke, M., Oberweis, A. (eds.) CAiSE 1999. LNCS, vol. 1626, pp. 333–348. Springer, Heidelberg (1999)
McBrien, P.J., Poulovassilis, A.: Schema evolution in heterogeneous database architectures, a schema transformation approach. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 484–499. Springer, Heidelberg (2002)
McBrien, P.J., Poulovassilis, A.: Data integration by bi-directional schema transformation rules. In: Proc. ICDE 2003, IEEE, Los Alamitos (2003)
McBrien, P.J., Poulovassilis, A.: Defining peer-to-peer data integration using both as view rules. In: Proc. DBISP2P, at VLDB 2003, Berlin, Germany (2003)
Poulovassilis, A., McBrien, P.J.: A general formal framework for schema transformation. Data and Knowledge Engineering 28(1), 47–71 (1998)
Rizopoulos, N.: BAV transformations on relational schemas based on semantic relationships between attributes. Technical Report 22, AutoMed (2003)
Rizopoulos, N.: Automatic discovery of semantic relationships between schema elements. In: Proc. of 6th ICEIS (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Boyd, M., Kittivoravitkul, S., Lazanitis, C., McBrien, P., Rizopoulos, N. (2004). AutoMed: A BAV Data Integration System for Heterogeneous Data Sources. In: Persson, A., Stirna, J. (eds) Advanced Information Systems Engineering. CAiSE 2004. Lecture Notes in Computer Science, vol 3084. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-25975-6_8
Download citation
DOI: https://doi.org/10.1007/978-3-540-25975-6_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22151-7
Online ISBN: 978-3-540-25975-6
eBook Packages: Springer Book Archive