Skip to main content
SpringerLink
Log in

Interpretation of statistical queries to relational databases

  • Work In Progress Papers
  • Chapter
  • First Online:
Statistical and Scientific Database Management (SSDBM 1988)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 339))

Abstract

A research in progress concerning the problem of extending the logical independence approach to statistical query answering is described. The main ideas and limitations of a system which assists a user in obtaining a statistical table from a relational database by describing only elements that compose the table are discussed. The proposed system assists the user in formulating statistical queries by means of a universal relation interface, i.e., independently from the underlying database structure. To generate the result, an extended relational algebra is needed to process aggregations in queries function; heuristics for the interpretation of queries and their translation in terms of database primitives are the basis of the proposed approach.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. G.A. Anderson, T. Snider, B. Robinson, J. Toporek, "An integrated research support system for inter-package communication and handling large volume output from statistical database analysis operations", Second International Workshop on Statistical Database Management, 1983.

    Google Scholar 

  2. P. Atzeni, D.S. Parker, "Assumptions in relational database theory", ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1982.

    Google Scholar 

  3. G. Ausiello, A. D'Atri, M. Moscarini, "Chordality properties on graphs and minimal logical connections in semantic data model", Journal of Computer and System Science, 33, 2, 1986.

    Google Scholar 

  4. R. Buhler, "Data manipulation in P-STAT", First LBL Workshop on Statistical Database Management, 1981.

    Google Scholar 

  5. P. Chan, A. Shoshani, "Subject: a directory driven system for organizing and accessing large statistical databases", Very Large Data Bases Conference, 1981.

    Google Scholar 

  6. A. D'Atri (ed.), "Comparative analysis of presently available languages and methods for supporting user interaction with data and knowledge base systems", Report on Task A2, Esprit Project 641, 1985.

    Google Scholar 

  7. A. D'Atri, P. Di Felice, M. Moscarini, "Dynamic query interpretation in relational databases", ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1987.

    Google Scholar 

  8. F. De Rosis, A. Franich, S. Pizzutilo, F.L. Ricci, "Handling and analyzing epidemiologial data by microcomputer", Lecture Notes in Medical Informatics, 24, Springer-Verlag, 1984.

    Google Scholar 

  9. G. Falcitelli, "Stipam: a system for preliminary management of statistical information oriented towards multivariate analysis", Cinquièmes Journées Internationales Analyse des Données et Informatique, 1987.

    Google Scholar 

  10. E. Fortunato, M. Rafanelli, F.L. Ricci, A. Sebastio, "An algebra for statistical data", Third International Workshop on Statistical and Scientific Database Management, 1986.

    Google Scholar 

  11. R.A. Hilhorst and others, "ROCHEFORT: research on creating a human environment for on-line research tools", Statistical Software Newletter, 13, 2, 1987.

    Google Scholar 

  12. H. Ikeda, Y. Kobayashi, "Additional facilities of a conventional DBMS to support interactive statistical analysis", First LBL Workshop on Statistical Database Management, 1981.

    Google Scholar 

  13. R.R. Johnson, "Modelling summary data", ACM-SIGMOD International Conference on Management of Data, 1981.

    Google Scholar 

  14. I. Karasalo, P. Svensson, "An overview of CANTOR — A new system for data analysis", Second International Workshop on Statistical Database Management, 1983.

    Google Scholar 

  15. W. Kent, "Consequences of assuming a universal relation", ACM Trans. on Database Systems, 6, 4, 1981.

    Google Scholar 

  16. J.G. Klensin, "A statistical database component of a data analysis and modelling system: lessons from eight years of user experience", Second International Workshop on Statistical Database Management, 1983.

    Google Scholar 

  17. A. Klug, "ABE — A query language for constructing aggregate-by-example", First LBL Workshop on Statistical Database Management, 1981.

    Google Scholar 

  18. A. Klug, "Equivalence of relational algebra and relational calculus query languages having aggregate functions", J. of ACM, 29, 3, 1982.

    Google Scholar 

  19. H.Kohji, H. Sato, "Statistical database research project in Japan and the CAS SDB project", Second International Workshop on Statistical Database Management, 1983.

    Google Scholar 

  20. D. Maier, "Windows on the world", ACM-SIGMOD International Conference on Management of Data, 1983.

    Google Scholar 

  21. A.T. Maness, S.A. Dintelman, "Design of the genealogical information system", First LBL Workshop on Statistical Database Management, 1981.

    Google Scholar 

  22. J. McCarthy and others, "The SEDIS project; a summary overview of social, economic, environmental, demografic information system", L.B.L. report, Un. of California, Berkeley, 1982.

    Google Scholar 

  23. M. Minsky, "A framework for representing knowledge", in "The psychology of computer vision", McGraw-Hill, 1975.

    Google Scholar 

  24. A. Motro, "Baroque: a browser for relational databasee", ACM-SIGMOD International Conference on Management of Data, 1986.

    Google Scholar 

  25. A. Motro, A. D'Atri, L. Tarantino, "The design of KIWI: an object oriented browser", Expert Database Systems Conference, 1988.

    Google Scholar 

  26. Z.M. Ozsoyoglu, G. Ozsoyoglu, "STBE — Database query language for manipulating summary data", Report CES-82-2, Case Western Reserve University, Cleveland, 1982.

    Google Scholar 

  27. G. Ozsoyoglu, Z.M. Ozsoyoglu, "Statistical database query languages", IEEE Trans. on Software Engineering, SE-11, 10, 1985.

    Google Scholar 

  28. Z.M. Ozsoyoglu, G. Ozsoyoglu, V. Matos, "Extending relational algebra and relational calculus with set-valued attributes and aggregate function", ACM Trans. on Database Systems, 12, 4, 1987.

    Google Scholar 

  29. M. Rafanelli, F.L. Ricci, "Proposal of a logical model for a statistical database", Second International Workshop on Statistical Database Management, 1983.

    Google Scholar 

  30. D. Saccà, et al., "Description of the overall architecture of the KIWI system", in "ESPRIT 85: Status Report on Continuing Work", Elsevier Science Publishers B.V. (North-Holland), 1986.

    Google Scholar 

  31. H.J. Schek, M.H. Scholl, "The relational model with relational-valued attributes", Information Systems, 11, 2, 1986.

    Google Scholar 

  32. A. Shoshani, "Statistical databases: characteristics, problems and some solutions", Very Large Data Bases Conference, 1982.

    Google Scholar 

  33. A. Shoshani, H.K.T. Wong, "Statistical and scientific database issues", IEEE transaction on Software Engineering, SE-11, 10, 1985.

    Google Scholar 

  34. J.M. Smith, D.C.P. Smith, "Database abstractions: aggregation and generalization", ACM Trans. on Database Systems, 2, 2, 1977.

    Google Scholar 

  35. P. Stecher, P. Hellemaa, "An intelligent extraction and aggregation tool for company data bases", Decision Support Systems, 2, 1986.

    Google Scholar 

  36. S.Y.W. Su, "SAM*: a semantic association model for corporate and scientific-statistical databases", Information Science, 29, 2 and 3, 1983.

    Google Scholar 

  37. M. Turner, R. Hammond, P. Cotten, "A DBMS for large statistical databases", Very Large Data Bases Conference, 1979.

    Google Scholar 

  38. J.D. Ullman, "Universal relation interfaces for database systems", IFIP Conference, 1983.

    Google Scholar 

  39. J.D. Ullman, Principles of Database and Knowledge Base Systems, Computer Science Press, 1988.

    Google Scholar 

  40. S.E. Weiss, P.L. Weeks, N.J. Byrd, "Must we navigate through databases?", First LBL Workshop on Statistical Database Management, 1981.

    Google Scholar 

  41. H.K.T. Wong, I. Kuo, "GUIDE: graphical user interface for database exploration", Very Large Data Bases Conference, 1982.

    Google Scholar 

  42. H.K.T. Wong, "Micro and macro statistical/scientific database management", IEEE Conference on Data Engineeering, 1984.

    Google Scholar 

  43. M.M. Zloof, "Query-by-Example: a data base language", IBM Systems Journal, 16, 4, 1977.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dipartimento di Ingegneria Elettrica, Università dell'Aquila, Poggio di Roio, 67040, L'Aquila, Italy

    Alessandro D'Atri

  2. Istituto di Studi sulla Ricerca e la Documentazione Scientifica del CNR, via C. De Lollis 12, 00185, Roma, Italy

    Fabrizio L. Ricci

Authors
  1. Alessandro D'Atri
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Fabrizio L. Ricci
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Maurizio Rafanelli John C. Klensin Per Svensson

Rights and permissions

Reprints and permissions

Copyright information

© 1989 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

D'Atri, A., Ricci, F.L. (1989). Interpretation of statistical queries to relational databases. In: Rafanelli, M., Klensin, J.C., Svensson, P. (eds) Statistical and Scientific Database Management. SSDBM 1988. Lecture Notes in Computer Science, vol 339. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0027517

Download citation

  • DOI: https://doi.org/10.1007/BFb0027517

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-50575-4

  • Online ISBN: 978-3-540-46045-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation