Обсуждение: Using Postgres to store genetic data
We're looking at potentially using Postgres to store a variety of molecular and genetic data. At this point I have a bunch of general questions which I can take to other lists if someone can tell me where they would be most appropriate:
1) are there groups or individuals already doing this that have things they can share? I've seen the BLASTgres work and it needs rework to compile against 8.3 but might be potentially useful some of our forms of data;
2) if we do decided to implement our own data types where's the best place for discussion about such efforts?
3) Can anyone talk about what it would take to add columnar indexes to Postgres? Where would be the best place for discussion about what this would take?
I can go into more details here if appropriate and if that will help...
--
Peter Hunsberger
--
Peter Hunsberger
Peter Hunsberger wrote: > We're looking at potentially using Postgres to store a variety of > molecular and genetic data. At this point I have a bunch of general > questions... I don't know enough about your area of expertise to know if this is useful, but I'd look at the Unison project to see what they are doing. There are also videos/slides up from a recent San Francisco PUG meeting at UCSF that might be of interest: http://www.vimeo.com/3732938 http://www.slideshare.net/linuxpoet/unison-ucsf-sfpug
On Fri, Jul 10, 2009 at 4:02 PM, Steve Crawford <scrawford@pinpointresearch.com> wrote: > > Peter Hunsberger wrote: >> >> We're looking at potentially using Postgres to store a variety of molecular and genetic data. At this point I have abunch of general questions... > > I don't know enough about your area of expertise to know if this is useful, but I'd look at the Unison project to see whatthey are doing. There are also videos/slides up from a recent San Francisco PUG meeting at UCSF that might be of interest: > > http://www.vimeo.com/3732938 > http://www.slideshare.net/linuxpoet/unison-ucsf-sfpug > Looks like it may be somewhat applicable to my first question. Thanks. Area of expertise is application architecture and design, focusing on clinical systems for medical research these last 7 years or so and medical in general for the last 15. Adding the genomic and molecular world to the mix is a new initiative. At the moment I've got enough domain knowledge to be dangerous... -- Peter Hunsberger
Peter-
if by 'dangerous' you mean employable then count me in!
Oracle is probably the only DB vendor which implements Clinical Informatics product
would like to hear about any Clinical Informatics offerings postgres would offer
I'm thinking a relational tree might work something like
Gene ->1..n-> Sequence(s) ->1..n-> GCATPermutations
thanks,
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
> Date: Fri, 10 Jul 2009 21:56:09 -0500
> Subject: Re: [GENERAL] Using Postgres to store genetic data
> From: peter.hunsberger@gmail.com
> To: scrawford@pinpointresearch.com
> CC: pgsql-general@postgresql.org
>
> On Fri, Jul 10, 2009 at 4:02 PM, Steve Crawford
> <scrawford@pinpointresearch.com> wrote:
> >
> > Peter Hunsberger wrote:
> >>
> >> We're looking at potentially using Postgres to store a variety of molecular and genetic data. At this point I have a bunch of general questions...
> >
> > I don't know enough about your area of expertise to know if this is useful, but I'd look at the Unison project to see what they are doing. There are also videos/slides up from a recent San Francisco PUG meeting at UCSF that might be of interest:
> >
> > http://www.vimeo.com/3732938
> > http://www.slideshare.net/linuxpoet/unison-ucsf-sfpug
> >
>
> Looks like it may be somewhat applicable to my first question. Thanks.
>
> Area of expertise is application architecture and design, focusing on
> clinical systems for medical research these last 7 years or so and
> medical in general for the last 15. Adding the genomic and molecular
> world to the mix is a new initiative. At the moment I've got enough
> domain knowledge to be dangerous...
>
> --
> Peter Hunsberger
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Lauren found her dream laptop. Find the PC that’s right for you.
if by 'dangerous' you mean employable then count me in!
Oracle is probably the only DB vendor which implements Clinical Informatics product
would like to hear about any Clinical Informatics offerings postgres would offer
I'm thinking a relational tree might work something like
Gene ->1..n-> Sequence(s) ->1..n-> GCATPermutations
thanks,
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
> Date: Fri, 10 Jul 2009 21:56:09 -0500
> Subject: Re: [GENERAL] Using Postgres to store genetic data
> From: peter.hunsberger@gmail.com
> To: scrawford@pinpointresearch.com
> CC: pgsql-general@postgresql.org
>
> On Fri, Jul 10, 2009 at 4:02 PM, Steve Crawford
> <scrawford@pinpointresearch.com> wrote:
> >
> > Peter Hunsberger wrote:
> >>
> >> We're looking at potentially using Postgres to store a variety of molecular and genetic data. At this point I have a bunch of general questions...
> >
> > I don't know enough about your area of expertise to know if this is useful, but I'd look at the Unison project to see what they are doing. There are also videos/slides up from a recent San Francisco PUG meeting at UCSF that might be of interest:
> >
> > http://www.vimeo.com/3732938
> > http://www.slideshare.net/linuxpoet/unison-ucsf-sfpug
> >
>
> Looks like it may be somewhat applicable to my first question. Thanks.
>
> Area of expertise is application architecture and design, focusing on
> clinical systems for medical research these last 7 years or so and
> medical in general for the last 15. Adding the genomic and molecular
> world to the mix is a new initiative. At the moment I've got enough
> domain knowledge to be dangerous...
>
> --
> Peter Hunsberger
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Lauren found her dream laptop. Find the PC that’s right for you.