Name
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 manageability. This approach implements data isolation between tenants, per-tenant schema extension and further tenant-centric data management features in application logic. This is complex, disables some optimization opportunities in the RDBMS and represents 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 context 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. Finally, we evaluate a preliminary implementation of our approach. |
Year | DOI | Venue |
|---|---|---|
2011 | 10.1145/1951365.1951382 | EDBT |
Keywords | Field | DocType |
data isolation,schema extension,small tenant,single relational schema instance,per-tenant schema extension,core application schema,low service fee,tenant context,native support,schema inheritance concept,multiple tenant,separation of concern,data model,relational database management system,data management,multi tenancy,relational database management systems,software as a service,logical data model | Data mining,Isolation (database systems),Computer science,Logical data model,Separation of concerns,Multitenancy,Software as a service,Database schema,Relational database management system,Data management,Database | Conference |
Citations | PageRank | References |
17 | 0.85 | 9 |
Authors | ||
4 | ||
Name | Order | Citations | PageRank |
|---|---|---|---|
| Oliver Schiller | 1 | 38 | 4.32 |
| Benjamin Schiller | 2 | 17 | 0.85 |
| Andreas Brodt | 3 | 110 | 10.91 |
| Bernhard Mitschang | 4 | 928 | 284.89 |