Retrieving Records of the Population of any Iraqi City Using Mango Database
Downloads
In this paper, we worked on the data related to some population of Baghdad city as an example that can be applied to any iraqi city directly by just changing the dataset since Iraq is a famous, important and big country, and Baghdad is a famous historical city. In our paper, we have created a website for Baghdad city’s Population that allows the user to view all the documents in the database, update existing document in the database, insert new document to the database, and delete one document from the database based on the case number field in the document. Furthermore, our website allows the user to search documents by year. Our website also provides some visualization to see the information of the records that are added each year to Baghdad city. The goal of this paper is to implement a prototype that visualizes some information about the records of the population of Baghdad city. The other goal is to design a NoSQL database using MongoDB and how to use the indexing method in MongoDB to provide the efficient and important queries that retrieve information from the database. Then, we have implemented some types of queries using pymongo.py. These quires are as follow: new, delete, find, find by year, update, count by year, and find by birthdate. Our database is huge because it includes a lot of documents.
Downloads
1. https://en.wikipedia.org/wiki/Database
2. https://en.wikipedia.org/wiki/Relational_database
3. https://en.wikipedia.org/wiki/NoSQL
4. https://spring.io/understanding/NoSQL
5. https://www.tutorialspoint.com/mongodb/mongodb_overview.htm
6. https://en.wikipedia.org/wiki/Website
7. Chang Glasgow, Gergely Juhasz, and Laura Stephan, “Creating Your Personal Website,” in Mac Edition, 2006, http://andrew.cmu.edu/70-271-htmlman.
8. Webware staff, “11 Steps to Create a Successful Website,” in Copyright © 2007 StartupNation, LLC, 2007, CNET.com.
9. Mike Garcia, “Creating a Webpage Using HTML & CSS,” in ULN Internship Program, PCL Media Lab, 2015.
10. Sumitkumar Kanoje, Varsha Powar, and Debajyoti Mukhopadhyay, “Using MongoDB for Social Networking Website,” in IEEE Sponsored 2nd International Conference on Innovations in Information Embedded and Communication Systems ICIIECS’15, 2015.
11. Zhu Wei-ping, Li Ming-xin, and Chen Huan, “Using MongoDB to implement textbook management system instead of MySQL,” in 2011 IEEE 3rd International Conference on Communication Software and Networks, 2011.
12. Dipina Damodaran B, Shirin Salim and Surekha Marium Vargese, “MongoDB vs. MySQL: A Comparative Study of Performance in Super Market Management System,” in International Journal of Computational Science and Information Technology (IJCSITY) Vol.4, No.2, 2016.
13. Comelia GYORODI, Robert GYORODI, George PECHERLE, and Andrada OLAH, “A Comparative Study: MongoDB vs. MySQL,” in 2015 13th International Conference on Engineering of Modern Electric Systems (EMES), 2015.
14. Sushil Soni, Mayuresh Ambavane, Shamal Ambre, and Shirshendu Maitra, “A Comparative Study: MongoDB vs. MySQL,” in International Journal of Scientific & Engineering Research Volume 8, Issue 5, 2017.
15. Rusul J. Alsaedi, Farah S. Kamw, and Qasim S. Kadhim, “Creating a Website for Chicago City’s Crimes Using MongoDB,” in Global Scientific Journal of Computer Science Volume 1, April(2024).
Copyright (c) 2024 Rusul J. Alsaedi
This work is licensed under a Creative Commons Attribution 4.0 International License.