SURVEY ON DATABASE DESIGN FOR SAAS CLOUD APPLICATION

Data management and sharing is the challenge being faced by all the IT majors today. Adds over it, is the challenge faced by the cloud service providers in terms of multi-tenancy of data and its efficient retrieval. It becomes more complex in a heterogeneous computing environment to provide cloud services. A simple, robust, query efficient, scalable and space saving multi-tenant database architecture is proposed for SaaS model of cloud architecture where organizations can collaborate to create a cloud, that doesn’t harm their existence or profitability. In the survey we find that many multitenant designs are available for implementation the best being the extension table approach which solves the null value problem.