Re: IDS to DB2 conversion

Not quite. Federation is more along the lines of a single interface to a collection of other data sources, be they legacy systems, flat files, web pages or competing RDBMS's. But then you know all that. cheers j. ----- Original Message ----- From: "Obnoxio The Clown" <obnoxio@hotmail.com> To: <informix-list@iiug.org> Sent: Tuesday, February 03, 2004 4:14 PM Subject: Re: IDS to DB2 conversion > Serge Rielau wrote: > > > Federation for example? Need in the middleware layer? > > Uhhh... federation? What's that? Sticking tons of big boxes together because > your database server can't handle the load on a single instance? > > And I don't see why a database should have to compensate for badly designed > middleware? > > > Also this is the principle of bang-for-the-buck. > > It is? > > > I can tell you first hand that sequences and serial/identity are nearly > > identical under the hood. But one gives more options than the other. > > Personally I'm a fan of RISC. Use the least number of features that > > yield the most function. > > Sequence + before trigger = serial/identity > > How do you go from a serial/identity to a sequence? > > A major ISV asked us this question a few years back. I couldn't come up > > with a good answer. Best I could propose was to use a table with serial > > and keep inserting into it. Then garbage collect on occassion. > > Got a better idea? > > Stick with the serial? > > -- > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche sending to informix-list