| 1 | ********The followings are not conclusions,just for recording the procedures.********* |
| 2 | |
| 3 | (1)CumulusRDF: |
| 4 | |
| 5 | |
| 6 | configuration: |
| 7 | |
| 8 | CumulusRDF does currently not work with Cassandra 2.x CumulusRDF has been tested with Cassandra 1.2.x and 1.1.x. The recommended version is: Cassandra 1.2.x. |
| 9 | |
| 10 | We use apache-cassandra-1.2.16. |
| 11 | replace snappy-java-1.0.5.jar with snappy-java-1.1.0.1.jar. |
| 12 | |
| 13 | load: |
| 14 | java -cp cumulusrdf-1.0.1.jar edu.kit.aifb.cumulus.cli.Main Load -i /path/data -s triple |
| 15 | |
| 16 | query: |
| 17 | |
| 18 | java -cp cumulusrdf-1.0.1.jar edu.kit.aifb.cumulus.cli.Main Query -q "select * where {?a ?b ?c.} limit 1000" |
| 19 | |
| 20 | single node: |
| 21 | |
| 22 | load |
| 23 | start: 0418 18:27:37 |
| 24 | end: 0421 05:20 |
| 25 | |
| 26 | Query: |
| 27 | CLI tools: |
| 28 | |
| 29 | Caused by: org.openrdf.query.MalformedQueryException: Lexical error at line 1, c |
| 30 | olumn 507. Encountered: " " (32), after : "en" |
| 31 | at org.openrdf.query.parser.sparql.SPARQLParser.parseQuery(SPARQLParser. |
| 32 | |
| 33 | === Allie query === #alliequery |
| 34 | |
| 35 | ||Query\time(ms) ||time 1 || |
| 36 | ||case1||1559ms|| |
| 37 | ||case2||29353ms|| |
| 38 | ||case3||29723ms|| |
| 39 | ||case4||2604ms|| |
| 40 | ||case5||over 20min|| |
| 41 | |
| 42 | (2)StarDog(not yet support cluster): |
| 43 | |
| 44 | start a server: |
| 45 | stardog-admin server start |
| 46 | |
| 47 | create a database:(stardog-admin help db create) |
| 48 | stardog-admin db create -n <dbname> |
| 49 | |
| 50 | ./stardog data add -g <graphname> <dbname> /path/data |
| 51 | |
| 52 | load cost:3h39m |
| 53 | |
| 54 | |
| 55 | {{{ |
| 56 | ls -lah Allie/ |
| 57 | 合計 96G |
| 58 | drwxr-xr-x 4 togordf togordf 4.0K 4月 18 16:05 . |
| 59 | drwxr-xr-x 8 togordf togordf 4.0K 4月 18 14:28 .. |
| 60 | -rw-r--r-- 1 togordf togordf 17 4月 18 16:05 dict.hcf |
| 61 | -rw-r--r-- 1 togordf togordf 626M 4月 18 16:05 dict.key |
| 62 | -rw-r--r-- 1 togordf togordf 220M 4月 18 16:05 dict.key.ext |
| 63 | -rw-r--r-- 1 togordf togordf 464M 4月 18 16:05 dict.val |
| 64 | -rw-r--r-- 1 togordf togordf 1.2K 4月 18 16:11 index.metadata |
| 65 | -rw-r--r-- 1 togordf togordf 9.5M 4月 18 16:05 keys.0 |
| 66 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.0 |
| 67 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.1 |
| 68 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.10 |
| 69 | ................ |
| 70 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.54 |
| 71 | -rw-r--r-- 1 togordf togordf 427M 4月 18 16:05 pages.55 |
| 72 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.6 |
| 73 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.7 |
| 74 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.8 |
| 75 | -rw-r--r-- 1 togordf togordf 2.0G 4月 18 16:05 pages.9 |
| 76 | drwxr-xr-x 2 togordf togordf 4.0K 4月 18 14:28 statistics.0 |
| 77 | drwxr-xr-x 2 togordf togordf 4.0K 4月 18 16:11 statistics.1 |
| 78 | |
| 79 | |
| 80 | }}} |
| 81 | |
| 82 | |
| 83 | stardog: |
| 84 | |
| 85 | jvm:STARDOG_JAVA_ARGS="-Xmx54g -Dapple.awt.UIElement=true" |
| 86 | |
| 87 | stardog-admin:default |
| 88 | |
| 89 | 問い合わせ: |
| 90 | |
| 91 | ./stardog query myDB "SELECT DISTINCT ?s WHERE { ?s ?p ?o } LIMIT 10" |
| 92 | |
| 93 | 結果はゼロだった。原因不明。 |
| 94 | |
| 95 | statusで調べったところ、正常なはずだった。 |
| 96 | |
| 97 | ./stardog-admin db status Allie |
| 98 | Database: Allie |
| 99 | Status : Online |
| 100 | Size : 94420988 triples |
| 101 | Queries : None running |