Abstract
Supporting the idea of the semantic web, we developed a Semantic Stored Procedures (SSP) programming environment for the Oracle11g database, similar to the existing ones, available for the stored procedures in the relational databases. This show-case SSP-environment supports the basic test/store/execute/remove scenarios for sem_match-queries, but is also a quite extensive system. An eclipse plug-in that provides a GUI for these operations and java API which helps programmers to use the SSP-call functionality were released in the package with the Oracle11g SSP-extension. The performances of our system are comparable (much better in most of the cases) with the existing adapters, as shown with the measurements in comparison with the well-known Jena adapter. Thus, a complete development environment for SSP-programming is now available and the semantic query management, as a simple concatenation of strings inside the code, seems to becoming just a forgotten nightmare of our semantic web programmer’s life.
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.
References
Strasunskas, D., Tomassen, S.L.: On Variety of Semantic Search Systems and Their Evaluation Methods. In: Proceedings of International Conference on Information Management and Evaluation, University of Cape Town, South Africa, pp. 380–387. Academic Conferences Publishing (2010)
Pan, J.Z., Thomas, E., Sleeman, D.: Ontosearch2: Searching and querying web ontologies. In: Proc. of the IADIS International Conference, Oracle 11g Database, pp. 211–218 (2006), http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html (accessed March 24, 2011)
RDF, Resource Description Framework (2010), http://www.w3.org/RDF/ (accessed March 27, 2011)
Jena Adapter for Oracle Database, http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_jena.htm
Jena – A semantic web, java framework, Official API documentation and examples for Jena libraries (2010), http://jena.sourceforge.net/ (accessed March 20, 2011)
SPARQL, http://www.w3.org/TR/rdf-sparql-query/ (accessed March 20, 2011)
Eclipse - plug-in-based editor, http://eclipse.org/ (accessed March 10, 2011)
Semantic Technologies Center – Oracle, http://www.oracle.com/technetwork/database/options/semantic-tech/whatsnew/index-088828.html (accessed March 5, 2011)
Oracle Database 11g Semantic Features, http://www.oracle.com/technetwork/database/options/semantic-tech/whatsnew/semtech-makes-ed-sm-195114.html (accessed March 5, 2011)
Oracle Database 11g Semantics Technical Talk, http://www.oracle.com/technetwork/database/options/semantic-tech/whatsnew/oracle-33.pdf?ssSourceSiteId=otnjp (accessed March 5, 2011)
SPARUL, SPARQL update, http://www.w3.org/Submission/SPARQL-Update/ (accessed April 10, 2011)
OWL, Web Ontology Language, http://www.w3.org/TR/owl-features/ (accessed)
Sesame, A semantic web, java framework, http://www.openrdf.org/about.jsp (accessed April 10, 2011)
API, application programming interface, http://en.wikipedia.org/wiki/API
Sesame Adapter for Oracle Database, http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_sesame.htm (accessed April 10, 2011)
Murray, C.: Oracle Database Semantic Technologies Developer’s Guide 11g Release 2 (11.2) (2010), http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sdo_rdf_concepts.htm#CIHHEDAC
Oracle Feature Overview, Oracle Database Semantic Technologies (2009), http://www.oracle.com/technetwork/database/options/semantic-tech/semtech11gr2-featover-131765.pdf
Oracle Semantic Technologies Overview, http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28397/sdo_rdf_concepts.htm (accessed March 10, 2011)
Generating XML Data from the Database, http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb13gen.htm (accessed March 30, 2011)
SEM_MATCH and Jena Adapter Queries Compared, http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_jena.htm (accessed March 20, 2011)
Wu, Z., Perry, M., Kolovski, V.: Oracle Database Semantic Technologies: Understanding How to Install, Load, Query and Inference (2010)
Compilation of SPARQL queries to a single SEM_MATCH Call, http://www.filibeto.org/sun/lib/nonsun/oracle/11.2.0.1.0/E11882_01/appdev.112/e11828/sem_jena.htm#sthref298 (accessed March 20, 2011)
Murray, C.: Oracle Database Semantic Technologies Developer’s Guide 11g Release 2 (11.2) (2010), http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_jena.htm
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag GmbH Berlin Heidelberg
About this paper
Cite this paper
Efremov, M., Zdraveski, V., Ristoski, P., Trajanov, D. (2012). Semantic Stored Procedures Programming Environment and Performance Analysis. In: Kocarev, L. (eds) ICT Innovations 2011. ICT Innovations 2011. Advances in Intelligent and Soft Computing, vol 150. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-28664-3_33
Download citation
DOI: https://doi.org/10.1007/978-3-642-28664-3_33
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-28663-6
Online ISBN: 978-3-642-28664-3
eBook Packages: EngineeringEngineering (R0)