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”...
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | English |
| Published: |
2020
|
| Subjects: | |
| Online Access: | http://eprints.usm.my/54797/ http://eprints.usm.my/54797/1/HAMOUDA%20SHADY%20M%20S%20-%20TESIS%20cut.pdf |
| _version_ | 1848882904577343488 |
|---|---|
| author | M S, Hamouda Shady |
| author_facet | M S, Hamouda Shady |
| author_sort | M S, Hamouda Shady |
| building | USM Institutional Repository |
| collection | Online Access |
| 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. |
| first_indexed | 2025-11-15T18:42:20Z |
| format | Thesis |
| id | usm-54797 |
| institution | Universiti Sains Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T18:42:20Z |
| publishDate | 2020 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | usm-547972022-09-20T02:10:03Z http://eprints.usm.my/54797/ Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema 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 NonPeerReviewed application/pdf en http://eprints.usm.my/54797/1/HAMOUDA%20SHADY%20M%20S%20-%20TESIS%20cut.pdf M S, Hamouda Shady (2020) Migration From A Relational Database To A Document-Oriented Database Based On Document-Oriented Data Schema. PhD thesis, Universiti Sains Malaysia. |
| 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 |
| title | 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_short | 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 |
| topic | QA75.5-76.95 Electronic computers. Computer science |
| url | http://eprints.usm.my/54797/ http://eprints.usm.my/54797/1/HAMOUDA%20SHADY%20M%20S%20-%20TESIS%20cut.pdf |