Middleware at HVA

Assignment 4.5

Brian Samson

& Peter Troon

Introduction 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 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 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? 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

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/