User-Centric Data Integration with the MappingAssistant

  • Heiner Stuckenschmidt
  • Jan Noessner
  • Faraz Fallahi
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 141)


Data integration is the problem of transferring complex data from one into another representation in order to support exchange between different systems. From a technical point of view data integration has intensively been studied. However, less attention has been paid to user-centric aspects of data integration. In this work, we present the MappingAssistant which supports the user in finding and validating mapping rules between heterogeneous data sources. Compared to existing approaches we focus on an user-centric approach where the user inspects the consequences of the data integration rules on the instance level rather than being confronted with complex data integration rules. We performed a study which shows that the user-centric approach leads to better integration results, especially for users with little or no technical knowledge and is perceived as being more intuitive.


Data integration User study Software tools Usability 


  1. 1.
    Halevy, A., Rajaraman, A., Ordille, J.: Data integration: The teenage years. In: Proceedings of the 32nd International Conference on Very Large Data Bases, VLDB Endowment, pp. 9–16 (2006)Google Scholar
  2. 2.
    Euzenat, J., Shvaiko, P.: Ontology Matching. Springer, New York (2007)Google Scholar
  3. 3.
    Bellahsene, Z., Bonifati, A., Rahm, E.: Schema matching and mapping. Int. J. Comput. Appl. 34(8), 14–21 (2011)Google Scholar
  4. 4.
    von Alan, R., March, S., Park, J., Ram, S.: Design science in information systems research. Mis Q. 28, 75–105 (2004)Google Scholar
  5. 5.
    Noessner, J., Fallahi, F., Kiss, E., Stuckenschmidt, H.: Interactive data integration with mappingassistant. Demo Paper at the 10th International Semantic Web Conference ISWC (2011)Google Scholar
  6. 6.
    Fallahi, F., Noessner, J., Kiss, E., Stuckenschmidt, H.: Mappingassistant: Interactive conflict-resolution for data integration. Poster at the 8th Extended Semantic Web Conference, ESWC (2011)Google Scholar
  7. 7.
    Teevan, J., Jones, W., Gwizdka, J.: Personal information management. Commun. ACM 49, 68–73 (2006)CrossRefGoogle Scholar
  8. 8.
    Gass, O., Maedche, A.: Enabling end-user-driven data interoperability - a design science research project. In: Proceedings of the 17th Americas Conference on Information Systems (AMCIS 2011), Detroit, USA (2011)Google Scholar
  9. 9.
    Falconer, S., Noy, N.: Interactive techniques to support ontology matching. Schema Matching Mapp. 9, 29–51 (2011)CrossRefGoogle Scholar
  10. 10.
    Falconer, S.: Cognitive support for semi-automatic ontology mapping. Ph.D. thesis, University of Victoria (2009)Google Scholar
  11. 11.
    Falconer, S.M., Storey, M.A.: A cognitive support framework for ontology mapping. In: Aberer, K., et al. (eds.) ASWC 2007 and ISWC 2007. LNCS, vol. 4825, pp. 114–127. Springer, Heidelberg (2007)Google Scholar
  12. 12.
    Granitzer, M., Sabol, V., Onn, K.W., Lukose, D., Tochtermann, K.: Ontology alignment - a survey with focus on visually supported semi-automatic techniques. Future Internet 2, 238–258 (2010)CrossRefGoogle Scholar
  13. 13.
    Euzenat, J., Ferrara, A., Hollink, L., Isaac, A., Joslyn, C., Malaisé, V., Meilicke, C., Nikolov, A., Pane, J., Sabou, M., et al.: Results of the ontology alignment evaluation initiative 2010 (2010)Google Scholar
  14. 14.
    Cruz, I., Antonelli, F., Stroe, C.: Agreementmaker: efficient matching for large real-world schemas and ontologies. Proc. VLDB Endowment 2(2), 1586–1589 (2009)Google Scholar
  15. 15.
    Hair Jr., J., Anderson, R., Tatham, R., Black, W.: Multivariate data analysis (1995)Google Scholar
  16. 16.
    Maier, A., Schnurr, H.-P., Sure, Y., et al.: Ontology-based information integration in the automotive industry. In: Fensel, D., Mylopoulos, J. (eds.) ISWC 2003. LNCS, vol. 2870, pp. 897–912. Springer, Heidelberg (2003)Google Scholar
  17. 17.
    Wohlin, C.: Experimentation in software engineering: an introduction. Springer, Heidelberg (2000)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Heiner Stuckenschmidt
    • 1
    • 2
  • Jan Noessner
    • 1
  • Faraz Fallahi
    • 3
  1. 1.School of Business Informatics and MathematicsUniversity of MannheimMannheimGermany
  2. 2.Institute for Enterprise Systems (InES)MannheimGermany
  3. 3.Ontoprise GmbHKarlsruheGermany

Personalised recommendations