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
ACID and BASE in PostgreSQL: DISTRIBUTED DATABASE PERFORMANCE
KTH, School of Computer Science and Communication (CSC).
KTH, School of Computer Science and Communication (CSC).
2015 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesis
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.

Place, publisher, year, edition, pages
2015.
National Category
Computer Science
Identifiers
URN: urn:nbn:se:kth:diva-168669OAI: oai:DiVA.org:kth-168669DiVA: diva2:817850
Examiners
Available from: 2015-07-10 Created: 2015-06-07 Last updated: 2015-07-10Bibliographically approved

Open Access in DiVA

fulltext(924 kB)72 downloads
File information
File name FULLTEXT01.pdfFile size 924 kBChecksum SHA-512
95ed2c90c97b712c37eb87696e215b4fe7182ca18b66ed83017b67e5e06d07056423e01a836c1eb2dbec3c4505b71405a52391364854fad23ca820c96b88262b
Type fulltextMimetype application/pdf

By organisation
School of Computer Science and Communication (CSC)
Computer Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 72 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: 119 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