Re: Real time data trasfer between 2 DB

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 27 Aug 2010 17:47:39 +0530
Message-ID: <AANLkTikYKp=Q_fYkcAxsYrBBK7Zc2y_RbMB-Tqu5EzCj_at_mail.gmail.com>



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 bus
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.. Thanks!
Subodh
On 27 August 2010 10:51, Arvind Kumar (IT-SIS-UIF) < Arvind.Kumar_at_labour.gov.za> 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
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 27 2010 - 07:17:39 CDT

Original text of this message