Semantic Stored Procedures Programming Environment and Performance Analysis

  • Marjan EfremovEmail author
  • Vladimir Zdraveski
  • Petar Ristoski
  • Dimitar Trajanov
Conference paper
Part of the Advances in Intelligent and Soft Computing book series (AINSC, volume 150)


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.


Resource Description Framework SPARQL Query Triple Pattern Semantic Technology Oracle Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 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. 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), (accessed March 24, 2011)
  3. 3.
    RDF, Resource Description Framework (2010), (accessed March 27, 2011)
  4. 4.
  5. 5.
    Jena – A semantic web, java framework, Official API documentation and examples for Jena libraries (2010), (accessed March 20, 2011)
  6. 6.
    SPARQL, (accessed March 20, 2011)
  7. 7.
    Eclipse - plug-in-based editor, (accessed March 10, 2011)
  8. 8.
    Semantic Technologies Center – Oracle, (accessed March 5, 2011)
  9. 9.
  10. 10.
  11. 11.
    SPARUL, SPARQL update, (accessed April 10, 2011)
  12. 12.
    OWL, Web Ontology Language, (accessed)
  13. 13.
    Sesame, A semantic web, java framework, (accessed April 10, 2011)
  14. 14.
    API, application programming interface,
  15. 15.
    Sesame Adapter for Oracle Database, (accessed April 10, 2011)
  16. 16.
    Murray, C.: Oracle Database Semantic Technologies Developer’s Guide 11g Release 2 (11.2) (2010),
  17. 17.
    Oracle Feature Overview, Oracle Database Semantic Technologies (2009),
  18. 18.
    Oracle Semantic Technologies Overview, (accessed March 10, 2011)
  19. 19.
    Generating XML Data from the Database, (accessed March 30, 2011)
  20. 20.
    SEM_MATCH and Jena Adapter Queries Compared, (accessed March 20, 2011)
  21. 21.
    Wu, Z., Perry, M., Kolovski, V.: Oracle Database Semantic Technologies: Understanding How to Install, Load, Query and Inference (2010)Google Scholar
  22. 22.
    Compilation of SPARQL queries to a single SEM_MATCH Call, (accessed March 20, 2011)
  23. 23.
    Murray, C.: Oracle Database Semantic Technologies Developer’s Guide 11g Release 2 (11.2) (2010),

Copyright information

© Springer-Verlag GmbH Berlin Heidelberg 2012

Authors and Affiliations

  • Marjan Efremov
    • 1
    Email author
  • Vladimir Zdraveski
    • 2
  • Petar Ristoski
    • 2
  • Dimitar Trajanov
    • 2
  1. 1.Open Mind Solutions – SkopjeSkopjeRepublic of Macedonia
  2. 2.Faculty of Electrical Engineering and Information Technologies – SkopjeSs. Cyril and Methodius UniversitySkopjeRepublic of Macedonia

Personalised recommendations