Keeping Web pages up-to-date with SQL:1999

From the beginnings of the World Wide Web (WWW or Web) and the definition of the Common Gateway Interface (CGI), Web site administrators have used dynamically generated HTML pages to provide up-to-date information. Due to the high resource consumption of dynamic page generation approaches, many sites have switched over to periodical updates of frequently visited pages, e.g., a headline index of an electronic newspaper. However, this approach has led to reduced topicality of information provoking less user acceptance. We present iWebDB/DG, the document generator of our integrated Web Content Management System. It guarantees up-to-date Web documents without on-the-fly generation. The approach is based on the extensibility infrastructure of object-relational database systems. By utilizing DB triggers and so-called user-defined functions, documents can automatically be generated by the DBMS whenever data is updated.

[1]  Arun Iyengar,et al.  A scalable system for consistently caching dynamic Web data , 1999, IEEE INFOCOM '99. Conference on Computer Communications. Proceedings. Eighteenth Annual Joint Conference of the IEEE Computer and Communications Societies. The Future is Now (Cat. No.99CH36320).

[2]  Jim Melton,et al.  SQLJ Part 1: SQL routines using the Java programming language , 1999, SGMD.

[3]  Alberto O. Mendelzon,et al.  Database techniques for the World-Wide Web: a survey , 1998, SGMD.

[4]  Giuseppe Sindoni,et al.  Incremental Maintenance of Hypertext Views , 1998, WebDB.

[5]  Werner Retschitzegger,et al.  Ready for prime time: pre-generation of web pages in TIScover , 1999, CIKM '99.

[6]  Michael Stonebraker,et al.  Object-Relational DBMSs: The Next Great Wave , 1995 .