Advertisement

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

  • John C. Klensin
  • Roselyn M. Romberg
Invited Lectures
Part of the Lecture Notes in Computer Science book series (LNCS, volume 339)

Keywords

Relational Model Database Management Database Management System Statistical Database Multidimensional Array 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [Ande 72]
    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. [Ande 77]
    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. [Asht 88]
    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. [Bels 80]
    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. [Bish 83]
    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. [Brod 77]
    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. [Brow 83]
    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. [Celk 87]
    Celko, J., ANSI X3H2 87-23, "Domains in SQL2", September 1987.Google Scholar
  9. [Chan 83]
    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 70]
    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 79]
    Codd, E.F., "Extending the database relational model to capture more meaning", ACM Trans. on Database Systems, 4, 4 (1979).Google Scholar
  12. [COMP 80]
    Barritt, M.M. and D. Wishart, COMPSTAT 80: Proceedings in Computational Statistics, Vienna: Physica-Verlag, 1980.Google Scholar
  13. [Coom 67]
    Coombs, C.H., A Theory of Data, New York: Wiley, 1967.Google Scholar
  14. [Couc 69]
    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 87]
    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. [Denn 83]
    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. [DeGW 80]
    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. [DeNS 83]
    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. [Dixo 64]
    Dixon, W.J., ed., BMD: Biomedical Computer Programs, Los Angeles: Health Sciences Computing Facility, University of California, Los Angeles, 1964.Google Scholar
  20. [Fran 76]
    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. [Fran 81]
    Francis, I., ed., Statistical Software, A Comparative Review, New York: Elsevier North-Holland, 1981.Google Scholar
  22. [Gold 70]
    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. [Hirs 87]
    Hirsch, A.R., "Array Processing in SQL2", ANSI X3H2-87-294, October 26, 1987.Google Scholar
  24. [Hirs 88]
    Hirsch, A.R., Personal communication.Google Scholar
  25. [Info 81]
    Information Builders, Inc., "Sample MULTR Terminal Session", FOCUS Users Manual, pp. 8–18–8–20.Google Scholar
  26. [IN22 87]
    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 87]
    ISO 9075-1987, Database Language—SQL, 1987 and ANSI X3.135-1986, ANSI Database Language—SQL, 1986.Google Scholar
  28. [Klen 81]
    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. [Klen 81a]
    Klensin, J.C., and R. Dawson, The Consistent System, Program Summaries, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1981.Google Scholar
  30. [Klen 83]
    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. [LAP 75]
    The Consistent System, Janus Reference Manual, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1975.Google Scholar
  32. [Lotu 88]
    Mace, S. and E. Warner, "Lotus Choses Gupta Database Engine", Info World, 10, 7 (February 15, 1988), p. 1.Google Scholar
  33. [Malm 86]
    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. [Mart 86]
    Martin, D. Advanced Database Techniques, Cambridge, MA: The MIT Press, 1986.Google Scholar
  35. [McIn 70]
    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. [Melt 87]
    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. [Melt 88]
    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. [Merr 83]
    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. [Mill 71]
    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. [Most 68]
    Mosteller, F., "Association and Estimation in Contingency Tables", Journal of the American Statistical Association, 63 (1968), pg. 1977.Google Scholar
  41. [Mull 83]
    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. [Mull 83a]
    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 75]
    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. [Olke 86]
    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. [Orac 86]
    Oracle Corporation, SQL *Plus Reference Guide and SQL *Plus User's Guide, Belmont, CA: Oracle, 1986.Google Scholar
  46. [Ozso 83]
    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. [Part 82]
    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. [Pell 80]
    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 86]
    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. [Rian 86]
    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 78]
    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. [Sonq 77]
    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. [SRCM 79]
    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. [Stam 73]
    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. [Stev 46]
    Stevens, S.S., "On the Theory of Scales of Measurement", Science, 103 (1946), pp. 677–680.Google Scholar
  56. [Stew 88]
    Stewart, K. editorial, Journal of Food Composition and Analysis, Vol. 1, No. 2, (March 1988), p. 103.Google Scholar
  57. [Ston 66]
    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. [SuNa 83]
    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. [Teit 82]
    Teitel, R., "User Interface with a Relational Model of Data", ACM SIGSOC Bulletin, 13, 2–3 (January 1982).Google Scholar
  60. [Tuke 65]
    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. [Tuke 77]
    Tukey, J.W., Exploratory Data Analysis, Reading, MA, USA: Addison-Wesley, 1977. See Preface, esp. p. vi.Google Scholar
  62. [Ynte 70]
    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

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • John C. Klensin
    • 1
  • Roselyn M. Romberg
    • 1
  1. 1.Massachusetts Institute of TechnologyCambridgeUSA

Personalised recommendations