Re: In an RDBMS, what does "Data" mean?

"mAsterdam" <mAsterdam_at_vrijdag.org> wrote in message news:40ce486e$0$568$e4fe514c_at_news.xs4all.nl...
> Anthony W. Youngman wrote:
>
> [snip]
> > Chopping up is just as easy in MV. The difference is, (a) you're not
> > required to do it to get the data IN to the database, and (b) if you've
> > done it properly, the database will do it for you when you want to get
> > the data OUT.
>
> Magic! Yey!
>
> >> Now, I also want one listing for the measurements of stock turnaround,
> >> in order to aim for just-in-time logistics and optimally sized orders.
> >> In an RDBMS I would create another view on the same schema. Would, in
> >> MV, another portal be the way to approach this?
> >
> > Not quite sure what you mean by portal but ...
>
> Ask Dawn. I was trying to figure out what a portal is.

Another place where the current words don't quite cut it -- I have used that term as an entry point for users to see their data. In a SQL-DBMS, that would be any RELATION for which the user has proper security. In Pick, it is a DICTionary for a FILE. There are considerably differences between these concepts, however, but both provide a vocabulary and means into the data for the user.

> > To get the invoice data
> > LIST INVOICES BY _at_ID field-names
> >
> > and to get a listing of what's shipped grouped by stock code
> > LIST INVOICES BY.EXP STOCK-CODE field-names.
> >
> > In other words, I've just changed the sort criteria from the primary
> > single-valued invoice number to the multi-valued stock code, and the db
> > will chuck a different view of the data at me.
>
> The logistic manager is not iterested in INVOICES.
> Why do you bother her with INVOICES? She wants to see
> SHELVES, WAREHOUSES, ORDERQUANTITIES, PACKLISTS (just adapting
> to your shouting habit ;-)

I think we can safely say that Wol isn't shouting, but rather providing us a history lesson regarding use of upper case for file and field names. And if she wants to see SHELVES, she will undoubtedly go to the SHELVES "portal" to find that information. Cheers! --dawn Received on Tue Jun 15 2004 - 19:02:44 CEST