Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SOA
Where I work, there are a high number of dblink between databases. Some dblinks aim to be the way for loading immense amount of data while others only exist for simple queries.
I am wondering whether it could be better to use web services than dblink. As a principle, I am thinking that simple queries could be fit as web service to improve the reuse and governance but I find web service not apropriated for data loads.
Obviously, the decision is more complex than only thinking about tecnology. Even so, it will be helpfull to hear if there are people around the world thinking to change from dblinks to web services even heavy load as well querys with small amount of data to be trafficked and what the principles, patterns or motivations behind that decision.
Basically we are implementing SOA and OSB and I am trying the best I can to rethink how we are used to do until now. I heard from a friend of mine that we must avoid the use of dblinks and only use web services. This sounds strange to me because I am wondering how much overhead by the net we are going to face. Could someone give your personal opinion or suggest some article? Are there some advantages and disadvantages previously known about this consideration?
Posted 6-Nov-12 10:21am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 210
2 BillWoodruff 205
3 Jochen Arndt 180
4 Sergey Alexandrovich Kryukov 165
0 OriginalGriff 5,130
1 DamithSL 4,157
2 Maciej Los 3,670
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,821


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100