article

Free access

Human Factors Studies of Database Query Languages: A Survey and Assessment

Author:

Phyllis ReisnerAuthors Info & Claims

ACM Computing Surveys (CSUR), Volume 13, Issue 1

Pages 13 - 31

https://doi.org/10.1145/356835.356837

Published: 01 March 1981 Publication History

PDF eReader

References

[1]

ATWOOD, M.E., RAMSEY, H.R., HOOPER, J.N., AND KULLAS, D.A. "Annotated bibliography on human factors in software development," ARI Tech. Rep. P-79-1, U.S. Army Research Institute, Alexandria, Va., June 1979.

Google Scholar

[2]

BOYCE, R.F., CHAMBERLIN, D.D., KING, W.F., AND HAMMER, M.M. "Specifiying as relational expressions: The SQUARE data sublanguage," Commun. ACM 18, 11 (Nov. 1975), 621-628.

Crossref

Google Scholar

[3]

BROADBENT, D.E., AND BROADBENT, M.H.P. "The allocation of descriptor terms by individuals in a simulated retrieval system," Ergonomics 21 (1978), 343-354.

Google Scholar

[4]

BROSEY, M., AND SHNEIDERMAN, B. "Two experimental comparisons of relational and hierarchical database models," Int. J. Man-Mach. Stud. 10 (1978), 625- 637.

Google Scholar

[5]

CARD, S.K., AND MORAN, T.P. "The keystroke level model for user performance time with interactive systems," Commun. ACM 23, 7 (July 1980), 396-410.

Crossref

Google Scholar

[6]

CHAMBERLIN, D.D., ASTRAHAN, M.M., ESWARAN, K.P., GRIFFITHS, P.P., LORIE, R.A., MEHL, J.W., REISNER, P., AND WADE, B.W. "SEQUEL 2: A unified approach to data definition, manipulation, and control," IBM J. Res. Dev. 20 (Nov. 1976), 560-575.

Google Scholar

[7]

CHAMBERLIN, D.D. "Relational database management systems," Comput. Surv. 8, 1 (March 1976), 43-66.

Crossref

Google Scholar

[8]

CHAPANIS, A. Man-machine engineering, Wadsworth, Belmont, Calif., 1965.

Google Scholar

[9]

CHAPASlS, A., AND VAN COTT, H.P. "Human engineering tests and evaluations," in Human engineering guide to equipment design, H. P. Van Cott and R. G. Kinkade, Eds., American Institutes for Research, Washington, D.C., 1972.

Google Scholar

[10]

CHOMSKY, N. Syntactic structures, Mouton, The Hague; 1964.

Google Scholar

[11]

"Codasyl Data Base Task Group report," in Conf. Data System Languages (ACM), New York, 1971.

Google Scholar

[12]

CORD, E.F. "A relational model of data for large shared data bases," Commun. ACM 13, 2 (June 1970), 377-397.

Crossref

Google Scholar

[13]

CODD, E.F. "A data base sublanguage founded on the relational calculus," in Proc. ACM SIGFIDET Workshop on Data Description, Access, and Control, 1971, pp. 35-68.

Google Scholar

[14]

DATE, C.J. An introduction to database systems (2nd ed.), Addison-Wesley, Reading, Mass., 1977.

Crossref

Google Scholar

[15]

DE GREENE, K.B. Systems psychology, McGraw-Hill, New York, 1970.

Google Scholar

[16]

DURDING, B.M., BECKER, C.A., AND GOULD, J.D. "Data organization," Hum. Factors 19 (1977), 1-14.

Google Scholar

[17]

GOULD, J.D., AND ASCHER, R.N. "Use of an IQF-like query language by nonprogrammers," IBM IRes. Rep. RC 5279, IBM Thomas J. Watson Research Center, Yorktown Heights, N.Y., Feb. 1975.

Google Scholar

[18]

GREENBLATT, D., AND WAXMAN, J. "A study Of three database query languages," in Databases: Improving usability and responsiveness, B. Shneiderman, Ed., Academic Press, New York, 1978.

Google Scholar

[19]

"IBM information management system/ virtual storage (IMS/VS), General information manual," GH20-1260.3, IBM Corp., White Plains, N.Y., 1975.

Google Scholar

[20]

KIM, W. "Relational database systems," Comput. Surv. 11, 3 (Sept. 1979), 185-211.

Crossref

Google Scholar

[21]

LEAVENWORTH, B.M., AND SAMMET, J. "An overview of nonprocedural languages," Sigplan Notices 9 (April 1974), 1-12.

Crossref

Google Scholar

[22]

LOCHOVSKY, F.H., AND TSICHRITZIS, D.C. "User performance considerations in DBMS selection," in Proc. ACM SIG- MOD, 1977, pp. 128-134.

Crossref

Google Scholar

[23]

LOCHOVSKY, F.H. "Data base management system user performance," Ph.D dissertation, Univ. Toronto, Canada, 1978.

Crossref

Google Scholar

[24]

MAYER, R.E. "A psychology of learning BASIC," Commun. ACM 22, 11 (Nov. 1979), 589-593.

Crossref

Google Scholar

[25]

MAYER, R.E. "The psychology of learning computer programming by novices," Comput. Surv. 13, 1 (March 1981), 121- 141.

Crossref

Google Scholar

[26]

McCoRMICK, E.J. Human factors engineering (3rd ed.), McGraw-Hill, New York, 1970.

Google Scholar

[27]

MEISTER, D. Heresies: Brief essays on human factors, U.S. Navy Personnel Research and Development Center, San Diego, Calif., March 1977.

Google Scholar

[28]

MILLER, L.A., AND BECKER, C.A. "Programming in natural English," IBM Tech. Rep. RC 5137, Nov. 1974.

Google Scholar

[29]

MORAN, T.P. "The command language grammar," Int. J. Man-Mach. Stud. 14 (in press).

Google Scholar

[30]

MORAN, T.P. "An Applied Psychology of the User," Comput. Surv. 13, 1 (March 1981), 1-11.

Crossref

Google Scholar

[31]

NEWMAN, W.S., AND SPROULL, R.F. Principles of interactive computer graphics, McGraw-Hill: New York, 1979.

Crossref

Google Scholar

[32]

RAMSEY, H.R., ATWOOD, M.E., AND KIRSHBAUM, P.J. A critically annotated bibliography of the literature of human factors of computer systems, Science Applications, Englewood, Colo., May 1978.

Google Scholar

[33]

REISNER, P., BoYCE, R.F., AND CHAM- BERLIN, D.D. "Human factors evaluation of two data base query languages-- Square and Sequel," in Proc. Nat. Computer Conf., AFIPS Press, Arlington, Va., 1975, pp. 447-452.

Google Scholar

[34]

REISNER, P. "Use of psychological experimentation as an aid to development of a query language," IEEE Trans. Soflw. Eng. SE-3 (May 1977), 218-229.

Google Scholar

[35]

ROBERTS, T.L. "Evaluation of computer text editors," Xerox Rep. SSL-79-9, Palo Alto Research Center, Palo Alto, Calif., Nov. 1979.

Google Scholar

[36]

ROSENTHAL, R. Experimenter effects in behavioral research. Appleton-Century- Crofts, New York, 1966.

Google Scholar

[37]

SHNEIDERMAN, B. "Improving the human factors aspect of data base interactions," ACM Trans. Database Syst. 3, 4 (Dec. 1978), 417-439.

Crossref

Google Scholar

[38]

SHNEIDERMAN, B. Software psychology, Winthrop, Cambridge, Mass., 1980.

Google Scholar

[39]

THOMAS, J.C., AND GOULD, J.D. "A psychological study of query by example," in Proc. Nat. Computer Conf., AFIPS Press, Arlington, Va., 1975. pp. 439-445.

Google Scholar

[40]

THOMAS, J.C. "Quantifiers and question-asking," IBM Res. Rep. RC 5866, IBM Thomas J. Watson Research Center, Yorktown Heights, N.Y., Feb. 1976.

Google Scholar

[41]

THOMAS, J.C. "Psychological issues in data base management," in Proc. Third Int. Conf. on Very Large Data Bases, Tokyo, Oct. 1977, pp. 169-185.

Google Scholar

[42]

THOMAS, J.C. "Psychological issues in the design of data-base query languages," in Communication with computers, M. Sime and M. Fitter, Eds., Academic Press, London, to appear.

Google Scholar

[43]

VAN COTT, H.P., AND KINKADE, R.G., EDS. Human engineering guide to equipment design, American Institutes for Research, Washington, D.C., 1972.

Google Scholar

[44]

WEINBERG, G.M., AND SCHULMAN, E.L. "Goals and performance in computer programming," Hum. Factors 16 (Feb. 1974), 70-77.

Google Scholar

[45]

WELTY, C. "A comparison of a procedural and a nonprocedural query language: Syntactic metrics and human factors," Ph.D. dissertation, Univ. Massachusetts, Amherst, May 1979.

Crossref

Google Scholar

[46]

WELTY C., AND STEMPLE, D.W. "Human factors comparison of a procedural and a nonprocedural query language" ACM Trans. Database Syst. (in press).

Crossref

Google Scholar

[47]

WOODSON, W.E., AND CONOVER, D.C. Human engineering guide for equipment designers, University of California Press, Berkeley, 1973.

Google Scholar

[48]

ZLOOF, M.M. "Query by example," in Proc. Nat. Computer Conf., AFIPS Press, Arlington, Va., May 1975, pp. 431-437.

Google Scholar

Cited By

View all

Gatterbauer WDunne C(2024)On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational LanguagesProceedings of the ACM on Management of Data10.1145/36393162:1(1-27)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639316
Gatterbauer W(2024)A Comprehensive Tutorial on Over 100 Years of Diagrammatic Representations of Logical Statements and Relational Queries2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00407(5387-5392)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00407
Li YChen SHwang KJi XLei ZZhu YYe FLiu M(2024)Spatio-temporal data fusion techniques for modeling digital twin CityGeo-spatial Information Science10.1080/10095020.2024.2350175(1-24)Online publication date: 17-May-2024
https://doi.org/10.1080/10095020.2024.2350175
Show More Cited By

Recommendations

Query languages for data exchange: beyond unions of conjunctive queries
ICDT '09: Proceedings of the 12th International Conference on Database Theory

The class of unions of conjunctive queries (UCQ) has been shown to be particularly well-behaved for data exchange; its certain answers can be computed in polynomial time (in terms of data complexity). However, this is not the only class with this ...
Query optimization in distributed database systems
Query processing with database semantics

Comments

Information & Contributors

Information

Published In

ACM Computing Surveys Volume 13, Issue 1

March 1981

138 pages

ISSN:0360-0300

EISSN:1557-7341

DOI:10.1145/356835

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 March 1981

Published in CSUR Volume 13, Issue 1

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

181
Total Citations
View Citations
1,962
Total Downloads

Downloads (Last 12 months)155
Downloads (Last 6 weeks)31

Reflects downloads up to 14 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Gatterbauer WDunne C(2024)On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational LanguagesProceedings of the ACM on Management of Data10.1145/36393162:1(1-27)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639316
Gatterbauer W(2024)A Comprehensive Tutorial on Over 100 Years of Diagrammatic Representations of Logical Statements and Relational Queries2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00407(5387-5392)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00407
Li YChen SHwang KJi XLei ZZhu YYe FLiu M(2024)Spatio-temporal data fusion techniques for modeling digital twin CityGeo-spatial Information Science10.1080/10095020.2024.2350175(1-24)Online publication date: 17-May-2024
https://doi.org/10.1080/10095020.2024.2350175
Gatterbauer W(2023)A Tutorial on Visual Representations of Relational QueriesProceedings of the VLDB Endowment10.14778/3611540.361157816:12(3890-3893)Online publication date: 12-Sep-2023
https://dl.acm.org/doi/10.14778/3611540.3611578
Miedema DLiut MFletcher GAivaloglou E(2023)“There is no ambiguity on what to return”: Investigating the Prevalence of SQL MisconceptionsProceedings of the 23rd Koli Calling International Conference on Computing Education Research10.1145/3631802.3631821(1-12)Online publication date: 13-Nov-2023
https://dl.acm.org/doi/10.1145/3631802.3631821
Terzi IDivitini MAvouris N(2023)Human factors in software development: A study on database systems adoption by developers.Proceedings of the 2nd International Conference of the ACM Greek SIGCHI Chapter10.1145/3609987.3609994(1-6)Online publication date: 27-Sep-2023
https://dl.acm.org/doi/10.1145/3609987.3609994
Taipalus TGrahn H(2023)Framework for SQL Error Message Design: A Data-Driven ApproachACM Transactions on Software Engineering and Methodology10.1145/360718033:1(1-50)Online publication date: 23-Nov-2023
https://dl.acm.org/doi/10.1145/3607180
Miedema D(2023)Toward a Fundamental Understanding of SQL EducationProceedings of the 2023 ACM Conference on International Computing Education Research - Volume 210.1145/3568812.3603454(64-68)Online publication date: 7-Aug-2023
https://dl.acm.org/doi/10.1145/3568812.3603454
Miedema DFletcher GAivaloglou E(2022)Expert Perspectives on Student Errors in SQLACM Transactions on Computing Education10.1145/355139223:1(1-28)Online publication date: 29-Dec-2022
https://dl.acm.org/doi/10.1145/3551392
Mathon LMiedema D(2022)Increasing Awareness of SQL Anti-Patterns for Novices: A Study DesignProceedings of the 2022 ACM Conference on International Computing Education Research - Volume 210.1145/3501709.3544282(42-43)Online publication date: 7-Aug-2022
https://dl.acm.org/doi/10.1145/3501709.3544282
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

References

Cited By

Recommendations

Query languages for data exchange: beyond unions of conjunctive queries

Query optimization in distributed database systems

Query processing with database semantics

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations