I am really confused with the difference between Store procedure and Web services.
Web Service providing service to end user as per request.
And Web Service having methods and its implementation may be with Database.
Any way we have to use Database in webservice.
Like that, We can use the Store procedure in our application or any where which we want to use for our need.
Then What is the major difference between those things.?
In my point of view, I have found a small one, which when we created a web service and provide to some other then we dont want to give them the DB details. and we just done the implementation in web services and serve the outputs to end user.
But when we go for Store procedure, We should give the store procedure and DB connection strings to the end users.
This case when we develop a common service like, Updating cricket score and Current Share markets, and so & so.
But Still what is the major difference between those items.
Two points which I would like to clear about the WebService.
1. WebService can be used as the independent component with various Secure Methods(SOAP Header / Encryption).
2. WebService can call other WebService internally for hiding business logic.
By considering your Scenario I Suggest you create 2 WebService.
1st WebService Which you will give it to your client / vendor who will just pass the required paramaters.
It will give XML Output which need to be pass to the 2nd Web Service.
2nd Second WebService is hosted at your end and taking all XML as input form 1st Webservice.
Business validation & all DB Operations will be performed with 2nd WebService.
This way you can hind the & Secure your business login, DB Credential from outside world.
In one of our implementations We have consumed all most 5 WebServices internally to
get the desired out put.
Service 1--- > XML ---> Service 2 --- > Process DB
Output <----- Outout <----
I Hope you have got the Clear vision about Webservice Implementation.
Regards,
RajeshS.
<Happy coding/>
If this post answered your question or solved your problem, please Mark it as Answer.
Two points which I would like to clear about the WebService.
1. WebService can be used as the independent component with various Secure Methods(SOAP Header / Encryption).
2. WebService can call other WebService internally for hiding business logic.
By considering your Scenario I Suggest you create 2 WebService.
1st WebService Which you will give it to your client / vendor who will just pass the required paramaters.
It will give XML Output which need to be pass to the 2nd Web Service.
2nd Second WebService is hosted at your end and taking all XML as input form 1st Webservice.
Business validation & all DB Operations will be performed with 2nd WebService.
This way you can hind the & Secure your business login, DB Credential from outside world.
In one of our implementations We have consumed all most 5 WebServices internally to
get the desired out put.
Service 1--- > XML ---> Service 2 --- > Process DB
Output <----- Outout <----
I Hope you have got the Clear vision about Webservice Implementation.
Regards,
RajeshS.
<Happy coding/>
If this post answered your question or solved your problem, please Mark it as Answer.
//Happy Coding
Regards,
RajeshS.
Marked as answer by itechathi on Apr 25, 2012 01:56 AM
itechathi
Member
2 Points
26 Posts
Web Service
Apr 24, 2012 04:56 PM|LINK
Hi,
I am really confused with the difference between Store procedure and Web services.
Web Service providing service to end user as per request.
And Web Service having methods and its implementation may be with Database.
Any way we have to use Database in webservice.
Like that, We can use the Store procedure in our application or any where which we want to use for our need.
Then What is the major difference between those things.?
In my point of view, I have found a small one, which when we created a web service and provide to some other then we dont want to give them the DB details. and we just done the implementation in web services and serve the outputs to end user.
But when we go for Store procedure, We should give the store procedure and DB connection strings to the end users.
This case when we develop a common service like, Updating cricket score and Current Share markets, and so & so.
But Still what is the major difference between those items.
Please help me out.
Thanks & Regards,
Itechathi
Rajesh Sawan...
Participant
1612 Points
246 Posts
Re: Web Service
Apr 24, 2012 05:20 PM|LINK
Dear Friend,
Two points which I would like to clear about the WebService.
1. WebService can be used as the independent component with various Secure Methods(SOAP Header / Encryption).
2. WebService can call other WebService internally for hiding business logic.
By considering your Scenario I Suggest you create 2 WebService.
1st WebService Which you will give it to your client / vendor who will just pass the required paramaters.
It will give XML Output which need to be pass to the 2nd Web Service.
2nd Second WebService is hosted at your end and taking all XML as input form 1st Webservice.
Business validation & all DB Operations will be performed with 2nd WebService.
This way you can hind the & Secure your business login, DB Credential from outside world.
In one of our implementations We have consumed all most 5 WebServices internally to
get the desired out put.
Service 1--- > XML ---> Service 2 --- > Process DB
Output <----- Outout <----
I Hope you have got the Clear vision about Webservice Implementation.
Regards,
RajeshS.
<Happy coding/>
//Happy Coding
Regards,
RajeshS.
Rajesh Sawan...
Participant
1612 Points
246 Posts
Re: Web Service
Apr 24, 2012 05:21 PM|LINK
Dear Friend,
Two points which I would like to clear about the WebService.
1. WebService can be used as the independent component with various Secure Methods(SOAP Header / Encryption).
2. WebService can call other WebService internally for hiding business logic.
By considering your Scenario I Suggest you create 2 WebService.
1st WebService Which you will give it to your client / vendor who will just pass the required paramaters.
It will give XML Output which need to be pass to the 2nd Web Service.
2nd Second WebService is hosted at your end and taking all XML as input form 1st Webservice.
Business validation & all DB Operations will be performed with 2nd WebService.
This way you can hind the & Secure your business login, DB Credential from outside world.
In one of our implementations We have consumed all most 5 WebServices internally to
get the desired out put.
Service 1--- > XML ---> Service 2 --- > Process DB
Output <----- Outout <----
I Hope you have got the Clear vision about Webservice Implementation.
Regards,
RajeshS.
<Happy coding/>
//Happy Coding
Regards,
RajeshS.