Hi Sumit
Ah, didn't realise you started with a v6 row store database, thus how did you
upgrade to v7 ?
As if you simply check pointed and restarted the v6 database with a v7 binary
then it would be automatically upgraded but all the tables including the
RDF_QUAD tables and indexes would remain in the original row store mode.
There are two options for converting the RDF_QUAD table to column store which
are:
1. To dump the current RDF triples to datasets and reload them in an empty
database which will automatically then create the RDF_QUAD tables and indexes
in column wise mode. Scripts for dumping and reloading the RDF data can be
found at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump
2. You can convert the v7 row wise RDF_QUAD table and indexes to column wise as
detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksRowToColStoreConversion
Not sure what you mean by "When is a database gets created if you load a rdf
file into virtuoso using ld_dir_all() " ? When a v7 database is created
initially ie and empty database the RDF_QUAD table and indexes will
automatically have been created as column wise. So any data loaded in the Quad
Store using the RDF Bulk loader ie rdf_loader_run / ld_dir or any other method
will be loaded in the Column wise Quad Store.
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 18 May 2014, at 03:01, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
> I do store RDF data into virtuoso. Initial data was loaded into v 6.x.x. then
> gradually virtuoso was uploaded to v 7.0.0 and recently it has been upgraded
> to v 7.1.0
>
> When is a database gets created if you load a rdf file into virtuoso using
> ld_dir_all() ??
>
> thanks
> sumit
>
>
>
> ________________________________________
> From: Hugh Williams [hwilli...@openlinksw.com]
> Sent: Saturday, May 17, 2014 5:46 PM
> To: Purohit, Sumit
> Cc: virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-users] Using column store structure for exiting data
>
> Hi Sumit,
>
> By default all SQL tables would be created as row wise, if the ColumnStore=1
> setting is in place then any new SQL tables created will be column wise, but
> any existing table will not be auto converted or reindexed.
>
> The one exception are the RDF_QUAD and associated tables and indexes used for
> storing RDF data, which are created as column wise by default when a new v7
> database is created, as is best suited for hosting RDF datasets.
>
> 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 17 May 2014, at 23:19, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
>
>> Hi All,
>>
>> I am using Virtuoso (Open Source) 7.1.0 and read about support of
>> column-store structure in virtuoso.
>>
>> http://docs.openlinksw.com/virtuoso/databaseadmsrv.html
>>
>> Does setting ColumnStore=1 affect only tables created after the change OR
>> DOES IT RE-INDEX / RE-STRUCTURE exiting tables and indexes too ?
>>
>> If its former then is there any tool/utility which can restructure entire
>> data ?
>>
>> I have around 1.4B triples in my Virtuoso Store and i would not like to
>> reload entire data back after making above change.
>>
>> Thanks for the help.
>> Sumit Purohit
>>
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.
>> Get unparalleled scalability from the best Selenium testing platform
>> available
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.
> Get unparalleled scalability from the best Selenium testing platform available
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
