Middleware at HVA

1
Middleware at HVA

• Assignment 4.5
• Brian Samson
• Peter Troon

2
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.

3
Types of Middleware

• Remote Data Access (RDA)
• Remote procedure calls (RPCs)
• Message-oriented middleware (MOM)
• Object Request Brokers(ORBs) i.e. CORBA
• Distributed transaction processing (DTP)

4
Our Schools 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.

5
What do we need?

• A client program
• A DBMS
• A RDA standard. In our case ODBC
• A database server
• A good functioning network.

6
The Client/Server Model
7
Remote Request

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

8
Overview of ODBC
9
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.

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

11
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

12
Middleware at HVA

• . The End
• http//www.troon.org/middleware/