An Implementation of Enhanced Multi-tenancy Database Design in IoT System

Since the Internet of Things (IoT) has become more and more important, additional designs should be proposed daily to adapt the specificities introduced by this systems of the physical world (Sensors and Actuators) and the public networks (The Internet). Some of these solutions use a Cloud Computing and Multi-tenancy structures as Multi-tenancy increases resource and utilization as well as sharing the same database instance to multiple tenants. Multi-tenancy, which lets multiple tenants share a single application instance securely, is a key enabler for building such a middleware. However, merging the multi-tenancy structure with IoT systems becomes more and more challenging due to the different data types of IoT and the multi-tenancy design should adapt to tenants workloads and fit their special requirements and the fact that the multi-tenant database is shared between multiple tenants. Therefore, this paper presents An Implementation of Enhanced Multi-tenancy Database Design in IoT System which should allow the IoT system to store its data in a multi-tenant environment with less cost and better performance based on the Enhanced Elastic Extension Tables (E3T) and Native XML Database (NXD). The presented implementation achieves high scalability and increases performance for tenants who need those requirements to intermediate with a simple IoT system.