Re: spectral datasets in postgresql

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(at)ontko(dot)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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Glenn Sullivan
> Sent: Thursday, November 15, 2001 5:32 PM
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
>