A Comparative Study of Databases with Different Methods of Internal Data Management

The purpose of this paper is to present a comparative study between a non-relational MongoDB database and a relational Microsoft SQL Server database in the case of an unstructured representation of data, in XML or JSON format. We mainly focus our presentation on exploring all the possibilities that each type of database offers us, in the case that the data, which has to be stored, cannot or is not wanted to be normalized. This is a scenario most often found in production when, for the application that is being developed we are extracting unstructured data from social networks or all kinds of different channels that the user might have. The comparative study is based on the creation of a benchmark application developed in C# using Visual Studio 2013, which accesses databases created beforehand with proper optimizations that will be described.

@article{Gyorödi2016,
  title     = {A Comparative Study of Databases with Different Methods of Internal Data Management},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {7},
  number    = {4},
  year      = {2016},
  publisher = {The Science and Information Organization},
  author    = {Cornelia Gyorödi and Robert Gyorödi and Alexandra Stefan and Livia Bandici},
  doi       = {10.14569/IJACSA.2016.070433},
  url       = {https://doi.org/10.14569/IJACSA.2016.070433}
}