Distributed Relational Database Management System on PVM

Abstract

The possibility of enhancing parallel virtual machine (PVM) to support the distributed relational database management system (DRDBMS) can be realised by employing POSTGRES. The processing power can be increased by connecting the existing computers together. Large and complex data can be divided into portions, which are concurrently manipulated by using PVM. The work employs the reusability of POSTGRES to support relational database management system and PVM to support parallel processing. The utilization of these both systems brings about distributed relational database management system. The architecture of this system is twofold: data management and user interface. POSTGRES is employed to manage the data, whereas PVM is employed as an interface between users and the database system.

The design of distributed relational database management system on PVM requires additional programming to manage the data such as accessing and storing the data. Structured query language(SQL) is embedded to PVM. PVM is composed of heterogeneous workstations, which run byUNIX operating system; therefore, it is easier to access the distributed data from any heterogeneous workstation. The technique of data partitioning, which divides the data into portions, is also addressed.

Keywords : Distributed Relational Database Management System / Parallel Processing/ PVM /POSTGRES / SQL / Data Partitioning