Skip to main content
SpringerLink
Log in
Book cover

International Conference on Scientific and Statistical Database Management

SSDBM 1988: Statistical and Scientific Database Management pp 19–38Cite as

Statistical data management requirements and the SQL standards—an evolving comparison

  • Invited Lectures
  • Chapter
  • First Online:

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

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

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Anderson, R.E. and E. Coover, "Wrapping the package—critical thoughts on applications software for social data analysis", Computers and the Humanities, 7 (1972), pp. 81–95.

    Google Scholar 

  2. Anderson, R.E. and F.M. Sim, "Data Management and Statistical Analysis in Social Science Computing", American Behavioral Scientist, 20, 2 (January/February 1977), pp. 367–409.

    Google Scholar 

  3. Mace, S., "Ashton-Tate, Microsoft Join Forces to Introduce SQL Database Server", Info World, 10, 3 (January 18, 1988), p.1, and G. Abruzze, "Microsoft, A-T join forces to unveil new 'sQL Server'", Computer & Software News, 6, 3 (January 18, 1988), p. 1.

    Google Scholar 

  4. Belsley, D.A., E. Kuh, and R.E. Welsch, Regression Diagnostics: Identifying Influential Data and Sources of Collinearity, New York: John Wiley & Sons, 1980.

    Google Scholar 

  5. Bishop, Y.M., and S.R. Freedman, "Classification of Metadata", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 230–234.

    Google Scholar 

  6. Brode, J., P. Werbos, and E. Dunn, TSP in the Datatran Language, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1977.

    Google Scholar 

  7. Brown, V.A., S.B. Navathe, and S.Y.W. Su, "Complex Data Types and a Data Manipulation Language for Scientific and Statistical Databases", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 188–195.

    Google Scholar 

  8. Celko, J., ANSI X3H2 87-23, "Domains in SQL2", September 1987.

    Google Scholar 

  9. Chan, P. et al., "Statistical Data Management Research at Lawrence Berkeley Laboratory", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 273–279.

    Google Scholar 

  10. Codd, E.F., "A Relational Model of Data for Large Shared Data Banks", Communications of the ACM, 13, 6 (June 1970), pp. 377–387. See esp. pp. 380–381.

    Google Scholar 

  11. Codd, E.F., "Extending the database relational model to capture more meaning", ACM Trans. on Database Systems, 4, 4 (1979).

    Google Scholar 

  12. Barritt, M.M. and D. Wishart, COMPSTAT 80: Proceedings in Computational Statistics, Vienna: Physica-Verlag, 1980.

    Google Scholar 

  13. Coombs, C.H., A Theory of Data, New York: Wiley, 1967.

    Google Scholar 

  14. Couch, A.S., Armor, D.J., et al., DATA-TEXT System: A computer language for social science research, Cambridge, MA, USA: Harvard University Department of Social Relations, 1969.

    Google Scholar 

  15. Date, C.J., A Guide to the SQL Standard: A user's guide to the standard relational language SQL, Reading, MA, USA: Addison-Wesley, 1987. See especially Appendix E, "An Annotated SQL Critique".

    Google Scholar 

  16. Denning, D., "A Security Model for the Statistical Database Problem", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 368–390.

    Google Scholar 

  17. Dennis, J.E., D.M. Gay, and R.E. Welsch, "An Adaptive Nonlinear Least-Squares Algorithm", Technical Report #TR-20, Alfred P. Sloan School of Management, Cambridge, MA, USA: MIT, 1980.

    Google Scholar 

  18. Denning, D., W. Nicholson, G. Sande, and A. Shoshani, "Research Topics in Statistical Database Management", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 46–53.

    Google Scholar 

  19. Dixon, W.J., ed., BMD: Biomedical Computer Programs, Los Angeles: Health Sciences Computing Facility, University of California, Los Angeles, 1964.

    Google Scholar 

  20. Francis, I. and J. Sedransk, "Software Requirements for the Analysis of Surveys", Proceedings of the International Biometric Conference, 1976, pp. 228–253.

    Google Scholar 

  21. Francis, I., ed., Statistical Software, A Comparative Review, New York: Elsevier North-Holland, 1981.

    Google Scholar 

  22. Goldstein, R.C. and A.J. Strnad, "The MacAims Data Management System", Proc. 1970 ACM SIGFIDET Workshop on Data Description and Access, New York: ACM, 1970.

    Google Scholar 

  23. Hirsch, A.R., "Array Processing in SQL2", ANSI X3H2-87-294, October 26, 1987.

    Google Scholar 

  24. Hirsch, A.R., Personal communication.

    Google Scholar 

  25. Information Builders, Inc., "Sample MULTR Terminal Session", FOCUS Users Manual, pp. 8–18–8–20.

    Google Scholar 

  26. Klensin, J.C., "Representation of trace, missing, and zero values in food data interchange", INFOODS Working Paper INFOODS/IS N22, Cambridge, MA, USA: MIT INFOODS Secretariat, 1987.

    Google Scholar 

  27. ISO 9075-1987, Database Language—SQL, 1987 and ANSI X3.135-1986, ANSI Database Language—SQL, 1986.

    Google Scholar 

  28. Klensin, J.C. and D.B. Yntema, "Beyond the package: A new approach to behavioral science computing", Social Science Information, 20, 4/5 (1981), pp. 787–815.

    Google Scholar 

  29. Klensin, J.C., and R. Dawson, The Consistent System, Program Summaries, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1981.

    Google Scholar 

  30. Klensin, J.C., "A Statistical Database Component of a Data Analysis and Modelling System: Lessons from eight years of user experience", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 280–286.

    Google Scholar 

  31. The Consistent System, Janus Reference Manual, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1975.

    Google Scholar 

  32. Mace, S. and E. Warner, "Lotus Choses Gupta Database Engine", Info World, 10, 7 (February 15, 1988), p. 1.

    Google Scholar 

  33. Malmborg, E., "On the Semantics of Aggregated Data", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 152–158.

    Google Scholar 

  34. Martin, D. Advanced Database Techniques, Cambridge, MA: The MIT Press, 1986.

    Google Scholar 

  35. McIntosh, S.D. and D.M. Griffel, "ADMINS Mark III—The User's Manual", Cambridge, MA, USA: MIT Center for International Studies, March 1970.

    Google Scholar 

  36. Melton, J., ANSI X3H2-88-2, "ANSI SQL2 vs. SQL3 preliminary preferences (revised)", 22 December 1987 and X3H2-88-3, "Some criteria for discriminating between SQL2 and SQL3", 26 December 1987. Of the X3H2 members at the December 1987 meeting, 39% preferred to defer DOMAINs and 59% preferred to defer ENUMERATED DATA TYPEs until SQL3 or later.

    Google Scholar 

  37. Melton, J., ISO Data Base Language CPH-2a, ANSI X3H2-88-127, ANSI X3H2 ISO/IEC JTC1/SC21/WG3 Data Base Languages, ISO-ANSI (working draft) SQL2, April 1988.

    Google Scholar 

  38. Merrill, D., J. McCarthy, F. Gey, and H. Holmes, "Distributed Data Management in a Minicomputer Network: The SEEDIS Experience," Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 99–103.

    Google Scholar 

  39. Miller, J.R. III, "Proposed user conventions and the kernel of a user language for the Janus (front-end) system", Cambridge Project working paper, April 8, 1971.

    Google Scholar 

  40. Mosteller, F., "Association and Estimation in Contingency Tables", Journal of the American Statistical Association, 63 (1968), pg. 1977.

    Google Scholar 

  41. Muller, R.J., "Using Statistical Software with a Database Management Data Theory", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 414–423.

    Google Scholar 

  42. Muller, R.J., Data Organization: The integration of database management, data analysis, and software technology applied to the National Crime Survey, unpublished Ph.D. dissertation, MIT Department of Political Science, 1983.

    Google Scholar 

  43. Nie, N.H., C.H. Hull, J. Jenkins, K. Steinbrenner, and D.H. Bent, SPSS Statistical Package for the Social Sciences, New York: McGraw-Hill, 1975.

    Google Scholar 

  44. Olken, F., D. Rotem, A. Shoshani, and H.K.T. Wong, "Scientific and Statistical Data Management Research at LBL", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 1–20.

    Google Scholar 

  45. Oracle Corporation, SQL *Plus Reference Guide and SQL *Plus User's Guide, Belmont, CA: Oracle, 1986.

    Google Scholar 

  46. Ozsoyoglu, G. and Z.M. Ozsoyoglu, "Features of a System for Statistical Databases", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 9–18.

    Google Scholar 

  47. Parta, R.E., J.C. Klensin, and I. de Sola Pool, "The Shortwave Audience in the USSR: Methods for Improving the Estimates", Communications Research, 9, 4 (Oct 1982), pp. 581–606.

    Google Scholar 

  48. Pelletier, P.A. and M.A. Nolte, "Time and the Panel Study of Income Dynamics", in J. Rabin and A. Marks, eds., Data Bases in the Humanities and Social Sciences, 1980, pp. 53–60.

    Google Scholar 

  49. Read, B.J., "Scientific Data Manipulation in a Relational Database System", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 31–35.

    Google Scholar 

  50. Riano, C., "Using Logic to Organize Statistical Databases", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 159–164.

    Google Scholar 

  51. Shye, S., "Partial Order Scalogram Analysis", in Shey, S., ed., Theory Construction and Data Analysis in the Behavioral Sciences, San Francisco: Jossey-Bass, 1978.

    Google Scholar 

  52. Sonquist, J.A. and W.C. Dunkelberg, Survey and Opinion Research: Procedures for Processing and Analysis, New Jersey: Prentice-Hall, 1977, See especially pp. 20–40.

    Google Scholar 

  53. Survey Research Center, Computer Support Group, OSIRIS IV: Statistical Analysis and Data Management Software System, Ann Arbor, MI, USA: Institute for Social Research, University of Michigan, 1979.

    Google Scholar 

  54. Stamen, J.P. and R. Wallace, "Janus: A Data Management and Analysis System for the Behavioral Sciences", Proceedings of the 1973 Annual Conference of the ACM, New York: ACM 1973.

    Google Scholar 

  55. Stevens, S.S., "On the Theory of Scales of Measurement", Science, 103 (1946), pp. 677–680.

    Google Scholar 

  56. Stewart, K. editorial, Journal of Food Composition and Analysis, Vol. 1, No. 2, (March 1988), p. 103.

    Google Scholar 

  57. Stone, P.S., D.C. Dunphy, M.S. Smith, and D.M. Ogilve, The General Inquirer: A computer approach to content analysis, Cambridge, MA, USA: MIT Press, 1966.

    Google Scholar 

  58. Su, S.Y.W., S.B. Navathe, and D.S. Batory, "Logical and Physical Modeling of Statistical/Scientific Databases", Proc., 2nd Int. Workshop on Statistical Database Management, 1983.

    Google Scholar 

  59. Teitel, R., "User Interface with a Relational Model of Data", ACM SIGSOC Bulletin, 13, 2–3 (January 1982).

    Google Scholar 

  60. Tukey, J.W. and M.B. Wilk, "Data analysis and statistics: techniques and approaches", Proceedings of the Symposium on Information Processing in Sight Sensory Systems, Pasadena, CA, USA: California Institute of Technology, 1–3 November 1965.

    Google Scholar 

  61. Tukey, J.W., Exploratory Data Analysis, Reading, MA, USA: Addison-Wesley, 1977. See Preface, esp. p. vi.

    Google Scholar 

  62. Yntema, D.B., ed., "Summer Study Report", MIT: Cambridge Project, 1970. A summary of important points appear as Chapter 6 of Yntema, D.B., ed., The Cambridge Project: Annual Progress Report June 1970-June 1971, Cambridge, MA, USA: MIT Cambridge Project, 1971, available from USA Defense Documentation Center (Contract DAHC15 690347), July 1971.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Massachusetts Institute of Technology, Room 20A-226, 02139, Cambridge, MA, USA

    John C. Klensin & Roselyn M. Romberg

Authors
  1. John C. Klensin
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Roselyn M. Romberg
    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

Klensin, J.C., Romberg, R.M. (1989). Statistical data management requirements and the SQL standards—an evolving comparison. 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/BFb0027503

Download citation

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

  • 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