Failing to load a table

Franck Routier franck.routier at axege.com
Fri Jul 5 10:51:37 CEST 2013


Thanks a lot Martin for your input.
I will experiment this idea and I'll come back to share the results I 
get iwth MonetDB.

Best regards,
Franck

Le 04/07/2013 20:12, Martin Kersten a écrit :
> Use vertical decomposition schema design.
>
> create table large( i integer, j integer)
>
> can be represented by
> create table largeI( surrogate integer, i integer );
> create table largeJ( surrogate integer, j integer );
>
> create view large as
> select * from largeI join largeJ
> union
> select * from largeI left outerjoin largeJ
> union
> select * from largeI right outerjoin largeJ
>
> On 7/4/13 8:08 PM, Franck Routier wrote:
>> Hi Martin,
>>
>> Le 04/07/2013 19:04, Martin Kersten a écrit :
>>> You might consider using a large number of columns using your own key,
>>> glued together with a view.
>>>
>> What do you mean by 'using your own key' ?
>>
>> Best regards,
>> Franck
>>
>>
>> _______________________________________________
>> users-list mailing list
>> users-list at monetdb.org
>> http://mail.monetdb.org/mailman/listinfo/users-list
>>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list



-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4477 bytes
Desc: Signature cryptographique S/MIME
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20130705/f2f88c42/attachment.p7s>


More information about the users-list mailing list