VirutuosoQuickPrimer: fct-init.sql

File fct-init.sql, 1.1 KB (added by admin, 14 years ago)
Line 
1  drop index RDF_QUAD_OPGS;
2  drop index RDF_QUAD_POGS;
3  drop index RDF_QUAD_GPOS;
4  drop index RDF_QUAD_OGPS;
5
6  checkpoint;
7
8  create table R2 (G iri_id_8, S iri_id_8, P iri_id_8, O any, primary key (S, P, O, G));
9  alter index R2 on R2 partition (S int (0hexffff00));
10
11  log_enable (2);
12
13  insert into R2 (G, S, P, O) select G, S, P, O from rdf_quad;
14
15  drop table RDF_QUAD;
16  alter table r2 rename RDF_QUAD;
17
18  checkpoint;
19
20  create bitmap index RDF_QUAD_OPGS on RDF_QUAD (O, P, G, S) partition (O varchar (-1, 0hexffff));
21  create bitmap index RDF_QUAD_POGS on RDF_QUAD (P, O, G, S) partition (O varchar (-1, 0hexffff));
22  create bitmap index RDF_QUAD_GPOS on RDF_QUAD (G, P, O, S) partition (O varchar (-1, 0hexffff));
23  create bitmap index RDF_QUAD_OGPS on RDF_QUAD (O, G, P, S) partition (O varchar (-1, 0hexffff));
24
25  checkpoint;
26
27grant select on DB.DBA.RDF_QUAD to "SPARQL";
28
29RDF_OBJ_FT_RULE_ADD (null, null, 'All');
30DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ ();
31
32  checkpoint;
33
34grant EXECUTE ON DB.DBA.SPARQL_INSERT_DICT_CONTENT to "SPARQL";
35grant EXECUTE ON DB.DBA.SPARQL_DELETE_DICT_CONTENT to "SPARQL";
36
37  checkpoint;
38