in.tum.de

Ruminations on Multi-Tenant Databases

Authors: 
Jacobs, Dean; Aulbach, Stefan

Abstract: This is a position paper on multi-tenant databases. As motivation, it first
describes the emerging marketplace of hosted enterprise services and the
importance of using multi-tenancy to handle high traffic volumes at low cost. It
then outlines the main requirements on multi-tenant databases: scale up by
consolidating multiple tenants onto the same server and scale out by providing an
administrative framework that manages a farm of such servers. Finally it describes
three approaches to implementing multi-tenant databases and compares them based

Year: 
2007

A Comparison of Flexible Schemas for Software as a Service

Authors: 
Aulbach, Stefan; Jacobs, Dean; Kemper, Alfons; Seibold, Michael

A multi-tenant database system for Software as a Service
(SaaS) should offer schemas that are flexible in that they
can be extended for different versions of the application and
dynamically modified while the system is on-line. This pa-
per presents an experimental comparison of five techniques
for implementing flexible schemas for SaaS. In three of these
techniques, the database “owns” the schema in that its struc-
ture is explicitly defined in DDL. Included here is the com-
monly-used mapping where each tenant is given their own
private tables, which we take as the baseline, and a map-

Year: 
2009
Syndicate content