This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes SOA and ESB and the fly likes While implementing SOA and OSB, how worth is to consider change from dblink to web service? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » SOA and ESB
Bookmark "While implementing SOA and OSB, how worth is to consider change from dblink to web service?" Watch "While implementing SOA and OSB, how worth is to consider change from dblink to web service?" New topic
Author

While implementing SOA and OSB, how worth is to consider change from dblink to web service?

Deme Carva
Greenhorn

Joined: Nov 01, 2012
Posts: 3
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?
Roger Sterling
Ranch Hand

Joined: Apr 06, 2012
Posts: 426

Abstracting database operations into a Web Service is an ideal solution as long as the Web Service can support the throughput and security necessary. Some tables have very specific restrictions on who can access what data. Your Web Service abstraction must pass these operating parameters along to the caller so the caller does not gain access to resources the caller should not have access to. You could query the people over at Enterprise Service Bus Q&A for more ideas if you still need help with this. There is a dedicated forum for OSB.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: While implementing SOA and OSB, how worth is to consider change from dblink to web service?
 
Similar Threads
Open Source SOA?
which design pattern to build services on different systems and interact each other
SOA Vs WSA
Tomcat versus Axis2
is SOA just mean use web service?