A Unified Metamodel for NoSQL and Relational Databases
Carlos J. Fern\'andez Candel, Diego Sevilla Ruiz, Jes\'us J. Garc\'ia-Molina

TL;DR
This paper introduces U-Schema, a unified metamodel capable of representing schemas across NoSQL and relational databases, facilitating data migration, integration, and handling structural variability.
Contribution
The paper presents U-Schema, a comprehensive metamodel that unifies schema representation for multiple NoSQL paradigms and relational databases, including new features like entity-relationship distinction and variability support.
Findings
Successfully formalized mappings between U-Schema and data models
Implemented schema extraction strategies for schemaless systems
Addressed performance and scalability in the metamodel implementation
Abstract
The Database field is undergoing significant changes. Although relational systems are still predominant, the interest in NoSQL systems is continuously increasing. In this scenario, polyglot persistence is envisioned as the database architecture to be prevalent in the future. Multi-model database tools normally use a generic or unified metamodel to represent schemas of the data model that they support. Such metamodels facilitate developing utilities, as they can be built on a common representation. Also, the number of mappings required to migrate databases from a data model to another is reduced, and integrability is favored. In this paper, we present the U-Schema unified metamodel able to represent logical schemas for the four most popular NoSQL paradigms (columnar, document, key-value, and graph) as well as relational schemas. We will formally define the mappings between U-Schema…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
