Skip to main content
SpringerLink
Log in

A Multi-database Access System with Instance Matching

  • Conference paper
  • First Online:
Intelligent Information and Database Systems (ACIIDS 2017)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 10191))

Included in the following conference series:

Abstract

Organizations that use several separately-developed information systems face a common problem. The data which are used by different systems have no standard. Different databases that keep information of same entity instances use different representations. Attribute names are different. Attribute values are different. Even unique identifiers which are used to identify object instances are different. Yet the data need to be referred to and used by some mission-critical applications. This paper presents a multi-database instance matching system which is developed to bring data from separate sources that refer to different unique identifiers and attribute details. Entity resolution techniques are employed to match the database instances. After matched entity instances are identified, an ontology is used to keep the matched identifiers. Queries from the users then refer to the ontology and are rewritten to refer to the correct instances of the original database.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Mate, S., Köpcke, F., Toddenroth, D., Martin, M., Prokosch, HU., Bürkle, T., Ganslandt, T.: Ontology-based data integration between clinical and research systems. In: PLOS One 2015, pp. 1–20. PLOS One, San Francisco (2015)

    Google Scholar 

  2. Jung, Y., Yoon, Y.: Data integration for clinical decision support. In: 2016 8th International Conference on Ubiquitous and Future Networks (ICUFN), pp. 164–166 (2016)

    Google Scholar 

  3. Anjum, A., Bloodsworth, P., Branson, A., Hauer, T.: The requirements for ontologies in medical data integration: a case study. In: IEEE Database Engineering and Applications Symposium (IDEAS 2007), pp. 308–314 (2007)

    Google Scholar 

  4. Anjum, A., Bloodsworth, P., Branson, A., Hauer, T.: The requirements for ontologies in medical data integration: a case study. In: 11th Database Engineering and Applications Symposium 2007 (IDEAS 2007), pp. 308–314 (2007)

    Google Scholar 

  5. Liu, Z., Du, X., Ishii, N.: Integrating database in internet. In: 1998 Second International Conference on Knowledge-Based Intelligent Electronic System, pp. 381–385 (1998)

    Google Scholar 

  6. Karasneh, Y., Ibrahim, H., Othman, M., Yaakob, R.: A model for matching and integrating heterogeneous relational biomedical databases schemas. In: Proceedings of the 2009 International Database Engineering & Applications Symposium (IDEAS 2009), pp. 242–250 (2009)

    Google Scholar 

  7. Kavitha, C., Sadasivam, G.S., Shenoy, S.N.: Ontology based semantic integration of heterogeneous databases. Eur. J. Sci. Res. 64, 115–122 (2011)

    Google Scholar 

  8. Kiran, V.K., Vijayakumar, R.: Ontology based data integration of NoSQL datastores. In: 9th International Conference on Industrial and Information Systems (ICIIS), pp. 1–6 (2014)

    Google Scholar 

  9. Kantere, V.: Approximate queries on big heterogeneous data. In: Proceedings of the 2015 IEEE International Congress on Big Data, pp. 712–715 (2015)

    Google Scholar 

  10. Niang, C., Marinica, C., Leboucher, É., Bouiller, L., Capderou, C., Bouchou, B.: Ontology-based data integration system for conservation-restoration data (OBDIS-CR). In: Proceedings of the 20th International Database Engineering & Applications Symposium (IDEAS 2016), pp. 218–223 (2016)

    Google Scholar 

  11. Garg, B., Kaur, K.: Integration of heterogeneous databases. In: 2015 International Conference on Advances in Computer Engineering and Applications (ICACEA), pp. 1034–1038 (2015)

    Google Scholar 

  12. Alexiev, V., Breu, M., Bruijin, J., Fensel, D., Lara, R., Lausen, H.: Information Integration with Ontologies Experiences from an Industrail Showcase. Wiley, New Jersey (2005)

    Google Scholar 

  13. Kopcke, H., Thor, A., Rahm, E.: Evaluation of entity resolution approaches on real-world match problems. In: Conference on Very Large Databases (VLDB) Proceedings of the VLDB Endowment, pp. 484–493 (2010)

    Google Scholar 

  14. Lee, M.L., Ling, T.W.: A methodology for structural conflicts resolution in the integration of entity-relationship schema. Knowl. Inf. Syst. J. 5, 225–247 (2003)

    Article  Google Scholar 

  15. Giunchiglia, F., Shvaiko, P., Yatskevich, M.: Semantic schema matching. In: Meersman, R., Tari, Z. (eds.) OTM 2005. LNCS, vol. 3760, pp. 347–365. Springer, Heidelberg (2005). doi:10.1007/11575771_23

    Chapter  Google Scholar 

  16. Kılıç, Y.O., Aydin, M.N.: Automatic XML schema matching. Eur. Mediterr. Conf. Inf. Syst. 2009, 1–7 (2009)

    Google Scholar 

  17. Raunich, S., Rahm, E.: Towards a benchmark for ontology merging. In: Interoperability and Networking (EI2 N’2012), pp. 1–10 (2012)

    Google Scholar 

  18. Lawrence, R., Barker, K.: Integrating relational database schemas using a standardized dictionary. In: Proceedings of the 2001 ACM symposium on Applied computing (SAC 2001), pp. 225–230 (2001)

    Google Scholar 

  19. Giunchiglia, F., Yatskevich, M., Giunchiglia, E.: Efficient semantic matching. In: Gómez-Pérez, A., Euzenat, J. (eds.) ESWC 2005. LNCS, vol. 3532, pp. 272–289. Springer, Heidelberg (2005). doi:10.1007/11431053_19

    Chapter  Google Scholar 

  20. Karasneh, Y., Ibrahim, H., Othman, M., Yaakob, R.: Integrating schemas of heterogeneous relational databases through schema matching. In: Proceedings of the 11th International Conference on Information Integration and Web-based Applications & Services (WAS 2009), pp. 209–216 (2009)

    Google Scholar 

  21. He, B., Chang, K.C.: Object matching for information integration: a profiler-based approach. ACM Trans. Database Syst. 31, 1–45 (2006)

    Article  Google Scholar 

  22. Phungtua-Eng, T., Chittayasothorn, S.: Semi-automatic relational databases integration using ontology. In: The 17th World Multi-conference on Systemics, Cybernetics and Informatics, pp. 203–208 (2013)

    Google Scholar 

  23. Chao, A., Chazdon, R.L., Colwell, R.K., Shen, T.: Abundance-based similarity indices and their estimation when there are unseen species in samples. Biometrics 26, 361–371 (2006)

    Article  MathSciNet  MATH  Google Scholar 

Download references

Acknowledgement

The authors would like to express our sincere thanks to the anonymous reviewers whose constructive comments gave us an opportunity to clarify the points that we did not previously explain. Many thanks also to Dr. Pitak Thumwarin, Vice President for Human Resource Evaluation of King Mongkut’s Institute of Technology Ladkrabang Thailand, for providing the actual working datasets from the university databases.

Author information

Authors and Affiliations

  1. Faculty of Business Administration and Information Technology, Rajamangala University of Technology Tawan-Ok Chakrabongse Bhuvanarth Campus, Bangkok, 10400, Thailand

    Thanapol Phungtua-Eng

  2. Faculty of Engineering, King Mongkut’s Institute of Technology Ladkrabang, Bangkok, 10520, Thailand

    Suphamit Chittayasothorn

Authors
  1. Thanapol Phungtua-Eng
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Suphamit Chittayasothorn
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Suphamit Chittayasothorn .

Editor information

Editors and Affiliations

  1. Wrocław University of Science and Technology , Wroclaw, Poland

    Ngoc Thanh Nguyen

  2. Japan Advanced Institute of Science and Technology , Nomi, Japan

    Satoshi Tojo

  3. Japan Advanced Institute of Science and Technology , Nomi, Japan

    Le Minh Nguyen

  4. Wrocław University of Science and Technology , Wrocław, Poland

    Bogdan Trawiński

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Phungtua-Eng, T., Chittayasothorn, S. (2017). A Multi-database Access System with Instance Matching. In: Nguyen, N., Tojo, S., Nguyen, L., Trawiński, B. (eds) Intelligent Information and Database Systems. ACIIDS 2017. Lecture Notes in Computer Science(), vol 10191. Springer, Cham. https://doi.org/10.1007/978-3-319-54472-4_30

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-54472-4_30

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-54471-7

  • Online ISBN: 978-3-319-54472-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation