his.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • 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
En prestandajämförelse mellan relationella databaser och ickerelationella databaser: I samband med händelsedrivna MES system
University of Skövde, School of Informatics.
2018 (Swedish)Independent thesis Basic level (degree of Bachelor), 20 credits / 30 HE creditsStudent thesisAlternative title
A performance comparison between relational databases and nonrelational databases : In connection with event-driven MES system (English)
Abstract [sv]

Syftet med detta arbete var att utvärdera om NoSQL databaser kunde fungera och erbjuda bättre prestanda än SQL databaser i samband med händelsedrivna MES System. Utvärderingen skedde hos ett utvecklingsteam på Volvo Group It i Skövde som tillhandhåller dessa system. Metoden för arbetet blev ett laboratorieexperiment, där olika databaser testades på en testbänk erbjuden av utvecklingsteamet. Testbänken hade ett befintligt system för att testa prestanda på databaserna. De undersökta NoSQL databaser var kolumnorienterade databaser med tillhörande plattform Cassandra och dokumentorienterade databaser med tillhörande plattform MongoDB. MongoDB hann inte implementeras färdigt och lämnades för framtida arbete. En testapplikation implementerad i .Net med språket C# utvecklat av utvecklingsteamet användes för att testa prestanda på databaserna. Resultatet som arbetet visade var att kolumnorienterade databaser kunde fungera med händelsedrivna MES system och att den kunde prestera bättre på grund av sin förmåga att de-normalisera data. SQL databaser passar fortfarande bra för många system.

Abstract [en]

The purpose of this work was to evaluate whether NoSQL databases could work and offer better performance than SQL databases with event-driven MES Systems. The evaluation took place at a development team at Volvo Group It in Skövde, which provides these systems. The method of work was a laboratory experiment, where different databases were tested on a test bench offered by the development team. The test bench had an existing system for testing performance on the databases. The examined NoSQL databases were column-oriented databases with associated Cassandra platform and document-oriented databases with associated MongoDB platform. MongoDB was not fully implemented and was left for future work. A test application implemented in .Net with the language C # developed by the development team was used to test performance on the databases. The result that the work showed was that column-oriented databases could work with event-driven MES systems and could perform better because of their ability to denormalize data. SQL databases are still good for many systems.

Place, publisher, year, edition, pages
2018. , p. 42
National Category
Information Systems
Identifiers
URN: urn:nbn:se:his:diva-15769OAI: oai:DiVA.org:his-15769DiVA, id: diva2:1222264
Subject / course
Informationsteknologi
Educational program
Information Systems - Enterpise Information Management
Supervisors
Examiners
Available from: 2018-06-21 Created: 2018-06-21 Last updated: 2018-06-21Bibliographically approved

Open Access in DiVA

fulltext(1756 kB)6 downloads
File information
File name FULLTEXT01.pdfFile size 1756 kBChecksum SHA-512
25eeece0e97f9da1b2d9fe5fbda4cc01faa442b11a273b997bb5855807d3c328bb3d42e7bf1a87f404e04a9f53d96943b128752308a6f64d7155e400fe99ecc7
Type fulltextMimetype application/pdf

By organisation
School of Informatics
Information Systems

Search outside of DiVA

GoogleGoogle Scholar
Total: 6 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

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

Direct link
Cite
Citation style
  • apa
  • harvard1
  • 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