A native enhanced elastic extension tables multi-tenant database

Multi-tenancy is a cloud computing service that enables multiple customers to share the same software. The internet of things (IoT) is based on distributing devices and objects through the internet that needs an effective multi-tenant schema. Merging the multi-tenant structure with IoT systems becomes more challenging due to the different data types of IoT and workloads. There is a need to handle a massive amount of metadata by multi-tenant applications. This paper has two main aims to solve this problem. First, it proposes an enhanced elastic extension tables (E3T) schema to query the IoT database efficiently. Second, it proposes a Hybrid multi- tenant database (NXD-E3T) as a combination of the E3T and Native XML Database to reduce the response time and support a common query language. The proposed schema was implemented on an IoT benchmark. The simulation results show that the proposed NXD-E3T outperforms the other multi-tenant databases in terms of the query speed.