Re: Informix to Oracle replication
Ian Michael Gumby wrote: > > Art, > > If you define "real time" to mean that the data is ready when you need > it, sure its a vague response. Not vague at all! It's just that one man's well defined real time is another's well defined vacation week. If my client needs the data to be on his desk on the third Monday of the month, then that's his real-time constraint for my system. Period. Well defined. Art > > But when you talk to someone who develops RTOS apps, that definition > means that you need it in "real time". > ;-) > > With respects to databases, "real time" could mean that the data is > available as soon as the dust settles from a transaction. > > So what happens when you say your system is "real time" and then > someone changes the SLA on you? :-P > > > ------------------------------------------------------------------------ > Date: Fri, 8 Feb 2008 09:56:46 -0500 > From: art@oninit.com > To: im_gumby@hotmail.com > CC: neil.truby@ardenta.com; informix-list@iiug.org > Subject: Re: Informix to Oracle replication > > Ian Michael Gumby wrote: > > 15 mins isn't real time. > > > Now you've hit one of my pet peeves (only a few that this one's up > there with pronouncing the T in often): > > Real-time does NOT mean instantaneous or anything near > instantaneous. Real-time means that the data (or whatever) is > available at the time that it's needed. For some data that can > mean updated once a day! > > >From Wikipedia: > > Real-time computing: ... systems which are subject to a > "real-time constraint"—i.e., operational deadlines from event > to system response. ... Real-time computations can be said to > have /failed/ if they are not completed before their deadline, > where their deadline is relative to an event. > > >From CIO search: > > /Real time/ is a level of computer responsiveness that a user > senses as sufficiently immediate or that enables the computer > to keep up with some external process. > > That says nothing about the length of the deadline or time between > 'now' and the 'event'. Sufficiently immediate is in the user's or > data recipient's domain to determine. The current buzzword that > corresponds best to the true meaning is the SLA (Service Level > Agreement) craze. If you meet your SLA you are operating in > real-time. > > > Art S. Kagel > Oninit > > > Instead of transfering the log for replication, you can use a > trigger to transfer the row to the other database. > > There are a couple of ways of doing this. > > Look at using a VTI and a trigger. > > > From: neil.truby@ardenta.com <mailto:neil.truby@ardenta.com> > > Subject: Informix to Oracle replication > > Date: Fri, 8 Feb 2008 08:49:55 +0000 > > To: informix-list@iiug.org <mailto:informix-list@iiug.org> > > > > I realise that this is a high-level question. > > IDS 10.0. > > > > Does anyone know of a product, available NOW, preferably IBM > but not > > necessarily, that could viably insert data from an Informix > database into an > > Oracle data warehouse in more-or-less real time (say a delay > of up to 15 > > minutes would be permitted)? > > > > > > thx > > -- > > Neil Truby t:01932 724027 > > > > ------------------------------------------------------------------------ > Connect and share in new ways with Windows Live. Get it now! > <http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008>; =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================