Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Lucid statement of the MV vs RM position?

Re: Lucid statement of the MV vs RM position?

From: dawn <dawnwolthuis_at_gmail.com>
Date: 24 Apr 2006 11:06:29 -0700
Message-ID: <1145901989.675970.236250@i39g2000cwa.googlegroups.com>

Jan Hidders wrote:
> Jan Hidders wrote:
> > dawn wrote:
> > > If you
> > > are saying that every site can implement it, including making any
> > > relevant changes to the query language, has anyone done that?
> >
> > Yes. User-defined types (UDTs) were already added in SQL:1999.
>
> Silly me. More to the point is of course the ARRAY type in SQL:1999.
> For an example and short explanation see:
>
> http://www.cl.cam.ac.uk/Teaching/2003/Databases/sql1999.pdf
>
> There they are still bounded, in SQL:2003 they are also allowed to be
> unbounded.

Cool. We would surely want variable length (and the ability to ask the length). I still don't see where you can work with these arrays as one (I, at least) would want to, with grouping and ungrouping, for example.  I would want to be able to ask for all students with every major not equal to 'PHIL' for example, even if we opted to implement majors in a list. I would hope there is some way to do that with the functions provided, but my guess (without being able to find examples right off) is that the SQL might not be really sweet.

OK, so let's say that relational theory has caught up with Pick ;-) in these ways (NF2, 2VL, and LVAs). Where is this implemented. How I can I get access to this data from any reporting or BI tools?

This is very helpful. Thanks. --dawn Received on Mon Apr 24 2006 - 13:06:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US