Abstract In software development, migration from a Data Base Management System (DBMS) to another, especially with distinct characteristics, is a challenge for programmers and database administrators. Changes in the application code in order to comply with new DBMS are usually vast, causing migrations infeasible. In order to tackle this problem, we present NoSQLayer, a framework capable to support conveniently migrating from relational (i.e., MySQL) to NoSQL DBMS (i.e., MongoDB). This framework is presented in two parts: (1) migration module; and, (2) mapping module. The first one is a set of methods enabling seamless migration between DBMSs (i.e. MySQL to MongoDB). The latter provides a persistence layer to process database requests, being capable to translate and execute these requests in any DBMS, returning the data in a suitable format as well. Experiments show NoSQLayer as a handful solution suitable to handle large volume of data (e.g., Web scale) in which traditional relational DBMS might be inept in the duty.
[1]
Nancy A. Lynch,et al.
Brewer's conjecture and the feasibility of consistent, available, partition-tolerant web services
,
2002,
SIGA.
[2]
Rick Cattell,et al.
Scalable SQL and NoSQL data stores
,
2011,
SGMD.
[3]
Jaroslav Pokorný,et al.
NoSQL databases: a step to database scalability in web environment
,
2011,
iiWAS '11.
[4]
John Roijackers.
Bridging SQL and NoSQL
,
2012
.
[5]
Kenneth Mark Anderson,et al.
MySQL to NoSQL: data modeling challenges in supporting scalability
,
2012,
SPLASH '12.
[6]
Roberto Ierusalimschy,et al.
Lua—An Extensible Extension Language
,
1996,
Softw. Pract. Exp..
[7]
Rabi Prasad Padhy,et al.
RDBMS to NoSQL: Reviewing Some Next-Generation Non-Relational Database's
,
2011
.