Hi Sumit,
NULL indicates is it a row wise table, which would have been a result of
upgrading a v6 database to v7. Note, just using a v7 binary will not result in
a table being converted to column wise, it will remain in he format it was
found which is why the instructions for converting from rows to column wise are
provided ...
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 20 May 2014, at 23:02, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
> Thanks Hugh for prompt response.
> mine has neither "row" or "column" but "NULL" . what does this mean ?
>
> DB.DBA.RDF_QUAD
> NULL
> DB.DBA.RDF_QUAD
> vector ('distinct', 'no_pk', 'bitmap', vector (525, 0, 0, '__ALL', vector
> (vector (0, 'S', 1, 16776960, 0))))
> DB.DBA.RDF_QUAD
> vector ('distinct', 'no_pk', vector (525, 0, 0, '__ALL', vector (vector
> (0, 'O', 3, -1, 65535))))
> DB.DBA.RDF_QUAD
> vector ('bitmap', vector (525, 0, 0, '__ALL', vector (vector (0, 'O', 3,
> -1, 65535))))
> DB.DBA.RDF_QUAD
> vector ('distinct', 'no_pk', 'bitmap', vector (525, 0, 0, '__ALL', vector
> (vector (0, 'S', 1, 16776960, 0))))
>
> 5 Rows. -- 2 msec.
>
>
> You also asked about how did i upgrade virtuoso : I recompile it from source
> and then used my older ini file as i have made some performance tuning it
> that.
>
> --sumit
>
>
> ________________________________________
> From: Hugh Williams [hwilli...@openlinksw.com]
> Sent: Tuesday, May 20, 2014 3:03 PM
> To: Purohit, Sumit
> Cc: Bart Vandewoestyne; virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-users] Using column store structure for exiting data
>
> Hi Summit/Bart,
>
> The sys_keys table can then be queried to verify if the index type of the
> table is column, row (index, or bitmap) wise:
>
> 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>
>
> as indicated in the tip initially provided at:
>
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksRowToColStoreConversion
>
> 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 20 May 2014, at 22:35, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
>
>> I +1 Bart's question as I also want to know which tables are using latest
>> column store.
>> Is there a way ?
>>
>>
>> Thanks
>> Sumit Purohit
>>
>> -----Original Message-----
>> From: Bart Vandewoestyne [mailto:bart.vandewoest...@telenet.be]
>> Sent: Tuesday, May 20, 2014 4:50 AM
>> To: virtuoso-users@lists.sourceforge.net
>> Subject: Re: [Virtuoso-users] Using column store structure for exiting data
>>
>> On 2014-05-18 16:11, Hugh Williams wrote:
>>> 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.
>>
>> I have a question related to this: suppose you are given a database and you
>> don't know (or don't remember anymore) whether that data was created with a
>> v6 or v7 version of Virtuoso. How can you then check what tables/indexes
>> (and for my case, more specifically the RDF_QUAD table) are already stored
>> column-wise, and which ones are still stored row-wise?
>>
>> Kind regards,
>> Bart
>>
>> ------------------------------------------------------------------------------
>> "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
------------------------------------------------------------------------------
"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
