Data Migration From SQL to MongoDB Article Swipe
YOU?
·
· 2018
· Open Access
·
· DOI: https://doi.org/10.29042/2018-3701-3704
· OA: W2904868740
As the Internet related technologies have emerged, a lot of changes were observed in the data collected, stored and processed by the organizations.The new incoming data was unstructured, available from a number of outside areas and accumulated in large volumes within a small time span.It was realized the traditional system is inefficient to handle this data.Solution to that is NoSQL type database.The databases that belong to this category are highly scalable, powerful and efficient.But the problem that occurs with these databases is they don't use the traditional SQL (Structured Query language) to query the data.Hence it is difficult to migrate data from existing traditional databases to the NoSQL databases and develop efficient and optimized functions to query the data under these NoSQL databases.Various tools are available which have the capabilities to address this, but none of them actually provide a complete integrated system for efficiently doing this.This paper proposes an architecture which will provide a GUI Application that will provide the users with a click and use Querying feature with Data Migration and Automatic Query Conversion.MongoDB is the most slanting database for NoSQL, therefore our proposed system focuses on these perspectives with reference to MongoDB.
