Skip to main content
SpringerLink
Log in

RTL a Relation and Table Language for statistical databases

  • Conference paper
  • First Online:
MFDBS 89 (MFDBS 1989)

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

Included in the following conference series:

Abstract

In this paper, we present a multidimentional data language-RTL (Relation and Table Language) allowing statisticans to handle micro and macro statistical databases. We first describe our data model for statistical applications, based upon a twofold structure : relation and Complex Statistical Table (CST). Then, we present RTL, that encompasses relational algebra with aggregate operator, transformation operators, in order to achieve conversion between relations and CSTs, and specific CST-manipulation operators, allowing to modify CST organization (and making this data-structure dynamic) or to aggregate macro-data.

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. Beeri C., Bernstein P. A., Goodman N.: "A Sophisticate's Introduction to Database Normalization Theory". Proc. VLDB, 113–124, (1978).

    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. Codd E. F.: "Futher Normalization of the Data Base Relational Model". Proc. Courant Computer Science Symposium, 33–64, (1971).

    Google Scholar 

  7. Date C. J.: "An Introduction to Database Systems". Reading, Massachusetts: Addison-Wesley, (1983).

    Google Scholar 

  8. Delobel C.: "Normalization and Hierarchical Dependencies in the Relational Data Model". ACM TODS, 201–222, (1978).

    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. Hecker G. A., Unger E. A.: "A user interface for database Creation, Use and Maintenance". Proc. ACM SIGSMALL/PC Conf. (1988).

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  15. Khoshafian S., Bates D. M., DeWith D. J.: "Efficient Support of Statistical Operations". IEEE Transaction on Software Ingineering, Vol. SE-11, No10, 1058–1070, (1985).

    Google Scholar 

  16. Lakhal L., Cicchetti R., Miranda S.: "Complex-Statistical-Table Structure and Operators for Macro Statistical Databases". Proc. FODO89. Lecture Notes in computer science, Springer Verglag, (1989).

    Google Scholar 

  17. Lakhal L., Cicchetti R., Miranda S.: "Formal Operators for Macro Statistical Databases". Research Report, University of Nice-CNRS, BAOU≠4-89, (1989).

    Google Scholar 

  18. Le Thanh N., Lakhal L., Miranda S.: "Isodependances et nouvelle méthode de décomposition d'un schéma relationnel". Revue-AFCET, "Modèles et Bases de données", No 11, 1–9, (1989).

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  21. Nie H. N.: "SPSS-Statistical Package for the Social Sciences". McGraw-Hill, (1975).

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  24. Ozsoyoglu G., Ozsoyoglu Z. M.: "Satistical Database Query Languages". IEEE Transaction on Software Ingineering, Vol. SE-11, No10, 1071–1081, (1985).

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  27. Shoshani A.: "Statistical Databases: Characteristics, Problems and some Solutions". Proc. VLDB Conf., 208–222, (1982).

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  31. Thomas S. J.: "A Non-First-Normal-Form Relational Database Model". Ph.D Thesis, Vanderbilt University, (1983)

    Google Scholar 

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

    Google Scholar 

  33. Ullman J. D.: "Principales of Database Systems". Potomac, Maryland: Computer Science Press, (1980).

    Google Scholar 

  34. 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

János Demetrovics Bernhard Thalheim

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). RTL a Relation and Table Language for statistical databases. In: Demetrovics, J., Thalheim, B. (eds) MFDBS 89. MFDBS 1989. Lecture Notes in Computer Science, vol 364. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-51251-9_19

Download citation

  • DOI: https://doi.org/10.1007/3-540-51251-9_19

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-51251-6

  • Online ISBN: 978-3-540-46182-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation