Middleware at HVA Assignment 4 5 Brian Samson

Middleware at HVA Assignment 4. 5 Brian Samson & Peter Troon

Introduction n Assignment: Take a closer look at the middleware, which is needed to make a connection between a client machine and the database server at school.

Types of Middleware n n n Remote Data Access (RDA) Remote procedure calls (RPC’s) Message-oriented middleware (MOM) Object Request Brokers(ORB’s) i. e. CORBA Distributed transaction processing (DTP)

Our School’s Situation n Microsoft SQL Server running on a Windows NT Machine A client running on a Windows 95 Computer Database is used for user account data, user rights, etc.

What do we need? n n n A client program A DBMS A RDA standard. In our case: ODBC A database server A good functioning network.

The Client/Server Model

Remote Request What happens if someone wants to perform an operation on the database server?

Overview of ODBC

Conclusion Except the hardware necessary to make a network connection you need software, that supports the RDA protocol if you want make a database connection between a client and a database server. In most cases an ODBC driver is used.

Questions 1. What is Middleware? 2. How is a database connection between a client and a server established? 3. What is the advantage of ODBC?

Resources n n Distributed Information Systems from Client/Server to Distributed Multimedia Errol Simon, ISBN 0 07 709076 4 Microsoft SQL Server 6. 5 Second Edition Solomon, Rankins, et al. , ISBN 0 -672 -30956 -4

Middleware at HVA …. The End http: //www. troon. org/middleware/