Re: Modeling Data for XML instead of SQL-DBMS
Date: 27 Oct 2006 14:02:24 -0700
Message-ID: <1161982944.123108.35990_at_m7g2000cwm.googlegroups.com>
mAsterdam wrote:
> dawn wrote:
> > mAsterdam wrote:
> >> dawn wrote:
> >>> mAsterdam wrote:
> >>>> dawn wrote:
> >>>>> mAsterdam wrote:
> >>>>>> dawn wrote:
> >>>>>>> mAsterdam wrote:
> > <snip>
> >> In the logical model there is strictly no
> >> more need for implementation specifics than in the conceptual
> >> model. However, the team is closer to cut-over day, so
> >> implementation is more on their mind. So in real logical model
> >> documents you will see some implementation stuff, but that
> >> is noise, not signal.
> >
> > OK. Restating this, I think that here you are saying that a designer
> > could create a logical data model without knowing whether the
> > implementation will use a SQL-DBMS, a MUMPs product, a Nelson-Pick
> > product, or XML. Additionally I think you are saying that when the
> > design does know the target, this often influences the logical data
> ^team<
> > model, but that is not a good thing.
>
> Yep.
>> >>> process (the implementation model). It is the last one that includes
> >>> there we go to "design." I think of the conceptual model as analysis
> >>> and the logical model as design. I don't really think about any other
> >>> models, with iterations of the logical model until it becomes the
> >>> version of the logical model that gets implemented. I used to think of
> >>> the logical model as the one at the start of that process, but after
> >>> reading a bit, I started to think of it as the one at the end of the
> >>> design related to optimizing for the target environment.
>> > Why should they be forbidden when they are quite viable logically and
> >> If these different models are defined, they are
> >> defined as deliverables in some 'formal' (handbook/official/case-tool)
> >> software development process. There is no generally accepted
> >> reference process, AFAIK, so I have to rely on those I dealt with.
> >> In one official process the requirements for these deliverables
> >> (or artifacts if you prefer) were such that the conceptual models
> >> allowed for many to many relationships, while in the (integrated)
> >> logical model they were forbidden.
> >
> > can be implemented in some DBMS tools?
>
> [m:n]
> No 'should', really. Whatever the implementation will be,
> at some point in the process the many to many relationships
> will have to be transformed into named things
> (SQL: tables with at least two foreign keys, Codasyl: records
> in at least two sets, etcetera).
Am I missing the mark on what you are saying? Thanks. --dawn Received on Fri Oct 27 2006 - 23:02:24 CEST
