Play with sesame native store for large triples

The Sesame Native Store is reported to scale up to about 100-150 million triples (depending on hardware and data-set characteristics). And Rivuli also mentioned in his blogpost that it is becomeing slow while the data set normally over 600,0000 triples 500MB for inserting files to Native Store of sesame.

Tested for chunk commit in sesame API, see example here, that is, stop auto commit and commit in every chunk size you set.

• Test: commit every 5 triples, how many will be committed if there's exception in 14th triple(statement)?
• A: 10
• B: 13
• Answer: 13 ( It will be committed before the exception point)

Virtuoso triple store database for Windows

1. Download the virtuoso for Windows.

http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSUsageWindows



2. Create [system environment] VIRTUOSO_HOME as C:/Program Files/OpenLink Software/VOS7/virtuoso-opensource/



3. Add PATH value ;%VIRTUOSO_HOME%/bin;%VIRTUOSO_HOME%/lib


4. Create a servie :

cd %VIRTUOSO_HOME%/database

virtuoso-t +service create +instance "New Instance Name" +configfile virtuoso.ini 

5. After U create the service, you could list / start / stop / delete by commands below:

Action	Command
List all Virtuoso services	virtuoso-t +service list
Start a Virtuoso service	virtuoso-t +instance "Instance Name" +service start
Stop a Virtuoso service	virtuoso-t +instance "Instance Name" +service stop
Delete a Virtuoso service	virtuoso-t +instance "Instance Name" +service delete

---------------------Erros Resolution--------------------

Error 1 : Unable to open the service control manager  > (5).

Solution : Run cmd as Administration

Error 2 : While executing iSQL, can't access file directory because of ini file settings.

Solution : Modify (or add) directory allow settings in virtuoso.ini file.


References:

Using Virtuoso : http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSUsageWindows

Configuration : 
http://docs.openlinksw.com/virtuoso/dbadm.html#fp_acliniallowed