Re: [GENERAL] Incremental refresh - Materialized view

From: Nguyễn Trần Quốc Vinh <ntquocvinh(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Incremental refresh - Materialized view
Date: 2019-01-02 08:44:50
Message-ID: CAAU9oxuUq+iemCofZ3_zsXH1F7gvP3tms2NGnQ2g0o=WD7AiOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Dear all,
>
> We have some result on incremental update for MVs. We generate triggers in
> C to do the incremental maintenance. We posted the code to github about 1
> year ago, but unfortunately i posted a not-right version of ctrigger.h
> header. The mistake was exposed to me when a person could not compile the
> generated triggers and reported to me. And now i re-posted with the right
> ctrigger.h file.
>
> You can find the codes of the generator here:
> https://github.com/ntqvinh/PgMvIncrementalUpdate/commits/master. You can
> find how did we do here:
> https://link.springer.com/article/10.1134/S0361768816050066. The paper is
> about generating of codes in pl/pgsql. Anyway i see it is useful for
> reading the codes. I don't know if i can share the paper or not so that i
> don't publish anywhere else. The text about how to generate triggers in C
> was published with open-access but unfortunately, it is in Vietnamese.
>
> We are happy if the codes are useful for someone.
>
> Thank you and best regards,
>
> NTQ Vinh
>
--
TS. Nguyễn Trần Quốc Vinh
-----------------------------------------------
Chủ nhiệm khoa Tin học
Trường ĐH Sư phạm - ĐH Đà Nẵng
------------------------------------------------
Nguyen Tran Quoc Vinh, PhD
Dean
Faculty of Information Technology
Danang University of Education
Website: http://it.ued.udn.vn; http://www.ued.vn <http://www.ued.udn.vn/>;
http://www.ued.udn.vn
SCV: http://scv.ued.vn/~ntquocvinh <http://scv.ued.udn.vn/~ntquocvinh>
Phone: (+84) 511.6-512-586
Mobile: (+84) 914.78-08-98

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2019-01-02 10:31:34 Re: Thoughts on row-level security for webapps?
Previous Message Rob Sargent 2019-01-02 01:21:25 Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL