Explain the advantages of including a transaction server in the architecture of a transaction processing system.

What will be an ideal response?

1. Separating the stored procedures from the application program has the advantages of decreasing communication costs and providing a more abstract interface to the application program.
2. Executing the stored procedures on a separate transaction server instead of in the DBMS has the advantage of reducing the load on the DBMS, thus providing increased scalability for large numbers of transactions.

Computer Science & Information Technology

You might also like to view...

When you use ASP and an Access database, you must input a custom ____________________ that Dreamweaver inserts into the page's server behaviors to set up the recordset.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Most authoring tools usually:

a. use a frame-oriented approach to animation. b. use an object-oriented approach to animation. c. use both frame- and object-oriented approach to animation. d. use either a frame- or object-oriented approach to animation, but rarely both. e. do not directly support animation, but allow animations to be imported in an appropriate format.

Computer Science & Information Technology