Transforming RDB with BLOB fields to MongoDB

Abstract

Recently the No-SQL databases has been popularly used in the mobile and web applications. There are several types of No-SQL databases such as columnar, key-value, graph databases and finally the document store database which is efficient and has more dynamic queries than the normal RDBMS. This paper proposes an automatic method to map the data from the relational database to document store database (MONGODB). This is true for both structured and unstructured data such as word document files. The proposed method also has the capability of extracting the keywords from Blobs “Binary Large Object” Stored in relational databases to be mapped inside the MONGODB. The results show a complexity of order n where n is the number of records processed when it comes to the performance in creating the output from mapping the relational database to document store database for both types of data.