{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,1,5]],"date-time":"2025-01-05T19:40:29Z","timestamp":1736106029988,"version":"3.32.0"},"publisher-location":"Berlin\/Heidelberg","reference-count":62,"publisher":"Springer-Verlag","isbn-type":[{"type":"print","value":"354050575X"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"DOI":"10.1007\/bfb0027503","type":"book-chapter","created":{"date-parts":[[2005,11,19]],"date-time":"2005-11-19T09:50:20Z","timestamp":1132393820000},"page":"19-38","source":"Crossref","is-referenced-by-count":1,"title":["Statistical data management requirements and the SQL standards\u2014an evolving comparison"],"prefix":"10.1007","author":[{"given":"John C.","family":"Klensin","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Roselyn M.","family":"Romberg","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","reference":[{"key":"2_CR1","doi-asserted-by":"crossref","first-page":"81","DOI":"10.1007\/BF02395358","volume":"7","author":"R.E. Anderson","year":"1972","unstructured":"Anderson, R.E. and E. Coover, \"Wrapping the package\u2014critical thoughts on applications software for social data analysis\", Computers and the Humanities, 7 (1972), pp. 81\u201395.","journal-title":"Computers and the Humanities"},{"issue":"2","key":"2_CR2","doi-asserted-by":"crossref","first-page":"367","DOI":"10.1177\/000276427702000305","volume":"20","author":"R.E. Anderson","year":"1977","unstructured":"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\u2013409.","journal-title":"American Behavioral Scientist"},{"issue":"3","key":"2_CR3","first-page":"1","volume":"10","author":"S. Mace","year":"1988","unstructured":"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.","journal-title":"Info World"},{"key":"2_CR4","doi-asserted-by":"crossref","DOI":"10.1002\/0471725153","volume-title":"Regression Diagnostics: Identifying Influential Data and Sources of Collinearity","author":"D.A. Belsley","year":"1980","unstructured":"Belsley, D.A., E. Kuh, and R.E. Welsch, Regression Diagnostics: Identifying Influential Data and Sources of Collinearity, New York: John Wiley & Sons, 1980."},{"key":"2_CR5","unstructured":"Bishop, Y.M., and S.R. Freedman, \"Classification of Metadata\", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 230\u2013234."},{"key":"2_CR6","volume-title":"TSP in the Datatran Language","author":"J. Brode","year":"1977","unstructured":"Brode, J., P. Werbos, and E. Dunn, TSP in the Datatran Language, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1977."},{"key":"2_CR7","unstructured":"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\u2013195."},{"key":"2_CR8","unstructured":"Celko, J., ANSI X3H2 87-23, \"Domains in SQL2\", September 1987."},{"key":"2_CR9","unstructured":"Chan, P. et al., \"Statistical Data Management Research at Lawrence Berkeley Laboratory\", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 273\u2013279."},{"issue":"6","key":"2_CR10","doi-asserted-by":"crossref","first-page":"377","DOI":"10.1145\/362384.362685","volume":"13","author":"E.F. Codd","year":"1970","unstructured":"Codd, E.F., \"A Relational Model of Data for Large Shared Data Banks\", Communications of the ACM, 13, 6 (June 1970), pp. 377\u2013387. See esp. pp. 380\u2013381.","journal-title":"Communications of the ACM"},{"key":"2_CR11","first-page":"4","volume":"4","author":"E.F. Codd","year":"1979","unstructured":"Codd, E.F., \"Extending the database relational model to capture more meaning\", ACM Trans. on Database Systems, 4, 4 (1979).","journal-title":"ACM Trans. on Database Systems"},{"key":"2_CR12","volume-title":"COMPSTAT 80: Proceedings in Computational Statistics","author":"M.M. Barritt","year":"1980","unstructured":"Barritt, M.M. and D. Wishart, COMPSTAT 80: Proceedings in Computational Statistics, Vienna: Physica-Verlag, 1980."},{"key":"2_CR13","volume-title":"A Theory of Data","author":"C.H. Coombs","year":"1967","unstructured":"Coombs, C.H., A Theory of Data, New York: Wiley, 1967."},{"key":"2_CR14","volume-title":"DATA-TEXT System: A computer language for social science research","author":"A.S. Couch","year":"1969","unstructured":"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."},{"key":"2_CR15","volume-title":"A Guide to the SQL Standard: A user's guide to the standard relational language SQL","author":"C.J. Date","year":"1987","unstructured":"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\"."},{"key":"2_CR16","unstructured":"Denning, D., \"A Security Model for the Statistical Database Problem\", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 368\u2013390."},{"key":"2_CR17","series-title":"Technical Report","volume-title":"An Adaptive Nonlinear Least-Squares Algorithm","author":"J.E. Dennis","year":"1980","unstructured":"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."},{"key":"2_CR18","unstructured":"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\u201353."},{"volume-title":"BMD: Biomedical Computer Programs","year":"1964","key":"2_CR19","unstructured":"Dixon, W.J., ed., BMD: Biomedical Computer Programs, Los Angeles: Health Sciences Computing Facility, University of California, Los Angeles, 1964."},{"key":"2_CR20","unstructured":"Francis, I. and J. Sedransk, \"Software Requirements for the Analysis of Surveys\", Proceedings of the International Biometric Conference, 1976, pp. 228\u2013253."},{"volume-title":"Statistical Software, A Comparative Review","year":"1981","key":"2_CR21","unstructured":"Francis, I., ed., Statistical Software, A Comparative Review, New York: Elsevier North-Holland, 1981."},{"key":"2_CR22","volume-title":"Proc. 1970 ACM SIGFIDET Workshop on Data Description and Access","author":"R.C. Goldstein","year":"1970","unstructured":"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."},{"key":"2_CR23","unstructured":"Hirsch, A.R., \"Array Processing in SQL2\", ANSI X3H2-87-294, October 26, 1987."},{"key":"2_CR24","unstructured":"Hirsch, A.R., Personal communication."},{"key":"2_CR25","unstructured":"Information Builders, Inc., \"Sample MULTR Terminal Session\", FOCUS Users Manual, pp. 8\u201318\u20138\u201320."},{"key":"2_CR26","series-title":"INFOODS Working Paper INFOODS\/IS","volume-title":"Representation of trace, missing, and zero values in food data interchange","author":"J.C. Klensin","year":"1987","unstructured":"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."},{"key":"2_CR27","unstructured":"ISO 9075-1987, Database Language\u2014SQL, 1987 and ANSI X3.135-1986, ANSI Database Language\u2014SQL, 1986."},{"issue":"4\/5","key":"2_CR28","doi-asserted-by":"crossref","first-page":"787","DOI":"10.1177\/053901848102000407","volume":"20","author":"J.C. Klensin","year":"1981","unstructured":"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\u2013815.","journal-title":"Social Science Information"},{"key":"2_CR29","volume-title":"The Consistent System, Program Summaries","author":"J.C. Klensin","year":"1981","unstructured":"Klensin, J.C., and R. Dawson, The Consistent System, Program Summaries, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1981."},{"key":"2_CR30","unstructured":"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\u2013286."},{"key":"2_CR31","unstructured":"The Consistent System, Janus Reference Manual, Cambridge, MA, USA: MIT Laboratory of Architecture and Planning, 1975."},{"issue":"7","key":"2_CR32","first-page":"1","volume":"10","author":"S. Mace","year":"1988","unstructured":"Mace, S. and E. Warner, \"Lotus Choses Gupta Database Engine\", Info World, 10, 7 (February 15, 1988), p. 1.","journal-title":"Info World"},{"key":"2_CR33","unstructured":"Malmborg, E., \"On the Semantics of Aggregated Data\", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 152\u2013158."},{"key":"2_CR34","volume-title":"Advanced Database Techniques","author":"D. Martin","year":"1986","unstructured":"Martin, D. Advanced Database Techniques, Cambridge, MA: The MIT Press, 1986."},{"key":"2_CR35","volume-title":"ADMINS Mark III\u2014The User's Manual","author":"S.D. McIntosh","year":"1970","unstructured":"McIntosh, S.D. and D.M. Griffel, \"ADMINS Mark III\u2014The User's Manual\", Cambridge, MA, USA: MIT Center for International Studies, March 1970."},{"key":"2_CR36","unstructured":"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."},{"key":"2_CR37","unstructured":"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."},{"key":"2_CR38","unstructured":"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\u2013103."},{"key":"2_CR39","unstructured":"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."},{"key":"2_CR40","doi-asserted-by":"crossref","first-page":"1977","DOI":"10.1080\/01621459.1968.11009219","volume":"63","author":"F. Mosteller","year":"1968","unstructured":"Mosteller, F., \"Association and Estimation in Contingency Tables\", Journal of the American Statistical Association, 63 (1968), pg. 1977.","journal-title":"Journal of the American Statistical Association"},{"key":"2_CR41","unstructured":"Muller, R.J., \"Using Statistical Software with a Database Management Data Theory\", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 414\u2013423."},{"key":"2_CR42","unstructured":"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."},{"key":"2_CR43","volume-title":"SPSS Statistical Package for the Social Sciences","author":"N.H. Nie","year":"1975","unstructured":"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."},{"key":"2_CR44","unstructured":"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\u201320."},{"key":"2_CR45","volume-title":"SQL *Plus Reference Guide and SQL *Plus User's Guide","author":"O. Corporation","year":"1986","unstructured":"Oracle Corporation, SQL *Plus Reference Guide and SQL *Plus User's Guide, Belmont, CA: Oracle, 1986."},{"key":"2_CR46","unstructured":"Ozsoyoglu, G. and Z.M. Ozsoyoglu, \"Features of a System for Statistical Databases\", Proc., 2nd Int. Workshop on Statistical Database Management, 1983, pp. 9\u201318."},{"issue":"4","key":"2_CR47","doi-asserted-by":"crossref","first-page":"581","DOI":"10.1177\/009365082009004005","volume":"9","author":"R.E. Parta","year":"1982","unstructured":"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\u2013606.","journal-title":"Communications Research"},{"key":"2_CR48","unstructured":"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\u201360."},{"key":"2_CR49","unstructured":"Read, B.J., \"Scientific Data Manipulation in a Relational Database System\", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 31\u201335."},{"key":"2_CR50","unstructured":"Riano, C., \"Using Logic to Organize Statistical Databases\", Proc., 3rd Int. Workshop on Statistical and Scientific Database Management, 1986, pp. 159\u2013164."},{"key":"2_CR51","volume-title":"Theory Construction and Data Analysis in the Behavioral Sciences","author":"S. Shye","year":"1978","unstructured":"Shye, S., \"Partial Order Scalogram Analysis\", in Shey, S., ed., Theory Construction and Data Analysis in the Behavioral Sciences, San Francisco: Jossey-Bass, 1978."},{"key":"2_CR52","volume-title":"Survey and Opinion Research: Procedures for Processing and Analysis","author":"J.A. Sonquist","year":"1977","unstructured":"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\u201340."},{"key":"2_CR53","unstructured":"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."},{"key":"2_CR54","volume-title":"Proceedings of the 1973 Annual Conference of the ACM","author":"J.P. Stamen","year":"1973","unstructured":"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."},{"key":"2_CR55","doi-asserted-by":"crossref","first-page":"677","DOI":"10.1126\/science.103.2684.677","volume":"103","author":"S.S. Stevens","year":"1946","unstructured":"Stevens, S.S., \"On the Theory of Scales of Measurement\", Science, 103 (1946), pp. 677\u2013680.","journal-title":"Science"},{"key":"2_CR56","doi-asserted-by":"crossref","unstructured":"Stewart, K. editorial, Journal of Food Composition and Analysis, Vol. 1, No. 2, (March 1988), p. 103.","DOI":"10.1016\/0889-1575(88)90013-0"},{"key":"2_CR57","volume-title":"The General Inquirer: A computer approach to content analysis","author":"P.S. Stone","year":"1966","unstructured":"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."},{"key":"2_CR58","unstructured":"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."},{"key":"2_CR59","doi-asserted-by":"crossref","first-page":"2","DOI":"10.1145\/1015579.810961","volume":"13","author":"R. Teitel","year":"1982","unstructured":"Teitel, R., \"User Interface with a Relational Model of Data\", ACM SIGSOC Bulletin, 13, 2\u20133 (January 1982).","journal-title":"ACM SIGSOC Bulletin"},{"key":"2_CR60","volume-title":"Proceedings of the Symposium on Information Processing in Sight Sensory Systems","author":"J.W. Tukey","year":"1965","unstructured":"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\u20133 November 1965."},{"key":"2_CR61","volume-title":"Exploratory Data Analysis","author":"J.W. Tukey","year":"1977","unstructured":"Tukey, J.W., Exploratory Data Analysis, Reading, MA, USA: Addison-Wesley, 1977. See Preface, esp. p. vi."},{"key":"2_CR62","unstructured":"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."}],"container-title":["Lecture Notes in Computer Science","Statistical and Scientific Database Management"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/BFb0027503.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,1,5]],"date-time":"2025-01-05T19:09:27Z","timestamp":1736104167000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/BFb0027503"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[null]]},"ISBN":["354050575X"],"references-count":62,"URL":"https:\/\/doi.org\/10.1007\/bfb0027503","relation":{},"subject":[]}}