MongoDB Database Creation, Query Execution, and Performance Evaluation

This report provides a comprehensive overview of MongoDB database creation and query execution. It includes various queries performed on MongoDB, along with screenshots of the outputs. Part A showcases the outputs of different queries, while Part B discusses the benefits and issues associated with MongoDB, such as its indexing capabilities, replication features, load balancing, and challenges related to binary collation and query optimization. The report also offers recommendations for ensuring network connection and data consistency. The conclusion summarizes the execution of queries using MongoDB commands and highlights the attributes and data types used in the tables. The report also references external sources to support its findings and analysis.

Contents
Introduction......................................................................................................................................2
Part A...............................................................................................................................................3
Part B...............................................................................................................................................8
Conclusion.....................................................................................................................................11
References......................................................................................................................................12

Introduction
The given report is based on the database creation on the MongoDB and in this report there are
various queries that performed and screenshots of the outputs are attached in the file. The overall
assessment provided the understanding of the MongoDB as well as the difference among No
SQL and Mongo DB.

Part A
Figure 1: Output 1
Figure 2: Output 2
Figure 3: Output 3

Figure 4: Output 4
Figure 5: Output 5
Figure 6: Output 6

Figure 7: Output 7
Figure 8: Output 8
Figure 9: Output 9
Figure 10: Output 10
Query 11:
db.GameData.stats(1024 * 1024) {
fileSizeBytes : 682428,

avgObjSize : 0,
}
Figure 11: Output 12
Figure 12: Output 13
Tables:
ATTRIBUTES DATA TYPE
GameID Integer
Title String
Description String
Main Genre String
Genre 2 String
Genre 3 String
Genre 4 String
Game Centre Enabled String
Released Date Date (ISO)
Supported Device String
Context Advisory Rating String
Language 1 String
Language 2 String
Language 3 String
Language 4 String
Language 5 String
Language 6 String
Language 7 String

Language 8 String
File Size Bytes Integer
Mini OS Version Decimal
Developer ID Integer
Developer Name String
Developer URL String
Price Decimal
Currency String
Average User Rating Decimal
User Rating Count Integer
Current Version String
Current Release Date Date (ISO)
Current Notes String
Avg User Rating For Current Version Decimal
User Rating Count for the current version Integer

Part B
Benefits of Mongo DB
1. MongoDB generally has many things including fields, searches and query range too ,it
can give question back to a specific fields of report and integrate user defined functions
which could be in Java Script ,there is also an option of sending back all queries of a
particular size ,which adds a benefit for it (Wu et al., 2015).
2. One of the benefits of it includes that it does indexing which means that it can be
traversed easily when needed which also means that it would be lesser time consuming in
nature and require lesser time to complete, it stores smaller parts which could be easily
traced and worked on (Aboutorabi et al., 2015).
3. MongoDB allows replication of data easily, it can make replicated data’s and copies of it
again and again which is helpful many times, it contains primary as well as secondary
replica in general where the primary one goes for writing and reading tasks while
secondary one goes to duplicating the data of the primary one which is made by using a
built-in feature of replication.
4. Mongo DB can do load balancing as it can scales horizontally using shrading, which can
be done when user can pick up the shard key, which could easily decide which
information collection can be distributed in which of the way, it can easily run over
various available servers, adjusting the replicated information without occurrence of any
error in general (Pereira et al., 2018).
5. Storage of file could be easily done over Mongo DB which makes it easier to access it
easily, it could also be utilized as a system in file while adjusting load.
6. It can process the given data and can return result as well as collect values from various
files hand to hand and then perform different processes to give back a solo result in
general.

7. It has one more benefit included which is it can easily work on different programming
language and different development environments to be used so it can be used any where
and any point of time in general.

Issues of Mongo DB
1. Mongo Db uses binary collation, which leads to more and more of time consumption
which is unhealthier and leads to frustration of the people involved surfing through it so
this is not a perfect thing to do and is not a good practice also.
2. It can accommodate larger documents of bigger sizes in it which could be seen as its
advantage but giving a deep thought to it, it is not an advantageous as it could only work
well when it is singularly employed.
3. It can be very frustrating if there is no link to relate our information in general, so if there
are no indexes relates then it is very difficult to surf our provided information which
could be time consuming and not applicable to do so.
4. The query optimizer is used to generate the desire results from the data, when there is a
need of fetching any data from the database ,it is only required to write the query of what
is needed rather than writing the explanation about the query it can be compared with
the example of restaurant ,In restaurant it is only require to order the food that is required
to be eaten instead of giving instructions to cook on how to make that specific food. In
case of Mongo Db there is a need to give instruction about every query so, this is a major
issue.
5. Each document contains arrays therefore it is necessary to keep these number of arrays
below the four figures. When the new array added in the document it will only results in
updating the index every time the array added and also the size of the document increases
constantly. This is another major issue in Mongo DB.
Recommendation
The recommendation that are to provide in the report is that the mongo dB software contains a
proper trusted software that helps in the proper connection for the network and also the data is
kept in a consistent manner here.

Conclusion
The conclusions of the above report are the execution of the provided queries that need to
perform using the MongoDB commands. The overall report consists of the tables that contain the
attribute and their respective data type. With the snapshots of queries that are added and various
issues about the Mongodb are also discussed in the above file.

References
Aboutorabi, S.H., Rezapour, M., Moradi, M. and Ghadiri, N., 2015, August. Performance
evaluation of SQL and MongoDB databases for big e-commerce data. In 2015 International
Symposium on Computer Science and Software Engineering (CSSE) (pp. 1-7). IEEE.
Wu, C.M., Huang, Y.F. and Lee, J., 2015. Comparisons between mongodb and ms-sql databases
on the twc website. American Journal of Software Engineering and Applications, 4(2), pp.35-41.
Pereira, D.A., Ourique de Morais, W. and Pignaton de Freitas, E., 2018. NoSQL real-time
database performance comparison. International Journal of Parallel, Emergent and Distributed
Systems, 33(2), pp.144-156.