Persistent Storage and Query of E-government Ontologies in Relational Databases

  • Jean Vincent Fonou-Dombeu
  • Nicholas Mwenya Phiri
  • Madga Huisman
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8650)


Over the past eight years, building ontologies for semantic-driven e-government applications has been a subject of interest to e-government researchers. However, only a few has focused on the persistent storage and query of ontologies of the e-government domain. In this paper, 3 selected e-government ontologies are persistently stored and queried in relational databases. The OWL and RDF codes of these ontologies generated with Protégé or downloaded from the Internet are parsed with Jena API (Application Programming Interface) and loaded into MySQL RDBMS (Relational Database Management System). Thereafter, SPARQL queries are written to extract information from the created ontology databases. Experiments show that (1) the Jena parser scales well and could successfully parse and store e-government ontologies of different sizes into relational databases, and (2) the response times of SPARQL queries written in Jena to MySQL ontology databases are proportional to the sizes of the ontologies.


E-government Semantic Web Ontology Storage Ontology Query Protégé Jena API MySQL SPARQL 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Gruber, T.R.: Toward Principles for the Design of Ontologies used for Knowledge Sharing. International Journal of Human-Computer Studies 43, 907–928 (1993)CrossRefGoogle Scholar
  2. 2.
    Allemang, D., Hodgson, R., Polikoff, I.: Federal Reference Model Ontologies (FEARMO). White Paper (2005)Google Scholar
  3. 3.
    Baldoni, R., Fuligni, S., Mecella, M., Tortorelli, F.: The Italian e-Government Service Oriented Architecture - Strategic Vision and Technical Solutions. In: 6th EGOV Conference, Regensburg, Germany, pp. 79–88 (2007)Google Scholar
  4. 4.
    Luts, M.: Estonian Semantic Interoperability Initiative. SEMIC.EU publications (2004)Google Scholar
  5. 5.
    Jarrar, M., Deik, A., Farraj, B.: Ontology-Based Data Process Governance Framework–The Case of e-Government Interoperability in Palestine. In: IFIP International Symposium on Data-Driven Process Discovery and Analysis (SIMPDA 2011), pp. 83–98 (2001)Google Scholar
  6. 6.
    Salhofer, P., Stadlhofer, B., Tretter, G.: Ontology Driven E-government. El. J. of E-government 7, 415–424 (2009)Google Scholar
  7. 7.
    Chen, D., Nie, G., Liu, P.: Research Knowledge Sharing of E-government Based on Automatic Ontology Mapping. In: 6th Wuhan International Conference on E-Business, Business, China, pp. 105–111 (2008)Google Scholar
  8. 8.
    Gugliotta, A., Cabral, L., Domingue, J., Roberto, V.: A Conceptual Model for Semantically-Based E-government Portal. In: International Conference on e-Government 2005 (ICEG 2005), Ottawa, Canada (2005)Google Scholar
  9. 9.
    Xiao, Y., Xiao, M., Zhao, H.: An Ontology for E-government Knowledge Modelling and Interoperability. In: IEEE International Conference on Wireless Communications, Networking and Mobile Computing (WiCOM 2007), Shanghai, pp. 3600–3603 (2007)Google Scholar
  10. 10.
    Sabucedo, L.M.A., Rifon, L.E.A.: Semantic Service Oriented Architectures for E-government Platforms. American Association for Artificial Intelligence (2006)Google Scholar
  11. 11.
    Sabucedo, L.M.A., Rifon, L.E.A., Corradini, F., Polzonetti, A., Re, B.: Knowledge-Based Platform for E-government Agents: A Web-based Solution Using Semantic Technologies. J. of Expert Systems with Applications 5, 3647–3656 (2010)CrossRefGoogle Scholar
  12. 12.
    Sanati, F., Lu, J.: Multilevel Life-event Abstraction Framework for E-government Service Integration. In: 9th European Conference on E-government 2009 (ECEG 2009), London, UK, pp. 550–558 (2009)Google Scholar
  13. 13.
    Torodovski, L., Kunstelj, M., Cukjati, D., Vintar, M., Trochidis, I., Tambouris, E.: OneStopGove: D13 – Life-event Reference Models, Deliverable No. 13 (2007)Google Scholar
  14. 14.
    Apostolou, D., Stojanovic, L., Lobo, T.P., Miro, J.C., Papadakis, A.: Configuring E-government Services Using Ontologies. In: Funabashi, M., Grzech, A. (eds.) Challenges of Expanding Internet: E-Commerce, E-Business, and E-Government. IFIP, vol. 189, pp. 141–155. Springer, Boston (2005)CrossRefGoogle Scholar
  15. 15.
    Ortiz-Rodriguez, F., Villazon-Terrazas, B.: EGO Ontology Model: Law and Regulation Approach for E-government. In: Workshop on Semantic Web for E-government 2006, Workshop at the 3rd European Semantic Web Conference, Budva, Serbia, Montenegro, pp. 13–23 (2006)Google Scholar
  16. 16.
    Butka, P., Gabor, A., Ko, A., Mach, M., Ntioudis, S., Papadakis, A., Stojanovic, N., Vas, R., Zelinsky, T.: Semantic-enable, Agile, Knowledge-based e-Government (SAKE). Deliverable No. 3 (2006)Google Scholar
  17. 17.
    Goudos, S.K., Peristeras, V., Tarabanis, K.: Mapping Citizen Profiles to Public Administration Services Using Ontology Implementations of the Governance Enterprise Architecture (GEA) models. In: 3rd Annual European Semantic Web Conference, Budva, Montenegro, pp. 25–37 (2006)Google Scholar
  18. 18.
    Goudos, S.K., Peristeras, V., Lutas, N., Tarabanis, K.: A Public Administration Domain Ontology for Semantic Discovery of e-Government Services. In: 2nd IEEE Conference on Digital Information Management 2007 (ICDIM 2007), Lyon, France, pp. 260–265 (2007)Google Scholar
  19. 19.
    Peristeras, V., Tarabanis, K.: Reengineering Public Administration through Semantic Technologies and the GEA Domain Ontology. In: AAAI Spring Symposium, Semantic Web meets eGovernment (SWEG). Stanford University, California (2006)Google Scholar
  20. 20.
    Fraser, J., Adams, N., Mckay-Hubbard, A., Macintosh, A., Canadas, R.: A Framework for e-Government Services. Deliverable No. 71 (2003)Google Scholar
  21. 21.
    Breuker, J., Hoekstra, R., Boer, A., van der Berg, K., Sartor, G., Rubino, R., Wyner, A., Bench-Capon, T., Palmirani, M.: OWL Ontology of Basis Legal Concepts (LKIF-Core). Deliverable 1.4 (2006)Google Scholar
  22. 22.
    Hreno, J., Bednar, P., Furdík, K., Sabol, T.: Integration of Government Services using Semantic Technologies. Journal of Theoretical and Applied Electronic Commerce Research 6, 143–154 (2011)Google Scholar
  23. 23.
    Barthes, J.P., Moulin, C.: Impact of e-Government on Territorial Government Services. Deliverable No. 1.4 (2005)Google Scholar
  24. 24.
    Spanos, D.E., Stavrou, P., Mirou, N.: Bringing Relational Databases into the Semantic Web: A Survey. Semantic Web Journal 3, 169–209 (2012)Google Scholar
  25. 25.
    Heymans, S., Ma, L., Anicic, D., Ma, Z., Steinmetz, N., Pan, Y., Mei, J., Fokoue, A., Kalyanpur, A., Kershenbaum, A., Schonberg, E., Srinivas, K., Feier, C., Hench, G., Westzstein, B., Keller, U.: Ontology Reasoning with Large Data Repositories. In: Ontology Management, pp. 89–128. Springer US (2008)Google Scholar
  26. 26.
    Keet, M.: Using and Improving Bio-ontologies Stored in Relational Databases. Extended Abstract of the Talk Held at SBIOLBD, EPFL, Lausanne, Switzerland (2006)Google Scholar
  27. 27.
    Laclavik, M.: Ontology and Agent Based Approach for Knowledge Management. PhD Thesis, Institute of Informatics, Slovak Academy of Sciences (2005)Google Scholar
  28. 28.
    Calero, C., Ruiz, F., Piattini, M. (eds.): Ontologies for Software Engineering and Software Technology. Springer, Heidelberg (2006)Google Scholar
  29. 29.
    Knublauch, H., Fergerson, R.W., Noy, N.F., Musen, M.A.: The Protégé OWL Plugin: An Open Development Environment for Semantic Web Applications. In: McIlraith, S.A., Plexousakis, D., van Harmelen, F. (eds.) ISWC 2004. LNCS, vol. 3298, pp. 229–243. Springer, Heidelberg (2004)CrossRefGoogle Scholar
  30. 30.
    Wilkinson, K., Sayers, C., Kuno, H., Reynolds, D.: Efficient RDF Storage and Retrieval in Jena2. In: 1st International Workshop on Semantic Web and Databases (SWDB), Berlin, Germany, pp. 131–150 (2003)Google Scholar
  31. 31.
    Watson, M.: Practical Artificial Intelligence Programming with Java, 3rd edn., pp. 57–72 (2008)Google Scholar
  32. 32.
    Zhang, W., Wang, Y.: Towards Building a Semantic Grid for e-Government Applications. WSEAS Transactions on Computer Research 3, 273–282 (2008)Google Scholar
  33. 33.
    Bailey, J., Bry, F., Furche, T., Schaffert, S.: Semantic Web Query Languages. In: Encyclopedia of Database Systems, pp. 2583–2586 (2009)Google Scholar
  34. 34.
    Fonou-Dombeu, J.V., Huisman, M.: Semantic-Driven E-government: Application of Uschold and King Ontology Building Methodology for Semantic Ontology Models Development. International Journal of Web and Semantic Technology (IJWesT) 4, 1–20 (2011)Google Scholar
  35. 35.
    CGOV: Central Government Ontology. An Ontology of the UK Central Government,
  36. 36.
    Silvio, P., Shotton, D., Vitali, F.: Tool for the Automatic Generation of Ontology Documentation: A Task-Based Evaluation. International Journal on Semantic Web and Information Systems (IJSWIS) 9, 21–44 (2013)CrossRefGoogle Scholar
  37. 37.
    Rajagopal, H.: JENA: A Java API for ontology management. IMB Corporation, Colorado Software Summit (2005)Google Scholar
  38. 38.
    Wang, S., Zhang, X.: A Highly Efficient Ontology Storage and Query Method Based on Relational Database. In: IEEE International Conference on Electrical and Control Engineering, Yichang, China, pp. 4253–4256 (2011)Google Scholar
  39. 39.
    Zhou, J., Ma, L., Liu, Q., Zhang, L., Yu, Y., Pan, Y.: Minerva: A Scalable OWL Ontology Storage and Inference System. In: Mizoguchi, R., Shi, Z.-Z., Giunchiglia, F. (eds.) ASWC 2006. LNCS, vol. 4185, pp. 429–443. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  40. 40.
    Zhong, L., Zheng, M., Yuan, J., Jin, J.: The Jen-Based Ontology Model Inference and Retrieval Application. Intelligent Information Management 4, 157–160 (2012)CrossRefGoogle Scholar
  41. 41.
    Gali, A., Chen, C.X., Claypool, K.T., Uceda-Sosa, R.: From Ontology to Relational Databases. In: Wang, S., et al. (eds.) ER Workshops 2004. LNCS, vol. 3289, pp. 278–289. Springer, Heidelberg (2004)CrossRefGoogle Scholar
  42. 42.
    Vysniauskas, E., Nemuraite, L., Paradauskas, B.: Preserving Semantics of OWL 2 Ontologies in Relational Databases Using Hybrid Approach. Information Technology and Control 41, 103–115 (2012)CrossRefGoogle Scholar
  43. 43.
    Yan, Y., Wang, C., Zhou, A., Qian, W., Ma, L., Pan, Y.: Efficient Querying RDF Data in Triple Stores. In: World Wide Web Conference, Beijing, China, pp. 1053–1054 (2008)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2014

Authors and Affiliations

  • Jean Vincent Fonou-Dombeu
    • 1
  • Nicholas Mwenya Phiri
    • 1
  • Madga Huisman
    • 2
  1. 1.Department of Software StudiesVaal University of TechnologyVanderbijlparkSouth Africa
  2. 2.School of Computer, Statistical and Mathematical SciencesNorth-West UniversityPotchefstroomSouth Africa

Personalised recommendations