| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: The naive test for equality
dawn wrote:
> VC wrote:
> > "dawn" <dawnwolthuis_at_gmail.com> wrote in message
> > news:1123732114.308246.150230_at_g49g2000cwa.googlegroups.com...
> > > VC wrote:
> > ....
> > >
> > >> You are kidding, right ? If the modellers chose the name/label "source"
> > >> and
> > >> did not define what entity the name refers to, then the name is just
> > >> meaningless, like say "fshsalkfd". Apparently, your hypothetical
> > >> modellers
> > >> are not modellers but some kind of impostors.
> > >
> > > It is usually much more subtle than that. Everyone agrees that we need
> > > to know whether or not someone is a fullTimeStudent. Ignore the fact
> > > that this would likely be a derived attribute -- it illustrates the
> > > problem. After some sessions with folks from many departments, the
> > > analyst works to get more precision and sits down with someone who
> > > knows all of the tuition rules, along with another person ('cause the
> > > analyst is no rookie) and they nail down this attribute with the
> > > precision of a surgeon.
> > >
> > > The system goes live and the financial aid people are irate! Federal
> > > aid has just been removed from students because they were no longer
> > > flagged as being a fullTimeStudent when by the standards for this
> > > financial aid, they clearly ARE a fullTimeStudent.
> > >
> > > Then you find out that these two departments use the very same term and
> > > might even both have external reasons to use the very same term, and
> > > they use it with just slightly different meanings.
> > >
> >
> > Apparently, the analysts made a mistake in assuming that the set of
> > fullTimeStudents is equal to the set of studentsEligibleForFinancialAid.
>
That's life. If the analyst was unable to anticipate some changes, then they can be introduced later. It's called schema evolution.
>> > did not claim that one can correctly analyze a complex system at one go,
> > I
>
>
It most certainly was not. It was about an incorrectly specified predicate defining set of students eligible for financial aid. What attribute (and its name) did you have in mind ?
>
>
In this case, during the analysis stage, one could have identified a more generic entity, say, Person with entity subtypes of Student and Customer.
> That is just an example,
> but the point is that entity names are also just words and are
> interpreted by humans, each of whom brings a different context to the
> meaning of the word.
You are quite right that names are just words without any specific meaning [in the modelling context]. That's why it's necessary to identify the actual entities (attributes, relations, etc) first and then give them names. That's what, among other things, modelling is about, no ?
>
![]() |
![]() |