3 research outputs found
UTILISING NETWORKED WORKSTATIONS TO ACCELERATE DATABASE QUERIES
The rapid growth in
the size of databases and the advances made in Query Languages has resulted in increased SQL query complexity submitted by users, which in turn slows down the speed of information retrieval from the database.
The future of high performance database systems lies in parallelism. Commercial
vendors´ database systems have introduced solutions but these have proved to be
extremely expensive.
This paper investagetes how networked resources such as workstations can be
utilised by using Parallel Virtual Machine (PVM) to Optimise Database Query Execution. An investigation and experiments of the scalability of the PVM are conducted. PVM is
used to implement palallelism in two separate ways:
(i) Removes the work load for deriving and maintaining rules from the
data server for Semantic Query Optimisation, therefore clears the way for more
widespread use of SQO in databases [16], [5].
(ii) Answers users queries by a proposed Parallel Query Algorithm PQA
which works over a network of workstations, coupled with a sequential Database
Management System DBMS called PostgreSql on the prototype called Expandable
Server Architecture ESA [11], [12], [21], [13].
Experiments have been conducted to
tackle the problems of Parallel and Distributed systems such as task
scheduling, load balance and fault tolerance
Using A Network of workstations to enhance Database Query Processing Performance
Query processing in database systems may be improved by applying parallel processing techniques. One reason for improving query response time is to support the increased number queries when databases are made accessible from the Internet