Title: Query translation between sources in peer-to-peer database sharing systems

Authors: Md Mehedi Masud

Addresses: Department of Computer Science, College of Computers and Information Systems, Taif University, Taif-Al Haweiah, P.O. Box 888, 21974 Taif, Saudi Arabia

Abstract: This paper presents a query translation mechanism between heterogeneous peers in peer-to-peer database sharing systems (PDSSs). A PDSS combines a database management system with P2P functionalities. In a PDSS, each peer chooses its own data model and schema, and maintains data independently without any global coordinator. One of the problems in such a system is translating queries between peers taking into account both the schema and data heterogeneity. Query translation is the problem of rewriting a query posed in terms of one peer schema to a query in terms of another peer schema. The proposed approach uses of user-provided syntax and data level mappings that each peer constructs and shares with other peers. Based on the mapping information, our algorithm applies translation rules to translate queries. The translation mechanism is evaluated on a prototype peer-to-peer network to demonstrate the viability of the approach.

Keywords: data sharing; peer-to-peer; P2P data management; interoperability; heterogeneous DBMS; federated DBMS; peer-to-peer databases; query translation; knowledge engineering; data heterogeneity; database management systems.

DOI: 10.1504/IJKEDM.2010.034840

International Journal of Knowledge Engineering and Data Mining, 2010 Vol.1 No.2, pp.115 - 146

Published online: 24 Aug 2010 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article