Dynamic and structured presentation of database contents on the Web
Attractive presentation of database contents is a key component of Web-based businesses. TFE (Target Form Expression) is a database publishing/presentation extension of SQL that yields a query result presented as a document in any of several target media, for example, HTML, Java, LaTeX. When a Web (HTML) document is the target medium, TFE yields intra-page and inter-page hierarchical structures in arbitrary size and complexity. The inter-page structures are automatically-generated hyper-links which allow the resulting Web document to be browsed in a fashion similar to drill down in a data warehouse. In this paper, we introduce a new primitive of TFE that allows the invocation of another query. Combined with the incremental evaluation of invoked queries, it improves both efficiency and functionality compared to monolithic and static implementations. The improved functionality includes recursive navigation. A small number of query rewriting rules are provided to show the equivalence of a query and its decompositions. Incremental query evaluation gives application system an enhanced capability for designing database/Web applications to meet performance and functionality requirements while retaining simplicity of description. A new diagramming method called Database Presentation Diagram is also introduced to visualize the structures of a set of queries and the presentation produced with them.
KeywordsOriginal Query Database Content Target Medium Inclusion Dependency Page Schema
Unable to display preview. Download preview PDF.
- 1.http://www.allaire.com/Google Scholar
- 2.C. Lang, J. Chow, Database Publishing on the Web and Intranets, Coriolis Group Books (1996).Google Scholar
- 3.P-C. Kim, http://grigg.chungnam.ac.kr/projects/UniWeb/documents/www_dbms.htmlGoogle Scholar
- 4.http://web.ce.utk.edu/DistanceLearningResources/databases.htmGoogle Scholar
- 5.T. Seto, T. Nagafuji, M. Toyama, Generating HTML Sources with TFE Enhanced SQL, in Proc. ACM Symp. on Applied Computing (SAC'97), ACM (1997), 96–105.Google Scholar
- 6.M. Toyama, Three Dimensional Generalization of Target List for Simple Database Publishing and Browsing, in Research and Practical Issues in Database (Proc. 3rd Australian Database Conference), World Scientific Pub. Co. (1992), 139–153.Google Scholar
- 7.G. Hulin, On Restructuring Nested Relations in Partitioned Normal Form, in Proc. 16th VLDB Conf., (1990), 626–637.Google Scholar
- 8.G. Jaeshke, H. J. Schek, Remarks on the Algebra of Non First Normal Form Relations, In Proc. PODS'82, ACM (1982), 124–138.Google Scholar