Distributed Query Performance Evaluation And Analysis On Fragmentation Services In Distributed DBMS Using JDBC And OGSA-DAI
Loading...
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