Performance of RDBMS-WWW Interfaces under Heavy Workload

Stathes Hadjiefthymiades (Department of Informatics, University of Athens, Greece)

Ioannis Varouxis (Department of Informatics, University of Athens, Greece)

Drakoulis Martakos (Department of Informatics, University of Athens, Greece)

Abstract: The WWW is currently considered as the most promising and rapidly evolving software platform for the deployment of applications in wide area networks as well as enterprise intranets. Interfacing legacy systems like RDBMS to the WWW has become a very important issue to the computing industry. We discuss the efficiency of RDBMS gateways throughout periods of increased workload. We present a client/server architecture aiming to diminish overheads encountered in conventional gateways. The performance gain is assessed through a series of measurements. Alternative architectures were subject to the same measurements to assess the performance achieved by technologies like ODBC, JDBC, Dynamic SQL, ISAPI, NSAPI and CORBA.

Keywords: CGI, Java, RDBMS, SQL, Server API, WWW, gateway, performance

Categories: H.3.3, H.3.4, H.4