Applying Multi-tenancy Architecture For Isolation of Cloud Database

Abstract

This research provides the basic knowledge about multi-tenancy model for data isolation and multi-tenancy architecture For sharing between different tenants, customers. Also provides an overview of the different multi-tenancy approaches that has been used and focuses on how multi- tenancy model works. Cloud providers adopt multi-tenants architecture to maximize resource sharing among different tenants and customers of their application. Multi-tenancy enables cloud providers to achieve higher resource utilization and scalability as well as significantly reduce the operational costs, simplify maintenance, management effort by assigning and multiplexing the shared hardware and software resources across multiple tenants simultaneously. Each customer in multi-tenancy model is called a tenant. In database discipline the shared schema approach has the lowest hardware and backup costs, because it allows you to serve the largest number of tenants per database server. Because multiple tenants share the same database tables, which may incur additional development effort in the area of security to ensure that tenants can never access other tenants data. A secure login process ensures that the entire database is accessible only by an associated tenant. The tools used in this research are oracle 11g and VMware Player. The software user are oracle 11g x86 for building, managing, maintaining the database. VMware player for applying virtualization software package for x64 computers running on host windows 7 and connect to the database that is available on host machine. Design and implement a technique for multi-tenant database schema. The conclusion is using the same database and the same set of tables to host multiple tenant’s data (a records from multiple tenants stored in any order, a tenant_ID column associate every record with the appropriate tenant).