1 / 12

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)

elina
Download Presentation

Middleware at HVA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 (RPC’s) • Message-oriented middleware (MOM) • Object Request Brokers(ORB’s) i.e. CORBA • Distributed transaction processing (DTP)

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

  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/

More Related