Re: storage of sensor data with Fourier transforms

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: storage of sensor data with Fourier transforms
Дата
Msg-id 19235.1178376199@sss.pgh.pa.us
обсуждение исходный текст
Ответ на storage of sensor data with Fourier transforms  ("Nathan Buchanan" <nbinont@gmail.com>)
Ответы Re: storage of sensor data with Fourier transforms  ("Nathan Buchanan" <nbinont@gmail.com>)
Список pgsql-hackers
"Nathan Buchanan" <nbinont@gmail.com> writes:
> I had the idea of taking the Fourier transform of the waveform and storing
> the waveform internally that way to reduce storage requirements.

Aside from what Steve said: The Fourier transform in itself doesn't
reduce data size --- it's N points in, N points out.  If you want to
reduce storage requirements you have to resort to lossy compression, ie,
deliberately throwing away some data.  The transformed data might be
more suitable for doing that (eg you can selectively discard
high-frequency components) but do you really want to?  Usually the point
of storing measurements is so you can do unspecified analysis on them
later.  Applying lossy compression will restrict what you can
(meaningfully) do later on.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Cache plan invalidation
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Cache plan invalidation