-
Notifications
You must be signed in to change notification settings - Fork 0
/
devNotes.txt
87 lines (62 loc) · 4.28 KB
/
devNotes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
CALL apoc.import.graphml("https://raw.githubusercontent.com/LITMUS-Benchmark-Suite/northwind-graphml/master/made_from_rdf.graphml", {})
CALL apoc.import.graphml("https://raw.githubusercontent.com/harsh9t/bsbm1mgraph/master/bsbm1m.graphml", {})
CALL apoc.import.graphml("https://raw.githubusercontent.com/emredmrcan/graphQT/master/src/test/resources/graphs/northwind.graphml", {})
C:\Neo4j\relate-data\dbmss\dbms-9752aa06-59d2-4b6d-bf82-1871c9e04f01\import
DB.DBA.TTLP_MT (file_to_string_output ('C:/Users/ardam/IdeaProjects/bsbmtools-0.2/dataset.ttl'), '', 'http://example.com');
DB.DBA.TTLP_MT (file_to_string_output ('C:/Users/ardam/IdeaProjects/bsbmtools-0.2/dataset.ttl'), '', 'http://example2.com');
select ?property from <http://example.com> where {?a v:ProductProperyTextual_1 ?property}
PREFIX bsbm-inst: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/>
PREFIX bsbm: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
SELECT DISTINCT ?product ?label
FROM <http://example.com>
WHERE {
?product rdfs:label ?label .
?product bsbm:productPropertyTextual1 ?b
}
// Create data with scale 1000 http://wifo5-03.informatik.uni-mannheim.de/bizer/berlinsparqlbenchmark/spec/BenchmarkRules/index.html#datagenerator
java -cp lib/* benchmark.generator.Generator -fc -pc 1000 -s ttl -fn dataset_scale_1000
// Load into Virtuoso
DB.DBA.TTLP_MT (file_to_string_output ('C:/Users/ardam/IdeaProjects/bsbmtools-0.2/dataset_scale_1000.ttl'), '', 'http://bsbmScale1000.com');
// Create data with scale 10000
java -cp lib/* benchmark.generator.Generator -fc -pc 10000 -s ttl -fn dataset_scale_10000
DB.DBA.TTLP_MT (file_to_string_output ('C:/Users/ardam/IdeaProjects/bsbmtools-0.2/dataset_scale_10000.ttl'), '', 'http://bsbmScale10000.com');
// Create data with scale 1000 in xml format
java -cp lib/* benchmark.generator.Generator -fc -pc 1000 -s xml -fn dataset_scale_1000
DB.DBA.RDF_LOAD_RDFXML (file_to_string_output ('C:/Users/ardam/IdeaProjects/bsbmtools-0.2/dataset_scale_1000.xml'), '', 'http://bsbmScale1000.com');
java -cp lib/* benchmark.testdriver.TestDriver -ucf usecases/thesis/sparql.txt http://localhost:8890/sparql
java -cp lib/* benchmark.testdriver.TestDriver -ucf usecases/thesis/sparql.txt -runs 1024 -w 128 http://localhost:8890/sparql
java -cp lib/* benchmark.testdriver.TestDriver -ucf usecases/thesis/sparql.txt -runs 10 -w 20 http://localhost:8890/sparql
//DROP GRAPH
sparql DROP SILENT GRAPH <http://example.com>
//QUERY1
PREFIX bsbm-inst: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/>
PREFIX bsbm: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
SELECT DISTINCT ?product ?label
FROM <http://bsbmScale1000.com>
WHERE {
?product rdfs:label ?label .
?product bsbm:productPropertyTextual1 ?b
}
// NEO4j import graphml
#********************************************************************
# Other Neo4j system properties
#********************************************************************
apoc.import.file.enabled=true
CALL apoc.import.graphml("file://dataset10000.graphml", {})
//NEO4J Indexing - if nothing is specified is native-btree-1.0.
CREATE INDEX product_property_textual_1_index FOR (n:ProductPropertyTextual_1) ON (n.ProductPropertyTextual_1)
CREATE INDEX product_property_textual_2_index FOR (n:ProductPropertyTextual_2) ON (n.ProductPropertyTextual_2)
CREATE INDEX product_property_textual_3_index FOR (n:ProductPropertyTextual_3) ON (n.ProductPropertyTextual_3)
CREATE INDEX product_property_numeric_1_index FOR (n:ProductPropertyNumeric_1) ON (n.ProductPropertyNumeric_1)
CREATE INDEX product_property_numeric_2_index FOR (n:ProductPropertyNumeric_2) ON (n.ProductPropertyNumeric_2)
CREATE INDEX product_property_numeric_4_index FOR (n:ProductPropertyNumeric_4) ON (n.ProductPropertyNumeric_4)
CREATE INDEX review_index FOR (n:review) ON (n.review)
CREATE INDEX reviewer_id_index FOR (n:reviewerID) ON (n.reviewerID)
CREATE INDEX product_id_index FOR (n:productID) ON (n.productID)
CREATE INDEX type_index FOR (n:type) ON (n.type)
CREATE INDEX rating2_index FOR (n:Rating_2) ON (n.Rating_2)
CREATE INDEX label_n_index FOR (n:label_n) ON (n.label_n)