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