DAOi: A fully independent Java database access framework

Abstract

In this paper, we present a design and implementation of a Java database access framework named DAOi. It guarantees independence of database processing layer by separating SQL statement in an external XML file from programming codes. DAOi also adopts some elaborated schemes for internal processing. The effort results in enhanced maintainability and quality of the entire system. In addition, a GUI tool for configuring database connection and specifying the SQL statements in the XML file is provided. We carried out performance evaluation to show the feasibility of the proposed framework. Presently, DAOi has been widely deployed commercially.