Re: Real time data trasfer between 2 DB

  • From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
  • To: Arvind.Kumar@xxxxxxxxxxxxx
  • Date: Fri, 27 Aug 2010 17:47:39 +0530

Hi Arvind,

0)worked on replication but now on bus transport system have not worked on
such system and hence random gueses
what if you pull the data from city buses, replication, streams, golden gate
will be more suitable, you want transactions only..
pulling will keep the bus conductor/machine free from loading the data and
main hub will always know what is the status alogn with co-ordinates of city
1) insted installing databases in buses can the ticketing machine send the
data in flat file formats and that data you can be sent from wap devices to
a stage area from where you can load the data either using external
tables..or sqlloaders this will reduce the licensing cost.per city bus
ddatabse and maintence cost will be more..
On 27 August 2010 10:51, Arvind Kumar (IT-SIS-UIF) <
Arvind.Kumar@xxxxxxxxxxxxx> wrote:

>  Greeting all,
> What would be the best method to transfer data between two databases (10g
> R2) in real time (near real time). It’s a transport system where GPS devices
> installed in City Buses inserts records (location, timings) into oracle DB
> then this data has to be transferred to other oracle DB for reporting with a
> max latency on 5 second.
> Any input or experience on similar scenario will be highly appreciated.
> Thanks
> Arvind Kumar


Other related posts: