sparql - How to merge RDF subjects with same properties summing their values? -

-

given following triples:

s1 nameproperty "bozo" s1 laughproperty "haha" s1 valueproperty "2.00"^^xml:double  s2 nameproperty "clown" s2 laughproperty "hehe" s2 valueproperty "3.00"^^xml:double  s3 nameproperty "bozo" s3 laughproperty "haha" s3 valueproperty "1.00"^^xml:double

i'd merge subjects same name , laugh , sum values, result like:

s1 nameproperty "bozo" s1 laughproperty "haha" s1 valueproperty "3.00"^^xml:double s2 nameproperty "clown" s2 laughproperty "hehe" s2 valueproperty "3.00"^^xml:double

how perform sparql efficiency? (there no need retain subjects. can inserted long new 1 merged values shares same nameproperty , laughproperty.)

it's helpful if provide data can run queries over. here's data analogous yours, can work with:

@prefix xsd: <http://www.w3.org/2001/xmlschema#>. @prefix : <urn:ex:>  :s1 :nameproperty "bozo". :s1 :laughproperty "haha". :s1 :valueproperty "2.00"^^xsd:double.  :s2 :nameproperty "clown". :s2 :laughproperty "hehe". :s2 :valueproperty "3.00"^^xsd:double.  :s3 :nameproperty "bozo". :s3 :laughproperty "haha". :s3 :valueproperty "1.00"^^xsd:double.

this pretty straightforward construct query. tricky part since need group by have use nested select query can use sum , sample aggregate functions.

prefix : <urn:ex:>  construct {   ?clown :nameproperty ?name ;          :laughproperty ?laugh ;          :valueproperty ?total } {   { select (sample(?s) ?clown) ?name ?laugh (sum(?value) ?total) {       ?s :nameproperty ?name ;          :laughproperty ?laugh ;          :valueproperty ?value     }     group ?name ?laugh } }

results (in n3 , n-triples, sure 3.0e0 xsd:double):

@prefix :      <urn:ex:> . @prefix xsd:   <http://www.w3.org/2001/xmlschema#> .  :s3     :laughproperty  "haha" ;         :nameproperty   "bozo" ;         :valueproperty  3.0e0 .  :s2     :laughproperty  "hehe" ;         :nameproperty   "clown" ;         :valueproperty  "3.00"^^xsd:double . 

<urn:ex:s2> <urn:ex:laughproperty> "hehe" . <urn:ex:s2> <urn:ex:nameproperty> "clown" . <urn:ex:s2> <urn:ex:valueproperty> "3.00"^^<http://www.w3.org/2001/xmlschema#double> . <urn:ex:s3> <urn:ex:laughproperty> "haha" . <urn:ex:s3> <urn:ex:nameproperty> "bozo" . <urn:ex:s3> <urn:ex:valueproperty> "3.0e0"^^<http://www.w3.org/2001/xmlschema#double> .

Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more