ICT Innovations 2011 pp 357-366 | Cite as
Semantic Stored Procedures Programming Environment and Performance Analysis
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.
Keywords
Resource Description Framework SPARQL Query Triple Pattern Semantic Technology Oracle DatabasePreview
Unable to display preview. Download preview PDF.
References
- 1.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)Google Scholar
- 2.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)
- 3.RDF, Resource Description Framework (2010), http://www.w3.org/RDF/ (accessed March 27, 2011)
- 4.Jena Adapter for Oracle Database, http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_jena.htm
- 5.Jena – A semantic web, java framework, Official API documentation and examples for Jena libraries (2010), http://jena.sourceforge.net/ (accessed March 20, 2011)
- 6.SPARQL, http://www.w3.org/TR/rdf-sparql-query/ (accessed March 20, 2011)
- 7.Eclipse - plug-in-based editor, http://eclipse.org/ (accessed March 10, 2011)
- 8.Semantic Technologies Center – Oracle, http://www.oracle.com/technetwork/database/options/semantic-tech/whatsnew/index-088828.html (accessed March 5, 2011)
- 9.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)
- 10.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)
- 11.SPARUL, SPARQL update, http://www.w3.org/Submission/SPARQL-Update/ (accessed April 10, 2011)
- 12.OWL, Web Ontology Language, http://www.w3.org/TR/owl-features/ (accessed)
- 13.Sesame, A semantic web, java framework, http://www.openrdf.org/about.jsp (accessed April 10, 2011)
- 14.API, application programming interface, http://en.wikipedia.org/wiki/API
- 15.Sesame Adapter for Oracle Database, http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_sesame.htm (accessed April 10, 2011)
- 16.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
- 17.Oracle Feature Overview, Oracle Database Semantic Technologies (2009), http://www.oracle.com/technetwork/database/options/semantic-tech/semtech11gr2-featover-131765.pdf
- 18.Oracle Semantic Technologies Overview, http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28397/sdo_rdf_concepts.htm (accessed March 10, 2011)
- 19.Generating XML Data from the Database, http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb13gen.htm (accessed March 30, 2011)
- 20.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)
- 21.Wu, Z., Perry, M., Kolovski, V.: Oracle Database Semantic Technologies: Understanding How to Install, Load, Query and Inference (2010)Google Scholar
- 22.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)
- 23.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