A Coherent Distributed Grid Service for Assimilation and Unification of Heterogeneous Data Source

TL;DR

This paper introduces a lightweight, coherent grid service that enables seamless integration and querying of heterogeneous data sources by mapping schemas and converting queries, facilitating unified data access in distributed environments.

Contribution

It proposes a novel, easy-to-install grid service that handles schema heterogeneity, allowing unified data access across diverse distributed data sources.

Findings

Successfully maps central SQL schema to heterogeneous sources

Enables query conversion and data retrieval from diverse databases

Simplifies integration of heterogeneous data in grid environments

Abstract

Grid services are heavily used for handling large distributed computations. They are also very useful to handle heavy data intensive applications where data are distributed in different sites. Most of the data grid services used in such situations are meant for homogeneous data source. In case of Heterogeneous data sources, most of the grid services that are available are designed such a way that they must be identical in schema definition for their smooth operation. But there can be situations where the grid site databases are heterogeneous and their schema definition is different from the central schema definition. In this paper we propose a light weight coherent grid service for heterogeneous data sources that is very easily install. It can map and convert the central SQL schema into that of the grid members and send queries to get according results from heterogeneous data sources.