Paper Info
Title
Toward RDB to NoSQL - transforming data with metamorfose framework.
Abstract
The emergence of applications dealing with structured, semi structured, and non-structured data created demands on new data storage systems. The relational model, widely used to store data from diverse applications, does not meet all the imposed scenarios. In response, NoSQL databases have emerged as an option. As a consequence, new approaches for converting the relational model to NoSQL models have been created. However, most of them target a specific NoSQL model and provide little (or none) support for customization for transformations with different cardinalities. In this paper we present a novel approach to convert relational databases (RDB) to document and column family NoSQLs. Our approach receives as input a set of directed acyclic graphs (DAG) representing the target NoSQL model. The DAGs are used to generate commands to transform the input RDB data. The approach supports different cardinalities, and the commands can be customized. We have developed a tool to interpret the DAGs and that supports different transformation strategies. We performed experiments to validate our solution, with different configurations, where conversions were carried out to document and column-family storage.
Year
DOI
Venue
2019
10.1145/3297280.3299734
SAC
Keywords
Field
DocType
NoSQL databases, data mapping, data transformation, database conversion, relational databases
Relational database,Computer data storage,Data mapping,Computer science,Cardinality,Directed acyclic graph,NoSQL,Relational model,Database,Personalization
Conference
ISBN
Citations 
PageRank 
978-1-4503-5933-7
0
0.34
References 
Authors
0
3
Name
Order
Citations
PageRank
Evandro Miguel Kuszera100.34
Leticia Mara Peres214.41
Marcos Didonet Del Fabro327334.14