On 28/07/08 10:17 AM, "Dan Staines" <[EMAIL PROTECTED]> wrote:
>
>
> Dear all,
>
> I'm after some general guidance on how to either customise mart builder
> or how I use it to refine the way in which datasets are built and wonder
> if anyone has any advice on the best way forward.
>
> I need to be able to build multiple datasets from a single database
> (well, multiple datasets from each of multiple databases), using a SQL
> clause or similar to restrict the scope of the queries used to build
> each dataset from the original database (in my case, to a subset of
> genes). I don't see any scope for this in MartBuilder (please correct me
> if I'm missing something!), but three approaches seem plausible:
> 1. build a mart with one and then write some SQL to automatically
> subdivide a dataset into multiple sets by lots of select/insert
> 2. modify the SQL produced by martbuilder to add some clauses in the selects
> 3. modify martbuilder to add clauses to the SQL generated based on given
> criteria.
>
> Does anyone have any advice on the best way for me to proceed? I'm more
> than happy to get my hands dirty in martj if need be...
>
Hi Dan,
You may want to have a closer look at partition options. If you want to see
how this is configured look at mart-xml/builder/ensembl_50.xml in mart-xml
cvs module. This includes both dataset level partitions and table
partitions.
Please let me know if you need more info
A.
> Cheers,
>
> Dan.
>
> --
> Dan Staines, PhD
> EMBL-European Bioinformatics Institute Tel: +44-(0)1223-492507
> Wellcome Trust Genome Campus, Hinxton Fax: +44-(0)1223-494468
> Cambridge CB10 1SD, UK email: [EMAIL PROTECTED]
