Query translation for cloud databases
Shyam Kotecha, Minal Bhise, Sanjay Kumar Chaudhary · 2011
Due to features like on demand services, scalability and usage based pricing, today cloud computing has attracted many customers to move their applications to cloud. But cloud service providers are using different standards and frameworks which customer has to follow. There may be a case where customer wants to migrate data and application to another cloud service provider. In that case, code of application and structure of database must be modified according to the standard provided by new service provider which is very costly. This issue is regarded as cloud vendor lock-in. Work has already been done for providing techniques which can facilitate migration of data. But that technique is not providing support for transformation of query from one cloud to other. By taking Google App engine as one cloud service provider, algorithm can be developed to transform query supported by relational databases, SQL, to query supported by Google app engine datastore, Google Query Language (GQL). After that same algorithm can be generalized for any cloud datastore.