Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
SQL vs NoSQL: En prestanda jämförelse
University West, Department of Engineering Science, Division of Computer, Electrical and Surveying Engineering.
University West, Department of Engineering Science, Division of Computer, Electrical and Surveying Engineering.
2015 (Swedish)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesisAlternative title
SQL vs NoSQL : A performance comparison (English)
Abstract [sv]

I detta arbete jämförs prestandan på en NoSQL databas och på en MySQL databas. Det som mäts är exekveringstiden för en rad olika operationer, såsom läsning, skrivning och uppdatering i databaserna. Det görs även tester på en denormaliserad MongoDB databas när testerna använder mer än en samling. En mindre mängd strukturerad data används för att modellera ett fiktivt taxibolag. Testerna är skrivna i Python och körs i en virtuell miljö. Arbetet tar upp historia bakom relationsdatabaser och NoSQL. Den går även igenom MySQL och MongoDB vilket är de databashanterare som används för att utföra testerna på. Dessa är valda för att de är bland de populäraste på marknaden. Resultatet visar att MongoDB är snabbare än MySQL när operationerna sker i en samling/tabell.

Abstract [en]

In this paper we compare the performance of a NoSQL database and a MySQL database. The execution time is measured for a variety of different operations, such as read, write and update. We will also perform tests on a denormalized MongoDB database when the tests uses more than one collection. A small amount of structured data is used to model a fictive taxi company. The tests are written in Python and are performed in a virtual environment. The paper goes through the history behind relational databases and NoSQL types, and also covers both MySQL and MongoDB, which is the database managers used in these tests. They are chosen because they are the most popular on the market. Results show that MongoDB is quicker than MySQL when the operations are performed on a single collection/table.

Place, publisher, year, edition, pages
2015. , p. 18
Keywords [en]
NoSQL, MySQL, MongoDB, database, performance
Keywords [sv]
NoSQL, MySQL, MongoDB, databas, prestanda
National Category
Computer and Information Sciences
Identifiers
URN: urn:nbn:se:hv:diva-8684Local ID: EXD500OAI: oai:DiVA.org:hv-8684DiVA, id: diva2:873231
Subject / course
Computer enigeering
Educational program
Datateknisk systemutveckling
Supervisors
Examiners
Available from: 2015-11-30 Created: 2015-11-23 Last updated: 2018-01-10Bibliographically approved

Open Access in DiVA

No full text in DiVA

By organisation
Division of Computer, Electrical and Surveying Engineering
Computer and Information Sciences

Search outside of DiVA

GoogleGoogle Scholar

urn-nbn

Altmetric score

urn-nbn
Total: 801 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf