A Framework For Rapid Development Of OLTP Information Systems: Transformation Of SQL Statements To Three-Tier Web Applications

Abstract

In this paper, we present a framework for rapid development of online transaction processing (OLTP) information systems. The framework assumes that a Web application will be developed on top of an available database. It includes a transformation that receives as an input a SQL statement and results in as an output a three-tier Web application. The transformation allows developers to generate an implementation specification, i.e. the source code of the presentation and logic tier of a Web application, from a SQL statement. It consists of a development method and three transformations. The transformation is to produce (i) a query form page, (ii) a query result page, and (iii) a Web services method that implement the SQL statement. To result in ready-to-deploy source code, developers must supply the transformations with additional information. Keywords: model-driven engineering; transformation; SQL statements; web applications; three-tier architecture