Re: Real time data trasfer between 2 DB
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: deshpande.subodh@xxxxxxxxx, andrew.kerber@xxxxxxxxx
- Date: Mon, 30 Aug 2010 17:45:09 -0700 (PDT)
One more option on this thought- If you are going to dump it to a flatfile and
then load, how about CDC, (change data capture) to load it to db1 and db2? A
simple CDC could load the data into the destination system on regular
intervals.
Always 100 different way to skin this kind of database cat... :)
Kellyn Pedersen
Sr. Database Administrator
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.blogspot.com
"Go away before I replace you with a very small and efficient shell script..."
--- On Fri, 8/27/10, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
Subject: Re: Real time data trasfer between 2 DB
To: deshpande.subodh@xxxxxxxxx
Cc: Arvind.Kumar@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Friday, August 27, 2010, 6:40 AM
Is the 5 second latency the time between broadcast of the data and the time it
must be available in the second database? If you have a little more time in
there, then I like the idea of queueing it into a flat file and loading it into
both DB's from there. If it must go from the gps to db1 to db2, I would use
triggers rather than streams or dataguard.
Frankly, I think you will have more problems getting the data to the first
database quickly then you will have replicating it over to the second.
On Fri, Aug 27, 2010 at 7:17 AM, Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
wrote:
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@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
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
