Comparison of NoSQL Database Performance with SQL Server Database on Online Airplane Ticket Booking

Nadea Cipta Laksmita, Erwin Apriliyanto, I Wayan Pandu, Kusrini Rini

Abstract

Flight ticket booking services have become more advanced, where bookings can be made through the android / iOS application and through a web browser, ticket reservations, no longer have to come to travel agents or come to the airport to book plane tickets. In this study using an online ticket booking database where one database uses the NoSQL database and another database uses SQL Server. The purpose of this research is to test the performance of NoSQL speed with SQL Server with the Insert, Delete and Select commands. The testing method uses 100 records, 500 records, 1000 records, and 5000 records, with each record being tested four times and then taken on average. The results of this study are that the NoSQL database Insert command has a speed 4 times faster than the SQL Server database for under 500 records, whereas above 500 NoSQL database records 5 times slower, the Delete NoSQL database command has a speed 3 times faster than the SQL database Server, and the command Select 1 NoSQL database table 55 times faster than SQL Server databases, while 2 NoSQL database tables are 18 times slower than SQL Server databases, while 3 NoSQL database tables are 10 times slower than SQL Server databases, whereas 4 database tables NoSQL is 16 times slower than SQL Server databases.

Keywords

NoSQL, SQL Server, Online Airplane Ticket Booking

Full Text:

PDF

References

Aghi, R., Mehta, S.D., Chauhan, R., Chaudhary, S., & Bohra, N., “A comprehensive comparison of SQL and MongoDB databases, “ International Journal of Scientific and Research Publications, Volume 5, Issue 2, February 2015.

Winaya, I.Gede.,Ashari Ahmad, “Transformasi Skema Basis Data Relasional Menjadi Model Data Berorientasi Dokumen pada MongoDB,“ IJCCS, Vol.10, No.1, January 2016, pp.47~58.

Hermansyah, Y. Ruldeviyani and R. F. Aji, “Enhancing query performance of library information systems using NoSQL DBMS: Case study on library information systems of Universitas Indonesia, “ 2016 International Workshop on Big Data and Information Security (IWBIS), pp. 41-46.

G. Ongo and G. P. Kusuma, “Hybrid Database System of MySQL and MongoDB in Web Application Development, “ 2018 International Conference on Information Management and Technology (ICIMTech), pp. 256-260.

R. Gunawan, A. Rahmatulloh and I. Darmawan, “Performance Evaluation of Query Response Time in The Document Stored NoSQL Database, “ 2019 16th International Conference on Quality in Research (QIR): International Symposium on Electrical and Computer Engineering, pp. 1-6.

E. Tang and Y. Fan, “Performance Comparison between Five NoSQL Databases, 2016 7th International Conference on Cloud Computing and Big Data (CCBD), “ pp. 105-109.

Deari Raif, dkk, “Analysis And Comparison Of Document-Based Databases With Sql Relational Databases: Mongodb Vs Mysql, Proceedings of the International Conference on Information Technologies (InfoTech-2018).

Kuderu1, Neelima., Kumari2, Vijaya, “Relational Database to NoSQL Conversion by Schema Migration and Mapping, “ International Journal of Computer Engineering In Research Trends, Volume 3, Issue 9, September-2016, pp. 506-513.

Zhao, Gansen., Lin, Qiaoying., Li, Libo., Li, Zijing, “Schema Conversion Model of SQL Database to NoSQL, “ Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing.

Kumar, Ravi., K.S, Chethan, “Comparison and Data migration of Relational Database with NoSQL, “ IJSART - Volume 3 Issue 4-APRIL 2017.

DOI: https://doi.org/10.20961/ijai.v4i2.38956

Refbacks

  • There are currently no refbacks.