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

Abstract

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.

Authors and Affiliations

Cornelia Gyorödi, Robert Gyorödi, Alexandra Stefan, Livia Bandici

Keywords

Related Articles

Image and AES Inspired Hex Symbols Steganography (IAIS) for Anti-Forensic Artifacts

Technology (including mobiles and computers) has become a basic, indispensable need in our daily life. With an initial purpose of achieving basic functions such as communication, technology has evolved into a virtual gat...

Demand Response Programs Significance, Challenges and Worldwide Scope in Maintaining Power System Stability

In order to cope up the continuously increasing electric demand, Governments are forced to invest on Renewable Energy (RE) sources due to scarcity of fossil fuels (such as coal, gas and oil), high costs associated with i...

Improved Selfish Node Detection Algorithm for Mobile Ad Hoc Network

Mobile Ad hoc network (MANET) suffers from different security issues. Ideally, not all nodes in MANET cooperate in forwarding packets because of non-malicious intention. This node is called selfish node and it behaves so...

Conception of a management tool of Technology Enhanced Learning Environments

This paper describes the process of the conception of a software tool of TELE management. The proposed management tool combines information from two sources: i) the automatic reports produced by the Learning Content Mana...

Impact of Web 2.0 on Digital Divide in AJ&K Pakistan

Digital divide is normally measured in terms of gap between those who can efficiently use new technological tools, such as internet, and those who cannot. It was also hypothesized that web 2.0 tools motivate people to us...

Download PDF file
  • EP ID EP143815
  • DOI 10.14569/IJACSA.2016.070433
  • Views 106
  • Downloads 0

How To Cite

Cornelia Gyorödi, Robert Gyorödi, Alexandra Stefan, Livia Bandici (2016). A Comparative Study of Databases with Different Methods of Internal Data Management. International Journal of Advanced Computer Science & Applications, 7(4), 266-271. https://europub.co.uk/articles/-A-143815