Design of statistical information media: Time performances and storage constraints

  • G. Barcaroli
  • G. Di Battista
  • E. Fortunato
  • C. Leporelli
Contributed Papers
Part of the Lecture Notes in Computer Science book series (LNCS, volume 339)


A statistical database can be seen as a set of tables and a set of derivation functions; each function maps a set of tables into a new one. In order to optimize the time performance of the system it would be convenient to store the derived tables in secondary memory. However, a trade-off between storage resources and time performance arises: when the storage space is constrained, it is necessary to choose which derived tables have to be stored and which of them have to be computed on-line. In this paper such trade-off problem is investigated. We formulate it as an integer linear program, both for monadic and for polyadic derivation functions. In the first case we obtain a Simple Plant Location problem with a linear Knapsack constraint; in the second case the obtained program is equivalent to a Simple Plant Location problem with a submodular Knapsack constraint. Moreover we show that the problem is NP-complete and propose an efficient heuristic approach to solve it.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [B et al. 86]
    G. Barcaroli et al. — Csm: a Conceptual Statistical Model for Statistical Databases — Proc. of 7th Symposium on Computational Statistics (Compstat), Roma 1986.Google Scholar
  2. [C et al. 77]
    G.Cornuejols, M.Fisher, G.L.Nemhauser — On the Uncapacitated Location Problem — Annals of Discrete Mathematics 1 1977.Google Scholar
  3. [CCO 86]
    R.Cubitt, B.Cooper, and G. Ozsoyoglu (editors) — Proc. of the 3rd International Workshop on Statistical and Scientific Database Management, Luxembourg, 1986.Google Scholar
  4. [DB 88]
    G.Di Battista, C.Batini — Design of Statistical Databases: a Methodology for the Conceptual Step — Information Systems, vol.13, no.4, 1988 (to appear).Google Scholar
  5. [DG 87]
    A.Di Leva, P.Giolito — A Two Level Data Model for Distributed Statistical Databases — Dipartimento di Informatica, Universita' di Torino (manuscript) 1987.Google Scholar
  6. [GJ 79]
    M.R.Garey, D.S.Johnson — Computer and Intractability — Freeman and co. 1987.Google Scholar
  7. [O et al. 86]
    F. Olken, D. Rotem, A. Shoshani, and H.K.T. Wong — Scientific and Statistical Data Management Research at LBL — Proc. of the 3rd Intl. Workshop on Statistical Database Management, Luxembourg 1986.Google Scholar
  8. [RR 83]
    M. Rafanelli and F. Ricci — Proposal for a Logical Model for Statistical Databases — Proc. of the 2nd Intl. Workshop on Statistical Database Management, Los Angeles 1983.Google Scholar
  9. [S 82]
    A. Shoshani — Statistical Databases: Characteristics, Problems, and Some Solutions — Proc. VLDB, Mexico City, 1982.Google Scholar
  10. [SC 80]
    A.Shoshani and P.Chan — Subject: a Directory Driven System for Organizing and Accessing Large Statistical Databases — Proc. of the 2nd International Conference on Very Large Data Base (VLDB), 1980, pp.553–563.Google Scholar
  11. [SW 85]
    A.Shoshani and H.K.T.Wong — Statistical and Scientific Database Issues — IEEE Transactions on Software Engineering, vol. SE-11, N.10, October 1985.Google Scholar
  12. [Su 83]
    S.Y.W. Su — SAM*: A Semantic Association Model for Corporate and Scientific-Statistical Databases — Information Sciences 29, 1983, pp. 151–199.Google Scholar
  13. [Wol 82]
    L.A.Wolsey — Maximising Real-Valued Submodular Functions: Primal and Dual Heuristics for Location Problems — Mathematics of Operations Research, vol.7, no.3, 1982.Google Scholar
  14. [W 84]
    R.T. Wong — Location and Network Design — in Combinatorial Optimization Annotated Bibliographies (M. O'hEigeartaigh, J.K. Lenstra, A.H.G. Rinnoy Kan eds.) J.Wiley, 1985.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • G. Barcaroli
    • 1
    • 3
  • G. Di Battista
    • 2
    • 3
  • E. Fortunato
    • 1
    • 3
  • C. Leporelli
    • 2
    • 3
  1. 1.Istituto Centrale di Statistica (ISTAT)RomaItalia
  2. 2.Dipartimento di Informatica e SistemisticaUniversita' di RomaItalia
  3. 3."La Sapienza"RomaItalia

Personalised recommendations