Developing Data-driven Applications - SQL

Developing Data-driven Applications - SQL

1. Advantages of server-side programming

   • Database is responsible for consistency
     • Role of the database changes: - Data source - Services
   • Security
     • - Data modifications trough public interface - Requires execute permission to call - In the role of the calling user - Closed execution environment 
   • Increase perfomance
     • - Reduce network traffic - Stored execution plans - Cache 
   • Productive
     • - Called by multiple components - Easier to mainttenace

2. Disadvantagens of server-side programming

   • Not standardized
     • - Platform specific languages - Platform specific solutions
   • Interpreted
   • Increases the load of the server
   • Not possible or hard to scale