Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Ahn, I., "Performance Modeling and Access Methods for Temporal Database Management Systems," Technical Report 86-018, Univ. of North Carolina, Aug. 1986.
Ariav, G., "A Temporally Oriented Data Model," ACM Trans. on Database Systems, Vol. 11, No. 4 (Dec. 1986), pp.499–527.
Ben-Zvi, J., "The Time Relational Model," Ph.D. Thesis, Dept. of Computer Science, Univ. of California, Los Angeles, 1982.
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.
Chen, M. C. and McNamee, L., "A Data Model and Access Method for Summary Data Management," Proc. of Data Engineering 1989, pp.242–249.
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.
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.
Clifford, J. and Tansel, A. U., "On An Algebra for Historical Relational Databases: Two Views," Proc. of ACM SIGMOD 1985, pp.247–265.
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.
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.
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.
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.
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.
Lum, V. et. al., "Designing DBMS Support for the Temporal Dimension," Proc. of ACM SIGMOD 1984, pp.115–130.
Malvestuto, F. M., "The Derivation Problem for Summary Data," Proc. of ACM SIGMOD 1988, pp.82–89.
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.
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–220
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.
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.
Sato, H., "Handling Summary Information in a Database: Derivability," Proc. of ACM SIGMOD 1981, pp.98–106.
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.
Shoshani, A. and Kawagoe, K., "Temporal Data Management," Proc. of Int. Conf. on VLDB 1986, pp79–88.
Snodgrass, R. and Ahn, I., "A Taxanomy of Time in Databases," Proc. of ACM SIGMOD 1985, pp.236–246.
Snodgrass, R., "Research Concerning Time in Database Project Summaries," ACM SIGMOD Record, Vol.15, No.4 (Dec. 1986), pp.19–52.
Snodgrass, R., "The Temporal Query Language TQuel," ACM Trans. on Database Systems, Vol. 12, No. 2 (Jun. 1987), pp.247–298.
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.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1990 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ahn, T.H., Jo, H.J., Kim, J.H., Lee, Y.J., Kim, B.C. (1990). Temporal summary table management and graphic interface. In: Michalewicz, Z. (eds) Statistical and Scientific Database Management. SSDBM 1990. Lecture Notes in Computer Science, vol 420. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-52342-1_24
Download citation
DOI: https://doi.org/10.1007/3-540-52342-1_24
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-52342-0
Online ISBN: 978-3-540-46968-1
eBook Packages: Springer Book Archive