Retrieving Records of the Population of any Iraqi City Using Mango Database

Database; NoSQL; MongoDB; Website; Visualization; Iraq; Baghdad

Authors

Vol. 12 No. 09 (2024)
Engineering and Computer Science
September 13, 2024

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.