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

AdviseMe: An Intelligent Web-Based Application for Academic Advising

The traditional academic advising process in many tertiary-level institutions today possess significant inefficiencies, which often account for high levels of student dissatisfaction. Common issues include high student-a...

Spatiotemporal Context Modelling in Pervasive Context-Aware Computing Environment: A Logic Perspective

Pervasive context-aware computing, is one of the topics that received particular attention from researchers. The context, itself is an important notion explored in many works discussing its: acquisition, definition, mode...

Investigating the Effect of Different Kernel Functions on the Performance of SVM for Recognizing Arabic Characters

A considerable progress in the recognition techniques of Latin and Chinese characters has been achieved. By contrast, Arabic Optical character Recognition is still lagging in spite that the interest and research in this...

A Blockchain-based Value Added Tax (VAT) System: Saudi Arabia as a Use-Case

Businesses need trust to confidently perform trade among each other. Centralized business models are the only mature solutions available to perform trades over the Internet. However, they have many problems which include...

Lonospheric Anomalies before the 2015 Deep Earthquake Doublet, Mw 7.5 and Mw 7.6, in Peru

Two major earthquakes separated by ∼5 minutes occurred in the same fault in Peru at depths of 606.2 and 620.6 km on November 24, 2015. By using Global Ionospheric Maps (GIMs) from the Center for Orbit Determination in Eu...

Download PDF file
  • EP ID EP143815
  • DOI 10.14569/IJACSA.2016.070433
  • Views 111
  • 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