[NCLUG] normalizing data

[J. Paul Reed]

On Mon, 7 Jan 2002, quent wrote:

> With Oracle, for example, for your summary select, you could create a
> view called "summary" and just do "select * from summary" or some such
> thing.

Right... but if you're using a poor SQL-look-alike frontend to flat files
(i.e. MySQL), then you don't know about views... nor do you know about
referential integrity, transactions, stored procedures, or any of the ACID
properties... which is why if you're going to do database work that matters
(tm) (note to Mike... :-), it's gotta be PostgreSQL (yay!) or something you
pay for (Oracle, Sybase, etc.)

Later,
Paul
   ---------------------------------------------------------------------
   J. Paul Reed               preed at sigkill.com || web.sigkill.com/preed
   It's amazing what a little brain damage will do for your credibility.
                                              -- Leonard Shelby, Memento