The way that jBase handles the problem is by requiring the database be flattened out (i.e., no multivalues) and strict data typing. This is of course the standard with 1NF databases. Unfortunately for most of us, it means a complete redesign of the existing mv database structure. Over the past several years, all new systems that I have developed have used 1NF. Still most of the data still uses multivalues and would take years to convert. :-)
Steve >Implementation wise, I think there are some "right" and "wrong" decisions that could be made. One of the "biggies" has to do with data typing, and the "common" practice multiply defining a field for different purposes - you know the drill - <1> might be a date, or a null, or some kind of flag. > >This would obviously have an impact on the ability to "get at" data with SQL - assuming that records aren't stored as "blob/glob" as some products do. > >The message in this I suppose is to make sure that your database is "tight" if you are looking at walking down this path .... and before you say "we never do that", take a good, hard look at any temporary work files your application might use as an intermediate staging point !! > >Ross Ferris >Stamina Software >Visage – an Evolution in Software Development > > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>Behalf Of Dawn M. Wolthuis >>Sent: Thursday, 15 April 2004 3:30 AM >>To: 'U2 Users Discussion List' >>Subject: RE: The future of U2 >> >>I don't know the answer to this, but the picture in my head would permit >>SQL >>against the DB2 structures directly, so I'm guessing that will help for >>anyone requiring SQL. >> >>More importantly for the future, it will be important that anyone using >>this >>model be able to use their DB2 data through the multivalue/XML-model U2 >>view >>of the data. It would be a shame to take the data that is in non-1NF, then >>implement it in a 1NF model (which they might not be doing since DB2 has >>some other possibilities?) and then extract it into a non-1NF format for >>web >>services, for example. Direct U2<-->XML would be much smarter, I would >>think. >> >>--dawn >> >>Dawn M. Wolthuis >>Tincat Group, Inc. >>www.tincat-group.com >> >>Take and give some delight today. >> >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>Behalf Of Tom Firl >>Sent: Wednesday, April 14, 2004 10:27 AM >>To: U2 Users Discussion List >>Subject: RE: The future of U2 >> >>Has any one heard any specifics about the implementation? I'd be >>interested >>in knowing whether or not Universe applications using DB2 as a data store >>will require setting up a Universe SQL schema. I'm supposing that it >>will... >> >>Tom Firl >>Columbia Ultimate >> >>> -----Original Message----- >>> From: Roger Glenfield [mailto:[EMAIL PROTECTED] >>> Sent: Tuesday, April 13, 2004 8:21 PM >>> To: U2 Users Discussion List >>> Subject: RE: The future of U2 >>> >>> >>> I believe the wording was DB2 and then others based on 'demand'. >>> >>> Roger >>> >>> > -----Original Message----- >>> > From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] >>> > Behalf Of Ross Ferris >>> > Sent: Tuesday, April 13, 2004 11:06 PM >>> > To: U2 Users Discussion List >>> > Subject: RE: The future of U2 >>> > >>> > >>> > I'd also think that rather than "any" database, the target would >>> > be DB2 :-) >>> > >>> > Ross Ferris >>> > Stamina Software >>> > Visage - an Evolution in Software Development >>> > >>> > >>> > http://www.oliver.com/mailman/listinfo/u2-users >>> >>> >>> -- >>> u2-users mailing list >>> [EMAIL PROTECTED] >>> http://www.oliver.com/mailman/listinfo/u2-users >>> >>-- >>u2-users mailing list >>[EMAIL PROTECTED] >>http://www.oliver.com/mailman/listinfo/u2-users >> >>-- >>u2-users mailing list >>[EMAIL PROTECTED] >>http://www.oliver.com/mailman/listinfo/u2-users >> >> >>--- >>Incoming mail is certified Virus Free. >>Checked by AVG anti-virus system (http://www.grisoft.com). >>Version: 6.0.656 / Virus Database: 421 - Release Date: 9/04/2004 >> > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.656 / Virus Database: 421 - Release Date: 9/04/2004 > >-- >u2-users mailing list >[EMAIL PROTECTED] >http://www.oliver.com/mailman/listinfo/u2-users > > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
