Yes, an RDBMS is still a costly investment for any company and that won't change by front-ending it with what is otherwise bigger-bang-for-the-buck software. The way DB2 does constraint-handling, strong-typing, NULL-handling, etc are likely to be reasons to stick with what works and doesn't require additional staffing.
Relational databases are the king of the hill now, but they are definitely more concerned about their rear view mirror than they have been in the past couple of decades and in that rear view mirror are some sights that would make me think twice before any investment in any SQL-based products. But, well, that's just an opinion. Smiles. --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 Ross Ferris Sent: Wednesday, April 14, 2004 6:57 PM To: U2 Users Discussion List Subject: RE: The future of U2 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