On Pushing Multilingual Query Operators into Relational Engines

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 ...

• Type: Conference
• Year: 2006
• Where: ICDE
• Authors: A. Kumaran, Pavan K. Chowdary, Jayant R. Haritsa
• Keywords: Database, ICDE 2006, Multilingual Functionalities, Multilingual Operators, Multilingual Storage Datatype