Change search
ReferencesLink to record
Permanent link

Direct link
Analysis and Performance Evaluation of the Data-layer in a Multi-tenant Architecture
KTH, School of Computer Science and Communication (CSC).
2016 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesisAlternative title
Analys och prestandatest av dataskiktet i en Multi-tenant arkitektur (Swedish)
Abstract [en]

A Multi-tenant architecture is a cost optimization for Software as a Service, where customers, also referred to as tenants are consolidated into the same server. The main idea of this architecture is to consolidate as many tenants as possible into the same server to reduce the total cost for the service provider. However, the contention of shared resources can lead to reduced performance for the tenants. One shared resource between the tenants is the data-layer.This thesis aims to analyze and to do a performance evaluation of different data-layer designs in a Multi-tenant architecture. The thesis compares three data-layer designs implemented in a RDBMS.An experiment was performed to evaluate the transactions per secondfor tenants when both the amount of data and the number of tenants increase. The evaluations were computed for the Create, Read, Update and Delete operations, also known as the CRUD-operations.Three data-layer designs were tested in the experiment; Shared table design, where tenants share the same database system as well as the tables, Separated table design, where tenants share the same database system but store and query data to their own private tables and Oracle Multi-tenant, where each tenant gets its own database.The experiment indicates that the Oracle Multi-tenant has the highest performance while the Shared table design suffers when both the number of tenants and the amount of data increase.

Abstract [sv]

Multi-tenant arkitektur är en kostnadsoptimering för mjukvara som tillhandahålls över ett nätverk. Användarna, tenants är då betjänade av samma serverdator. Uppdraget för serverdatorn är att betjäna så många tenants som möjligt för att reducera kostnader för mjukvaruägaren. Men att dela resurser mellan tenants kan leda till försämrad prestanda. En delad resurs mellan tenants är dataskiktet.Målet med denna uppsats är att göra en analys och ett prestandatest av olika uppsättningar av dataskikt i en Multi-tenant arkitektur. Uppsatsen fokuserar endast på olika uppsättningar i ett RDBMS.Ett experiment utfördes där antalet tenants och data ökade för varje uppsättning. Experimentet evaluerade prestanda av Create, Read, Update och Delete operationer, även känt som CRUD-operationer. Tre uppsättningar testades; Shared table design, där tenants delar databas och tabeller, Separated table design, där tenants delar databas, men lagrar data i sina egna tabeller och Oracle Multi-tenant, där varje tenant får en egen databas.Experiment visar att Oracle Multi-tenant har högst prestanda medan Shared table design har lägst när antalet tenants och mängd data ökar.

Place, publisher, year, edition, pages
2016.
Keyword [en]
Multi-tenant database
National Category
Computer Science
Identifiers
URN: urn:nbn:se:kth:diva-191560OAI: oai:DiVA.org:kth-191560DiVA: diva2:957393
External cooperation
Skatteverket
Educational program
Master of Science in Engineering - Computer Science and Technology
Supervisors
Examiners
Available from: 2016-09-13 Created: 2016-09-01 Last updated: 2016-09-13Bibliographically approved

Open Access in DiVA

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

Search in DiVA

By author/editor
Blad, Julius
By organisation
School of Computer Science and Communication (CSC)
Computer Science

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

Total: 8 hits
ReferencesLink to record
Permanent link

Direct link