Authors:
Shady Hamouda
1
;
Mohammed Anbar
2
and
Omar Elejla
3
Affiliations:
1
Department of Business Information Technology, Liwa College of Technology, Abu Dhabi 51133, U.A.E.
;
2
National Advanced IPv6 (NAv6) Centre, University Sains Malaysia, USM, Penang 11800, Malaysia
;
3
Department of Computer Science, Al-Aqsa University, Gaza 4051, Palestine
Keyword(s):
Normalization, Embedded, Reference Document, NoSQL, Document-Oriented Database.
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.
(More)