Re: Does people favor to have matrix data type?

Поиск
Список
Период
Сортировка
От Kouhei Kaigai
Тема Re: Does people favor to have matrix data type?
Дата
Msg-id 9A28C8860F777E439AA12E8AEA7694F8011F55DA@BPXM15GP.gisp.nec.co.jp
обсуждение исходный текст
Ответ на Re: Does people favor to have matrix data type?  (Ants Aasma <ants.aasma@eesti.ee>)
Ответы Re: Does people favor to have matrix data type?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Does people favor to have matrix data type?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
> On Wed, May 25, 2016 at 10:38 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> > On 25 May 2016 at 03:52, Kouhei Kaigai <kaigai@ak.jp.nec.com> wrote:
> >>
> >> In a few days, I'm working for a data type that represents matrix in
> >> mathematical area. Does people favor to have this data type in the core,
> >> not only my extension?
> >
> >
> > If we understood the use case, it might help understand whether to include
> > it or not.
> >
> > Multi-dimensionality of arrays isn't always useful, so this could be good.
> 
> Many natural language and image processing methods extract feature
> vectors that then use some simple distance metric, like dot product to
> calculate vector similarity. For example we presented a latent
> semantic analysis prototype at pgconf.eu 2015 that used real[] to
> store the features and a dotproduct(real[], real[]) real function to
> do similarity matching. However using real[] instead of a hypothetical
> realvector or realmatrix did not prove to be a huge overhead, so
> overall I'm on the fence for the usefulness of a special type. Maybe a
> helper function or two to validate the additional restrictions in a
> check constraint would be enough.
>
The 'matrix' data type as domain type of real[] is an option to implement.
We can define operators on the domain types, thus, it allows us to process
large amount of calculation by one operation, in native binary speed.

My only concern is that domain type is not allowed to define type cast.
If we could add type cast on domain, we can define type transformation from
other array type to matrix.

Thanks,
--
NEC Business Creation Division / PG-Strom Project
KaiGai Kohei <kaigai@ak.jp.nec.com>


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [BUGS] BUG #14155: bloom index error with unlogged table
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Does people favor to have matrix data type?