International Business Machines Corporation
Mapping document data to relational data

Abstract:

A mechanism is provided in a data processing system to implement a data mapping engine for transparent and declarative translation of search queries on documents to queries on relational data. The data mapping engine receives a query from a search framework for a target database and translates the query to a target schema based on a mapping definition data structure to form a translated query. The mapping definition data structure declaratively maps between a source schema of the search framework to a target schema of a target database. The data mapping engine sends the translated query to the target database and receives a response from the target database. The data mapping engine translates the response to the source schema based on the mapping definition data structure to form a translated response and sends the translated response to the search framework.