Volume 2 Number 5 (Oct. 2010)
Home > Archive > 2010 > Volume 2 Number 5 (Oct. 2010) >
IJCEE 2010 Vol.2 (5): 846-851 ISSN: 1793-8163
DOI: 10.7763/IJCEE.2010.V2.238

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

Mohammad Ghulam Ali

Abstract—Creating a proxy table, this is an alternative way of looking at the data in one or more tables from different geographical located local component heterogeneous relational databases. Proxy tables provide indirect access to the data in remote tables. Location transparency of remote data will be maintained by creating a proxy table. The proxy table will be mapped with the remote table and view. The schema for proxy table resides in the multidatabase system but data resides in the remote locations. In this paper, we propose a framework to construct a Global Schema with a set of proxy tables created from different remote local databases. We can further merge two or more proxy tables to get results from two or more remote tables located in different sites. We have also illustrated the method of creating Global Schema with an example. Query submitted on proxy table without join, union or intersect will straightway go to the respective remote table or view and will send back results to the concerned user. Query submitted using join, union or intersect on two or more proxy tables will be decomposed into a set of sub queries and will go similarly to respective remote tables or views and individual sub-query will be executed at each remote sites and finally all sub-queries will be composed and will get back results to the concerned user.

Index Terms—Multidatabase, Global Schema, Relational Database, Proxy Table, View

Mohammad Ghulam Ali, Academic Post Graduate Studies & Research, Indian Institute of Technology Kharagpur, West Bengal 721302, India (email: ali@hijli.iitkgp.ernet.in, ali_iit@yahoo.com; Phone: 91-3222- 282056, 282188,220176).

Cite: Mohammad Ghulam Ali, Member IAENG, IACSIT, "A Framework for Creating Global Schema Using Proxy Tables from Distributed Heterogeneous Relational Databases in Multidatabase System," International Journal of
Computer and Electrical Engineering vol. 2, no. 5, pp. 846-851, 2010.

General Information

ISSN: 1793-8163
Frequency: Quarterly
Editor-in-Chief: Prof. Yucong Duan
Abstracting/ Indexing: EI (INSPEC, IET), Ulrich's Periodicals Directory, Google Scholar, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcee@iap.org

What's New

  • Mar 20, 2019 News!

    IJCEE Vol. 11, No. 1 is available online now.   [Click]

  • Aug 06, 2018 News!

    IJCEE Vol. 8, No. 4 - Vol. 9, No. 1 have been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Mar 20, 2019 News!

    The dois of published papers in Vol. 9, No. 1- Vol. 10, No. 4 have been validated by Crossref.

  • Dec 29, 2018 News!

    IJCEE Vol. 10, No. 4 is available online now.   [Click]

  • Oct 12, 2018 News!

    IJCEE Vol. 10, No. 3 is available online now.   [Click]

  • Read more>>