Heterogeneous Relational Databases for a Grid-enabled Analysis Environment
Arshad Ali, Ashiq Anjum, Tahir Azim, Julian Bunn, Saima Iqbal, Richard, McClatchey, Harvey Newman, S. Yousaf Shah, Tony Solomonides, Conrad, Steenberg, Michael Thomas, Frank van Lingen, Ian Willers

TL;DR
This paper presents a middleware system enabling seamless, transparent access to distributed heterogeneous relational databases via web services, facilitating data integration and analysis in grid environments for scientific applications.
Contribution
It introduces a middleware architecture that provides a virtual data access layer for distributed relational databases, using web services for platform-independent access.
Findings
Prototype implementation demonstrates effective data access across distributed databases.
System enables transparent data integration for grid-based scientific analysis.
Middleware supports heterogeneous database schemas and locations.
Abstract
Grid based systems require a database access mechanism that can provide seamless homogeneous access to the requested data through a virtual data access system, i.e. a system which can take care of tracking the data that is stored in geographically distributed heterogeneous databases. This system should provide an integrated view of the data that is stored in the different repositories by using a virtual data access mechanism, i.e. a mechanism which can hide the heterogeneity of the backend databases from the client applications. This paper focuses on accessing data stored in disparate relational databases through a web service interface, and exploits the features of a Data Warehouse and Data Marts. We present a middleware that enables applications to access data stored in geographically distributed relational databases without being aware of their physical locations and underlying…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsDistributed and Parallel Computing Systems · Distributed systems and fault tolerance · Advanced Database Systems and Queries
