Native support of multi-tenancy in RDBMS for software as a service
Native support of multi-tenancy in RDBMS for software as a service
复制标题
DOI：
10.1145/1951365.1951382
复制
发表时间：
2011-03
期刊：
影响因子：
--
通讯作者：
O. Schiller;Benjamin Schiller;Andreas Brodt;B. Mitschang
中科院分区：
文献类型：
--
作者：
O. Schiller;Benjamin Schiller;Andreas Brodt;B. Mitschang
软件即服务（SaaS）通过提供低服务费来帮助获得大量的小租户。为了实现低服务费，必须降低每个租户的成本。为此，将多个租户整合到一个关系模式实例上是有益的，因为每个租户的开销很低，而且可扩展。这种方法实现了租户之间的数据隔离、每租户模式扩展以及应用逻辑中以租户为中心的数据管理功能。这是复杂的，禁用了RDBMS中的一些优化机会，并且代表了关注点分离的概念性失误。因此，我们贡献了RDBMS的第一个功能来支持租户感知的数据管理。我们引入租户作为第一类数据库对象，并提出了租户上下文的概念，以隔离租户从其他租户。我们提出了一个模式继承的概念，允许共享租户之间的核心应用程序模式，同时使每个租户模式扩展。最后，我们评估我们的方法的初步实施。
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.