120 likes | 383 Views
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)
E N D
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.
Remote Request What happens if someone wants to perform an operation on the database server?
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/