A Table Presentation Language for Database and Web Applications
| Autor: | Chen Ping-Hung, 陳炳宏 |
|---|---|
| Rok vydání: | 2002 |
| Druh dokumentu: | 學位論文 ; thesis |
| Popis: | 90 Database application systems often provide a large number of query applications and/or reports. In general, a report usually consists of several data sources, which are not necessarily stored in formats that are ready for presentation. Therefore, programmers must write applications to convert different data sources into suitable presentation formats for each report. In particular, the aim is to place the right data in the right position so that the report is easy to understand. Although these conversion programs are not difficult to write, they are very tedious and require the intervention of programmers. Therefore, it is desirable to have tools that can simplify the generation of reports. This thesis investigates the problem of transferring (relocating) data from one table to another with emphasis on how the locations of the data are rearranged. We characterize and formulate fundamental transformations into high-level transformation operations. We then propose a Table Presentation Language (TPL) to support these operations. The TPL language is designed to be both high-level and concise with the hope that everyone, even a non-programmer, can use it. The language supports various transformation operations, including normal, transpose, fill, combine, and match. In addition, it also supports several output formats for different applications. By using simple combinations of these transformation operations, users can create sophisticated reports without writing tedious low-level programs. Therefore the complexity of generating query applications or reports is greatly reduced. The TPL language is useful for both client-server and web-based applications. We have fully implemented the language and use it to build several web-based database applications. In our experience, it is convincing that the language is very useful and practical for creating database query and report applications. |
| Databáze: | Networked Digital Library of Theses & Dissertations |
| Externí odkaz: |
|