A visual interface for browsing and manipulating statistical entities

  • Maurizio Rafanelli
  • Fabrizio L. Ricci
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 420)


In this paper we would like to present a proposal for a visual interface which can be easily used by statistical users. This interface, from a graphical point of view, is based on an extension of the Grass logical model. The commands for the manipulation of the statistical entities which were realized in this interface are based on the macro-data algebra defined in the Mefisto functional model. By means of this interface it is possible to browse in the database, to select topic-classified statistical entities and to manipulate these entities by carrying out queries based on an extension of the Staquel query language. The interface has been realized by the definition of windows for graphic visualization of the statistical entities, for direct manipulation, for data analysis options, information and functions (planned so far), for print format and for expression of data definition language and query language.


Visual interface Statistical databases Database browser Metadata manipulation Information retrieval 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Chan 81]
    P.Chan, A.Shoshani, "SUBJECT: a directory driven system for organizing and accessing large statistical databases", Proceed. of the VII Very Large Data Bases, 1981.Google Scholar
  2. [Di Battista 88]
    G.Di Battista, C.Batini, "Design of statistical databases: a methodology for the conceptual step" Inform. Systems, Vol.13, No.4, 1988Google Scholar
  3. [D'Atri 89]
    A.D'Atri, L. Tarantino, "From browsing to querying" IEEE Data Engineering Bulletin, June 1989.Google Scholar
  4. [Falcitelli 89]
    G.Falcitelli, L.Meo Evoli, E.Nardelli, F.L.Ricci, "The Mefisto⋆ model: an object oriented representation for statistical data management" Int. Symp. on Data analysis, learning symbolic and numeric knowledge, Sept. 1989.Google Scholar
  5. [Fortunato 86]
    E.Fortunato, M.Rafanelli, F.L.Ricci, A.Sebastio, "An algebra for statistical data" Proceed. of the 3rd Internat. Workshop on Statistical and Scientific Database Management, 1986.Google Scholar
  6. [Ghosh 86]
    S.P.Ghosh, "Statistical relational tables for statistical database management" IEEE Trans. on Software Engineering, Vol.SE-12, N.12, Dec.1986Google Scholar
  7. [Johnson 81]
    R.Johnson, "Modelling summary data" Proceed. ACM SIGMOD 1981Google Scholar
  8. [Ikeda 81]
    H.Ikeda, Y.Kobayashi, "Additional facilities of a conventional DBMS to support interactive statistical analysis" Proceed. 1st InterN Work. on Statistical Database Management, 1981Google Scholar
  9. [Klug 82]
    A.Klug, "Equivalence of relational algebra and relational calculus query languages having aggregate functions" Journ. ACM N.29-3, 1982Google Scholar
  10. [Malvestuto 88]
    F.Malvestuto, M.Rafanelli, C.Zuffada "Many — source databases: some problems and solutions" Tech. Rep. IASI R.218, June 1988.Google Scholar
  11. [Malvestuto 89]
    F.Malvestuto, C.Zuffada "The classification problem with semantically heterogeneous data" Proc. IV Intern. Confer. on Statistical and Scientific Database Management, Lecture Notes in Computer Science N.339 (Rafanelli, Klensin, Svensson Ed.s), Springer Verlag Pub., 1989Google Scholar
  12. [Ozsoyoglu 87]
    G.Ozsoyoglu, Z.M.Ozsoyoglu, V. Matos, "Extending relational algebra and relational calculus with set-valued attributes and aggregate functions", ACM trans. Database Systems, 12, 4, 1987.Google Scholar
  13. [Rafanelli 83]
    M.Rafanelli, F.L.Ricci, "Proposal of a logical model for statistical data base", Proceed. of the 2nd Internat. Workshop on Statistical Database Management, 1983.Google Scholar
  14. [Rafanelli 85]
    M.Rafanelli, F.L.Ricci "Staquel: a query language for statistical macrodatabase management systems" Proceed. CIL'85, 1985.Google Scholar
  15. [Rafanelli 89]
    M.Rafanelli, F.L.Ricci "Mefisto: a functional model for statistical entities" Tecn. Rep. IASI, 1989 (in press)Google Scholar
  16. [Rafanelli 90]
    M.Rafanelli, A.Shoshani "A Statistical object representation model" Proc. 5th Intern. Confer. on Statistical and Scientific Database Management, this volume.Google Scholar
  17. [Sato 81]
    H.Sato, "Handling summary information in a database: derivability" Proceed. ACM SIGMOD 1981Google Scholar
  18. [Su 83]
    S.Y.W.Su, "SAM⋆: a semantic association model for corporate and scientific-statistical databases", Information Sciences, Vol.29, N.2 and 3, May and June 1983.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1990

Authors and Affiliations

  • Maurizio Rafanelli
    • 1
  • Fabrizio L. Ricci
    • 2
  1. 1.Istituto di Analisi dei Sistemi ed InformaticaRoma
  2. 2.Istit. di Studi per la Ricerca e la Docum. Scient.RomaItaly

Personalised recommendations