PulseExploreJournal ClubDebatesTrendingResearchersJournals
Instagram
HomeExploreJournal ClubTrending
Synapse
⌘+K
Synapse
December 1, 1981ACM Transactions on Database Systems158 citationsOpen Access

Human factors comparison of a procedural and a nonprocedural query language

CWCharles WeltyDSDavid Stemple

Key Points

  • This research aims to compare the effectiveness of two query languages, SQL and TABLET, in writing complex queries based on their procedurality.
  • Conducted two experiments testing subjects' ability to write queries in SQL and TABLET.
  • Subjects learned both languages from the same manuals with identical examples and problem ordering.
  • Compared the performance of participants based on the procedurality of each language.
  • Participants using the procedural language TABLET outperformed those using the nonprocedural SQL in writing complex queries.
  • The findings highlight significant differences in query writing capabilities between the two languages.

Abstract

Two experiments testing the ability of subjects to write queries in two different query languages were run. The two languages, SQL and TABLET, differ primarily in their procedurality; both languages use the relational data model, and their Halstead levels are similar. Constructs in the languages which do not affect their procedurality are identical. The two languages were learned by the experimental subjects almost exclusively from manuals presenting the same examples and problems ordered identically for both languages. The results of the experiments show that subjects using the more procedural language wrote difficult queries better than subjects using the less procedural language. The results of the experiments are also used to compare corresponding constructs in the two languages and to recommend improvements for these constructs.

Ask AI
Helpful
Bookmark
Share
View Full Paper

Cite This Study

Welty et al. (1981) studied this question.

synapsesocial.com/papers/6a1106eccd70b138bf1a09a5https://doi.org/10.1145/319628.319656
Ask AI
Helpful
Bookmark
Share
View Full Paper