An ontology-based approach to designing a NoSQL database for semi-structured and unstructured health data
Abstract
With the advent of ICT-based healthcare applications, various formats of health data are generated every day in huge volume. Such data, consisting of unstructured, semi-structured and structured data, has every characteristic of Big data. NoSQL databases are generally preferred for storing such type of health data with the objective of improving query performance. However, for efficient retrieval and processing of Big Health Data and for resource optimization, suitable data models and design of the NoSQL databases are important requirements. Unlike relational databases, no standard methods or tools exist for NoSQL database design. In this work, we adopt an ontology-based schema design approach. We propose that an ontology, which captures the domain knowledge, be used for developing a health data model. An ontology for primary healthcare is described in this paper. We also propose an algorithm for designing the schema of a NoSQL database, keeping in mind the characteristics of the target NoSQL store, using a related ontology, a sample query set, some statistical information of the queries, and performance requirements of the query set. The ontology proposed by us for primary healthcare domain and the above mentioned algorithm along with a set of queries are used for generating a schema targeting MongoDB datastore. The performance of the proposed design is compared with a relational model developed for the same primary healthcare data and the effectiveness of our proposed approach is demonstrated. The entire experiment has been carried out on MongoDB cloud platform.
References
[1]
Mukherjee, N., Bose, S., Ray, H.S.: A framework for delivering iot services with virtual sensors: Case study remote healthcare delivery. In: Interoperability in IoT for Smart Systems, pp. 137–152 (2020). Taylor & Francis Book Chapter, CRC Press.
[2]
Kichloo, A., Albosta, M., Dettloff, K., Wani, F., El-Amir, Z., Singh, J., Aljadah, M., Chakinala, R.C., Kanugula, A.K., Solanki, S., Chugh, S.: Telemedicine, the current covid-19 pandemic and the future: a narrative review and perspectives moving forward in the USA. Fam Med Community Health 8(3):e000530 (2020).
[3]
Moorthy, R., Udupa, S., Bhagavath, S.A., Rao, V., et al.: Centralized and automated healthcare systems: A essential smart application post covid-19. In: 2020 3rd International Conference on Intelligent Sustainable Systems (ICISS), pp. 131–138 (2020). IEEE
[4]
Sil Sen, P., Banerjee, S., Mukherjee, N.: Ontology for preliminary detection of covid-19. In: Information and Communication Technology for Competitive Strategies (ICTCS 2020), pp. 349–361 (2022). Springer
[5]
Celesti A, Lay-Ekuakille A, Wan J, Fazio M, Celesti F, Romano A, Bramanti P, and Villari M Information management in iot cloud-based tele-rehabilitation as a service for smart cities: Comparison of nosql approaches Measurement 2020 151
[6]
Mehmood NQ, Culmone R, and Mostarda L Modeling temporal aspects of sensor data for mongodb nosql database Journal of Big Data 2017 4 1 8
[7]
Wang, L., Alexander, C.: Medical applications and healthcare based on cloud computing. International Journal of Cloud Computing and Services Science (IJ-CLOSER) 2 (2013).
[8]
Council, C.S.C.: Impact of Cloud Computing on Healthcare Version 2.0. https://www.omg.org/cloud/deliverables/CSCC-Impact-of-Cloud-Computing-on-Healthcare.pdf (2017)
[9]
Siddiqa A, Karim A, and Gani A Big data storage technologies: a survey Frontiers Inf Technol Electronic Eng 2017 18 1040-1070
[10]
Mazumdar S and Seybold KKEAD A survey on data storage and placement methodologies for cloud-big data ecosystem J. Big Data 2019 6 15 1040-1070
[11]
Mukherjee, N., Neogy, S., Chattopadhyay, S.: Big Data in Ehealthcare: Challenges and Perspectives (1st ed.). Chapman and Hall/CRC Press (2019).
[12]
Schneider T, Hashemi A, Bennett M, Brady M, Casanave C, Graves H, Grüninger M, Guarino N, Levenchuk A, Lucier E, Obrst L, Ray S, Sriram R, Vizedom A, West M, Whetzel T, and Yim P Ontology for big systems: the ontology summit 2012 communiqu Appl. Ontol. 2012 7 357-371
[13]
Zeshan, F., Mohamad, R.: Medical ontology in the dynamic healthcare environment. In: Proceedings of the 3rd International Conference on Ambient Systems, Networks and Technologies (ANT 2012), the 9th International Conference on Mobile Web Information Systems (MobiWIS-2012), Niagara Falls, Ontario, Canada, August 27-29, 2012, pp. 340–348 (2012).
[14]
Rhayem, A., Mhiri, M.B.A., Gargouri, F.: Healthiot ontology for data semantic representation and interpretation obtained from medical connected objects. In: 14th IEEE/ACS International Conference on Computer Systems and Applications, AICCSA, pp. 1470–1477. IEEE Computer Society. https://doi.org/10.1109/AICCSA.2017.171
[15]
Dang J, Hedayati A, Hampel K, and Toklu C An ontological knowledge framework for adaptive medical workflow J. of Biomed. Informatics 2008 41 5 829-836
[16]
Lasierra N, Alesanco A, Guillén S, and García J A three stage ontology-driven solution to provide personalized care to chronic patients at home J. Biomed. Informatics 2013 46 3 516-529
[17]
Edoh, T.: Internet of things in emergency medical care and services. In: Farhadi, H. (ed.) Medical Internet of Things (m-IoT). IntechOpen, Rijeka (2019). Chap. 1.
[18]
McMurray J, Zhu L, McKillop I, and Chen H Ontological modeling of electronic health information exchange J. Biomed. Informatics 2015 56 169-178
[19]
Boshnak H, Abdelgaber S, Yehia E, and Abdo A Ontology-based knowledge modelling for clinical data representation in electronic health records Int. J. Comput. Sci. Information Security 2019 16 68-86
[20]
Atzeni P, Bugiotti F, Cabibbo L, and Torlone R Data modeling in the nosql world Comput. Stand. Interfaces 2020 67
[21]
Imam AA, Basri S, Ahmad R, Watada J, and Gonzaez-Aparicio MT Automatic schema suggestion model for nosql documentstores databases J. Big Data 2018 5 1 46
[22]
Imam AA, Basri SB, Ahmad R, Watada J, Aparicio MTG, and Almomani MAT Data modeling guidelines for nosql document-store databases Int. J. Adv. Comput. Sci. Appl. 2018 9 2018
[23]
Mior, M.J.: Automated schema design for nosql databases. In: Proceedings of the 2014 SIGMOD PhD Symposium. SIGMOD’14 PhD Symposium, pp. 41–45. Association for Computing Machinery, New York, NY, USA (2014).
[24]
Daniel, G., Gomez, A., Cabot, J.: Umlto[no]sql: Mapping conceptual schemas to heterogeneous datastores. 2019 13th International Conference on Research Challenges in Information Science (RCIS), 1–13 (2019).
[25]
Moditha Hewasinghage, A.A. Sergi Nadal: DocDesign 2.0: Automated database design for document stores with multi-criteria optimization. https://upcommons.upc.edu/handle/2117/343145 (2020)
[26]
Mior MJ, Salem K, Aboulnaga A, and Liu R Nose: Schema design for nosql applications IEEE Trans. Knowl. Data Eng. 2017 29 2275-2289
[27]
Sen PS and Mukherjee N Ontology-based data modeling for nosql databases: A case study in e-healthcare application SN Comput. Sci. 2023 4 1 3
[28]
Pore, A.: How to Choose the Right NoSQL Database for Your Application? urlhttps://www.dataversity.net/how-to-design-schema-for-your-nosql-database/ (2018)
[29]
Sen, P.S., Banerjee, S., Mukherjee, N.: Ontology-driven approach to health data management for remote healthcare delivery. In: Proceedings of the 7th ACM Workshop on ACM Mobile Health 2017. MobileHealth’17 (2017).
[30]
of India, G.: Electronic Health Record Standards for India, August 2013. https://www.nhp.gov.in/NHPfiles/ehr_2013.pdf (2013)
[31]
Basra, R.: EHR Standards for India: A beginning of Integrated Indian Healthcare System. https://healthfore.wordpress.com/2013/11/13/ehr-standards-for-india-a-beginning-of-integrated-indian-healthcare-system/ (2013)
[32]
: Integrated Management of Neonatal and Childhood Illness (2003). https://www.jknhm.com/zip/IMNCI%20%20Students’%20Handbook.pdf
[33]
Bose, S., Gupta, A., Adhikary, S., Mukherjee, N.: Towards a sensor-cloud infrastructure with sensor virtualization, pp. 25–30 (2015).
Recommendations
Ontology-Based Data Modeling for NoSQL Databases: A Case Study in e-Healthcare Application
AbstractWith the advent of e-healthcare applications, managing health data manually is no longer possible. Health data being voluminous, complex in nature and generally described with specialized terminologies, requires to be specified with standards like ...
An effective model for store and retrieve big health data in cloud computing
Background and objectiveThe volume of healthcare data including different and variable text types, sounds, and images is increasing day to day. Therefore, the storage and processing of these data is a necessary and challenging issue. Generally, ...
Model Transformation From Object Relational Database to NoSQL Document Database
NISS '19: Proceedings of the 2nd International Conference on Networking, Information Systems & SecurityWith the high increase of data growing, NoSQL databases play a key role in storing large amount of data, to gain flexibility and scalability many industries are now replacing their relational and object relational databases by adopting NoSQL database ...
Comments
Information & Contributors
Information
Published In
© The Author(s), under exclusive licence to Springer Science+Business Media, LLC, part of Springer Nature 2023. Springer Nature or its licensor (e.g. a society or other partner) holds exclusive rights to this article under a publishing agreement with the author(s) or other rightsholder(s); author self-archiving of the accepted manuscript version of this article is solely governed by the terms of such publishing agreement and applicable law.
Publisher
Kluwer Academic Publishers
United States
Publication History
Published: 08 April 2023
Accepted: 18 March 2023
Revision received: 05 December 2022
Received: 05 December 2022
Author Tags
Qualifiers
- Research-article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 0Total Downloads
- Downloads (Last 12 months)0
- Downloads (Last 6 weeks)0
Reflects downloads up to 30 Aug 2024
Other Metrics
Citations
View Options
View options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in