CODEWITHSUNDEEP
oracle-databaseweb-servicesconnection
3vge
3vge

Reputation: 197

Two database connection vs replication on one database

Have a web service which connect to oracle database. On database side I have two database, from first I need select some information and in second database need to make some operations. My question is about which is better to connect only second database and make replication by dbms or scheduler job from first db which release x times in a day to refresh data or make two data source on java side and after select some data from first database, connect second one to make some operations.

Upvotes: 1

Views: 126

Answers (1)

Littlefoot
Littlefoot

Reputation: 142788

From my point of view, I'd access only the "second" database (in which you do those operations) and let it acquire data it needs from the "first" database via a database link.

That can be done directly, such as 

select some_columns from db1_table@db_link where ...

or, if it turns out to be way too slow and difficult to tune, create a materialized view in the second database which would then be refreshed using one of available options (a scheduled refresh might be one of the choices).

As it is primarily opinion-based answer, I presume that you'll hear other options from someone else. Further discussion will raise the most appropriate solution to the top.

Upvotes: 1

Related Questions