On the trade-offs between the file redundancy and the communication costs in distributed database systems

In distributed database systems (DDBS), the utmost purpose of data distribution and replication aims at shrinking transmission costs (TC), including communication costs, and response time. In this chapter, therefore, an enhanced heuristic clustering-based technique for data fragmentation and replicated based allocation is efficaciously presented. This work is mainly sought to further enhance an existing technique so TC is to be significantly minimized. In fact, the approached enhancement is applied by suggesting different replication scenarios. Off these scenarios, one scenario is to be selected based on competitive performance evaluation process. DDBS performance is measured via its being exposed on objective function (TC). Despite the fact that this work is mildly improved, yet evaluation results show that it has been promising, particularly as TC being the foremost design objective of DDBS System. Experimental results have been analyzed under all presented scenarios as an internal evaluation and are vividly provided to demonstrate the undeniable impact of data replication on DDBS performance.

Download Full-text

A Novel Query-Driven Clustering-Based Technique for Vertical Fragmentation and Allocation in Distributed Database Systems

International Journal on Semantic Web and Information Systems ◽

10.4018/ijswis.2017040103 ◽

2017 ◽

Vol 13 (2) ◽

pp. 27-54 ◽

Cited By ~ 5

Author(s):

Adel A. Sewisy ◽

Ali A. Amer ◽

Hassan I. Abdalla

Keyword(s):

Database Systems ◽

Distributed Database ◽

Communication Costs ◽

Design Objective ◽

Empirical Results ◽

Distributed Database Systems ◽

Allocation Process ◽

Vertical Fragmentation ◽

Initial Stage ◽

Data Statistics

In this paper, heuristic query-driven clustering-based vertical fragmentation technique is efficiently developed. The intrinsic idea is to meet the idealistic case of DDBS design which comes to happen as each query attune “closely match” its relevant fragment. The proposed technique is mainly sought to breed clusters of queries in the first place. Consequently, these clusters would be tacitly used to generate intended disjoint fragments. Moreover, the allocation process has been considered so that replicated and non-replicated scenarios of data are applied. This technique basically meant to be efficaciously applicable at the initial stage of DDBS design without the need for data statistics or empirical results, in either dynamic or static DDBS environment. Many existing design-related techniques are being incorporated to make a promising work, particularly as communication costs being the foremost design objective. Throughout this work, the experimental results and internal evaluation are extensively illustrated to demonstrate the effectiveness and validity of proposed technique.

Download Full-text

Performance Evaluation of Distributed Database Systems

INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY ◽

10.24297/ijct.v13i9.2383 ◽

2014 ◽

Vol 13 (9) ◽

pp. 4859-4867

Author(s):

Khaled Saleh Maabreh

Keyword(s):

Performance Evaluation ◽

System Performance ◽

Operation Mode ◽

Database Systems ◽

Distributed Database ◽

Evaluation Study ◽

Distributed Database Systems ◽

Different Types ◽

Distributed Database System ◽

Distributed Database Management

Distributed database management systems manage a huge amount of data as well as large and increasingly growing number of users through different types of queries. Therefore, efficient methods for accessing these data volumes will be required to provide a high and an acceptable level of system performance. Â Data in these systems are varying in terms of types from texts to images, audios and videos that must be available through an optimized level of replication. Distributed database systems have many parameters like data distribution degree, operation mode and the number of sites and replication. These parameters have played a major role in any performance evaluation study. This paper investigates the main parameters that may affect the system performance, which may help with configuring the distributed database system for enhancing the overall system performance.

Download Full-text