Abstract
In this paper we describe the fundamental components of a database management system for the definition, storage, manipulation and query of aggregate data, i.e. data which are obtained by applying statistical aggregations and statistical analysis functions over raw data. In particular, the attention has been focused on: (1) a data structure for the efficient storage and manipulation of aggregate data, called ADaS; (2) the graphical structures of the aggregate data model ADAMO for a more user-friendly definition and query of aggregate data; (3) a graphical user interface which enables a straightforward specification of the ADAMO structures; (4) a textual declarative query language to retrieve data from the aggregate database, called ADQUEL.
Preview
Unable to display preview. Download preview PDF.
Bibliography
A.Bezenchek, F.Massari, M.Rafanelli, “STORM+: Statistical Data Storage and Manipulation System” in 11th Symp. on Computational Statistics, Compstat '94, Vienna, Austria, Aug. 22–26, 1994.
A.Bezenchek, M.Rafanelli, L.Tininini, “A Data Structure for the Formal Definition of Aggregate Data”, Technical Report IASI, R.414 October 1995.
A.Bezenchek, M.Rafanelli, L.Tininini, “ADAMO: A Conceptual Model for the Graphical Definition and Manipulation of Aggregate Data”, Technical Report IASI, April 1996, in press
A.Bezenchek, M.Rafanelli, L.Tininini, “A Data Structure for Representing Aggregate Data”, Proceed. 8th Intern. Confer, on SSDBM, Stockholm, June 18–20, 1996, IEEE Press.
P.Chan, A.Shoshani, “SUBJECT: A Directory Driven System for Organising and Accessing Large Statistical Databases”, Proceed. of the 7th Intern. Confer, on Very Large Data Bases, 1981, Cannes, France, Pages 553–563
H.Darwen, C.J.Date, “The Third Manifesto”, SIGMOD Record, Vol. 24, No. 1, March 1995, Pages 39–49.
F.M.Malvestuto, “A universal-scheme approach to statistical databases containing homogeneous summary tables, ACM Transactions on Database Systems, Vol. 18, No.4, December 1993, Pages 678–708.
F.M.Malvestuto, M.Moscarini, M.Rafanelli, “Suppressing marginal cells to protect sensitive information in a two-dimensional statistical table”, Proceed. 10th ACM Symposium on Principles of Database Systems — PODS '91, ACM Press, Denver, Colorado, May 29–31, 1991.
G.Ozsoyoglu, M.Ozsoyoglu, F.Mata, “A language and a physical organization technique for summary tables”, Proceed. 4th ACM International Conference on Management of Data — SIGMOD '85, ACM Press, Austin, Texas, May 28–31, 1985, Pages 3–16.
G.Ozsoyoglu, M.Ozsoyoglu, V.Matos, “Extending Relational Algebra and Relational Calculus with Set-valued Attributes and Aggregate Functions” ACM Transactions on Database Systems, 1987, Vol. 12, No. 4, Pages 566–592.
M.Rafanelli, F.L.Ricci, “Proposal of a Logical Model for Statistical Data Base”, Proc. 2th Int. Work. on Statistical Database Management, Los Altos, CA, 1983.
M.Rafanelli, F.L.Ricci, “Mefisto: a functional model for statistical entities”, IEEE Transactions on Knowledge and Data Engineering, August 1993, Vol.5, No.4.
M.Rafanelli, A.Shoshani, “STORM: A STatistical Object Representation Model”, Proceed. 5th Intern. Confer. on SSDBM, Charlotte, NC, April 1990, Lecture Notes in Computer Science, Springer Verlag Pub., Vol. 420.
A.Shoshani, H.K.T.Wong, “Statistical and Scientific Database Issues” IEEE Transactions on Software Engineering, October 1985, Vol.SD-11, No.10.
Statistical Journal of the United Nations ECE, Volume 10, Number 2, IOS Press, Pages 91–226.
S.Y.W.Su, “SAM*: A Semantic Association Model for Corporate and Scientific Statistical Databases”, J. of Information Sciences, Vol. 29, No. 2–3, May–June 1983, Pages 151–199.
A.V.Tansel, “A Statistical Interface for Historical Relational Databases”, Proc. 3th Int. Conf. on Data Engineering, Los Angeles, February 3–5, 1987, Computer Society Press, Pages 538–546.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Tininini, L., Bezenchek, A., Rafanelli, M. (1996). A system for the management of aggregate data. In: Wagner, R.R., Thoma, H. (eds) Database and Expert Systems Applications. DEXA 1996. Lecture Notes in Computer Science, vol 1134. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0034708
Download citation
DOI: https://doi.org/10.1007/BFb0034708
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-61656-6
Online ISBN: 978-3-540-70651-9
eBook Packages: Springer Book Archive