Fine-grain vs. coarse-grain web-service for ETL correctness and performance in cloud databases

Cloud services can be consumed using web service calls through the APIs provided by the cloud provider. Although using a fine-grained web-service request allows better flexibility of services, this approach will require service consumers to make multiple service requests to the cloud. The cloud will end up receiving a significantly higher number of requests, lowering the performance and increasing latency. The fine-grain APIs can also leave the data in an inconsistent state and create maintenance problems. Using coarse-grain requests will reduce the load on the server, especially necessary for cloud PAAS (Platform as a service) with governor limits on the number of API requests. In our research, we have proved that encapsulating multiple objects in a single API request will also improve the bandwidth, latency and API consumption for cloud PAAS.