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

Munir, Kamran; Odeh, Mohammed; McClatchey, Richard

Abstract

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. Copyright ©2009 ACM.

• Presentation Conference Type: Conference Paper (Published)
• Conference Name: ACM International Conference Proceeding Series
• Publication Date: Nov 9, 2009
• Deposit Date: Nov 15, 2010
• Publicly Available Date: Feb 10, 2016
• Pages: 131-141
• DOI: https://doi.org/10.1145/1620432.1620446
• Keywords: relational databases, query formulation, domain ontology, domain metadata, OWL-DL, information systems
• Public URL: https://uwe-repository.worktribe.com/output/1435494
• Publisher URL: http://dx.doi.org/10.1145/1620432.1620446
• Related Public URLs: http://portal.acm.org/citation.cfm?id=1620446