I thought this was done "behind the scenes" ? For our part we are looking with interest at what comes out of the mix in terms of XML & databases over the next 18 months or so from the "big 3" - Oracle, SQL Server & DB2.
If we get these facilities "natively" from U2 (or another mv player), great. If not, then we have "Plan V" :-) Ross Ferris Stamina Software Visage – an Evolution in Software Development >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of Steve Mayo >Sent: Thursday, 15 April 2004 4:01 AM >To: U2 Users Discussion List >Subject: RE: The future of U2 > >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 > > >--- >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
