Re: spectral datasets in postgresql - Mailing list pgsql-general

From Nick Fankhauser
Subject Re: spectral datasets in postgresql
Date
Msg-id NEBBLAAHGLEEPCGOBHDGIEOMDOAA.nickf@ontko.com
Whole thread Raw
In response to spectral datasets in postgresql  (Glenn Sullivan <glenn.sullivan@varianinc.com>)
List pgsql-general
Glenn

If I understand correctly, you're asking if it is possible to represent the
one to many relationship between the spectra & the values they consist of.
The answer is yes- that is one of the things relational databases like
PostgreSQL do well, and what you describe is a fairly simple data structure.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/



> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Glenn Sullivan
> Sent: Thursday, November 15, 2001 5:32 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] spectral datasets in postgresql
>
>
> Hi,
>
> Is it possible/feasible/desirable to use postgresql to hold large spectral
> datasets.  The dataset would consist of a number of attributes and a
> spectrum.  The spectrum is simply a list of floating point
> values.  However,
> there can be from 128 points to 32 million points for one spectrum.
>
> There would then of course be thousands of these spectra.
>
> I don't know how you would save those 32 million points. If you can do
> so, I don't know if it is a feasible way to use postgresql.
>
>
> I welcome your comments.
>
> Glenn
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-general by date:

Previous
From: "Scott Muir"
Date:
Subject: FW: Vacuuming - how often? (scott's fault?)
Next
From: Bruce Momjian
Date:
Subject: Re: 7.2 pg_hba.conf load on SIGHUP?