Re: Materialized views proposal

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 26 November 2003 09:19, Hannu Krosing wrote:
>
> First, You could start by implementing materialized views manually,
> using tables and triggers, to get the feel of what should be generated.
>
> Next, still working from frontend, try to make some code (probably in
> some RAD/scripring language) which does the transform from CREATE VIEW
> (or whatever) syntax (or manually constructed syntax tree) into create
> table + create trigger statements.
>
> If you have the above working well, talk about moving this to backend.
>

Thanks for the suggestion. I will definitely do that.

> What is needed is good algorithms. Writing C code is secondary to that.
>
> Similar problem has kept us from implementing updatable views for quite
> some time.
>

You are definitely correct.

- --
Jonathan M. Gardner
Web Developer, Amazon.com
jonagard(at)amazon(dot)com - (206) 266-2906
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/xPfOBFeYcclU5Q0RAhgfAKDAYmm67Jc5n7WwyUDtn5IJOhhrXwCfcRud
EAR9U63FEqlHbGrdzKxGmdw=
=a6RK
-----END PGP SIGNATURE-----