RE: Informix to Oracle replication

Art, If you define "real time" to mean that the data is ready when you need it, sure its a vague response. 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 > Subject: Informix to Oracle replication > Date: Fri, 8 Feb 2008 08:49:55 +0000 > To: 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. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008