@inproceedings{f882562b8d5d45a7bb2ae3e4965c4726,
title = "SQL And NoSQL Object Database Mapping to Support CRUD Operation",
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.",
keywords = "NoSql, ORM, Object Database Mapping, Universal Schema, active record",
author = "Billy Montolalu and Siti Rochimah and Daniel Siahaan",
note = "Publisher Copyright: {\textcopyright} 2023 IEEE.; 2023 International Conference on Information Technology and Computing, ICITCOM 2023 ; Conference date: 01-12-2023 Through 02-12-2023",
year = "2023",
doi = "10.1109/ICITCOM60176.2023.10442056",
language = "English",
series = "Proceeding - International Conference on Information Technology and Computing 2023, ICITCOM 2023",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
pages = "279--284",
editor = "Hsing-Chung Chen and Cahya Damarjati and Christian Blum and Yessi Jusman and Kanafiah, {Siti Nurul Aqmariah Mohd} and Waleed Ejaz",
booktitle = "Proceeding - International Conference on Information Technology and Computing 2023, ICITCOM 2023",
address = "United States",
}
