Asynchronous data translation framework for converting relational tables to document stores. Issue 1 (2nd January 2016)

• Record Type: Journal Article
• Authors: Ma, Kun; Yang, Bo; Abraham, Ajith
• Is Part Of: International journal of computers and applications. Volume 38:Issue 1(2016)
• Page Start: 19
• Page End: 28
• Publication Date: 2016-01-02
• Subjects: Relational table -- document store -- NoSQL -- asynchronous translation -- migration; Computers -- Periodicals; Computer software -- Periodicals; Computer networks -- Periodicals; Multimedia systems -- Periodicals; Internet -- Periodicals; World Wide Web -- Periodicals; Minicomputers -- Periodicals; Microcomputers -- Periodicals; 004.05
• DOI: 10.1080/1206212X.2016.1188563
• Languages: English
• ISSNs: 1206-212X

Abstract

Abstract : Although Not Only SQL (NoSQL) techniques have some new features such as query optimization and caching in the era of big data, it is not mature enough to replace traditional Relational Database Management System (RDBMS). In a long period of time, the hybrid solution of RDBMS and NoSQL is a main steam technology. In this paper, we present an asynchronous data framework to translate relational tables into schema-free document stores. The challenge of this framework is how to ensure that the translation is transparent and pervasive to the application with minimal impact on RDBMS performance. To better describe the translation process, we present the intermediate cell state model (CSM) to describe versioning incremental state. We address this challenges by translating the binary log of RDBMS to CSM repository, and the repository is reset to the NoSQL when encountering schema adjustment asynchronously. Finally, we leverage the CSM rectification algorithm and NoSQL synchronization algorithm to implement the whole framework. The experimental results illustrate that this translation has a less minimal impact on RDBMS performance and lower cost than other solutions.