RTL a Relation and Table Language for statistical databases

  • Lotfi Lakhal
  • Rosine Cicchetti
  • Serge Miranda
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 364)


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.


Aggregate functions Complex Statistical Table Macro-data Micro-data Relational algebra Statistical databases Statistical Table 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [BEER78]
    Beeri C., Bernstein P. A., Goodman N.: "A Sophisticate's Introduction to Database Normalization Theory". Proc. VLDB, 113–124, (1978).Google Scholar
  2. [BRY86]
    Bry F., Thauront G.: "Gestion interne de données statistiques". Revue MBD, No 4, (1986).Google Scholar
  3. [CICC89a]
    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. [CICC89b]
    Cicchetti R.: "Gestion de données résumées statistiques". Thèse de Doctorat, Université de Nice, (1989).Google Scholar
  5. [CHAN 81]
    Chan P., Shoshani A.: "SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases". Proc. VLDB Conf. (1981).Google Scholar
  6. [CODD71]
    Codd E. F.: "Futher Normalization of the Data Base Relational Model". Proc. Courant Computer Science Symposium, 33–64, (1971).Google Scholar
  7. [DATE83]
    Date C. J.: "An Introduction to Database Systems". Reading, Massachusetts: Addison-Wesley, (1983).Google Scholar
  8. [DELO78]
    Delobel C.: "Normalization and Hierarchical Dependencies in the Relational Data Model". ACM TODS, 201–222, (1978).Google Scholar
  9. [GHOS84]
    Ghosh S.P.: "Statistical Relational Tables for Statistical Database Management". IBM Res. Lab. San Jose, Ca, Tech. Rep. RJ 4394 (1984).Google Scholar
  10. [HECK88]
    Hecker G. A., Unger E. A.: "A user interface for database Creation, Use and Maintenance". Proc. ACM SIGSMALL/PC Conf. (1988).Google Scholar
  11. [IKED81]
    Ikeda H., Kambayashi Y.: "Additional Facilities of Conventional DBMS to Support Interactive Statistical Analysis". Proc. WSDBM Conf. (1981).Google Scholar
  12. [JOHN81]
    Johnson R.R.: "Modelling Summary Data". Proc. ACM SIGMOD Conf. (1981).Google Scholar
  13. [KLUG81]
    Klug A.: "ABE-A Query Language for Construction Aggregates-By Example". Proc. WSDBM Conf. (1981).Google Scholar
  14. [KLUG82]
    Klug A.: "Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions". Journal ACM, Vol 29, No3 (1982).Google Scholar
  15. [KHOL85]
    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. [LAKH89a]
    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. [LAKH89b]
    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. [LETH89]
    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 81]
    Luo D. Yao S.B.: "Form Operation By Example-a Language for Office Information Processing". Proc. ACM SIGMOD Conf. (1981).Google Scholar
  20. [MALV88]
    Malvestuto F.M.: "The Derivation Problem of Summary Data". Proc. ACM SIGMOD Conf. (1988).Google Scholar
  21. [NIE 75]
    Nie H. N.: "SPSS-Statistical Package for the Social Sciences". McGraw-Hill, (1975).Google Scholar
  22. [OLKE86]
    Olken F.: "Physical Database Support for Scientific and Statistical Database Management". Proc. WSDBM Conf., 44–60, (1986).Google Scholar
  23. [OZSO85a]
    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. [OZSO85b]
    Ozsoyoglu G., Ozsoyoglu Z. M.: "Satistical Database Query Languages". IEEE Transaction on Software Ingineering, Vol. SE-11, No10, 1071–1081, (1985).Google Scholar
  25. [PSTA81]
    P-STAT Users Manual, Princeton, New Jersey, (1981).Google Scholar
  26. [RAFA86]
    Rafanelli M., Fortunato E., Ricci F. L., Sebastio A.: "An Algebra for Statistical Data". Proc. WSDBM Conf., 122–134, (1986).Google Scholar
  27. [SHOS82]
    Shoshani A.: "Statistical Databases: Characteristics, Problems and some Solutions". Proc. VLDB Conf., 208–222, (1982).Google Scholar
  28. [SHOS85]
    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 83]
    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 83]
    Su S.Y.W.: "SAM*: A Semantic Association Model for Corporate and Scientific-Statistical Databases". Inform. Sci. Vol. 29 (1983).Google Scholar
  31. [THOM83]
    Thomas S. J.: "A Non-First-Normal-Form Relational Database Model". Ph.D Thesis, Vanderbilt University, (1983)Google Scholar
  32. [TURN79]
    Turner M., Hammond R., Cotton F.: "A DBMS for Large Statistical Databases". Proc. VLDB, 319–327, (1979).Google Scholar
  33. [ULLM80]
    Ullman J. D.: "Principales of Database Systems". Potomac, Maryland: Computer Science Press, (1980).Google Scholar
  34. [WONG84]
    Wong H.K.T.: Micro and Macro Statistical/Scientific Database Management". First Int. Conf. On Data Engineering, Los Angeles (1984).Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • Lotfi Lakhal
    • 1
    • 3
  • Rosine Cicchetti
    • 2
    • 3
  • Serge Miranda
    • 3
  1. 1.University of Tunis, ENSIArianaTunisie
  2. 2.CeramValbonne cedexFrance
  3. 3.BAOU Project, University of Nice-CNRS, LISANSophia-Antipolis, ValbonneFrance

Personalised recommendations