Failing to load a table

Martin Kersten Martin.Kersten at cwi.nl
Thu Jul 4 20:12:16 CEST 2013


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
>



More information about the users-list mailing list