Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail

Faizal Anugrah Bhaswara, Riyanarto Sarno, Dwo Sunaryono
Submission Date: 2017-07-24 23:35:36
Accepted Date: 2018-01-09 21:27:31

Abstract


Makalah ini akan membahas dua jenis database, yaitu jenis Relational (SQL) dan Non-Relational (NOSQL). Mengingat dewasa ini para developer berlomba untuk memberikan database yang tepat dengan performa yang terbaik untuk aplikasinya. Kemudian makalah ini memberikan analisa perbandingan database NoSQL dengan SQL dalam hal kinerja, fleksibilitas, dan skalabilitas. Setelah terbukti database mana yang tepat, maka akan diterapkan aplikasi ERP Retail dengan yang berorientasikan multitenancy dengan tujuan agar aplikasi memiliki performa bagus, fleksibel dalam penyimpanan data, juga mendukung penyimpanan data yang terus berkembang seiring berjalannya waktu. Dalam uji coba yang telah dilakukan, database NoSQL terbukti memiliki kecepatan penyimpanan data yang lebih unggul dalam hal CRUD daripada SQL. Juga memiliki struktur penyimpanan data yang fleksibel karena model data berupa BSON (Binary JSON). Dan memiliki kemampuan untuk menjadi scalable dengan metode sharding. Jadi dalam hal ini database NoSQL akan lebih baik untuk diterapkan pada ERP Retail.

Keywords


ERP (Enterprise Resource Planning); Retail; Multitenancy; NoSQL

References


“Wiley: Integrated Business Processes with ERP Systems - Simha R. Magal, Jeffrey Word.” [Online]. Available: http://www.wiley.com/WileyCDA/WileyTitle/productCd-EHEP001815.html. [Accessed: 29-May-2017].

“Andrejs Tambovcevs and Tatjana Tambovceva ‘ERP system implementation: benefits and economic effectiveness’ Faculty of Computer Science and Information Technology Riga Technical University Riga, Latvia 2013.” .

“Mufid Itsnaini Zain and M. Rudyanto Arief ‘PERBANDINGAN STRUKTUR PENYIMPANAN DAN PERFORMANSI NOSQL MONGODB DENGAN DBMS SQL SERVER’ Jurusan Teknik Informatika STMIK AMIKOM YOGYAKARTA.” .

“Ameya Nayak, Anil Poriya, and Dikshay Poojary ‘Type of NOSQL Databases and its Comparison with Relational Databases’ Dept. of Computer Engineering Thakur College of Engineering and Technology University of Mumbai, March 2013.” .

J. R. Lourenço, B. Cabral, P. Carreiro, M. Vieira, and J. Bernardino, “Choosing the right NoSQL database for the job: a quality attribute evaluation,” J. Big Data, vol. 2, no. 1, p. 18, Aug. 2015.

“Divya Chauhan and K. L. Bansal ‘Using the Advantages of NOSQL: A Case Study on MongoDB’ Himachal Pradesh University Summerhill,Shimla,India.” .

“Rupali Arora, Rinkle Rani Aggarwal ‘Modeling and Querying Data in MongoDB’ July-2013.” .


Full Text: PDF

CC Licencing


Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement 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 acknowledgement 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 (See The Effect of Open Access).

Refbacks

  • There are currently no refbacks.


Creative Commons License
Jurnal Teknik ITS by Lembaga Penelitian dan Pengabdian Kepada Masyarakat, LPPM-ITS is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Based on a work at http://ejurnal.its.ac.id/index.php/teknik.
Statistik Pengunjung