Virtuoso Open-Source Edition

VOS.VirtFacetBrowserInstallConfigCommands

  • Topic
  • Discussion
  • VOS.VirtFacetBrowserInstallConfigCommands(Last) -- DAVWikiAdmin? , 2017-06-13 05:36:09 Edit WebDAV System Administrator 2017-06-13 05:36:09

    Faceted Browser Pre-Installation

    Run the following commands using the Virtuoso isql program before installing the Faceted Browser VAD:

    DROP INDEX  RDF_QUAD_OPGS;
    DROP INDEX  RDF_QUAD_POGS;
    DROP INDEX  RDF_QUAD_GPOS;
    DROP INDEX  RDF_QUAD_OGPS;
    
    CHECKPOINT;
    
    CREATE TABLE  R2 
       ( G  iri_id_8 , 
         S  iri_id_8 , 
         P  iri_id_8 , 
         O  ANY      , 
         PRIMARY KEY (S, P, O, G)
       );
    ALTER INDEX  R2  
      ON  R2  
      PARTITION ( S INT (0hexffff00) );
    
    LOG_ENABLE (2);
    
    INSERT INTO  R2 (G, S, P, O) 
      SELECT G, S, P, O 
      FROM rdf_quad;
    
    DROP TABLE RDF_QUAD;
    ALTER TABLE  R2 
      RENAME RDF_QUAD;
    
    CHECKPOINT;
    
    CREATE BITMAP INDEX  RDF_QUAD_OPGS 
      ON  RDF_QUAD (O, P, G, S) 
      PARTITION ( O  VARCHAR ( -1, 0hexffff ) );
    CREATE BITMAP INDEX  RDF_QUAD_POGS 
      ON  RDF_QUAD (P, O, G, S) 
      PARTITION ( O  VARCHAR ( -1, 0hexffff ) );
    CREATE BITMAP INDEX  RDF_QUAD_GPOS 
      ON  RDF_QUAD (G, P, O, S) 
      PARTITION ( O  VARCHAR ( -1, 0hexffff ) );
    
    CHECKPOINT;