Transcript Middleware at HVA

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/