Why should a developer use web services instead of direct connections to a db? [closed]

by

  1. Security. You’re not granting DB access to anyone but web server/app user.

    This is extra important when you have tons of users. You avoid the pain of user/role maintenance on DB side.

  2. DB load reduction. Web service can cache the data it retrieved from DB.

  3. Database connection pooling (hat/tip @Dogs).

    A web service can use a small pool of permanently opened DB connections. The helps in a variety of ways:

    • DB connection pool is limited on database server side.

    • opening a new DB connection is VERY costly (especially to database server).

  4. Ability for fault tolerance – the service can switch between primary/DR data sources without having details of fail-over be implemented by service consumers.

  5. Scalability – the service can spread requests between several parallel data sources without having details of the resource picking be implemented by service consumers.

  6. Encapsulation. You can change underlying DB implementation without impacting service users.

  7. Data enrichment (this includes anything from client customization to localization to internalization). Basically any of these might be useful but any of them is a major load on database and often very hard to implement inside a DB.

  8. May or may not apply to you – certain architecture decisions are not DB acces friendly.
    E.g. Java Servers running on Unix have an easy access to a database, whereas a java client running on a Windows PC is not database aware nor do you possibly want it to be.

  9. Portability. Your clients may not all be on the same platform/architecture/language. Re-creating a good data access layer in each one of those is harder (since it must take into account such issues as above-mentioned failovers/etc…) than building a consumer layer for a web service.

  10. Performance tuning. Assuming the alternative is clients running their own queries (and not pre-canned stored procedures), you can be 100% sure that they will start using less than optimal queries. Also, if the web service bounds the set of allowable queries, it can help with your database tuning significantly. I must add that this logic is equally applicable to stored procedures, not unique to web services.

A good list can also be found on this page: ‘Encapsulating Database Access: An Agile “Best” Practice’

Just to be crystal clear – some of these issues may not be applicable to ALL situations. Some people don’t care about portability. Some people don’t need to worry about DB security. Some people don’t need to worry about DB scalability.

More Related Contents:

  1. What are the differences between WCF and ASMX web services?
  2. Best way to support “application/x-www-form-urlencoded” post data with WCF?
  3. Web Service vs WCF Service
  4. Invoking WCF service method through a browser
  5. Why is my WCF web service presenting this object in a different namespace with different field names?
  6. How to turn on WCF tracing?
  7. Returning raw json (string) in wcf
  8. WCF Error “This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case”
  9. Consume WCF Web Service using Objective-C on iPhone
  10. Making a WCF Web Service work with GET requests
  11. WCF Datacontract, some fields do not deserialize
  12. Timeouts WCF Services
  13. Is there some way to handle async/await behind an ASMX service?
  14. HTTP could not register URL http://+:8000/HelloWCF/. Your process does not have access rights to this namespace
  15. WCFTestClient The HTTP request is unauthorized with client authentication scheme ‘Anonymous’
  16. The maximum string content length quota (8192) has been exceeded while reading XML data
  17. Large WCF web service request failing with (400) HTTP Bad Request
  18. HTTP Error 404.3 – Not Found” while browsing wcf service on Windows Server 2008(64bit)
  19. WCF Service Client: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding
  20. WCF Service , how to increase the timeout?
  21. How to remove the “.svc” extension in RESTful WCF service?
  22. WCF service configuration file question regarding
  23. How to consume WCF web service through URL at run time?
  24. WSDL-first approach: How to specify different names for wsdl:port and wsdl:binding?
  25. Connecting via named pipe from windows service (session#0) to desktop app (session #1)
  26. Getting a POST endpoint to work in self-hosted (WebServiceHost) C# webservice?
  27. WCF NetTcpBinding with mex
  28. How can a WCF service listen the same port as IIS?
  29. Adding basic HTTP auth to a WCF REST service
  30. The content type text/html; charset=UTF-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8)

Leave a Comment