Secure and efficient multitenant database for an ad hoc cloud

Effectively utilizing, unlocking and harnessing the data is the key to the success of organizations in the time to come. Although the software development and delivery technologies are matured, yet people are forced to start from scratch, when they encounter a new project, thus inducing cost and delay. In the proposed solution Organizations can collaborate to create a Data-center, that doesn´t harm their existence or profitability. At the same time, these organizations can compete by spreading to those locations where they carry certain edge over others. This is where an ad-hoc cloud helps to venture into remote areas. We propose multitenancy for database in ad hoc cloud that helps multiple organizations to collaborate and yet compete with each other. In our proposed approach, shared database shared schema approach has been proposed that offers larger number of tenants per database server. Authentication and authorization are prime requirements when dealing with multitenancy. Kerberos authentication protocol is used on the top of multitenant database for participating educational institution.