Title: A hybrid approach towards optimisation of data and knowledge management through cooperation of database and ontology

Authors: Jeevani Goonetillake; Achini Hettiarachchi; Anusha Indika Walisadeera

Addresses: University of Colombo School of Computing, Colombo 07, Sri Lanka ' Development Bank of Singapore, Singapore ' Department of Computer Science, Faculty of Science, University of Ruhuna, Matara, Sri Lanka

Abstract: There are many domains that require managing both data and knowledge together, under a single application. A common issue is database designers would design the knowledge as data. Normal practice is either to use only database or only ontology in managing/retrieving data and knowledge. There is still no proper methodology to differentiate what to be stored as data and/or knowledge in order to obtain benefits from both ontology and database. This paper proposes a methodology to obtain optimum benefits in managing/querying data and knowledge under a single application. Proposed method enhances storing mechanism by defining guidelines as to how to distribute data and knowledge between ontology and database. Further, it improves the retrieval of data and knowledge by allowing some part to be queried through database via SQL and some part to be queried through ontology via SPARQL. Query execution and accuracy were obtained by evaluating a prototype of proposed approach.

Keywords: information and knowledge representation; database; ontology; optimisation.

DOI: 10.1504/IJKMS.2021.116406

International Journal of Knowledge Management Studies, 2021 Vol.12 No.3, pp.243 - 267

Received: 01 Feb 2020
Accepted: 03 Sep 2020

Published online: 22 Jul 2021 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article