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 |
102 | | |