Data adapter for querying and transformation between SQL and NoSQL database

As the growing of applications with big data in cloud computing become popular, many existing systems expect to expand their service to support the explosive increase of data. We propose a data adapter system to support hybrid database architecture including a relational database (RDB) and NoSQL database. It can support query from application and deal with database transformation at the same time. We provide three modes of query approach in data adapter system: blocking transformation mode (BT mode), blocking dump mode (BD mode), and direct access mode (DA mode). We provide a data synchronization mechanism and describe the design and implementation in detail. This paper focuses on velocity with proposed three modes and partly variety with data stored in RDB, NoSQL database and temporary files. With the proposed data adapter system, we can provide a seamless mechanism to use RDB and NoSQL database at the same time. This paper presents data adapter to make possible the automated transformation of multi-structured data in Relational Database (RDB) and NoSQL systems.With the proposed data adapter, a seamless mechanism is provided for constructing hybrid database systems.With the proposed data adapter, hybrid database systems can be performed in an elastic manner, i.e., access can be either RDB or NoSQL, depending on the size of data.