Browse > Article

Automatic Generation of Web-based Database Applications  

Eum, Du-Heon (덕성여자대학교 전산학과)
Yu, Eun-Ja (덕성여자대학교 전산 및 정보통신 대학원)
Publication Information
Journal of KIISE:Databases / v.29, no.3, 2002 , pp. 207-216 More about this Journal
Abstract
Nowadays, we can easily access a remote database as well as a local database with HTML forms. Although implementing a database application with HTML forms is much simpler than implementing it with a proprietary graphical user Interface system, HTML forms and CGI programs still must be coded. We implemented a software tool that automatically generates the SQL statements that create a database for an application, the forms that are used as a user interface, and the Java servlets that retrieve the data requested through the forms. The database tables to be treated and the forms to be generated are determined by the class diagram for the application. Our software tool, which we call WebSiteGen, thus simplifies the implementation of a Web-based database application.
Keywords
Web-based database application; database schema; HTML forms; Java servlets; software tool;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Ken Getz AND Mike Gilbert, Access 2000 Developer's Handbook, Vol. 1, Sybex, 1999
2 http://support.codecharge.com/files/CodeChargeManual .pdf
3 Raymond J. A. Buhr, Use Case Maps as Architectural Entities for Complex Systems, IEEE Transactions on Software Engineering, Vol. 24, No.12, 1998, 1131-1155   DOI   ScienceOn
4 Ramez Elmasri and Shamkanth B. Navathe, Fundamentals of Database Systems, 2nd Ed., Benjamin/Cummings, 1994
5 Grady Booch, James Rumbaugh, and Ivar Jacobson, The Unified Modeling Language User Guide, Addison-Wesley, 1998
6 Michael W. Stowe, Oracle Developer/2000 Handbook, 2nd Ed., PH, 1999
7 http://www.microsoft.com/korea/msdn/library/Dnaspp/html/aspnetmigrissues.asp
8 C.J. Date, An Introduction to Database Systems, 6th Ed., Addison-Wesley, 1995
9 Rational Group, UML Notation Guide, Version 1.1, 1997
10 Angel R. Puerta, Henrik Eriksson, John H. Gennar, and Mark A. Musen, Model-Based Automated Generation of User Interfaces, In Proceedings of the 12th National Conference on Artificial Intelligence, Vol. 1, 1994, 471-477
11 http://1clickdb.com/1clickdbpro/launch.html
12 Michel E. Adiba and Christine Collect, Management of Complex Objects as Dynamic Forms, In Proceeding of the 14th International Conference on Very Large Data Bases, 1988, 134-147