Re: Another view on analysis and ER

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Fri, 07 Dec 2007 22:16:43 -0400
Message-ID: <4759fe8d$0$5272$9a566e8b@news.aliant.net>

paul c wrote:

> mAsterdam wrote:
>

>> paul c schreef:
>>
>>> mAsterdam wrote:
>>>
>>>> paul c schreef:
>>>>
>>>>> <Nomme, Ans>
>>>>> <Name, Years>
>>>>>
>>>>> are different headings.
>>>>
>>>> Yes. However, having multiple headings in one relation
>>>> is not part of RM AFAIK. ...
>>>
>>> Who said anything about multiple headings in one relation?
>>
>> I did. It is the way I labelled:
>>
>>  >>> <Nomme, Ans>
>>  >>> <Name, Years>
>>
>> ... appearantly not something you intended.
>> Why not - or, better: what are they?

>
> Oh, it was you, was it? Whew, that was a close one. Maybe I misled
> with the tilted carets or whatever they're called and should have used
> braces, also by abbreviating them without type names, which seems common
> whenever the purpose isn't affected.
>
> Anyway, I suppose there might not be anything theoretically wrong with
> an rdbms that allowed multi-lingual headings, so that the Frenchman
> could pretend the db was using his lingo and the Englishman his,
> although they might get up to more hijinks whenever RENAME came into
> play than those two nationalities ever did in the last 900 years.

If one wants this feature, all one has to do is declare a bunch of views.

> If you insist on such a thing, I hope you'll call them some kind of
> alias as I think there is already more than enough multi-lingual false
> correctness in the world.

View === some kind of alias

> As the Mott's Clamato man said, why stop there? Might as well have
> multi-lingual aliases for relation and relvar names too. What the heck,
> do similar for values in tuples. For a while, the effect might be
> drastically deleterious for update performance, but eventually an
> optimization theory might appear. So typical of the IT world to
> optimize the tool rather than the problem. The DB world being so
> over-endowed with clarity, I guess adding a good dose of obscurity can't
> hurt it either!
>
> (Just my not too blunt way of doing my bit and helping us all yet again
> that explaining analysis and design is harder than doing it.)
Received on Fri Dec 07 2007 - 20:16:43 CST