On Pushing Multilingual Query Operators into Relational Engines

Kumaran, A and Chowdary, Pavan K and Haritsa, Jayant R (2006) On Pushing Multilingual Query Operators into Relational Engines. In: Proceedings of the 22nd International Conference on Data Engineering, 2006. ICDE '06., 03-07 April 2006 , Atlanta, USA.

PDF On_Pushing_Multilingual.pdf - Published Version Restricted to Registered users only Download (351kB) | Request a copy

Abstract

To effectively support today’s global economy, database systems need to manage data in multiple languages simultaneously. While current database systems do support the storage and management of multilingual data, they are not capable of querying across different natural languages. To address this lacuna, we have recently proposed two cross-lingual functionalities, LexEQUAL[13] and SemEQUAL[14], for matching multilingual names and concepts, respectively. In this paper, we investigate the native implementation of these multilingual functionalities as first-class operators on relational engines. Specifically, we propose a new multilingual storage datatype, and an associated algebra of the multilingual operators on this datatype. These components have been successfully implemented in the PostgreSQL database system, including integration of the algebra with the query optimizer and inclusion of a metric index in the access layer. Our experiments demonstrate that the performance of the native implementation is up to two orders-of-magnitude faster than the corresponding outsidethe- server implementation. Further, these multilingual additions do not adversely impact the existing functionality and performance. To the best of our knowledge, our prototype represents the first practical implementation of a crosslingual database query engine.

Item Type:	Conference Paper
Publisher:	IEEE
Additional Information:	Copyright 2006 IEEE. Personal use of this material is permitted. However, permission to reprint/republish this material for advertising or promotional purposes or for creating new collective works for resale or redistribution to servers or lists, or to reuse any copyrighted component of this work in other works must be obtained from the IEEE.
Department/Centre:	Division of Electrical Sciences > Computer Science & Automation Division of Interdisciplinary Sciences > Supercomputer Education & Research Centre
Date Deposited:	10 Nov 2011 05:33
Last Modified:	10 Nov 2011 05:33
URI:	http://eprints.iisc.ac.in/id/eprint/41974

Actions (login required)

View Item