Re: Oracle 9i features?

Daniel Morgan wrote:
>
> Serge Rielau wrote:
>
> > I shouldn'thave given the SQL Server example. Should have known only
> > that part would be addressed, my bad.
> > I don't think Pascal's question was whether Oracle can create a view.
> > Let's presume a more complex example to illustrate.
> > Be somecol a shape and morecol another shape. now use intersect(comecol,
> > morecol)->shape.
> > overlap() is an expensive operation. The idea is to keep the computed
> > result persistent for faster access to shift the computation from the
> > frequent select to the rarer update at the cost of storage.
> >
> > Cheers
> > Serge
>
> Well don't let Joe Celko see this or he'll go ballistic. There is almost
> no excuse in a relational database for storing computation results.
> Perhaps in a datamart storing metadata but not in an OLTP system. I'd
> solve the problem in Oracle 9i or 10g by writing a function, native
> compiled in C, the compute the result on-the-fly.
>

Ya-but ... the competitor does it, so it must be OK <g>

However, the shape example above is kind-a irrelevant since that is aleady available in intermedia locator and spatial. So we can say - been there, done that (using the solution you outline).

/Hans Received on Sun Feb 08 2004 - 17:32:51 CST