International Journal of Applied Science and Engineering
Published by Chaoyang University of Technology

Edhy Sutanta1*, Erna Kumalasari Nurnawati1, Catur Iswahyudi1, Rosalia Arum Kumalasanti2

1 Department of Informatics, Institut Sains & Teknologi AKPRIND Yogyakarta 28 Kalisahak Road, Yogyakarta, 55222, Indonesia

2 Department of Informatics, Sanata Dharma University Yogyakarta, Paingan Road, Sleman, Yogyakarta, 55282, Indonesia

 

Download Citation: |
Download PDF


ABSTRACT

The problem of alignment of the scheme is that the process that cannot be thoroughly performed automatically is the similarity of the results of the element output map scheme alignment that the user still needs to correct to obtain a valid end result. The correction process which is carried out at the stage of verification and evaluation can only be done manually by the user. In this research, a modification of the hybrid schema matching model was proposed that previously develop by adding three new features, namely the use of a similarity value limit (SVL), checking the inter-attribute similarity of the input database, and selecting the appropriate database to act as a DBSource during the matching process. Every new feature is tested using a relational database model (RDBM). Compare the yields of the original model and the modified model to determine the reduction in output of the user-performed model validation process. The test result shows that the addition of new features succeeded in minimizing the user verification process.


Keywords: Hybrid schema matching, Modified model, User verification.


Share this article with your colleagues

 


REFERENCES

  1. Banek, M., Vrdoljak, B., Tjoa, A.M., Skočir, Z. 2008. Automated integration of heterogeneous data warehouse schemas. The International Journal of Data Warehousing and Mining, 4, 1–21.

  2. Bergamaschi, S., Castano, S., Vincini, M. 1999. Semantic integration of semistructured and structured data sources. SIGMOD Record, 28, 54–59.

  3. Bernstein, P.A. 2003. Applying model management to classical meta data problems. In CIDR, 2003, 209–220.

  4. Bernstein, P.A., Harry, B., Sanders, P., Shutt, D., Zander, J. 1997. The microsoft repository. In VLDB, 97, 25–29.

  5. Kavitha, C., Sadasivam, G.S., Shenoy, S.N. 2011. Ontology based semantic integration of heterogeneous databases. European Journal of Scientific Research, 64, 120–127.

  6. Kim, W., Seo, J. 1991. Classifying schematic and data heterogeneity in multidatabase systems. Computer, 24, 12–18.

  7. Lee, C.Y., Ibrahim, H., Othman, M., Yaakob, R. 2009. Reconciling semantic conflicts in electronic patient data exchange. Proceedings of the 11th International Conference on Information Integration and Web-based Applications and Services, Kuala Lumpur, Malaysia. 390–394.

  8. Li, W.S., Clifton, C. 2000. SEMINT: A tool for identifying attribute correspondences in heterogeneous databases using neural networks. Data Knowledge Engineering. 33, 49–84.

  9. Li, J., Tang, J., Li, Y., Luo, Q. 2009. RiMOM: A dynamic multistrategy ontology alignment framework. IEEE Transactions on Knowledge and Data Engineering, 21, 1218–1232.

  10. Madhavan, J., Bernstein, P.A., Rahm, E. 2001. Generic schema matching with cupid. In VLDB, 1, 49–58.

  11. Massmann, S., Raunich, S., Aumüller, D., Arnold, P., Rahm E. 2011. Evolution of the COMA match system. Proceedings of the 6th International Conference on Ontology Matching, Bonn, Germany, 814, 49–60.

  12. Melnik, S., Rahm, E., Bernstein, P. 2003. Rondo: A programming platform for generic model management. Proceedings of the 2003 ACM SIGMOD International conference on Management of data, New York, USA. 193–204.

  13. Milo, T., Zohar, S. 1998. Using schema matching to simplify heterogeneous data translation. In VLDB, 98, 24–27.

  14. Özsu, M.T., Valduriez, P. 2011. Principles of distributed database systems. Third Edition. Springer. New York.

  15. Rahm E., Bernstein, P.A. 2001. A survey of approaches to automatic schema matching. The International Journal on Very Large Data Bases, 10, 334–350.

  16. Schmidts, O., Kraft, B., Siebigteroth, I., Zündorf, A. 2019. Schema matching with frequent changes on semi-structured input files: A machine learning approach on biological product data. In ICEIS, 208–215.

  17. Sutanta, E., Nurnawati, E.K., Kumalasanti, R.A., 2019. The mathematical model of hybrid schema matching based on constraints and instances similarity. International Journal of Advanced Computer Science and Applications, 10, 459–464.

  18. Sutanta, E., Nurnawati, E.K., Kumalasanti, R.A., 2021. Using variation in weighting criteria and string size matching on hybrid model schema matching. International Journal on Advanced Science, Engineering and Information Technology, 11, 326–333.

  19. Sutanta, E., Wardoyo, R., Mustofa, K., Winarko, E., 2016a. Survey: Models and prototypes of schema matching. International Journal of Electrical and Computer Engineering, 6, 1011–1022.

  20. Sutanta, E., Wardoyo, R., Mustofa, K., Winarko, E., 2016b. A hybrid model schema matching using constraint-based and instance-based. International Journal of Electrical and Computer Engineering, 6, 1048–1058.


ARTICLE INFORMATION

Received: 2021-11-28
Revised: 2022-09-30
Accepted: 2022-12-27
Available Online: 2023-01-17


Cite this article:

Sutanta, E., Nurnawati, E.K., Iswahyudi, C., Kumalasanti, R.A. On hybrid schema matching modified model in minimizing user verification process in output validation. International Journal of Applied Science and Engineering, 20, 2021501. https://doi.org/10.6703/IJASE.202303_20(1).004

  Copyright The Author(s). This is an open access article distributed under the terms of the Creative Commons Attribution License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are cited.

Other people also read ...

doaj logo

 

2.3
2022CiteScore
 
 
48th percentile
Powered by  Scopus
 
 

SCImago Journal & Country Rank

IJASE - Most Read Articles

IJASE - Most popular articles