SQL And NoSQL Object Database Mapping to Support CRUD Operation

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.