Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #250

Re: Java Toplink Essentia

Show all headers | View raw

  To: comp.lang.java.databases
"Lew" <noone@lewscanon.com> wrote in message 
news:cqWdnWKfq97dBlXVnZ2dnUVZ_rCdnZ2d@comcast.com...
[ SNIP ]
> I don't know of a term analogous to "normal form" (as in "third normal 
> form") for excessive splitting of tables into many tables; all the normal 
> forms have to do with insufficient splitting.  Advances in the database 
> world occur in how to structure data - relations, normal forms, star 
> schemae, foreign keys, these are the building blocks of DBMSes as classes 
> and objects are of O-O programming.
[ SNIP ]

I've seen this particular operation - splitting one table into many tables 
based on the value of an attribute, and dropping that column - described as 
"attribute splitting". As I understand it this violates Domain Key Normal 
Form (DKNF), because not all of the logical decisions your program would 
want to make are defined by the data.

I'm leery of any approach where domain information is captured only in the 
names of files or database tables. Even when using flat files I'd still want 
to have a header line with information like this.

If the boss absolutely wanted this kind of splitting I'd at least argue for 
keeping a year column in each table, even if it's all the same value for 
each table.

AHS

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Find similar

Thread

Java Toplink Essential - "nicola" <nicola@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
  Re: Java Toplink Essentia "Martin Gregorie" <martin.gregorie@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
    Re: Java Toplink Essentia "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
      Re: Java Toplink Essentia "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000

csiph-web