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
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Gruber, T.R.: Toward Principles for the Design of Ontologies used for Knowledge Sharing. International Journal of Human-Computer Studies 43, 907–928 (1993)
Allemang, D., Hodgson, R., Polikoff, I.: Federal Reference Model Ontologies (FEARMO). White Paper (2005)
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)
Luts, M.: Estonian Semantic Interoperability Initiative. SEMIC.EU publications (2004)
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)
Salhofer, P., Stadlhofer, B., Tretter, G.: Ontology Driven E-government. El. J. of E-government 7, 415–424 (2009)
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)
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)
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)
Sabucedo, L.M.A., Rifon, L.E.A.: Semantic Service Oriented Architectures for E-government Platforms. American Association for Artificial Intelligence (2006)
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)
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)
Torodovski, L., Kunstelj, M., Cukjati, D., Vintar, M., Trochidis, I., Tambouris, E.: OneStopGove: D13 – Life-event Reference Models, Deliverable No. 13 (2007)
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)
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)
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)
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)
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)
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)
Fraser, J., Adams, N., Mckay-Hubbard, A., Macintosh, A., Canadas, R.: A Framework for e-Government Services. Deliverable No. 71 (2003)
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)
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)
Barthes, J.P., Moulin, C.: Impact of e-Government on Territorial Government Services. Deliverable No. 1.4 (2005)
Spanos, D.E., Stavrou, P., Mirou, N.: Bringing Relational Databases into the Semantic Web: A Survey. Semantic Web Journal 3, 169–209 (2012)
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)
Keet, M.: Using and Improving Bio-ontologies Stored in Relational Databases. Extended Abstract of the Talk Held at SBIOLBD, EPFL, Lausanne, Switzerland (2006)
Laclavik, M.: Ontology and Agent Based Approach for Knowledge Management. PhD Thesis, Institute of Informatics, Slovak Academy of Sciences (2005)
Calero, C., Ruiz, F., Piattini, M. (eds.): Ontologies for Software Engineering and Software Technology. Springer, Heidelberg (2006)
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)
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)
Watson, M.: Practical Artificial Intelligence Programming with Java, 3rd edn., pp. 57–72 (2008)
Zhang, W., Wang, Y.: Towards Building a Semantic Grid for e-Government Applications. WSEAS Transactions on Computer Research 3, 273–282 (2008)
Bailey, J., Bry, F., Furche, T., Schaffert, S.: Semantic Web Query Languages. In: Encyclopedia of Database Systems, pp. 2583–2586 (2009)
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)
CGOV: Central Government Ontology. An Ontology of the UK Central Government, http://reference.data.gov.uk/def/central-government
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)
Rajagopal, H.: JENA: A Java API for ontology management. IMB Corporation, Colorado Software Summit (2005)
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)
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)
Zhong, L., Zheng, M., Yuan, J., Jin, J.: The Jen-Based Ontology Model Inference and Retrieval Application. Intelligent Information Management 4, 157–160 (2012)
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)
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)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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)