Specifying queries as relational expressions

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

Specifying queries as relational expressions: the SQUARE data sublanguage

Full text

Pdf (727 KB)

Source

Communications of the ACM archive
Volume 18 , Issue 11 (November 1975) table of contents

Pages: 621 - 628

Year of Publication: 1975

ISSN:0001-0782

Authors

Raymond F. Boyce	IBM Research Lab., San Jose, CA
Donald D. Chamberlin	IBM Research Lab., San Jose, CA
W. Frank King, III	IBM Research Lab., San Jose, CA
Michael M. Hammer	Massachusetts Institute of Technology, Cambridge, MA

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 5, Downloads (12 Months): 47, Citation Count: 24

Additional Information:

abstract references cited by index terms collaborative colleagues

Tools and Actions:	Request Permissions Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/361219.361221 What is a DOI?

ABSTRACT

This paper presents a data sublanguage called SQUARE, intended for use in ad hoc, interactive problem solving by non-computer specialists. SQUARE is based on the relational model of data, and is shown to be relationally complete; however, it avoids the quantifiers and bound variables required by languages based on the relational calculus. Facilities for query, insertion, deletion, and update on tabular data bases are described. A syntax is given, and suggestions are made for alternative syntaxes, including a syntax based on English key words for users with limited mathematical background.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	R. F. Boyce , D. D. Chamberlin , M. M. Hammer , W. F. King, Specifying queries as relational expressions, Proceedings of the 1973 meeting on Programming languages and information retrieval, p.31-47, November 04-06, 1973, Gaithersburg, Maryland
	2	Boyce, R.F., and Chamberlin, D.D. Using a structured English query language as a data definition facility. Res. Report RJ 1318, IBM Res. Lab., San Jose, Calif., Dec. 1973.
	3	Bracchi, G., Fedeli, A., and Paolini, P. A language for a relational data base management system. Proc. Sixth Annual Princeton Conf. Inf. Science and Systems, March 1972, pp. 84-92.
	4	Donald D. Chamberlin , Raymond F. Boyce, SEQUEL: A structured English query language, Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control, p.249-264, May 01-03, 1974, Ann Arbor, Michigan [doi>10.1145/800296.811515]
	5	Childs, D.L. Description of a set-theoretic data structure. Proc. 1968 AFIPS Fall Joint Comp. Conf., pp. 557-564.
	6	Robert Bosak , Richard F. Clippinger , Carey Dobbs , Roy Goldfinger , Renee B. Jasper , William Keating , George Kendrick , Jean E. Sammet, An information algebra: phase 1 report—language structure group of the CODASYL development committee, Communications of the ACM, v.5 n.4, p.190-204, April 1962 [doi>10.1145/366920.366935]
	7	E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, v.13 n.6, p.377-387, June 1970 [doi>10.1145/362384.362685]
	8	Codd, E.F. Relational completeness of data base sublanguages. Courant Computer Science Symposia, Vol. 6: Data Base Systems. Prentice-Hall, New York, 1971.
	9	Codd, E.F. A data base sublanguage founded on the relational calculus. Proc. 1971 ACM SIGF1DET Workshop, San Diego, Calif., pp 35-68.
	10	Codd, E.F. Normalized data base structure: a brief tutorial. Proc. 1971 ACM SIGFIDET Workshop, San Diego, Calif., pp. 1-18.
	11	Fehder, P.L. The representation-independent language. Res. Rep. RJ 1121, IBM Research Laboratory, San Jose, Calif., Nov. 1972.
	12	Goldstein, R.C., and Strnad, A.L. The MACA1MS data management system. Proc. 1970 ACM SIGFIDET Workshop, Houston, Texas, pp. 201-230.
	13	Kuhns, J.L. Logical aspects of question-answering by computer. In Software Engineering: COINS 2, J. Tou (Ed.), Academic Press, New York, 1971, pp. 89-104.
	14	J. L. Kuhns, Quantification in query systems, Proceedings of the 1971 international ACM SIGIR conference on Information storage and retrieval, April 01-02, 1971, College Park, Maryland [doi>10.1145/511285.511295]
	15	R. E. Levien , M. E. Maron, A computer system for inference execution and data retrieval, Communications of the ACM, v.10 n.11, p.715-721, Nov. 1967 [doi>10.1145/363790.363817]
	16	Notley, M.G. The Peterlee IS/1 System. Tech. Rep. UKSC-0018, IBM Scientific Centre, Peterlee, U.K., March 1972.
	17	Whitehead, A.N., and Russell, B. Principia Mathematica. Cambridge University Press, 1950.
	18	Whitney, V.K. A relational data management system. In information Systems: COINS IV J. Tou (Ed.), Plenum Press, New York, 1974, pp. 55-66.
	19	Held, G.D., Stonebraker, M.R., and Wong, E. INGRES--a relational data base system. Proc. 1975 AFIPS Nat. Computer Conf., pp. 409-416.
	20	M. M. Astrahan , D. D. Chamberlin, Implementation of a structured English query language, Communications of the ACM, v.18 n.10, p.580-588, Oct. 1975 [doi>10.1145/361020.361215]

CITED BY 24

	E. A. Ozkarahan , S. A. Schuster , K. C. Sevcik, Performance evaluation of a relational associative processor, ACM Transactions on Database Systems (TODS), v.2 n.2, p.175-195, June 1977
	Donald D. Chamberlin , Morton M. Astrahan , Michael W. Blasgen , James N. Gray , W. Frank King , Bruce G. Lindsay , Raymond Lorie , James W. Mehl , Thomas G. Price , Franco Putzolu , Patricia Griffiths Selinger , Mario Schkolnick , Donald R. Slutz , Irving L. Traiger , Bradford W. Wade , Robert A. Yost, A history and evaluation of System R, Communications of the ACM, v.24 n.10, p.632-646, Oct. 1981
	Claude Deheneffe , Henri Hennebert, NUL: a Navigational User's Language for a network structured data base, Proceedings of the 1976 ACM SIGMOD international conference on Management of data, June 02-04, 1976, Washington, D.C.
	Tamer M. Ozso , Esen A. Ozkarahan, SYNGLISH - a high level query language for the RAP database machine, ACM SIGIR Forum, v.15 n.2, p.139-150, March 1980
	Michael D. Williams , Frederich N. Tou, RABBIT: An interface for database access, Proceedings of the ACM '82 conference, p.83-87, January 1982
	L. Kerschberg , E. A. Ozkarahan , J. E.S. Pacheco, A Synthetic English query language for a relational associative processor, Proceedings of the 2nd international conference on Software engineering, p.505-519, October 13-15, 1976, San Francisco, California, United States
	Joachim W. Schmidt, Some high level language constructs for data of type relation, ACM Transactions on Database Systems (TODS), v.2 n.3, p.247-261, Sept. 1977
	Phyllis Reisner, Human Factors Studies of Database Query Languages: A Survey and Assessment, ACM Computing Surveys (CSUR), v.13 n.1, p.13-31, March 1981
	Martha A. Centeno , Charles R. Standridge, Databases and artificial intelligence: enabling technologies for simulation modeling, Proceedings of the 24th conference on Winter simulation, p.181-189, December 13-16, 1992, Arlington, Virginia, United States
	I. Ganapathy , R. F. Hobson, GPMS, a general purpose memory management system—user's memory—that is., Proceedings of the eighth international conference on APL, p.155-165, September 22-24, 1976, Ottawa, Canada
	Charles Welty , David W. Stemple, Human factors comparison of a procedural and a nonprocedural query language, ACM Transactions on Database Systems (TODS), v.6 n.4, p.626-649, Dec. 1981
	Antonio L. Furtado , Larry Kerschberg, An algebra of quotient relations, Proceedings of the 1977 ACM SIGMOD international conference on Management of data, August 03-05, 1977, Toronto, Ontario, Canada
	Hai Zhuge, Resource space model, its design method and applications, Journal of Systems and Software, v.72 n.1, p.71-81, June 2004
	Michel Lacroix , Alain Pirotte, ILL: an English structured query language for relational data bases, ACM SIGART Bulletin
	Matthias Jarke , Yannis Vassiliou, A framework for choosing a database query language, ACM Computing Surveys (CSUR), v.17 n.3, p.313-340, Sept. 1985
	H. Rex Hartson , David K. Hsiao, A semantic model for data base protection languages, Proceedings of the second international conference on Systems for Large Data Bases, p.27-42, September 08-10, 1976, Brussels, Belgium, North Holland
	Larry Kerschberg , Anthony C. Klug , Dennis Tsichritzis, A taxonomy of data models, Proceedings of the second international conference on Systems for Large Data Bases, p.43-64, September 08-10, 1976, Brussels, Belgium, North Holland
	Alain Pirotte, Fundamental and secondary issues in the design of non-procedural relational languages, Proceedings of the fifth international conference on Very Large Data Bases, p.239-250, October 03-05, 1979, Rio de Janeiro, Brazil
	Emilio Luque , José J. Ruz , Ana Ripoll , Alfredo Bautista, Database concurrent processor, Proceedings of the fifth international conference on Very Large Data Bases, p.273-279, October 03-05, 1979, Rio de Janeiro, Brazil
	John C. Thomas, Psychological issues in data base management, Proceedings of the third international conference on Very large data bases, p.169-186, October 06-08, 1977, Tokyo, Japan
	Michel Lacroix , Alain Pirotte, Domain-oriented relational languages, Proceedings of the third international conference on Very large data bases, p.370-378, October 06-08, 1977, Tokyo, Japan
	Gaston H. Gonnet , Frank Wm. Tompa, Mind Your Grammar: a New Approach to Modelling Text, Proceedings of the 13th International Conference on Very Large Data Bases, p.339-346, September 01-04, 1987
	Levent Ormancioglu, An information base for procedure independent design of information systems, Proceedings of the May 19-22, 1980, national computer conference, May 19-22, 1980, Anaheim, California
	Phyllis Reisner , Raymond F. Boyce , Donald D. Chamberlin, Human factors evaluation of two data base query languages: square and sequel, Proceedings of the May 19-22, 1975, national computer conference and exposition, May 19-22, 1975, Anaheim, California