Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Property path query performance problems: help desperately needed.

07291868-dafd-4ac1-a608-b4a39a6efb1fFeb 11 2016 — edited Feb 15 2016

I am new to OracleRDF but not new to triple stores or SPARQL

I have some existing queries that run on various other triple stores (Virtuoso, Allegrograph, Sesame, Jena memory model etc). The graph I am testing against only contains 1600 triples (yes sixteen hundred)

However even simplified queries with property paths either never return or throw a java heap problem (I have 4Gbyte allocated to the Tomcat that is running Joseki)

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX owl: <http://www.w3.org/2002/07/owl#>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT  distinct *

               WHERE {

                {

                                ?property rdfs:subPropertyOf* ?sproperty .

                               ?sproperty rdfs:domain ?sdomain .

                                ?sproperty rdf:type ?propertyType .

                                ?property rdfs:range ?r .

               }

}

i have tried every combination of hints to get this query to work. For example:


PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#TIMEOUT=100,ASSERTED_ONLY,JENA_EXECUTOR>


The problem is this is not even close to the complexity of the queries i really need to run (and already run on 4 different triple stores without any issue).


I have looked at all of the hints available and tried most permutations.


What do I do other than switch to a different triple store?


Help!!!

Comments

Celvin Kattookaran

Why would you cherry pick department members in Planning webforms? Can't you drive that selection using functions available?

Why not use the Delete Descendants/Delete IDescendants/Delete Level0 in Operation?

Create a load file of the format

Parent,Department,Operation

Department,Engineering Department,Delete Descendants

This will delete all members under Engineering Department, then you can load members. (You cannot refer members which are used in webform)

Regards

Celvin

VManek

Thank Celvin for your reply.

You are right. Leaf level Departments are not used in web-forms and most of them are in Page section. But how about the deletion of approval status as per documentation? Using the approach suggested if we are in middle of budget / forecast cycle and if any member is moved between/across parents or is deleted, what would be the potential impact to change statuses (approval process) and/or planning unit hierarchy?

Regards,

VManek

Celvin Kattookaran

If you are deleting member which are used in your planning unit hierarchies, then yes those will be removed.

I think if you delete a member (no matter which method you use) those are going to be deleted. Issue that you'll have to worry about is the movement. There is an option to load planning units using outline load, or you can use LCM export the planning units and then import them back once the movement is done.

Regards

Celvin

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 14 2016
Added on Feb 11 2016
2 comments
1,088 views