The Transformation of RDB to NoSQL DB

In the past, Relational Database (RDB) is widely used to access data quickly because of high data accuracy and consistency. However, the Big Data era forces many industries to change RDB in order to process a huge amount of data in time. NoSQL (Not only SQL) database (NoSQL DB) is a tailor-made DB. Various industries can choose a suitable NoSQL DB to enhance their competitiveness according to their operational needs. But the data in RDB still need to be saved for company’s operation. How to convert data from RDB to NoSQL DB is an important issue. This paper proposes an algorithm to transfer an RDB to the Wide Column Store DB (WCSDB), one of the most popular NoSQL databases. The experiment results show that WCSDB performs better than RDB.