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: Jan Hidders <hidders_at_gmail.com>
Date: 25 Apr 2006 09:53:49 -0700
Message-ID: <1145984029.705210.318340@j33g2000cwa.googlegroups.com>

dawn wrote:
>
> 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.

Sweet is a matter of taste, but I would say it is quite simple. To get a feeling see slide 31 of

www.starlab.vub.ac.be/staff/robert/InleidingDB/Silberschatz%20ppt%20files%20etc/ch09%20ORDB.ppt

> OK, so let's say that relational theory has caught up with Pick ;-) in
> these ways (NF2, 2VL, and LVAs). Where is this implemented.

In the DBMSs I mentioned.

> How I can I get access to this data from any reporting or BI tools?

The usual way one gets information out of a SQL-DBMS. :-P IIRC JDBC 3.0 has caught up with SQL:1999.

Received on Tue Apr 25 2006 - 11:53:49 CDT

Original text of this message

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