Two-Tier is Enabled by DBMS Stored Procedures

• Stored procedure – An application procedure that runs inside the DBMS

  • Often in a proprietary language, such as PL/SQL (Oracle), T-SQL (MS, Sybase)
  • Moving toward standard languages, such as Java

• Implement transaction server as stored procedures

• Use DBMS client-server protocol

• No application server

  • Just a 4GL plus DBMS
  • Hence, sometimes called “TP lite”

Presentation

or Web Server

Stored

Procedures

SQL Engine

SQL DBMS

Previous slide

Next slide

Back to first slide

View graphic version