Bibliography | Schiller, 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-Schema | H.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 date | May 24, 2011 |
---|