Using metadata for developing automated Web system interface

ABSTRACT

In this paper we look into implementing a web interface design for applications that have a database element, we look at how and to what extent we can use information (Metadata) held in system catalog tables in databases to produce a better and automated Web interface that can easily accommodate changes in the underlying data model by altering those tables, rather than requiring changes to the interface code. We use Java and particularly Java Database Connectivity (JDBC), which provides a very general method for addressing databases and also includes Metadata features.

REFERENCES

• 1: Barry Eaglestone and Mick Ridley. (2001): "Web Database Systems", McGraw-Hill, London, UK. ISBN: 0077096002.
• 2: Keith G. Jeffery, Metadata The Future of Information Systems, http://www.wmo.ch/web/www/WDM/ET-IDM/Doc-2-3.html
• 3: Graham Hamilton , Rick Cattell , Maydene Fisher, Jdbc Database Access with Java: A Tutorial and Annotated Reference, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1997
• 4: Mark Weiner, Micah Sherr and Abigail Cohen, Metadata tables to enable dynamic data modeling and web interface design: the SEER example, International Journal of Medical Informatics Volume 65, Issue 1, April 2002, Pages 51--58, ISSN: 1386--5056
• 5: Jason Hunter , William Crawford, Java servlet programming, O'Reilly & Associates, Inc., Sebastopol, CA, 1998
• 6: Suresh Rajagopalan , Ramesh Rajamani , K. Ramesh, Java Servlet Programming Bible with CD-ROM, John Wiley & Sons, Inc., New York, NY, 2002
• 7: JavaServerTM Web Development Kit, Version 1.0.1, Sun Microsystems, Inc. http://java.sun.com/products/servlet/README.html.
• 8: PostgreSQL Inc. The world' s most advanced Open Source Database http://www.postgresql.org/.

INDEX TERMS

Keywords:
Java Database Connectivity (JDBC), Web system interface, metadata, relational database