Conceptual Mappings to Convert Relational into NoSQL Databases

Sometimes, data belonging to Relational databases need to be transferred to NoSQL ones. However, the data conversion process between Relational to NoSQL databases is considered as not trivial, since it is necessary to have considerable knowledge about the data models at hand. Regarding the structural heterogeneity underlying this problem, we propose an approach, named as R2NoSQL, which defines conceptual mappings to enhance the data conversion process. In this paper, we present our approach and some implementation and experimental results, which show that, by using the defined conceptual mappings, we obtain a consistent target NoSQL database with respect to a source Relational one.

• Publication year

  2016

• Venue

  International Conference on Enterprise Information Systems

• Publication date

  2016-04-25

• Fields of study

  Computer Science

• Identifiers
  DOI 10.5220/0005836301740181
• External record

  Open on Semantic Scholar

• Source metadata

  Semantic Scholar

• No claims are published for this paper.

• No concepts are published for this paper.

• From Relational Database to Column-Oriented NoSQL Database: Migration Process

  2015cited by this paper
• Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation

  2015cited by this paper
• Database Migration from Structured Database to non-Structured Database

  2015cited by this paper
• Schema Conversion Model of SQL Database to NoSQL

  2014cited by this paper
• Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence

  2013influential reference
• A flexible hash table design for 10GBPS key-value stores on FPGAS

  2013cited by this paper
• Survey on NoSQL database

  2011influential reference
• Cassandra: a decentralized structured storage system

  2010cited by this paper

• Abordagem de migração de bases relacionais para bases orientadas a documentos apoiada por LLM

  2025cites this paper
• DaMoOp: A global approach for optimizing denormalized schemas through a multidimensional cost model

  2025cites this paper
• FACT-DM: A Framework for Automated Cost-Based Data Model Transformation

  2024cites this paper
• Data Modeling for Connected Data - A systematic literature review

  2024influential citation
• Data Migration from Conventional Databases into NoSQL: Methods and Techniques

  2023cites this paper
• How to Optimize the Environmental Impact of Transformed NoSQL Schemas through a Multidimensional Cost Model?

  2023cites this paper
• A Novel Approach for Migrating Relational Databases into Graph Databases

  2023cites this paper
• Enabling schema-independent data retrieval queries in MongoDB

  2023cites this paper
• Hadoop as a Service: Integration of a Company’s Heterogeneous Data to a Remote Hadoop Infrastructure

  2022cites this paper
• Assuring Referential Integrity in Blockchain Applications

  2022cites this paper
• Translating a Distributed Relational Database to a Document Database

  2022cites this paper
• Building a Document-Oriented Warehouse Using NoSQL

  2021cites this paper
• Mapping rules for schema transformation : SQL to NoSQL and back

  2021cites this paper
• Exploring data structure alternatives in the RDB to NoSQL document store conversion process

  2021cites this paper
• Query-Based Metrics for Evaluating and Comparing Document Schemas

  2020cites this paper
• ANALYTICAL EVALUATION OF STRUCTURED TO UNSTRUCTURED DATABASE FOR LARGE VOLUME OF E-COMMERCE DATASET

  2020cites this paper
• Schema design advisor model for RDBMS to NoSQL database migration

  2020cites this paper
• QBMetrics: A Tool for Evaluating and Comparing Document Schemas

  2020cites this paper
• ModelDrivenGuide: An Approach for Implementing NoSQL Schemas

  2020cites this paper
• Advanced Information Systems Engineering: CAiSE Forum 2020, Grenoble, France, June 8–12, 2020, Proceedings

  2020cites this paper
• Conceptualization and Non-Relational Implementation of Ontological and Epistemic Vagueness of Information in Digital Humanities

  2019cites this paper
• Language Integrated Query as a Canonical Data Model for Virtual Data Integration

  2019influential citation
• Transformation of Schema from Relational Database (RDB) to NoSQL Databases

  2019cites this paper
• Toward RDB to NoSQL: transforming data with metamorfose framework

  2019cites this paper
• Secured Data Conversion, Migration, Processing and Retrieval between SQL Database and NoSQL Big Data

  2018cites this paper
• Approche dirigée par les modèles pour l'implantation de bases de données massives sur des SGBD NoSQL. (MDA-based Approach for implementing Big Data on NoSQL systems)

  2018cites this paper
• Modélisation NoSQL des entrepôts de données multidimensionnelles massives. (Modeling Multidimensional Data Warehouses into NoSQL)

  2016cites this paper