A Framework for Creating Global Schema Using Proxy Tables from Distributed Heterogeneous Relational Databases in Multidatabase System

Abstract

-Creating a global view, this is an alternative way of looking at the data in one or more tables from different geographical located heterogeneous local component databases with better security. A view is simply a stored query accessible as a virtual table that can be used similar to a table. In this paper, we propose a framework to integrate heterogeneous relational local component databases using Global View and construct a Global Schema with a set of Global Views in multidatabase system. We have also illustrated the method of integration with an example. Query submitted on Global View will be decomposed into a set of sub queries and will be executed at various remote sites and finally sub-queries will be composed and will get back result to concerned user. We also discuss some issues concerning distributed databases security in the Multidatabase System.