From Relational Databases to Ontology-Based Databases

Hamaz Kamal, Benchikha Fouzia


Nowadays, the volume of data used in an information system grows rapidly. Additionally, enterprise information systems are more open to distributed environments and platforms. Thus, the need for interoperability between the different underlying data sources increases considerably. Therefore, data storage should consider storing data as well as the semantic of it in a single database. To overcome this problem, Ontology-Based Databases seem to be a good choice to replace legacy databases. In this sense, this paper proposes a reverse engineering approach which transforms a relational database to an ontology. The extracted ontology is enriched with more semantics by mean of external domain ontology. Finally the ontology and data are stored in one of the existing specific architectures for Ontology-Based Databases.


  1. Alexaki, S. Christophides, V. Karvounarakis, G. Plexousakis, D. Tolle, K., 2001. The ics-forth rdfsuite: Managing voluminous rdf description bases. In SemWeb. Hong Kong, pp. 1-13.
  2. Astrova, I., 2004. Reverse Engineering of Relational Databases to Ontologies. In Proceedings of the 1st European Semantic Web Symposium (ESWS), Heraklion, Greece, pp 327-341.
  3. Astrova, I., Kalja, A., 2006. Mapping of SQL Relational Schemata to OWL Ontologies. In Proceedings of the 6th WSEAS International Conference on Applied Informatics and Communications, Elounda, Greece. pp375-380.
  4. Astrova, I., Stantic, B., 2005. An HTML Forms Driven Approach to Reverse Engineering of Relational Databases to Ontologies. In Proceedings of the 23rd IASTED International Conference on Databases and Applications (DBA), Innsbruck, Austria.pp 246 - 251.
  5. Benslimane, S., Malki, M., Rahmouni, M., Rahmoun, A., 2008. Towards Ontology Extraction from DataIntensiveWeb Sites: An HTML Forms-Based Reverse Engineering Approach. The International Arab Journal of Information Technology. pp 34-44.
  6. Broekstra, J., Kampman, A., Van Harmelen, F., 2002. Sesame : A generic architecture for storing and querying rdf and rdf schema. Proceedings of the First Internation Semantic WebConference, number 2342 in Lecture Notes in Computer Science. pp 54-68.
  7. Dehainsala, H., Pierra, G., Bellatreche, L., 2007. Ontodb: An ontology-based database for data intensive applications. In DASFAA. pp 497-508.
  8. Domain-Ontology Hainaut, J., 2002. Introduction to database reverse engineering. Book, 160 pages.
  9. Thomas R, Gruber., 1993. Formal ontology in conceptual analysis and knowledge representation. Chapter: “Towards principles for the design of ontologies used for knowledge sharing”. Kluwer Academic Publishers.
  10. Jean,. S., Aït Ameur, Y., Pierra, G., 2006. Querying ontology based databases the ontoql proposal. In Proceedings of the 18th International Conference on Software Engineering & Knowledge Engineering, pp 166-171.
  11. Jean, S (thesis).2006., OntoQL, un langage d'exploitation des bases de données à base ontologique. Mémoire de doctorat.
  12. Jing, L., Li, M.,Lei, Z., Jean-Sébastien, B., Chen, W., Yue, P., Yong, Y., 2007. SOR: A Practical System for Ontology Storage, Reasoning. In VLDB 2007, 33rd Very Large Data Bases Conference ,pp 1402-1405.
  13. Johannesson, P., 1994. A Method for Transforming Relational Schemas into Conceptual Schemas. In Proceedings of the Tenth International Conference on Data Engineering IEEE Computer Society Washington, DC, USA, pp 190-201.
  14. Kashyap, V., 1999. Design and creation of ontologies for environmental information retrieval. In Proceedings of the 12th Workshop on Knowledge Acquisition, Modeling and Management. Alberta, Canada. pp. 3- 21.
  15. Pierra, G. Dehainsala, H. Aït-Ameur, Y. Bellatreche, L. 2005. Base de données à base ontologique: principes et mise en oeuvre. Ingénierie des Systèmes d'Information, 10(2):91-115.
  16. Pierra, G., Dehainsala, H. Aït-Ameur, Y., Bellatreche, L. Chochon, J and Mimoune, M. (2004). Base de Données à Base Ontologique: le modèle OntoDB. Proceedings of Base de Données Avancées 20èmes Journées (BDA'04), 263-286.
  17. Ramanathan, S., Hodges, J., 1997. Extraction of objectoriented structures from existing relational databases. SIGMOD Jounral Vol 26 number 1, pp 59-64.
  18. Rene Robin, C.R., 2010. A Novel Algorithm for Fully Automated Ontology Merging Using Hybrid Strategy. European Journal of Scientific Research. Vol.47 No.1, PP. 074-081.
  19. Seaborne, A., Prud'hommeaux, E. Sparql query language for rdf. http: // www. w3. org/ TR/ rdf-sparql-query/ Wilkinson, K., Sayers C., Kuno, H., Reynolds, D. 2003. Efficient RDF storage and Retrtieval in Jena2. Proceedings of the 1st International Workshop on Semantic Web Database (SWDB'03). pp. 131-150.
  20. Zdenka, T., 2010. Relational Database as a Source of Ontology Creation. Proc, of the International Multiconference on Computer Science and Information Technology. 135.139.

Paper Citation

in Harvard Style

Kamal H. and Fouzia B. (2013). From Relational Databases to Ontology-Based Databases . In Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-59-4, pages 289-297. DOI: 10.5220/0004454802890297

in Bibtex Style

author={Hamaz Kamal and Benchikha Fouzia},
title={From Relational Databases to Ontology-Based Databases},
booktitle={Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - From Relational Databases to Ontology-Based Databases
SN - 978-989-8565-59-4
AU - Kamal H.
AU - Fouzia B.
PY - 2013
SP - 289
EP - 297
DO - 10.5220/0004454802890297