Normalization and Denormalization for a Document-Oriented Data

Shady Hamouda, Mohammed Anbar, Omar Elejla

2023

Abstract

Recently, the challenge of the increasing volume of data has led to the presentation of the “not only structured query language (NoSQL) database”. One of the most powerful types of NoSQL databases is the document-oriented database that supports a flexible schema. Normalization of the data model is one of the important research issues and there are no standard principles of normalization in the document-oriented database. Handling relationships based on normalization and denormalization has not been considered in document-oriented databases despite its importance probably because it is not recommended in creating a collection for each entity or using a reference document for all because of the need to execute a complex joint operation. Recently, many researchers have migrated from relational databases to document-oriented databases. However, their migration methods are facing issues; first is no method to normalize or de-normalize data to implement the embedded and reference document. Second, migration from a relational database to a document-oriented database does not consider how to handle various types of relationships based on normalization and de-normalization. This study proposed a way to deal with migration problems by enhancing transformation rules to map entity relational schema to document-based data schema based on normalization and denormalization data. The results of this study show that the dataset size determines whether reference or embedded documents should be used for migration.

Paper Citation

in Harvard Style

Hamouda S., Anbar M. and Elejla O. (2023). Normalization and Denormalization for a Document-Oriented Data. In Proceedings of the 15th International Conference on Agents and Artificial Intelligence - Volume 3: ICAART, ISBN 978-989-758-623-1, pages 972-979. DOI: 10.5220/0011868100003393

in Bibtex Style

@conference{icaart23,
author={Shady Hamouda and Mohammed Anbar and Omar Elejla},
title={Normalization and Denormalization for a Document-Oriented Data},
booktitle={Proceedings of the 15th International Conference on Agents and Artificial Intelligence - Volume 3: ICAART,},
year={2023},
pages={972-979},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011868100003393},
isbn={978-989-758-623-1},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 15th International Conference on Agents and Artificial Intelligence - Volume 3: ICAART,
TI - Normalization and Denormalization for a Document-Oriented Data
SN - 978-989-758-623-1
AU - Hamouda S.
AU - Anbar M.
AU - Elejla O.
PY - 2023
SP - 972
EP - 979
DO - 10.5220/0011868100003393