A system for the management of aggregate data

  • Leonardo Tininini
  • Antonia Bezenchek
  • Maurizio Rafanelli
Advance Database and Information System Methods 4
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1134)


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.


Aggregate Data Statistical Object Relation Scheme Category Attribute Efficient Storage 
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. [BeMR 94]
    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.Google Scholar
  2. [BeRT 95]
    A.Bezenchek, M.Rafanelli, L.Tininini, “A Data Structure for the Formal Definition of Aggregate Data”, Technical Report IASI, R.414 October 1995.Google Scholar
  3. [BeRT 96a]
    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 pressGoogle Scholar
  4. [BeRT 96b]
    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.Google Scholar
  5. [ChSh 81]
    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–563Google Scholar
  6. [DaDa 95]
    H.Darwen, C.J.Date, “The Third Manifesto”, SIGMOD Record, Vol. 24, No. 1, March 1995, Pages 39–49.CrossRefGoogle Scholar
  7. [Malv 93]
    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.CrossRefGoogle Scholar
  8. [MaMR 91]
    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.Google Scholar
  9. [OzOM 85]
    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.Google Scholar
  10. [OzOM 87]
    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.CrossRefGoogle Scholar
  11. [RaRi 83]
    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.Google Scholar
  12. [RaRi 93]
    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.Google Scholar
  13. [RaSh 90]
    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.Google Scholar
  14. [ShWo 85]
    A.Shoshani, H.K.T.Wong, “Statistical and Scientific Database Issues” IEEE Transactions on Software Engineering, October 1985, Vol.SD-11, No.10.Google Scholar
  15. [StaJ 93]
    Statistical Journal of the United Nations ECE, Volume 10, Number 2, IOS Press, Pages 91–226.Google Scholar
  16. [Su 83]
    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.CrossRefGoogle Scholar
  17. [Tans 87]
    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.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1996

Authors and Affiliations

  • Leonardo Tininini
    • 1
  • Antonia Bezenchek
    • 1
  • Maurizio Rafanelli
    • 1
  1. 1.Istituto di Analisi dei Sistemi ed InformaticaRomaItaly

Personalised recommendations