question

Upvotes
Accepted
mandeepsingh avatar image
1 ●0 ●0 ●0

How to query .nt files in Apache Jena Server


Hi,

Sorry if this question is already answered on the forum. Please redirect me to the right page.


I have uploaded the organization file (OpenPermID-bulk-organization-20210307_112038.nt ) on the apache jena server.

Result: success. 57832465 triples

I am now on the query window but my queries don't return a response. Can someone share sample queries for organization files? sorry for the limited knowledge on this query language.


Few use cases I want to build :

1. Count of PermIds in the file

2. List of PermId having LEI associated with it




intelligent-tagging-apipermid-apiopen-permid-api
1.png (18.2 KiB)
2.png (35.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
Jirapongse avatar image
38.1k ●69 ●35 ●53

@mandeepsingh

I am new to SPARQL too. I think the query could be:

1. Count of PermIds in the file 

SELECT (count(distinct ?s) as ?count)
WHERE { ?s ?p ?o }

2. List of PermId having LEI associated with it 

SELECT ?permID ?object
WHERE {  
  ?permID <http://permid.org/ontology/organization/hasLEI> ?object .
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
mandeepsingh avatar image
1 ●0 ●0 ●0

Thanks for the response @jirapongse.phuriphanvichai. Not sure why I can't see the results while executing the above two queries.


3.png (36.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Jirapongse avatar image Jirapongse

From my test, it returns the following.

Can you check with this query?

SELECT ?permID 
WHERE {  
  ?permID <http://permid.org/ontology/organization/hasLEI> "5493000BPC9ZTGJKQW88" .
}
1615971399111.png (76.0 KiB)
Click below to post an Idea Post Idea