[Nottingham] TALK: Relational databases, SQL and PostgreSQL.

Martin Garton martin at stupids.org
Mon Jan 15 15:11:31 GMT 2007


On Mon, 2007-01-15 at 06:56 -0800, Ovid wrote:
> --- Martin Garton <martin at stupids.org> wrote:
> 
> > I believe oracle has something similar that may or not be called
> > materialised views.
> 
> Yes.  Because they're static, you need to remember to update them every
> once in a while, but they're very handy (it's been a while since I've
> worked with Oracle, though, so this may have changed).

Right.  The db2 ones can either be set to manual refresh, or immediate
refresh (where it is always up to date.) Of course immediate refresh may
be too expensive in some situations.

> > Hmmm. given all this recent discussion on list, my talk on Thursday
> > is going to seem very basic..
> 
> I suspect that your talk will seem like a relief to many :)

I hope so!

-- 
Martin.





More information about the Nottingham mailing list