Hi Alexey, Yes, you can use that script which rename the original row wise RDF_QUAD tables create an empty column wise RDF_QUAD table and insert the data from the rename table into it. You verify if the index type of the table is column, index, or bitmap using a query of the form:
SQL> SELECT TOP 10 KEY_TABLE, sys_sql_val_print (KEY_OPTIONS)
FROM sys_keys
WHERE KEY_TABLE = 'DB.DBA.RDF_QUAD' ;
KEY_TABLE sys_sql_val_print
VARCHAR NOT NULL VARCHAR
_______________________________________________________________________________
DB.DBA.RDF_QUAD vector ('column')
DB.DBA.RDF_QUAD vector ('distinct', 'no_pk', 'column', vector (525,
0, 0, '__ALL', vector (vector (0, 'S', 1, 16776960, 0))))
DB.DBA.RDF_QUAD vector ('distinct', 'no_pk', 'column', vector (525,
0, 0, '__ALL', vector (vector (0, 'O', 3, -1, 65535))))
DB.DBA.RDF_QUAD vector ('column', vector (525, 0, 0, '__ALL',
vector (vector (0, 'O', 3, -1, 65535))))
DB.DBA.RDF_QUAD vector ('distinct', 'no_pk', 'column', vector (525,
0, 0, '__ALL', vector (vector (0, 'S', 1, 16776960, 0))))
5 Rows. -- 1 msec.
SQL>
Note this will result in a duplicate of the table which based on size will
consume a significant amount of disk space and memory, but the old table can be
removed afterwards.
Alternatively you can dump and reload the data into an empty v7 database (or
RDF_QUAD table) using the scripts we provide at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump
and would not result in the duplicate table ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 8 Jul 2013, at 12:05, Alexey Zakhlestin <[email protected]> wrote:
> As far as I understand, Virtuoso/7 doesn't do any automatic conversions of
> existing databases to column-based.
> So, what is the proper procedure for upgrading triplestore to column-based
> indices?
> Marketing materials tell that it is recommended for large datasets :)
>
> Should I just execute this script?
> https://github.com/openlink/virtuoso-opensource/blob/develop/7/libsrc/Wi/rdfcol.sql
>
> what's the command to verify format of indices?
>
> --
> Alexey Zakhlestin
> CTO at Grids.by/you
> https://github.com/indeyets
> PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc
>
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
