Count Mismatch in Stardog Studio

I have created an empty database on stardog studio and loaded my simple class definition turtle file. there are two classes, employee and skill and there is object property - acquires ( Employee acquires Skill) and one data property for each class, hasEmployeeName and hasSkillName. when i first loaded, Stardog Studio showed 14 triples, i loaded the same turtle file one more time, even now the load is successful, and i see the count updated to 28 for the database in stardog studio. but when i run the select query ( select * {?s ?p ?o)), the result set is only showing 14 rows. I am not sure why there is a difference in counts and I am not sure if stardog studio is intelligent enough to recognize there are dupes and ignored them?

Hi Krishna,

Thanks for the note. The behavior you're seeing is actually expected; it's a result of some details regarding Stardog's storage layer. You can get more info here (note especially point 3 and the paragraph that follows it), but the basic things to note are these:

  1. At the time a triple is added to Stardog, there is no check for duplicates; the triple is simply appended.
  2. Read queries to Stardog do filter out duplicates, so the duplicates will be removed when you run the SELECT query you mentioned (that's why you see only 14 triples in that case).
  3. You can remove duplicates from your data by running an optimize operation on the database. In the Databases section of Studio, there is an "Optimize" button that will do this for you (it's in the "Other Actions" section). Alternatively, you can do it from the command line, via stardog-admin db optimize.

I hope this helps!


Thank you Jason. I ran the optimize on Stardog Studio and it did remove the dupes. Another Question, the model icon on the left side of Stardog studio does show the classes and their relation, but it doesnot show the data properties of the classes. Is there any way i can get a visual diagram that shows the classes, relations and the data properties of the classes, all in one diagram?

thank you

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.