On 10 Jan 2007, at 19:06, Marina Olhovsky wrote:
Hi Arek,
If both packets_tbl and association_tbl have FK rID referencing
reagents_tbl, how come I cannot make both packets_tbl and
association_tbl subclass reagents_tbl in the same dataset? Each of
packets_tbl and association_tbl has dimension tables of its own;
depending on which dimension table name I choose to include in the
dataset creation I can force either packets_tbl or association_tbl to
subclass reagents_tbl, the other becomes dimension - the same scenario
I get when I create separate datasets. What sort of configuration
should I undertake if I need to set filters on both the association
type and packet number in reagent search? Thank you very much.
Hi Marina,
the MBuilder algorithm will not allow you to do it because the BioMart
query software
will not understand such structure. You can have multiple subclass
tables
only if they become a subclass of a subclass etc and no two tables can
be
sub-classed from one. Basically, you have three options there:
1. reagents main and packets and association dimensions
2. reagents main, packets main (subclass) and association dimension
3. reagents main, association main (subclass) and packets dimension
It is important to realize that as far as querying is concerned you will
end up with equivalent query options and subclassing is only really
important if your subclasses can have independent dimensions which
in your schema does not seem to be the case.
As far as filtering is concerned, you can have identical filtering
options
in all three cases, the only difference is that MEditor will create
filters
automatically for the main tables so it will save you some work of
manually
creating them but again normally you do not require a filter on every
single
column anyway.
I'd suggest that you try all three combinations as three separate
datasets
and configure them with MEditor point your website at them and choose
the one you like the most as you can make them look identical in your
website anyway :)
a.
Best regards,
Marina.
---------------------------------------------------------
Marina Olhovsky
Software Engineer, Pawson Laboratory
Mount Sinai Hospital
600 University Avenue, Room 1060
Toronto, Ontario, M5G 1X5
[EMAIL PROTECTED]
---------------------------------------------------------
-----Original Message-----
From: Arek Kasprzyk [mailto:[EMAIL PROTECTED]
Sent: Wed 1/10/2007 10:20 AM
To: Marina Olhovsky
Cc: Richard Holland; mart-dev (E-mail)
Subject: Re: [mart-admin] Re: MartBuilder Dataset Error
> > Attaching a use case example of what users in my LIMS system
might
> > want to search for. I will apply Arek's recommendations to set
> > filters on packets in MartEditor.
> >
> > Thank you both very much for your prompt responses, detailed
> > explanations and most valuable recommendations. This is one of
the
> > best learning experiences I've ever had, and your help is most
> greatly
> > appreciated.
> >
> > Best regards,
> > Marina.
>
Hi Marina
I have looked at your example and it seems that it is completely
satisfied through the 'reagents' dataset ei, the default dataset
which you get if you choose 'reagents' as your main table. It seems
however that it would require that you use some of the dimension
filters so you will have to insert them manually during MEditor
configuration step.
The thing to do now would be to come up with more query examples
and check if they they are satisfied through your dataset(s) that you
design
with MBuilder
or alternatively
just to create one - let's say "reagents" using MBuilder,
pop it into your database, configure it with MartEditor and connect to
it with the website you just installed. You should have a pretty good
feel of how the system works by doing that and you'll be able to
design
more datasets or improve existing ones. The great thing about using
MBuilder is that you don't have to worry about trying different
options
as it does not cost you much to create new datasets and modify
exisiting ones :)
please drop us a line if you need more info,
a.
>
>
-----------------------------------------------------------------------
> -
> -------
> Arek Kasprzyk
> EMBL-European Bioinformatics Institute.
> Wellcome Trust Genome Campus, Hinxton,
> Cambridge CB10 1SD, UK.
> Tel: +44-(0)1223-494606
> Fax: +44-(0)1223-494468
>
-----------------------------------------------------------------------
> -
> -------
>
>
>
>
-----------------------------------------------------------------------
-
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
-----------------------------------------------------------------------
-
-------
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
