Temporal summary table management and graphic interface

  • Tae H. Ahn
  • Hyuk J. Jo
  • Jin H. Kim
  • Yoon J. Lee
  • Byung C. Kim
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 420)


Temporal databases maintain all evolution history of objects in the real world to support applications requiring not only current data but also old data. The history of data is used to analyze past and current data and to forecast the future. Thus temporal databases are a good source of data for statistical analysis procedures.

This paper presents a system supporting summary tables on temporal databases. A summary table is a tabular representation of summary statistics obtained from source relations. This is a useful structure to support the users' statistical analysis. Our system also provides a graphic user interface displaying the data of summary tables in graphical forms such as histograms, graphs, and diagrams. This interface provides users with convenient and useful views of statistical data.


Graphical Display Category Attribute Summary Table Column Index Aggregate Function 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Ahn 86]
    Ahn, I., "Performance Modeling and Access Methods for Temporal Database Management Systems," Technical Report 86-018, Univ. of North Carolina, Aug. 1986.Google Scholar
  2. [Aria 86]
    Ariav, G., "A Temporally Oriented Data Model," ACM Trans. on Database Systems, Vol. 11, No. 4 (Dec. 1986), pp.499–527.Google Scholar
  3. [Ben 82]
    Ben-Zvi, J., "The Time Relational Model," Ph.D. Thesis, Dept. of Computer Science, Univ. of California, Los Angeles, 1982.Google Scholar
  4. [Bolo 82]
    Bolour, A. et. al., "The Role of Time in Information Processing: A Survey," ACM SIGMOD Record, Vol. 12, No. 3 (April 1982), pp.28–48.Google Scholar
  5. [Chen 89]
    Chen, M. C. and McNamee, L., "A Data Model and Access Method for Summary Data Management," Proc. of Data Engineering 1989, pp.242–249.Google Scholar
  6. [Cicc 89]
    Cicchetti, R., Lakhal, L., Thanh, N. L., and Miranda, S., "A Logical Summary-Data Model for Macro Statistical Databases," to appear in Proc. of International Symposium on Database Systems for Advanced Applications 1989.Google Scholar
  7. [Clif 83]
    Clifford, J. and Warren, D. S., "Formal Semantics for Time in Databases," ACM Trans. on Database Systems, Vol. 8, No. 2 (June 1983), pp.214–254.Google Scholar
  8. [Clif 85]
    Clifford, J. and Tansel, A. U., "On An Algebra for Historical Relational Databases: Two Views," Proc. of ACM SIGMOD 1985, pp.247–265.Google Scholar
  9. [Gadi 88]
    Gadia, S. K., "A Homogeneous Relational Model and Query Languages for Temporal Databases," ACM Trans. on Database Systems, Vol. 13, No. 4 (Dec. 1988), pp.418–448.Google Scholar
  10. [Ghos 86]
    Ghosh, S. P., "Statistical Relational Tables for Statistical Database Management," IEEE Trans. on Software Engireering, Vol. SE-12, No. 12 (Dec 1986), pp.1106–1116.Google Scholar
  11. [Iked 81]
    Ikeda, I. and Kobayashi, Y., "Additional Facilities of a Conventional DBMS to Support Interactive Statistical Analysis," Proc. of 1st LBL Workshop on SDBM 1981, pp.25–36.Google Scholar
  12. [Kim 88]
    Kim, J., Yoo, H., and Lee, Y., "Implementation of a Temporal Query Language with Abstract Time," Proc. of International Computer Symposium 1988, pp.64–70.Google Scholar
  13. [Kim 89]
    Kim, J., Ahn, T., and Lee, Y., "A Graphic Presentation of Temporal Aggregate Data," to appear in Proc. of ISMM International Symposium on Mini and Microcomputers and Their Applications 1989.Google Scholar
  14. [Lum 84]
    Lum, V. et. al., "Designing DBMS Support for the Temporal Dimension," Proc. of ACM SIGMOD 1984, pp.115–130.Google Scholar
  15. [Malv 88]
    Malvestuto, F. M., "The Derivation Problem for Summary Data," Proc. of ACM SIGMOD 1988, pp.82–89.Google Scholar
  16. [Nava 86]
    Navathe, S. B. and Ahmed, R., "A Temporal Relational Model and A Query Language," CIS Technical Report No.85-16, Database System R & D Center, Univ. of Florida, 1986.Google Scholar
  17. [Oh 88]
    Oh, S., Kim, J., and Lee, Y., "A Storage Structure for Temporal Database with Multiple Times," Proc. of International Working Conf. on Statistical and Scientific Database Management 1988, Vol. 2, pp.203–220Google Scholar
  18. [Ozso 83]
    Ozsoyoglu, Z. M. and Ozsoyoglu, G., "An Extension of Relation Algebra for Summary Tables," Proc. of 2nd LBL Workshop on Statistical Database Management 1983, pp.202–211.Google Scholar
  19. [Ozso 85]
    Ozsoyoglu, Z. M. and Ozsoyoglu, G., "Statistical Database Query Languages," IEEE Trans. on Software Engineering, Vol. SE-11, No. 10 (Oct. 1985), pp.1071–1081.Google Scholar
  20. [Sato 81]
    Sato, H., "Handling Summary Information in a Database: Derivability," Proc. of ACM SIGMOD 1981, pp.98–106.Google Scholar
  21. [Shif 86]
    Shiftan, J., "Assessing the Temporal Differentiation of Attributes as an Implementation Strategy for a Temporally Oriented Relational DBMS," Ph.D. Dissertation, New York University, 1986.Google Scholar
  22. [Shos 86]
    Shoshani, A. and Kawagoe, K., "Temporal Data Management," Proc. of Int. Conf. on VLDB 1986, pp79–88.Google Scholar
  23. [Snod 85]
    Snodgrass, R. and Ahn, I., "A Taxanomy of Time in Databases," Proc. of ACM SIGMOD 1985, pp.236–246.Google Scholar
  24. [Snod 86]
    Snodgrass, R., "Research Concerning Time in Database Project Summaries," ACM SIGMOD Record, Vol.15, No.4 (Dec. 1986), pp.19–52.Google Scholar
  25. [Snod 87]
    Snodgrass, R., "The Temporal Query Language TQuel," ACM Trans. on Database Systems, Vol. 12, No. 2 (Jun. 1987), pp.247–298.Google Scholar
  26. [Tans 85]
    Tansel, A. U. and Arkun, M. E., "Query Language for Historical Relational Databases," Technical Report, Bernard M. Baruch College, City University of New York, Oct. 1985.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1990

Authors and Affiliations

  • Tae H. Ahn
    • 1
  • Hyuk J. Jo
    • 2
  • Jin H. Kim
    • 2
  • Yoon J. Lee
    • 2
  • Byung C. Kim
    • 3
  1. 1.Goldstar Software, Ltd.Republic of Korea
  2. 2.Dept. of Computer ScienceKorea Advanced Institute of Science and TechnologySeoulRepublic of Korea
  3. 3.Dept. of Applied MathematicsKorea Advanced Institute of Science and TechnologySeoulRepublic of Korea

Personalised recommendations