Re: When is a NULL Not a NULL ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

« Do you ever feel the need to denormalise a database for the sake of the
user interface? »

The Users interface is with an application and in turn the application
interfaces with the database.

Even the applications may not see the underlying base tables.

Yeah, I do when there is a speed problem. A database is not some god
living in its own universe but a piece of software to be used by people
not only for them to enter data at one end but also for them to read data
at the other end.

Whilst denormalisation is generally wrong, some people think they are
denormalising when what they are doing is adjusting an over normalised
design, by that I mean the design has been more influenced by global
concerns than the actual problem domain being modelled.

However denormalisation can often result in fast access to garbage, without
taking a whole series of precautions to make up for the failings in the
database design.

As to Nulls, I much prefer the elimination of -most- Nulls, it is fairly
straightforward with careful design

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:e$WaMAOsGHA.4752@xxxxxxxxxxxxxxxxxxxxxxx


.

Relevant Pages

  • Re: Help understanding object-oriented approach
    ... I have a number of the class OO books which help me understand the principals, but, not how to leverage those principals in to system design. ... Now, we want to save this information in to a database, what is the correct way for doing this; is it to create a saveCD method in my musicCD class? ... Surely in the OO concept the MusicCD class doesn't need to know about my table structure etc, would this be a case for a MusicCDDatabase class which knows about MusicCD and DB? ... The O.O. system is told that for some methods it needs a user interface, thus the instance constructors accept parameters that indicate which parts of an existing user interface belongs to which method. ...
    (comp.lang.php)
  • Re: Is this too much OOP?
    ... I have an app that hits the database. ... That's about as much OOP design I have done. ... In a lot of RDBMS based applications, most of the logic is really in the database itself, and the application is mostly a user interface - which can in itself be somewhat more complex than the RBBMS based part!-) ... So is your application really modeling the "domain", or in fact modeling the interaction between the user and the RDBMS? ...
    (comp.object)
  • Re: Two many controls
    ... Access would complain that you have too many controls on the form. ... To get around this problem, create a new database, and import the offending ... I've never seen a user interface where large numbers of ... when i open it for design, ...
    (microsoft.public.access.formscoding)
  • Re: Why the iPhone will Slaughter the Linux based phones.
    ... ZnU wants Linux to have only ... For people who do not care about usability / productivity there is no reason ... universal foundations in UI design that would make all variations better ... Lorne Olfman "User Interface Consistency ...
    (comp.sys.mac.advocacy)
  • Re: Stategy for (Large?) 16bit COBOL code conversion to Net Express
    ... Express and Visual studio 2005 loaded on a Windows 2003 Terminal server. ... database and GUI, respectively. ... have the business logic on Unix and the user interface on Windows. ... By the same token, they don't judge a system by its browser security, either. ...
    (comp.lang.cobol)