Managing the mappings between domain ontologies and database schemas when formulating relational queries

Munir, K., Odeh, M. ed and McClatchey, R. (2009) Managing the mappings between domain ontologies and database schemas when formulating relational queries. IDEAS '09 Proceedings of the 2009 International Database Engineering & Applications Symposium. pp. 131-141. Available from:

PDF - Published Version

Publisher's URL:


In recent years, the tremendous increase in the use of medical knowledge-discovery and decision-support applications has often required clinical researchers to write complex database queries. The users of these data analysis systems are normally unaware of the semantic relationships between the concepts stored in a database. In order to provide automated query formulation services, some mechanism for generating queries is required. In this regard, as reported in [1], domain ontologies can be used to formulate relational database queries in order to simplify the data access of the underlying data sources. However, the provision of such a query generation facility requires managing complex mappings between domain ontologies and relational data sources. In this regard, this paper discusses our approach to define mappings between domain ontologies and database schemas to support the ontology assisted relational query formulation process. This approach has been applied to the integrated medical database schema of the EU funded Health-e-Child (HeC) project.

Item Type:Article
Uncontrolled Keywords:relational databases, query formulation, domain ontology, domain metadata, OWL-DL, information systems
Faculty/Department:Faculty of Environment and Technology > Department of Computer Science and Creative Technologies
ID Code:12514
Deposited By: Dr K. Munir
Deposited On:15 Nov 2010 10:39
Last Modified:20 Jan 2018 17:40

Request a change to this item

Total Document Downloads in Past 12 Months

Document Downloads

Total Document Downloads

More statistics for this item...