Flexible Data Refreshing Architecture for Health Information System Integration
DOI:
https://doi.org/10.12928/spekta.v4i1.7845Keywords:
DataBase Integration, Schema and Subschema, Data Warehouse and repository, System Integration , ImplementationAbstract
Background: Having a consistent and unified view of heterogeneous distributed medical information sources is an inevitable need of health informatics. Integrating medical information of patients or about a disease, a treatment or side effects of a drug, etc, is very useful to help medical education, to achieve medical research goals and to provide the computer- based decision support systems.
Contribution: This article proposes a flexible incremental update method for the materialized part of the integration system. It permits us to manage the integration system according to the characteristics of the data sources which can change.
Method: This paper presents a hybrid data integration approach in which the materialized part of the system in mediator is the object indexation structure based on an instance classification of the sources objects which correspond to the global schema. The object identifier of each object in the indexation structure is materialized together with the attributes which are needed for the incremental updating of this indexation (classifying attributes).
Results: The main idea of this paper is to develop a hybrid data integration framework, which represents a new aspect of a hybrid method focusing on flexible data refreshing.
Conclusion: This hybrid approach implements a vertical hybrid approach. It means that at the mediator level, some data of each object are materialized and others are virtual.
References
L. M. Haas, “Beauty and the Beast: The theory and practice of information integration”, in ICDT, pp. 28-43, 2007
H. Wache, T. Vogele, U. Visser, H. Stuckenschmidt, G. Schuster, H. Neumann, S. Hubner, “Ontology-based integration of information | a survey of existing approaches”, in : H. Stuckenschmidt (Ed.), IJCAI{01 Workshop : Ontologies and Information Sharing}, pp. 108-117, 2001.
Andrew Branson, Tamas Hauer, Richard McClatchey, Dmitri Rogulin, Jetendr Shamdasani, “A Data Model for Integrating Heterogeneous Medical Data in the Health- e-Child Project”. 2008.
A. Y. Levy, A. Rajaraman, J. Ordille, “Querying heterogeneous information sources using source descriptions”, in Proceedings of the Twenty second International Conference on Very Large Databases, VLDB Endowment, Saratoga, Calif., Bombay, India, pp. 251-262, 1996.
S. S. Chawathe, H. Garcia-Molina, J. Hammer, K. Ireland, Y. Papakonstantinou, J. D. Ullman, J. Widom, “The tsimmis project : Integration of heterogeneous information sources”, in IPSJ, pp. 7-18, 1994.
P.J. McBrien and A. Poulovassilis, “Towards Data Visualisation Based on Conceptual Modelling”, ER 2018, Pages 91-99, 2018.
A. Gupta, “Materialized Views: Techniques, Implementations, and Applications”, MIT Press, 1999.
Yi Zhao, Lexin Li, “Multimodal data integration via mediation analysis with high- dimensional exposures and mediators”, Human Brain Mapping. Volume 43, Issue 8, Pages 2519-2533, 2022.
Daneshpour, N. “View Maintenance Expression Improvement in Data Warehouses”, Journal of Modeling in Engineering, 16(55), 101-111. 2018.
L. M. V. Y. V. P. Jarke, M., “Fundamentals of Data Warehouses”, 2nd Edition, Springer, ISBN : 978-3-540-42089-7, 2003.
Li, Y., Feng, A., Li, J., Chen, S., Mumick, S., Halevy, A.Y., Li, V., & Tan, W.C., “Querying subjective data”. The VLDB Journal, 30, 115 – 140, 2020.
Ulrich, H., Kock-Schoppenhauer, A. K., Deppenwiese, N., Gött, R., Kern, J., Lablans, M., Majeed, R. W., Stöhr, M. R., Stausberg, J., Varghese, J., Dugas, M., & Ingenerf, J. “Understanding the Nature of Metadata: Systematic Review”, Journal of medical Internet research, 24(1), 2022.
F. G. V. Lattes, M.-C. Rousset, “The use of CARIN language and algorithms for information integration: The PICSEL sys-tem”, International Journal of Cooperative Information Systems 9 (4), pp. 383-401, 2000.
Gianluca Cima, Federico Croce, Maurizio Lenzerini, “Separability and its Approximations in Ontology-based Data Management”, Semantic Web Journal, 2022.
Ian Harrow, Rama Balakrishnan, Ernesto Jimenez-Ruiz, Simon Jupp, Jane Lomax, Jane Reed, Martin Romacker, Christian Senger, Andrea Splendiani, Jabe Wilson, Peter Woollard, “Ontology mapping for semantically enabled applications”, Drug Discovery Today, Volume 24, Issue 10, Pages 2068-2075, 2019.
Michael Meier, Michael Schmidt, Fang Wei, Georg Lausen, “Semantic query optimization in the presence of types”, Journal of Computer and System Sciences, Volume 79, Issue 6, Pages 937-957, 2013.
Alon Halevy, Cristian Canton-Ferrer, Hao Ma, Umut Ozertem, Patrick Pantel, Marzieh Saeidi, Fabrizio Silvestri, Ves Stoyanov, “Preserving integrity in online social networks”, Communications of the ACM, 66 (2), pp. 92-98, 2022
Michael Meier, Michael Schmidt, Fang Wei, Georg Lausen, “Semantic query optimization in the presence of types”, Journal of Computer and System Sciences, Volume 79, Issue 6, Pages 937-957, 2013.
S. Kermanshahani, H. R. Hamidi, “An Efficient and Adaptive Framework to Access Heterogeneous Health Information Sources”, INFORMATION TECHNOLOGY IN INDUSTRY, Vol 7, No 2, 2019.
A. Simonet, “Types abstraits et bases de donnees: formalisation du concept de partage et analyse statique de contraintes d'integrite”, Phd thesis, Universite Scientique et Medicale de Grenoble, France, 1984.
M. Roger, A. Simonet, M. Simonet, “Bringing together de-scription logics and database in an object oriented model”, in : DEXA '02 : Proceedings of the 13th International Conference on Database and Expert Systems Applications, Springer-Verlag, London, UK, pp. 504-513, 2002..
E. Gay, “Vues osiris sur une base relationnelle”, Memoire d’ingnieur cnam, p-89, CNAM, Centre de Grenoble, France, 1999.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Shokooh Kermanshahani, Hamid Reza Hamidi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with SPEKTA (Jurnal Pengabdian Kepada Masyarakat: Teknologi dan Aplikasi) agree to the following terms:
- Authors retain copyright and grant the journal the right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
