Re: Does Codd's view of a relational database differ from that ofDate&Darwin?[M.Gittens]
Date: Fri, 17 Jun 2005 11:35:38 +0200
Jon Heggland schrieb:
> In article <42b182de$1_at_news.fhg.de>, firstname.lastname@example.org says...
>>There is also another problem. Sometimes there are alternative (not >>unique) paths along which we can propagate constraints. In this case the >>database also cannot help but it is not its fault. The model simply does >>not define what path to choose (path is used in terms of COM). >> >>In UR it is a serious drawback bcause it is based on relational model >>(its spirit and fundamental assumptions), it is actually a complement to >>the RM. We need to look at the data differently in order to solve the >>problem.
> I don't really consider this a problem, though. The different paths have
> different semantics, and the user should---no, must---be able to choose
> between them. Views and/or well-designed user interfaces can be used to
> make this more convenient. The (relational) database can indeed help.
> The ORM people have done nifty things in this regard, IIRC.
Yes, I agree. If we have an interactivity then we can solve the problem by asking questions. But I meant that it is a problem when we design our database. At this moment the designer, if he wants to explain what the data means, has to correctly specify the structure of tables. As one extreme we can create a number of tables without any relationships where each query has to contain all instructions (declarative) for building the necessary result set. Another extreme is where all ambiguities are resolved by moving the relationships (joins) into the database where they have a persistent form and are a integral part of the database and data semantics. In this case all simple constraints (imposed on one table) can be formally correctly propagated for getting the result.Received on Fri Jun 17 2005 - 11:35:38 CEST