Skip to content

Latest commit

 

History

History
113 lines (103 loc) · 2.68 KB

gcloud_stat_count.md

File metadata and controls

113 lines (103 loc) · 2.68 KB

SPARQL example

v1.0.0

Data set: gcloud.ttl

Query

PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
SELECT (COUNT(?VM) AS ?count_VM)
WHERE {
    ?VM a cocoon:VM .
}

PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
SELECT (COUNT(?storage) AS ?count_storage)
WHERE {
    ?storage a cocoon:Storage .
}

PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
SELECT (COUNT(*) AS ?count)
WHERE {
    ?x a cocoon:Region .
}

PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
SELECT (COUNT(*) AS ?count)
WHERE {
    ?x a cocoon:SystemImage .
}

PREFIX gr:    <http://purl.org/goodrelations/v1#>
PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
SELECT (COUNT(*) AS ?count)
WHERE {
    ?x a gr:UnitPriceSpecification .
}

Nested query

PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
select * { 
    {
        select (count(?storage) AS ?count_storage)
        { ?storage a cocoon:Storage . }
    } 
    {
        select (count(?VM) AS ?count_VM) 
        { ?VM a cocoon:VM . } 
    } 
}

VALUES

PREFIX cocoon: <https://raw.githubusercontent.com/miranda-zhang/cloud-computing-schema/master/ontology_dev/cocoon.ttl>
select ?cls (count(?s) AS ?count)
{VALUES ?cls {cocoon:Storage cocoon:VM} ?s a ?cls}
group by ?cls

Result

Class Count
VM 57
Storage 8
Region 30
SystemImage 9
gr:UnitPriceSpecification 1340

v1.0.1

PREFIX cocoon: <https://w3id.org/cocoon/v1.0.1#>
PREFIX gr: <http://purl.org/goodrelations/v1#>
select ?cls (count(?s) AS ?count)
{
    VALUES ?cls {
        cocoon:ComputeService
        cocoon:SystemImage
        cocoon:StorageService
        cocoon:NetworkStorage
        cocoon:NetworkService
        cocoon:InternetService
        cocoon:Region
        cocoon:Location
        gr:BusinessEntity
    } ?s a ?cls
}
group by ?cls

Result: stat_count.csv

PREFIX cocoon: <https://w3id.org/cocoon/v1.0.1#>
PREFIX schema: <https://schema.org/>
SELECT (COUNT(*) AS ?count)
WHERE {
    ?s schema:typeOfGood cocoon:LocalStorage .
}

count
1412