Abstract
A database refers to data structure used for systematical and organized collection of data. Now-a-days, Database system follows mostly two different algorithms i.e. SQL and NoSQL. In SQL, databases schema is predefined, fixed and vertically scalable whereas in NoSQL database, schema is dynamic and horizontally scalable. Also, SQL database are table-based database such as MySQL, Oracle, and MS SQL whereas NoSQL databases are document based, key-value based, and graph databases such as MongoDB, CouchDB, and so on. Here, A login system project developed using Python programming language is used to analyze performance of MongoDB and MySQL based on their data fetching speed from databases. A login system can be used where it is required that user should be verified before accessing confidential information or data. This paper will also help us to decide which type of database system should be used as backend database for storing and retrieving user credential information for any login-based system.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Dipina Damodaran B, Salim S, Vargese SM (2016) MONGODB Versus MYSQL: A comparative study of performance in super market management system. Int J Comput Sci Inf Technol (IJCSITY) 4(2)
Kolonko K (2018) Performance comparison of the most popular relational and non-relational database management systems. Master of science in software
Vidushi Jain VIT University-Vellore, Aviral Upadhyay VIT University-Vellore (2017) MongoDB and NoSQL atabases. Int J Comput Appl (0975–8887) 167(10)
Han J, Haihong E, Le G, Du J (2011) Survey on NoSQL database, IEEE
Okman L, Gal-Oz N, Gonen Y, Gudes E, Abramov J (2011) Security issues in NoSQL databases, IEEE
Jia T, Zhao X, Wang Z, Gong D, Ding G (2016) Model transformation and data migration from relational database to mongoDB, IEEE
Mukesh BA, Garg M (2018) Comparative analysis of simple and aggregate query in MongoDB. Int J Adv Res Ideas Innov Technol
Jayathilake D, Sooriaarachchi C, Gunawardena T, Kulasuriya B, Dayaratne T (2016) A study into the capabilities of NoSQLDatabases in handling a highly heterogeneoustree. Int J Comput Sci Inf Technol (IJCSITY) 4(2)
Elmsari, Navathe (2006) In: Fundamentals of database systems. 5th edn, Pearson Education
Ullman JD In: Principals of database systems, Galgotia
Malhar L In: Python data persistence: with SQL and NOSQL databases
Meier A (Author), Kaufmann M (Contributor) In: SQL and NoSQL databases: models, languages, consistency options and architectures for big data management
Bradshaw S (Author), Brazil E (Author), Chodorow K (Author) In: MongoDB: the definitive guide: powerful and scalable data 4
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2021 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Patel, S., Kumar, S., Katiyar, S., Shanmugam, R., Chaudhary, R. (2021). MongoDB Versus MySQL: A Comparative Study of Two Python Login Systems Based on Data Fetching Time. In: Kumar, R., Quang, N.H., Kumar Solanki, V., Cardona, M., Pattnaik, P.K. (eds) Research in Intelligent and Computing in Engineering. Advances in Intelligent Systems and Computing, vol 1254. Springer, Singapore. https://doi.org/10.1007/978-981-15-7527-3_6
Download citation
DOI: https://doi.org/10.1007/978-981-15-7527-3_6
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-15-7526-6
Online ISBN: 978-981-15-7527-3
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)