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