Last update: 2012-05-20

TPS: Table Presentation System

• Introduction to TPS
  • TPS1
    • TPS is a java based application that is designed to support data transformation for database reports.  TPS can be configured as a CGI script.  Thus, TPS can also serve as a dynamic web-page generator.  
    • The design of TPS is a refinement of TPL (Table Presentation Language).  Both TPS and TPL rely on Table Operations to perform data transformation (the table operations provided in TPS are not the same as the table operations provided by TPL; however, they are at least as strong as those of TPL).
  • TPS2
    • TPS2 is an enhancement of TPS with the addition of report structuring ability. TPS2 is capable of producing nested tables.
    • A series of tree nodes are used to define the structure of reports, produce nested results, and offer aggregation functions.
  • TPS3
    • TPS3 is an enhancement of TPS2 with the addition of report formatting capability.

• Related Publications
  • W.K. Chen, P.H. Chen, and W.T. Huang, “A Table Presentation Language for Database Applications,” International Computer Symposium: Workshop on Databases and Software Engineering, Vol. 2, pp. 1203-1210, 2002. Download
  • W.K. Chen and K.H. Chung, “A Table Presentation System for Database and Web Applications,” Proceedings of the 2004 IEEE International Conference on e-Technology, e-Commerce and e-Service, pp. 492-497, 2004.
  • W.K. Chen and J.H. Wang, “A Report-Structuring Model for Database and Web Applications,” Proceedings of IEEE 2005 Fifth International Conference on Information, Communication, and Sig- nal Processing, pp. 1259-1263, 2005.

  　

• Documents
  • Formal definition of table operations
  • The grammar of report structure tree

  　

• Downloads
  • TPS1.0 readme (text file)
  • TPS1.0 executable (zip file; 721k)
  • TPS3.0 executable (zip file; 3.5M)