Transaction servers– Clients invoke remote procedures that reside on servers which also contains an SQL database engine. There are procedural statements on the server to execute a group of SQL statements (transactions) which either all succeed or fail as a
unit. The applications based on transaction servers are called On-line Transaction Processing (OLTP) and tend to be mission-critical applications which require 1-3 second response time, 100% of the time and require tight controls over the security and integrity of the database.
The communication overhead in this approach is kept to a minimum as the exchange typically consists of a single request/reply (as opposed to multiple SQL statements in database servers). Application servers are not necessarily database centered but are used to server user needs, such as. download capabilities from Dow Jones or regulating a electronic mail process. Basing resources on a server allows users to share data, while security and management services, which are also based in the server, ensure data integrity and security.
Latest posts by BMS Team (see all)
- Meterdown Annual Festival is back with its 7th edition – Starts today! - January 16, 2020
- Tybms sem 6 results 2019 declared on 19th June 2019 - June 19, 2019
- TYBMS Sem 6 Results 2019 Update from BMS khabri! - June 15, 2019