Applied Sciences (Jun 2022)

AMANDA: A Middleware for Automatic Migration between Different Database Paradigms

  • Jordan S. Queiroz,
  • Thiago A. Falcão ,
  • Phillip M. Furtado,
  • Fabrício L. Soares,
  • Tafarel Brayan F. Souza,
  • Pedro Vitor V. P. Cleis,
  • Flavia S. Santos,
  • Felipe T. Giuntini

DOI
https://doi.org/10.3390/app12126106
Journal volume & issue
Vol. 12, no. 12
p. 6106

Abstract

Read online

In a world rich in interconnected and complex data, the non-relational database paradigm can better handle large volumes of data at high speed with a scale-out architecture, which are two essential requirements for large industries and world-class applications. This article presents AMANDA, a flexible middleware for automatic migration between relational and non-relational databases based on a user-defined schema that offers support for multiple sources and target databases. We evaluate the performance of AMANDA by assessing the migration speed, query execution, query performance, and migration correctness, from two Relational Database Management Systems (RBMSs), i.e., Postgres and MySQL, to a non-relational database (NoSQL), i.e., DGpraph. The results show that AMANDA successfully migrates data 26 times faster than previous approaches, when considering Northwind. Regarding the IMDB database, it took 7 days to migrate 5.5 GB of data.

Keywords