A System for the Management of Aggregate Data

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.

[1]  Gultekin Özsoyoglu,et al.  A language and a physical organization technique for summary tables , 1985, SIGMOD Conference.

[2]  Francesco M. Malvestuto,et al.  A universal-scheme approach to statistical databases containing homogeneous summary tables , 1993, TODS.

[3]  Maurizio Rafanelli,et al.  A data structure for representing aggregate data , 1996, Proceedings of 8th International Conference on Scientific and Statistical Data Base Management.

[4]  Stanley Y. W. Su,et al.  SAM*: A Semantic Association Model for Corporate and Scientific/Statistical Databases , 1983, Inf. Sci..

[5]  C. J. Date,et al.  The third manifesto , 1995, SGMD.

[6]  Arie Shoshani,et al.  STORM: A Statistical Object Representation Model , 1990, IEEE Data Eng. Bull..

[7]  Maurizio Rafanelli,et al.  Mefisto: A Functional Model for Statistical Entities , 1993, IEEE Trans. Knowl. Data Eng..

[8]  Arie Shoshani,et al.  Statistical and Scientific Database Issues , 1985, IEEE Transactions on Software Engineering.

[9]  Maurizio Rafanelli,et al.  Proposal of a Logical Model for Statistical Data Base , 1983, SSDBM.

[10]  Abdullah Uz Tansel.  A statistical interface for historical relational databases , 1987, 1987 IEEE Third International Conference on Data Engineering.

[11]  Gultekin Özsoyoglu,et al.  Extending relational algebra and relational calculus with set-valued attributes and aggregate functions , 1987, TODS.

[12]  Maurizio Rafanelli,et al.  Suppressing marginal cells to protect sensitive information in a two-dimensional statistical table (extended abstract) , 1991, PODS.

[13]  Maurizio Rafanelli,et al.  STORM+: Statistical Data Storage and Manipulation System , 1994 .

[14]  Arie Shoshani,et al.  SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases , 1981, VLDB.