Abstract

SQL and NoSQL databases have different data models and query languages, which can pose challenges when mapping between them for CRUD operations. Utilizing object database mapping can help minimize errors when executing database query commands within program code. Manually mapping object models to database tables remains a labor- intensive and error-prone process. This research introduces an approach for building an object mapping framework on SQL and NoSQL databases. We build a framework by carrying out concept mapping, syntax conversion, and developing object database mapping. Object database mapping is developed using chaining method and active record design pattern. The framework was tested using the hospital information system billing module. The results of this research demonstrate that the constructed framework can execute CRUD query commands on three distinct types of databases: MySQL, MongoDB, and Neo4j.

Original languageEnglish
Title of host publicationProceeding - International Conference on Information Technology and Computing 2023, ICITCOM 2023
EditorsHsing-Chung Chen, Cahya Damarjati, Christian Blum, Yessi Jusman, Siti Nurul Aqmariah Mohd Kanafiah, Waleed Ejaz
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages279-284
Number of pages6
ISBN (Electronic)9798350359633
DOIs
Publication statusPublished - 2023
Event2023 International Conference on Information Technology and Computing, ICITCOM 2023 - Hybrid, Yogyakarta, Indonesia
Duration: 1 Dec 20232 Dec 2023

Publication series

NameProceeding - International Conference on Information Technology and Computing 2023, ICITCOM 2023

Conference

Conference2023 International Conference on Information Technology and Computing, ICITCOM 2023
Country/TerritoryIndonesia
CityHybrid, Yogyakarta
Period1/12/232/12/23

Keywords

  • NoSql
  • ORM
  • Object Database Mapping
  • Universal Schema
  • active record

Fingerprint

Dive into the research topics of 'SQL And NoSQL Object Database Mapping to Support CRUD Operation'. Together they form a unique fingerprint.

Cite this