Logo des Repositoriums
 

Simulating multi-tenant OLAP database clusters

Kurzanzeige
dc.contributor.authorSchaffner, Jan
dc.contributor.authorEckart, Benjamin
dc.contributor.authorSchwarz, Christian
dc.contributor.authorBrunnert, Jan
dc.contributor.authorJacobs, Dean
dc.contributor.authorZeier, Alexander
dc.contributor.authorPlattner, Hasso
dc.contributor.editorHärder, Theo
dc.contributor.editorLehner, Wolfgang
dc.contributor.editorMitschang, Bernhard
dc.contributor.editorSchöning, Harald
dc.contributor.editorSchwarz, Holger
dc.date.accessioned2019-01-17T10:36:45Z
dc.date.available2019-01-17T10:36:45Z
dc.date.issued2011
dc.description.abstractSimulation of parallel database machines was used in many database research projects during the 1990ies. One of the main reasons why simulation approaches were popular in that time was the fact that clusters with hundreds of nodes were not as readily available for experimentation as it is the case today. At the same time, the simulation models underlying these systems were fairly complex since they needed to capture both queuing processes in hardware (e.g. CPU contention or disk I/O) and software (e.g. processing distributed joins). Todays trend towards more specialized database architectures removes large parts of this complexity from the modeling task. As the main contribution of this paper, we discuss how we developed a simple simulation model of such a specialized system: a multi-tenant OLAP cluster based on an in-memory column database. The original infrastructure and testbed was built using SAP TREX, an in-memory column database part of SAP's business warehouse accelerator, which we ported to run on the Amazon EC2 cloud. Although we employ a simple queuing model, we achieve good accuracy. Similar to some of the parallel systems of the 1990ies, we are interested in studying different replication and high-availability strategies with the help of simulation. In particular, we study the effects of mirrored vs. interleaved replication on throughput and load distribution in our cluster of multi-tenant databases. We show that the better load distribution inherent to the interleaved replication strategy is exhibited both on EC2 and in our simulation environment.en
dc.identifier.isbn978-3-88579-274-1
dc.identifier.pissn1617-5468
dc.identifier.urihttps://dl.gi.de/handle/20.500.12116/19592
dc.language.isoen
dc.publisherGesellschaft für Informatik e.V.
dc.relation.ispartofDatenbanksysteme für Business, Technologie und Web (BTW)
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) - Proceedings, Volume P-180
dc.titleSimulating multi-tenant OLAP database clustersen
dc.typeText/Conference Paper
gi.citation.endPage429
gi.citation.publisherPlaceBonn
gi.citation.startPage410
gi.conference.date02.-04.03.2011
gi.conference.locationKaiserslautern
gi.conference.sessiontitleRegular Research Papers

Dateien

Originalbündel
1 - 1 von 1
Vorschaubild nicht verfügbar
Name:
410.pdf
Größe:
578.69 KB
Format:
Adobe Portable Document Format
Herunterladen

Sammlungen

P180 - BTW2011 - Datenbanksysteme für Business, Technologie und Web