Title: SaaS level database integration in cloud environment through database as a service

Authors: Trushna Parida; Sanjukta Pal; Anirban Sarkar

Addresses: Department of Computer Applications, National Institute of Technology, Durgapur, India ' Department of Computer Applications, National Institute of Technology, Durgapur, India ' Department of Computer Applications, National Institute of Technology, Durgapur, India

Abstract: Data retrieval from multiple heterogeneous cloud databases is a complex engineering task. Ensuring scalability, flexibility and data availability while integrating data from the multiple heterogeneous cloud databases are the major research issues in such task. A proper integration semantics for cloud databases and data retrieval through Database as a Service (DBaaS) can be helpful to solve those issues. In this paper, a graph semantic based model for SaaS level database integration (SLDI) has been proposed, which is useful towards realization of various cloud database integration approaches through services. Several important quality metrics like integration complexity, degree of consistency, degree of availability and degree of partitioning tolerance also have been defined over the proposed model. The proposed SLDI model is compatible with CAP (Consistence-Availability-Partitioning) theorem. Besides, the proposed approach is capable of handling data heterogeneity through service while ensuring scalability and flexibility in data retrieval from multiple cloud databases.

Keywords: database as a service; DBaaS; application service; data service; orchestration based integration; choreography based integration; query evaluation time.

DOI: 10.1504/IJSTM.2019.100049

International Journal of Services Technology and Management, 2019 Vol.25 No.3/4, pp.236 - 266

Available online: 29 May 2019 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article