Re: Is it Possible to Enforce This Relationship at the DB Level?
Date: 24 Oct 2007 09:44:02 -0700
Message-ID: <1193204566.898245.140840_at_i13g2000prf.googlegroups.com>
On Oct 22, 11:33 am, Cimode <cim..._at_hotmail.com> wrote:
> On 22 oct, 18:42, dutone <dut..._at_hotmail.com> wrote:
>
>
>
> > > > > > > In *no case* presentation should determine design. Proper design
> > > > > > > should be the consequence of studying sound principles of relational
> > > > > > > modeling.
>
> > > > > > Huh, who said anything about presentation? I'm trying to construct an
> > > > > > appropriate data model based on a set of business rules.
> > > > > > Thanks for the advice....
>
> > > > > "client", "spreadsheet", "cells", etc. all sound like user interface
> > > > > or
> > > > > presentation concepts. Difficult to tell without working definitions
> > > > > for these entities that you have identified, though.
>
> > > > Yes, words can imply a specific idea to someone at first; context,
> > > > context, context.
> > > > In my case, spreadsheets are what drives the whole process and must be
> > > > decomposed before additional processes can take place.
> > > > The associated tables the represent configuration information each
> > > > client's service has.
>
> > > Ok let me get this straight...you are basically saying to people here
> > > that you want to design a system which purpose would be building a
> > > data store where propositions would be presentation elements and then
> > > your pretend that it has nothing to do with a confusion between
> > > presentation and data layer.
>
> > > Is it me or is this a joke.
>
> > You're a joke.
>
> Looking at the epidermic way you react to something so obvious makes a
> clear cut case of your ignorance and confusion. Both TroyK and I have
> tried to point out an obvious confusion but you keep arguing for some
> obscure reasons meaningful only to you. Case closed.
> > Why don't you quit deferring to the notion of spreadsheets being a
> > presentation element and look at the problem for what it is?
>
> I doubt the problem here is truly about design or even spreadsheets.
Well you dolt, initially it was about design, until you chimed in.
> position to have to design a db system with no formal education about
> relational modeling, you simply rely on the some magical hope to find
> an online cookbook approach that would help you look good with your
> boss...
Not true.
> and hope that somebody will do it for you without getting paid.
No you sot, thats your hope.
> > I'm automatically importing spreadsheet data sent from various
> > clients, all of whom will be sending them in different formats.
>
> You do not need anything else than a name an X and a Y and a content
> represent spreadsheet information which obviously is not sufficient to
> qualify data a being structured and therefore ready to be structured.
> > In the scope of my system, what way, other than the fact they are called
> > "spreadsheets", are they being used as a presentation element?
>
> What else could they be?
Humm, maybe a datasource!
> > Should I cajole the clients to export their spreadsheets to CSV,XML, or
> > maybe YAML to avoid using a presentation element?
>
> If you are convinced that it is simpler to export data into some
> format, send it and reparsing it back into a database instead of
> directly interfacing directly with their original data source that
> simply show how hopeless is your enterprise to build a decent system.
Please, don't act like you're offering some sort of insight by
answering a nonsensical rhetorical question. You are so pathetic,
whew, it just keeps getting better: you deride my initial post's
content, yet respond to something that's not only mentioned for
satirical purposes, but off topic for this newsgroup. Come on, you
seem like someone who would be so quick to run your mouth about off
topic posters and newsgroup FAQs.
> > Where should one store vital configuration information related to key
> > entities then? Based on your stunning analysis, should I conclude that
> > using a database to store configuration information is wrong? Oh, I
> > hope someone tells all the CMS DB designers that they've been mixing
> > presentation and data layers.
>
> If they are as self assured and vociferous about their ignorance as
> you are, I have *no* doubt they did.
>
> If you plan on being insulting to people who simply try to help, then
> you can go fuck yourself.
Try to help; you really are a dickhead. Who did I insult that has helped me? The only one I have insulted is you. In no way have you tried to help anything but your own weak arguments. Received on Wed Oct 24 2007 - 18:44:02 CEST