Skip to main content
SpringerLink
Log in

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

  • Conference paper
Electronic Government and the Information Systems Perspective (EGOVIS 2014)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 8650))

  • 1103 Accesses

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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)

    Article  Google Scholar 

  2. Allemang, D., Hodgson, R., Polikoff, I.: Federal Reference Model Ontologies (FEARMO). White Paper (2005)

    Google Scholar 

  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. Luts, M.: Estonian Semantic Interoperability Initiative. SEMIC.EU publications (2004)

    Google Scholar 

  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. Salhofer, P., Stadlhofer, B., Tretter, G.: Ontology Driven E-government. El. J. of E-government 7, 415–424 (2009)

    Google Scholar 

  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. 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. 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. 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. 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)

    Article  Google Scholar 

  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. 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. 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)

    Chapter  Google Scholar 

  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. 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. 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. 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. 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. Fraser, J., Adams, N., Mckay-Hubbard, A., Macintosh, A., Canadas, R.: A Framework for e-Government Services. Deliverable No. 71 (2003)

    Google Scholar 

  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. 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. Barthes, J.P., Moulin, C.: Impact of e-Government on Territorial Government Services. Deliverable No. 1.4 (2005)

    Google Scholar 

  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. 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. 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. Laclavik, M.: Ontology and Agent Based Approach for Knowledge Management. PhD Thesis, Institute of Informatics, Slovak Academy of Sciences (2005)

    Google Scholar 

  28. Calero, C., Ruiz, F., Piattini, M. (eds.): Ontologies for Software Engineering and Software Technology. Springer, Heidelberg (2006)

    MATH  Google Scholar 

  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)

    Chapter  Google Scholar 

  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. Watson, M.: Practical Artificial Intelligence Programming with Java, 3rd edn., pp. 57–72 (2008)

    Google Scholar 

  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. Bailey, J., Bry, F., Furche, T., Schaffert, S.: Semantic Web Query Languages. In: Encyclopedia of Database Systems, pp. 2583–2586 (2009)

    Google Scholar 

  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. CGOV: Central Government Ontology. An Ontology of the UK Central Government, http://reference.data.gov.uk/def/central-government

  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)

    Article  Google Scholar 

  37. Rajagopal, H.: JENA: A Java API for ontology management. IMB Corporation, Colorado Software Summit (2005)

    Google Scholar 

  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. 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)

    Chapter  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Chapter  Google Scholar 

  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)

    Article  Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

  1. Department of Software Studies, Vaal University of Technology, Private Bag X021, Andries Potgieter Blvd, Vanderbijlpark, 1900, South Africa

    Jean Vincent Fonou-Dombeu & Nicholas Mwenya Phiri

  2. School of Computer, Statistical and Mathematical Sciences, North-West University, Private Bag X6001, Potchefstroom, 2520, South Africa

    Madga Huisman

Authors
  1. Jean Vincent Fonou-Dombeu
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Nicholas Mwenya Phiri
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Madga Huisman
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Corvinus University of Budapest, Fővám tér 13.-15, 1093, Budapest, Hungary

    Andrea Kő

  2. ITTIG - CNR, Institute of Legal Information Theory and Techniques, Italian National Research, Council, Via de’ Barucci 20, 50127, Florence, Italy

    Enrico Francesconi

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer International Publishing Switzerland

About this paper

Cite this paper

Fonou-Dombeu, J.V., Phiri, N.M., Huisman, M. (2014). Persistent Storage and Query of E-government Ontologies in Relational Databases. In: Kő, A., Francesconi, E. (eds) Electronic Government and the Information Systems Perspective. EGOVIS 2014. Lecture Notes in Computer Science, vol 8650. Springer, Cham. https://doi.org/10.1007/978-3-319-10178-1_10

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-10178-1_10

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-10177-4

  • Online ISBN: 978-3-319-10178-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation