Thanks, Hugh! It worked like charm.
Here's a pull-request, which disables transaction log for period of conversion: https://github.com/openlink/virtuoso-opensource/pull/65 On 08.07.2013, at 20:18, Hugh Williams <hwilli...@openlinksw.com> wrote: > 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 <indey...@gmail.com> 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 >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > -- Alexey Zakhlestin CTO at Grids.by/you https://github.com/indeyets PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc
signature.asc
Description: Message signed with OpenPGP using GPGMail
------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
