Distributed Query Performance Evaluation And Analysis On Fragmentation Services In Distributed DBMS Using JDBC And OGSA-DAI

Loading...
Thumbnail Image
Date
2008-06
Authors
Al-Madi, Ahmed Azmi Qasem
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
In parallel and distributed systems environment, fragmentation design impact and the rapid development is nowadays taking big consideration of programmers and researchers. OGSA-DAI middleware is one of these new developments and its impact regarding performance on the distributed and grid environment is taking a big consideration of the researchers. Since the OGSA-DAI is structured of several layers, the processing time and communication time through the several layers shows a noticeable time overhead among the retrieval system on the fragmented database. In addition, when it comes to design the distributed system, a non-positive impact is clearly shown on several cases while applying the fragmentation regarding a time overhead impact. This thesis investigates and evaluate the impact of the fragmentation on different database retrieval modes based on derived horizontal fragmentation by generating and distributing the query to the servers (distributed search) or send the query to the direct server (direct search). Moreover, it provides recommendation on suitable query execution strategies based on a proposed fitness fragmentation formula. Furthermore, examine the suitable technology such as OGSA-DAI and JDBC in grid database to examine the time overhead in distributed systems and grid environments in different cases like size or number of servers. The results show that the fragmentation's time perfonnance impact is clearly effective and positively applied while increasing the database size or the number of servers. On the other hand, the OGSA-DAI kept on showing slower execution time on all conducted scenarios, and the differences between the execution time exceeds up to 70% while increasing the size of data or number of servers. In addition, this thesis has tested the impact of fragmentation search against the distributed search where the first one submit the query to direct server(s) (direct search), and the second one distribute the query to the servers (distributed search). The result shows that the speed effectiveness of direct search technique in JDBC case is around 70% faster than the distributed search and around 50% faster in OGSA-DAI case.
Description
Keywords
Fragmentation Services , JDBC And OGSA-DAI
Citation