#BlackLivesMatter Support the Equal Justice Initiative

NoSQL conceptual modeling

Conceptual modeling for NoSQL

Conceptual models such as the entity-relationship (ER) model have proved incredibly useful for relational database design. One of the goals of this line of research is to understand how conceptual models can be used for modeling NoSQL databases. This includes understanding how changes to a databases conceptual model may effect both the schema and the data stored in the underlying database.

Database renormalization

Constructing a normalized model from a NoSQL database is a challenging problem. Traditional normalization algorithms such as lossless join BCNF decomposition fail to appropriately handle the forms of denormalization present in NoSQL databases. Appropriate algorithms for constructing a normalized schema from NoSQL databases are a critical step in performing meaningful data integration with other sources.

An implementation of our ESON normalization algorithm is available on GitHub


CoDEvo: Column family database evolution using model transformations
Pablo Suárez-Otero, Michael J. Mior, Maria José Suárez-Cabal, Javier Tuya
Journal of Systems and Software

Maintaining NoSQL Database Quality During Conceptual Model Evolution
Pablo Suárez-Otero, Michael J. Mior, Maria José Suárez-Cabal, Javier Tuya
6th International Workshop on Methods to Improve Big Data Science Projects

Renormalization of NoSQL Database Systems
Michael J. Mior, Kenneth Salem ER '18 Proceedings of the 36th International Conference on Conceptual Modeling, 2018