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

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.

REFERENCES

• 1: K. Munir, M. Odeh and R. McClatchey, Ontology Assisted Query Reformulation Using the Semantic and Assertion Capabilities of OWL-DL Ontologies, Twelfth International Database Engineering & Applications Symposium (IDEAS) 2008.
• 2: M. Zloof, Query-by-example: the invocation and definition of tables and forms, VLDB: Proceedings of the 1st International Conference on Very Large Data Bases pp. 1--24, 1975.
• 3: K. Munir, M. Odeh, P. Bloodsworth and R. McClatchey, Using Assertion Capabilities of an OWL-Based Ontology for Query Formulation, 3rd International Conference on Information & Communication Technologies: from Theory to Applications (ICTTA) 2008.
• 4: Health-e-Child, The Information Societies Technology Project: Health-e-Child, EU Contract IST-2004-027749, 2004.
• 5: J. Freund, Health-e-Child: An Integrated Biomedical Platform for Grid-Based Pediatric Applications, vol. Studies in Health Te, pp. 259--270, 2006.
• 6: A. Anjum, P. Bloodsworth, A. Branson, T. Hauer, R. McClatchey, K. Munir, D. Rogulin and J. Shamdasani, The Requirements for Ontologies in Medical Data Integration: A Case Study, Eleventh International Database Engineering & Applications Symposium (IDEAS) vol. 6, pp. 308--314, 2007.
• 7: A. Branson, T. Hauer, R. Mcclatchey, D. Rogulin and J. Shamdasani, A Data Model for Integrating Heterogeneous Medical Data in the Health-e-Child Project, Accepted in HealthGrid'08 Conference 2008.
• 8: N. W. Paton, R. Stevens, P. Baker, C. A. Goble, S. Bechhofer and A. Brass, Query Processing in the TAMBIS Bioinformatics Source Integration System, Proceedings of the IEEE International Conference on Scientific and Statistical Databases (SSDBM) pp. 138--147, 1999.
• 9: E. Mena, A. Illarramendi, V. Kashyap and A. Sheth, OBSERVER: An Approach for Query Processing in Global Information Systems based on Interoperation across Pre-existing Ontologies, Journal on Distributed and Parallel Databases vol. 8, no. 2, pp. 223--271, 2000.
• 10: D. Baer, P. Groenewoud, E. Kapetanios and S. Keuser, A Semantics Based Interactive Query Formulation Technique, User Interfaces to Data Intensive Systems: Second International Workshop on User Interfaces to Data Intensive Systems pp. 43--49, 2001.
• 11: E. Kapetanios, D. Baer, B. Glaus and P. Groenewoud, Data Querying and Analysis through Integration of Intentional and Extensional Semantics, 16th International Conference on Scientific and Statistical Database Management (SSDBM) pp. 353--356, 2004.
• 12: C. B. Necib and J.-C. Freytag, Query Processing using Ontologies, CAiSE pp. 167--186, 2005.
• 13: A. L. Rector, S. Bechhofer, C. A. Goble, I. Horrocks, W. A. Nowlan and W. D. Solomon, The GRAIL Concept Modelling Language for Medical Terminology, Artificial Intelligence in Medicine vol. 9, pp. 139--171, 1997.
• 14: D. Calvanese, G. D. Giacomo, D. Lembo, M. Lenzerini, A. Poggi and R. Rosati, Ontology-based Database Access, Proc. of the 15th Italian Conf. on Database Systems (SEBD) pp. 324--331, 2007.
• 15: D. Calvanese, G. D. Giacomo, D. Lembo, M. Lenzerini, A. Poggi and R. Rosati, Linking Data to Ontologies: The Description Logic DL-LiteA, In Proc. of the 2nd Workshop on OWL: Experiences and Directions (OWLED) 2006.
• 16: Y. Arens, C. A. Knoblock and W.-M. Shen, Query Reformulation for Dynamic Information Integration, Journal of Intelligent Information Systems - Special Issue on Intelligent Information Integration vol. 6, no. 2, pp. 99--130, 1996.
• 17: Z. Xu, S. Zhang and Y. Dong, Mapping between Relational Database Schema and OWL Ontology for Deep Annotation, Web Intelligence, 2006. WI 2006. IEEE/WIC/ACM International Conference on Web Intelligence pp. 248--552, 2006.
• 18: J. Barrasa, O. Corcho, G. Shen and A. Gomez-Perez, R2O, an Extensible and Semantically Based Database-to-ontology Mapping Language, 2nd Workshop on Semantic Web and Databases (SWDB) 2004.
• 19: A. Borgida, M. Lenzerini and R. Rosati, Description Logics for Databases, The description logic handbook: theory, implementation, and applications pp. 462--484, 2003.
• 20: D. Caragea, J. Pathak, J. Bao, A. Silvescu, C. Andorf, D. Dobbs and V. Honavar, Information Integration from Semantically Heterogeneous Biological Data Sources, DEXA Workshops: Proceedings of the 3rd International Workshop on Biological Data Management pp. 580--584, 2005.
• 21: E. Vysniauskas and L. Nemuraite, Transforming Ontology Representation from OWL to Relational Database, Information Technology and Control vol. 35, no. 3A, 2006.
• 22: J. Trinkunas and O. Vasilecas, A Graph Oriented Model for Ontology Transformation into Conceptual Data Model, Journal of Information Technology and Control vol. 36, no. 1A, 2007.
• 23: P. Mitra, G. Wiederhold and M. Kersten, A Graph Oriented Model for Articulation of Ontology Interdependencies, Proc. Extending Database Technologies vol. 1777, pp. 86--100, 2000.
• 24: H. El-Ghalayini, M. Odeh, R. McClatchey and T. Solomonides, Reverse Engineering Domain Ontologies to Conceptual Data Models, Proceedings of the 23rd IASTED International Conference on Databases and Applications pp. 222--227, 2005.
• 25: I. Astrova, N. Korda and A. Kalja, Rule-Based Transformation of SQL Relational Databases to OWL Ontologies, 2nd International Conference on Metadata & Semantic Research 2007.
• 26: E. Vysniauskas and L. Nemuraite, Transforming Ontology Representation from OWL to Relational Database, Information Technology and Control vol. 35, no. 3A, pp. 333--343, 2006.
• 27: F. Baader, I. Horrocks and U. Sattler, Description Logics as Ontology Languages for the Semantic Web, Mechanizing Mathematical Reasoning: Essays in Honor of Jörg Siekmann, in Lecture Notes in Artificial Intelligence vol. 2605, pp. 228--248, 2005.

INDEX TERMS

Keywords:
domain metadata, domain ontology, query formulation, relational databases