Обсуждение: Incremental update for matview - automatic trigger-in-c generator

Поиск
Список
Период
Сортировка

Incremental update for matview - automatic trigger-in-c generator

От
Nguyễn Trần Quốc Vinh
Дата:
Dear sir/madam.

We build a program that can automatically generate triggers in C-language for synchronous incremental matview update. It supports queries with limitations:
- inner join
- group by with sum, count, avg, min, max
- the join has to be of the form: t1 1-n t2 1-n t3 1-n t4....

The binary and source can be find at http://it.ued.vn/myprojects/pgTriggerGen/.

It is the first version. We now are build another version with some improvements.

Anyone can use it if they find it useful. All comments, recommendations, improvements are welcome. 

Corresponding address: ntquocvinh@ued.vn.

Thank you for attentions.