Endre søk
RefereraExporteraLink to record
Permanent link

Direct link
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annet format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annet språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf
ACID and BASE in PostgreSQL: DISTRIBUTED DATABASE PERFORMANCE
KTH, Skolan för datavetenskap och kommunikation (CSC).
KTH, Skolan för datavetenskap och kommunikation (CSC).
2015 (engelsk)Independent thesis Basic level (degree of Bachelor), 10 poäng / 15 hpOppgave
Abstract [en]

This thesis studies the performance impact of the Two Phase Commit

mechanism used in order to achieve consistency in a distributed PostgreSQL

system. This impact is compared to the performance gained

by removing Two Phase Commit and abandoning consistency. The

tests are run on different number of nodes in the system to find a link

between the performance hit and the size of the system. Performance

is measured using the unit Queries per Second.

Firstly, a short introduction is given to demonstrate why and when

distributed database systems is necessary and the difficulties it poses.

Thereafter follows a description of the system constructed to conduct

the experiment, together with the results of this experiment. The thesis

is concluded with a discussion regarding the results and thoughts

on future variations of the experiment.

The conclusion of the experiment is that Two Phase Commit puts

a low maximum performance on the system, especially when compared

to the alternative of abandoning consistency. The number of

nodes did not significantly affect the performance of the system using

Two Phase Commit, however the alternative had a clear negative

correlation between numbers of nodes and Queries per Second.

sted, utgiver, år, opplag, sider
2015.
HSV kategori
Identifikatorer
URN: urn:nbn:se:kth:diva-168669OAI: oai:DiVA.org:kth-168669DiVA, id: diva2:817850
Examiner
Tilgjengelig fra: 2015-07-10 Laget: 2015-06-07 Sist oppdatert: 2018-01-11bibliografisk kontrollert

Open Access i DiVA

fulltext(924 kB)100 nedlastinger
Filinformasjon
Fil FULLTEXT01.pdfFilstørrelse 924 kBChecksum SHA-512
95ed2c90c97b712c37eb87696e215b4fe7182ca18b66ed83017b67e5e06d07056423e01a836c1eb2dbec3c4505b71405a52391364854fad23ca820c96b88262b
Type fulltextMimetype application/pdf

Av organisasjonen

Søk utenfor DiVA

GoogleGoogle Scholar
Totalt: 100 nedlastinger
Antall nedlastinger er summen av alle nedlastinger av alle fulltekster. Det kan for eksempel være tidligere versjoner som er ikke lenger tilgjengelige

urn-nbn

Altmetric

urn-nbn
Totalt: 128 treff
RefereraExporteraLink to record
Permanent link

Direct link
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annet format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annet språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf