Skip to main content
SpringerLink
Log in

Complex-statistical-table structure and operators for macro statistical databases

  • Interfaces And Formal Models
  • Conference paper
  • First Online:
Foundations of Data Organization and Algorithms (FODO 1989)

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

Abstract

They are two kinds of Statistical DataBases (SDBs), micro and macro-SDBs. Micro-SDBs describe individual entities or events, they are mainly used for statistical analysis. Macro-SDBs contain only summary-data achieved by statistical-mathematical operations on micro-SDBs. In this paper, we propose a data-structure called Complex Statistical Table (CST) which offer a formal and homogeneous framework to develop macro-SDBs. In order to manipulate CST structure, we define two classes of operators : CST transposition operators making data-organisation dynamic and CST retrieval operators that work on CST instances. We also propose a discussion pointing out our approach contrasted with other contributions of this field.

This work is supported, in part, by French Departement of Education and Science — Direction de l' Evaluation et de la Prospective.

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. Anderson G. D., Snider T., Robinson B., Toporek J.: "An integrated research support system for interpackage communication and handling analysis database operations". Proc. WSDBM Conf., (1983).

    Google Scholar 

  2. Bry F., Thauront G.: "Gestion interne de données statistiques". Revue MBD, No 4, (1986).

    Google Scholar 

  3. Cicchetti R., Lakhal L., N. Le Thanh, Miranda S.: "A logical Summary-Data Model for Statistical Databases". Proc. Int. Symp. on Database Systems for Advanced Applications, Seoul, (1989).

    Google Scholar 

  4. Cicchetti R.: "Gestion de données résumées statistiques". Thèse de Doctorat, Université de Nice, (1989).

    Google Scholar 

  5. Chan P., Shoshani A.: "SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases". Proc. VLDB Conf., (1981).

    Google Scholar 

  6. Datta. A., Fournier B., Hou W.C., Ozsoyoglu G.: "The Design and Implementation of the SSDB". Proc. WSDBM Conf., (1986).

    Google Scholar 

  7. Delobel C.: "Bases de données et systèmes relationnels". DUNOD Ed., (1982).

    Google Scholar 

  8. DATE C. J.: "An Introduction to Database Systems". Addison-Wesley publishing Ed., (1981).

    Google Scholar 

  9. Ghosh S.P.: "Statistical Relational Tables for Statistical Database Management". IBM Res. Lab. San Jose, Ca, Tech. Rep. RJ 4394, (1984).

    Google Scholar 

  10. Ghosh S.P. "An Application of Statistical Databases in Manufacturing Testing". IEEE Transaction on Software Ingineering, Vol. SE-11, No 7, (1985).

    Google Scholar 

  11. Hecker G. A., Unger E. A.: "A user interface for database Creation, Use and Maintenance". Proc. ACM SIGSMALL/PC Conf., (1988).

    Google Scholar 

  12. Hebrail G.: "Définition de Résumés et Incertitude dans les Grandes Bases de Données". Thèse de Doctorat, Université de Paris-Sud, (1987).

    Google Scholar 

  13. Ikeda H., Kambayashi Y.: "Additional Facilities of Conventional DBMS to Support Interactive Statistical Analysis". Proc. WSDBM Conf., (1981).

    Google Scholar 

  14. Johnson R.R.: "Modelling Summary Data". Proc. ACM SIGMOD Conf., (1981).

    Google Scholar 

  15. Kambayashi Y., Futagami K., Ikeda H.: "Implementation of a Statistical Database System HSDB". Proc. COMPSTAT Conf., (1982).

    Google Scholar 

  16. Klug A.: "ABE — A Query Language for Construction Aggregates-By Example". Proc. WSDBM Conf., (1981).

    Google Scholar 

  17. Klug A.: "Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions". Journal ACM, Vol 29, No3, (1982).

    Google Scholar 

  18. Khoshafian S. Bates D. M., DeWitt D. J.: "Efficient Support of Statistical Operators". IEEE Transaction on Software Ingineering, Vol. SE-11, No 10, (1985).

    Google Scholar 

  19. Lakhal L., Cicchetti R., Miranda S.: "A Relation and Table Language for Statistical Databases". Proc. MFDBS89. Lecture Notes in computer science, Springer Verglas, (1989).

    Google Scholar 

  20. Latour P.: "La controverse entre SGBD classique et relationnel n'est-elle-pas un faux débat ?". Revue MBD, No 2, (1986).

    Google Scholar 

  21. Luo D. Yao S.B.: "Form Operation By Example — a Language for Office Information Processing". Proc. ACM SIGMOD Conf., (1981).

    Google Scholar 

  22. Malvestuto F. M.: "The Derivation Problem of Summary Data". Proc. ACM SIGMOD Conf., (1988).

    Google Scholar 

  23. McCarthy J.: "Meta-data Management for Large Statistical Database". Proc. VLDB Conf., (1982).

    Google Scholar 

  24. Nie H. W.: "SPSS-Statistical Package for the social sciences". McGraw-Hill Ed., (1975)

    Google Scholar 

  25. Nwokogba I., Rowan W. H.: "A Model for Integrated Statistical and Commercial Database". First Int. Conf. On Data Engineering, Los Angeles, (1984).

    Google Scholar 

  26. Olken F.: "Physical Database Support for Scientific and Statistical Database Management". Proc. WSDBM Conf., (1986).

    Google Scholar 

  27. Ozsoyoglu Z. M., Ozsoyoglu G.: "STBE — A Database Query Language for Manipulating Summary Data". First Int. Conf. On Data Engineering, Los Angeles, (1984).

    Google Scholar 

  28. Ozsoyoglu Z.M, Ozsoyoglu G.: "A Language and a physical organization technique for summary-tables". Proc. ACM SIGMOD Conf., (1985).

    Google Scholar 

  29. Ozsoyoglu G., Ozsoyoglu Z. M.: "Satistical Database Query Languages". IEEE Transaction on Software Ingineering, Vol. SE-11, No 10, (1985).

    Google Scholar 

  30. P-STAT Users Manual, Princeton, New Jersey, (1981).

    Google Scholar 

  31. Rafanelli M., Fortunato E., Ricci F. L., Sebastio A.: "An Algebra for Statistical Data". Proc. WSDBM Conf., (1986).

    Google Scholar 

  32. Sato H.: "Handling Summary Information in a Database: Derivability". Proc. ACM SIGMOD Conf., (1981).

    Google Scholar 

  33. Shoshani A.: "Statistical Databases: Characteristics, Problems and some Solutions". Proc. VLDB Conf., (1982).

    Google Scholar 

  34. Shoshani A., Wong H.K.T.: "Statistical and Scientific Database Issues". IEEE Transaction on Software Ingineering, Vol. SE-11, No 10, (1985).

    Google Scholar 

  35. Shu N. C., Wong K. T. Lum V. Y.: "Forms Approach to Requirements Specification for Database Design". Proc. ACM SIGMOD Conf., (1983).

    Google Scholar 

  36. Su S.Y.W.: "SAM*: A Semantic Association Model for Corporate and Scientific-Statistical Databases". Inform. Sci. Vol. 29, (1983).

    Google Scholar 

  37. Turner M., Hammond R., Cotton F.: "A DBMS for Large Statistical Databases". Proc. VLDB, (1979).

    Google Scholar 

  38. Wong H.K.T.: Micro and Macro Statistical/Scientific Database Management". First Int. Conf. On Data Engineering, Los Angeles, (1984).

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Tunis, ENSI, 2049, Ariana, TUNISIE

    Lotfi Lakhal

  2. CERAM, Sophia Antipolis, BP 120, 06561, Valbonne cedex, France

    Rosine Cicchetti

  3. BAOU Project, University of Nice-CNRS, LISAN, Bat 3, Rue A. Einstein, 06560, Sophia-Antipolis, Valbonne, France

    Lotfi Lakhal, Rosine Cicchetti & Serge Miranda

Authors
  1. Lotfi Lakhal
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rosine Cicchetti
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Serge Miranda
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Witold Litwin Hans-Jörg Schek

Rights and permissions

Reprints and permissions

Copyright information

© 1989 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Lakhal, L., Cicchetti, R., Miranda, S. (1989). Complex-statistical-table structure and operators for macro statistical databases. In: Litwin, W., Schek, HJ. (eds) Foundations of Data Organization and Algorithms. FODO 1989. Lecture Notes in Computer Science, vol 367. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-51295-0_146

Download citation

  • DOI: https://doi.org/10.1007/3-540-51295-0_146

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-51295-0

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

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation