What is it about?

NoSQL databases often have data which is denormalized and duplicated to improve query performance. This work is fully automated and uses data dependency analysis followed by modifications to traditional relational normalized algorithms to produce a normalized model.

Featured Image

Why is it important?

When working with an unfamiliar databases, this can make it challenging to understand relationships between different data structures. A normalized model is much easier to understand and utilize. While not explored fully in this work, It is also possible to use this model for query rewriting so users can write queries against an easily-understood normalized model and have them executed against the appropriate structure in the underlying database.

Perspectives

This work was a follow up on my earlier PhD research on NoSQL schema design. As we were looking forward to managing evolution of NoSQL database schema, the thought came as to what would happen to existing schemas created without a database design tool. These databases generally do not have any mapping to a meaningful normalized model meaning any changes to the conceptual model would need to be manually reflected in the database schema. The mapping produced as a byproduct of our normalization process enables this to be automated.

Assistant Professor Michael J. Mior
Rochester Institute of Technology

Read the Original

This page is a summary of: Renormalization of NoSQL Database Schemas, January 2018, Springer Science + Business Media, DOI: 10.1007/978-3-030-00847-5_34.
You can read the full text:

Read

Resources

Contributors

The following have contributed to this page