Distributed Database System (DSS) Design Over a Cloud Environment

Raouf, Ahmed E. Abdel; Badr, Nagwa L.; Tolba, Mohamed F.

doi:10.1007/978-3-319-44270-9_5

Cited by 18 publications

(3 citation statements)

References 24 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Figure 5 shows the number of proposals related to each type of fragmentation. Articles [ 1 , 2 , 3 , 38 , 39 , 40 , 41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 , 53 , 54 , 55 , 56 , 57 , 58 , 59 , 60 , 61 , 62 , 63 , 64 , 65 , 66 ] focus on horizontal fragmentation; while [ 7 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 ] consider vertical partitioning, [ 67 , 68 , 69 , 70 , 71 , 72 ,…”

Section: Discussionmentioning

confidence: 99%

“…Figure 4 shows a bar graph that relates the number of articles to the publisher; most of the articles are concentrated in the Springer publishing house. Springer’s articles primarily addressed vertical ([ 22 , 24 , 25 , 26 , 32 , 33 , 34 , 36 ]) and horizontal ([ 1 , 43 , 46 , 47 , 51 , 55 , 58 , 59 , 63 , 66 ]) fragmentation, 18 of 26 articles. Only one article considers both fragmentation and CBIR ([ 1 ]).…”

Section: Classification Of Research Papersmentioning

confidence: 99%

“…Abdel et al [ 58 ] developed an improved dynamic system of distributed databases on a cloud environment, which allows them to dynamically make fragmentation, allocation, and replication decisions at runtime. Experiments were performed on a table containing data on bank user accounts.…”

Section: Description Of the Set Of Work By Categorymentioning

confidence: 99%

See 2 more Smart Citations

Application of Dynamic Fragmentation Methods in Multimedia Databases: A Review

Castro-Medina

Rodríguez-Mazahua

López-Chau

et al. 2020

Entropy

View full text Add to dashboard Cite

Fragmentation is a design technique widely used in multimedia databases, because it produces substantial benefits in reducing response times, causing lower execution costs in each operation performed. Multimedia databases include data whose main characteristic is their large size, therefore, database administrators face a challenge of great importance, since they must contemplate the different qualities of non-trivial data. These databases over time undergo changes in their access patterns. Different fragmentation techniques presented in related studies show adequate workflows, however, some do not contemplate changes in access patterns. This paper aims to provide an in-depth review of the literature related to dynamic fragmentation of multimedia databases, to identify the main challenges, technologies employed, types of fragmentation used, and characteristics of the cost model. This review provides valuable information for database administrators by showing essential characteristics to perform proper fragmentation and to improve the performance of fragmentation schemes. The reduction of costs in fragmentation methods is one of the most desired main properties. To fulfill this objective, the works include cost models, covering different qualities. In this analysis, a set of characteristics used in the cost models of each work is presented to facilitate the creation of a new cost model including the most used qualities. In addition, different data sets or reference points used in the testing stage of each work analyzed are presented.

show abstract

Section: Discussionmentioning

confidence: 99%

Section: Classification Of Research Papersmentioning

confidence: 99%

See 1 more Smart Citation

Application of Dynamic Fragmentation Methods in Multimedia Databases: A Review

Castro-Medina

Rodríguez-Mazahua

López-Chau

et al. 2020

Entropy

View full text Add to dashboard Cite

show abstract

Dynamic data reallocation and replication over a cloud environment

Raouf

Badr

Tolba

2018

Concurrency and Computation

Self Cite

View full text Add to dashboard Cite

The performance and efficiency of the distributed database system (DDBS) design are dependent on proper data fragmentation, reallocation, and replication of global relations. In this research, a Cluster Based Distributed and Parallel Database System (CB-DDBS) architecture over a cloud environment is proposed. The proposed CB-DDBS architecture processes the client's query requests, which access the clustered DDBS from anywhere. It also allows vertical and horizontal fragmentation, allocation, and replication decisions to be taken statically at the initial stage of the design. In addition, it allows migration and/or replication decisions to be taken by each cluster independently of other clusters using the proposed Optimal Fragment Reallocation and Replication (OFRAR) Algorithm. The proposed CB-DDBS architecture and the proposed OFRAR Algorithm are tested in both Amazon cloud environment and a simulated environment. Experimental results show that the proposed OFRAR Algorithm efficiently reduces the communication costs for typical access patterns, the overloads of the sites, and the frequency and time spent on fragment migration over the network sites by imposing a stricter condition for fragment reallocation and replication, resulting in a great overall improvement in the DDBS performance. It also shows that the proposed CB-DDBS architecture results in a significant reduction of the execution time needed for the transactions and for noticing an error.

show abstract