Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema

Big data is a crucial issue that has emerged as one of the most important technologies in the modern world. Most studies have highlighted the inability of a relational database to handle big data. This challenge has led to the presentation of the “not only structured query language (NoSQL) database”...

Full description

Saved in:

Bibliographic Details
Main Author:	M S, Hamouda Shady
Format:	Thesis
Language:	English
Published:	2020
Subjects:	QA75.5-76.95 Electronic computers Computer science
Online Access:	http://eprints.usm.my/54797/1/HAMOUDA%20SHADY%20M%20S%20-%20TESIS%20cut.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-usm-ep.54797
record_format	uketd_dc
spelling	my-usm-ep.547972022-09-20T02:10:03Z Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema 2020-07 M S, Hamouda Shady QA75.5-76.95 Electronic computers. Computer science Big data is a crucial issue that has emerged as one of the most important technologies in the modern world. Most studies have highlighted the inability of a relational database to handle big data. This challenge has led to the presentation of the “not only structured query language (NoSQL) database” as a new concept of database technology. One of the most powerful types of NoSQL databases is the document-oriented database that supports a flexible schema and store data in a semi-structured format. Recently, many researchers have migrated from relational databases to document-oriented databases because of scalability, availability, and performance. However, their migration methods are facing three issues; the first issue is that there are no specifications that can be recognized to define a schema for a document-oriented database, and second, there is no method to normalize or de-normalize data in order to implement the embedded and reference document. The third is the migration from the relational database to a document-oriented database does not consider all the properties of the former, especially on how to handle various types of relationships. This study proposed a methodology to handle the migration issues through three phases: first, design a document-oriented data schema (DODS) based on the entity-relational (ER) model; second, enhance transformation rules to map the entity relational schema to the document-oriented data schema based on normalization and de-normalization data; third, migrate a relational database to a document-oriented database. 2020-07 Thesis http://eprints.usm.my/54797/ http://eprints.usm.my/54797/1/HAMOUDA%20SHADY%20M%20S%20-%20TESIS%20cut.pdf application/pdf en public phd doctoral Universiti Sains Malaysia Pusat Pengajian Sains Komputer
institution	Universiti Sains Malaysia
collection	USM Institutional Repository
language	English
topic	QA75.5-76.95 Electronic computers Computer science
spellingShingle	QA75.5-76.95 Electronic computers Computer science M S, Hamouda Shady Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema
description	Big data is a crucial issue that has emerged as one of the most important technologies in the modern world. Most studies have highlighted the inability of a relational database to handle big data. This challenge has led to the presentation of the “not only structured query language (NoSQL) database” as a new concept of database technology. One of the most powerful types of NoSQL databases is the document-oriented database that supports a flexible schema and store data in a semi-structured format. Recently, many researchers have migrated from relational databases to document-oriented databases because of scalability, availability, and performance. However, their migration methods are facing three issues; the first issue is that there are no specifications that can be recognized to define a schema for a document-oriented database, and second, there is no method to normalize or de-normalize data in order to implement the embedded and reference document. The third is the migration from the relational database to a document-oriented database does not consider all the properties of the former, especially on how to handle various types of relationships. This study proposed a methodology to handle the migration issues through three phases: first, design a document-oriented data schema (DODS) based on the entity-relational (ER) model; second, enhance transformation rules to map the entity relational schema to the document-oriented data schema based on normalization and de-normalization data; third, migrate a relational database to a document-oriented database.
format	Thesis
qualification_name	Doctor of Philosophy (PhD.)
qualification_level	Doctorate
author	M S, Hamouda Shady
author_facet	M S, Hamouda Shady
author_sort	M S, Hamouda Shady
title	Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema
title_short	Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema
title_full	Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema
title_fullStr	Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema
title_full_unstemmed	Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema
title_sort	migration from a relational database to a document-oriented database based on document-oriented data schema
granting_institution	Universiti Sains Malaysia
granting_department	Pusat Pengajian Sains Komputer
publishDate	2020
url	http://eprints.usm.my/54797/1/HAMOUDA%20SHADY%20M%20S%20-%20TESIS%20cut.pdf
_version_	1747822293905571840

Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema

Similar Items