A new hybrid schema-sharing technique for multitenant applications

Abstract

This paper presents a new schema-sharing technique for multitenant applications. Our approach is built on top of the Extension table method and makes use of the native XML data support to store the additional data supplied by each tenant. Our proposed technique can be used to implement multitenancy on top of a standard relational database. This paper also describes an implementation of our approach using a real-world case study aiming at improving the communication channel of information related to drinking water quality parameters used by all stakeholders involved in the water treatment process in Ireland. These include the Environmental Protection Agency, the Health Service Executive, drinking water treatment plant staff, local authorities and everybody consuming water.