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
>