Article in Proceedings INPROC-2011-36

BibliographySchiller, Oliver; Schiller, Benjamin; Brodt, Andreas; Mitschang, Bernhard: Native support of multi-tenancy in RDBMS for software as a service.
In: EDBT.
University of Stuttgart, Faculty of Computer Science, Electrical Engineering, and Information Technology.
pp. 117-128, english.
ACM, January 2011.
Article in Proceedings (Conference Paper).
CR-SchemaH.2.1 (Database Management Logical Design)
H.2 (Database Management)
Abstract

Software as a Service (SaaS) facilitates acquiring a huge number of small tenants by providing low service fees. To achieve low service fees, it is essential to reduce costs per tenant. For this, consolidating multiple tenants onto a single relational schema instance turned out beneficial because of low overheads per tenant and scalable man- ageability. This approach implements data isolation between ten- ants, per-tenant schema extension and further tenant-centric data management features in application logic. This is complex, dis- ables some optimization opportunities in the RDBMS and repre- sents a conceptual misstep with Separation of Concerns in mind. Therefore, we contribute first features of a RDBMS to support tenant-aware data management natively. We introduce tenants as first-class database objects and propose the concept of a tenant con- text to isolate a tenant from other tenants. We present a schema inheritance concept that allows sharing a core application schema among tenants while enabling schema extensions per tenant. Fi- nally, we evaluate a preliminary implementation of our approach.

Full text and
other links
http://doi.acm.org/10.1145/1951365.1951382
Department(s)University of Stuttgart, Institute of Parallel and Distributed Systems, Applications of Parallel and Distributed Systems
Entry dateMay 24, 2011
   Publ. Department   Publ. Institute   Publ. Computer Science