Document (#12203)

Author

Smelcer, J.B.

Title

User errors in database query composition

Source

International journal of human-computer studies. 42(1995) no.4, S.353-381

Year

1995

Abstract

Reports on the experimental test of several causes of user errors while composing database queries. The query language under consideration is SQL. A query writing model was developed that integrated a GOMS type analysis of query writing with the characterisitcs of human cognition. This model revealed multiple cognitive causes of a frequent and troublesome error, join clause omission. This semantic user error returns answers from the database that may undetectably wrong, affecting users, decision makers, and programmers. The model predicted 4 possible causes of join clause omission, and empirical testing revealed that all 4 contributed to the error. Gives reasons why the frequency of this error increased. These results are significant for understanding user errors in general and for the developing new interfaces and training schemes for the task of writing database queries

Similar documents (content)

1. Doran, C.; Martin, C.: Measuring success in outsourced cataloging : a data-driven investigation (2017) 0.21

   0.20670418 = sum of:
     0.20670418 = product of:
       0.86126745 = sum of:
         0.010793402 = weight(abstract_txt:that in 150) [ClassicSimilarity], result of:
           0.010793402 = score(doc=150,freq=2.0), product of:
             0.034423325 = queryWeight, product of:
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.014555717 = queryNorm
             0.31354907 = fieldWeight in 150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.09375 = fieldNorm(doc=150)
         0.011368801 = weight(abstract_txt:this in 150) [ClassicSimilarity], result of:
           0.011368801 = score(doc=150,freq=2.0), product of:
             0.035636116 = queryWeight, product of:
               1.0174633 = boost
               2.4062347 = idf(docFreq=10885, maxDocs=44421)
               0.014555717 = queryNorm
             0.31902468 = fieldWeight in 150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.4062347 = idf(docFreq=10885, maxDocs=44421)
               0.09375 = fieldNorm(doc=150)
         0.060382124 = weight(abstract_txt:database in 150) [ClassicSimilarity], result of:
           0.060382124 = score(doc=150,freq=1.0), product of:
             0.15043277 = queryWeight, product of:
               2.4138715 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.014555717 = queryNorm
             0.40138945 = fieldWeight in 150, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.09375 = fieldNorm(doc=150)
         0.22911927 = weight(abstract_txt:errors in 150) [ClassicSimilarity], result of:
           0.22911927 = score(doc=150,freq=2.0), product of:
             0.2639095 = queryWeight, product of:
               2.7688606 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.014555717 = queryNorm
             0.86817366 = fieldWeight in 150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.09375 = fieldNorm(doc=150)
         0.19877508 = weight(abstract_txt:causes in 150) [ClassicSimilarity], result of:
           0.19877508 = score(doc=150,freq=1.0), product of:
             0.3024581 = queryWeight, product of:
               2.964191 = boost
               7.01012 = idf(docFreq=108, maxDocs=44421)
               0.014555717 = queryNorm
             0.6571987 = fieldWeight in 150, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.01012 = idf(docFreq=108, maxDocs=44421)
               0.09375 = fieldNorm(doc=150)
         0.35082874 = weight(abstract_txt:error in 150) [ClassicSimilarity], result of:
           0.35082874 = score(doc=150,freq=2.0), product of:
             0.38588414 = queryWeight, product of:
               3.866085 = boost
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.014555717 = queryNorm
             0.9091556 = fieldWeight in 150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.09375 = fieldNorm(doc=150)
       0.24 = coord(6/25)
   

2. Schaefer, A.; Jordan, M.; Klas, C.-P.; Fuhr, N.: Active support for query formulation in virtual digital libraries : a case study with DAFFODIL (2005) 0.20

   0.20110986 = sum of:
     0.20110986 = product of:
       0.62846833 = sum of:
         0.008994502 = weight(abstract_txt:that in 296) [ClassicSimilarity], result of:
           0.008994502 = score(doc=296,freq=2.0), product of:
             0.034423325 = queryWeight, product of:
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.014555717 = queryNorm
             0.2612909 = fieldWeight in 296, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.0116032325 = weight(abstract_txt:this in 296) [ClassicSimilarity], result of:
           0.0116032325 = score(doc=296,freq=3.0), product of:
             0.035636116 = queryWeight, product of:
               1.0174633 = boost
               2.4062347 = idf(docFreq=10885, maxDocs=44421)
               0.014555717 = queryNorm
             0.3256032 = fieldWeight in 296, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               2.4062347 = idf(docFreq=10885, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.04256294 = weight(abstract_txt:queries in 296) [ClassicSimilarity], result of:
           0.04256294 = score(doc=296,freq=1.0), product of:
             0.10679119 = queryWeight, product of:
               1.4381218 = boost
               5.1015973 = idf(docFreq=734, maxDocs=44421)
               0.014555717 = queryNorm
             0.39856228 = fieldWeight in 296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1015973 = idf(docFreq=734, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.03037834 = weight(abstract_txt:model in 296) [ClassicSimilarity], result of:
           0.03037834 = score(doc=296,freq=1.0), product of:
             0.09763094 = queryWeight, product of:
               1.6840978 = boost
               3.9827821 = idf(docFreq=2249, maxDocs=44421)
               0.014555717 = queryNorm
             0.31115484 = fieldWeight in 296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9827821 = idf(docFreq=2249, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.055380207 = weight(abstract_txt:user in 296) [ClassicSimilarity], result of:
           0.055380207 = score(doc=296,freq=3.0), product of:
             0.11118691 = queryWeight, product of:
               2.0752468 = boost
               3.6808684 = idf(docFreq=3042, maxDocs=44421)
               0.014555717 = queryNorm
             0.4980821 = fieldWeight in 296, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               3.6808684 = idf(docFreq=3042, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.13781148 = weight(abstract_txt:query in 296) [ClassicSimilarity], result of:
           0.13781148 = score(doc=296,freq=4.0), product of:
             0.18550742 = queryWeight, product of:
               2.680548 = boost
               4.754492 = idf(docFreq=1039, maxDocs=44421)
               0.014555717 = queryNorm
             0.74288934 = fieldWeight in 296, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.754492 = idf(docFreq=1039, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.13500983 = weight(abstract_txt:errors in 296) [ClassicSimilarity], result of:
           0.13500983 = score(doc=296,freq=1.0), product of:
             0.2639095 = queryWeight, product of:
               2.7688606 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.014555717 = queryNorm
             0.51157624 = fieldWeight in 296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
         0.2067278 = weight(abstract_txt:error in 296) [ClassicSimilarity], result of:
           0.2067278 = score(doc=296,freq=1.0), product of:
             0.38588414 = queryWeight, product of:
               3.866085 = boost
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.014555717 = queryNorm
             0.53572506 = fieldWeight in 296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.078125 = fieldNorm(doc=296)
       0.32 = coord(8/25)
   

3. Chan, H.C.; Wei, K.K.; Siau, K.L.: ¬A system for query comprehension (1997) 0.20

   0.19514401 = sum of:
     0.19514401 = product of:
       0.6969429 = sum of:
         0.0076320875 = weight(abstract_txt:that in 1422) [ClassicSimilarity], result of:
           0.0076320875 = score(doc=1422,freq=1.0), product of:
             0.034423325 = queryWeight, product of:
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.014555717 = queryNorm
             0.22171268 = fieldWeight in 1422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.0722317 = weight(abstract_txt:queries in 1422) [ClassicSimilarity], result of:
           0.0722317 = score(doc=1422,freq=2.0), product of:
             0.10679119 = queryWeight, product of:
               1.4381218 = boost
               5.1015973 = idf(docFreq=734, maxDocs=44421)
               0.014555717 = queryNorm
             0.6763826 = fieldWeight in 1422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               5.1015973 = idf(docFreq=734, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.036454007 = weight(abstract_txt:model in 1422) [ClassicSimilarity], result of:
           0.036454007 = score(doc=1422,freq=1.0), product of:
             0.09763094 = queryWeight, product of:
               1.6840978 = boost
               3.9827821 = idf(docFreq=2249, maxDocs=44421)
               0.014555717 = queryNorm
             0.37338582 = fieldWeight in 1422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9827821 = idf(docFreq=2249, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.0542613 = weight(abstract_txt:user in 1422) [ClassicSimilarity], result of:
           0.0542613 = score(doc=1422,freq=2.0), product of:
             0.11118691 = queryWeight, product of:
               2.0752468 = boost
               3.6808684 = idf(docFreq=3042, maxDocs=44421)
               0.014555717 = queryNorm
             0.4880188 = fieldWeight in 1422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.6808684 = idf(docFreq=3042, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.14321789 = weight(abstract_txt:query in 1422) [ClassicSimilarity], result of:
           0.14321789 = score(doc=1422,freq=3.0), product of:
             0.18550742 = queryWeight, product of:
               2.680548 = boost
               4.754492 = idf(docFreq=1039, maxDocs=44421)
               0.014555717 = queryNorm
             0.7720333 = fieldWeight in 1422, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.754492 = idf(docFreq=1039, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.15402664 = weight(abstract_txt:writing in 1422) [ClassicSimilarity], result of:
           0.15402664 = score(doc=1422,freq=1.0), product of:
             0.25516504 = queryWeight, product of:
               2.722602 = boost
               6.4387774 = idf(docFreq=192, maxDocs=44421)
               0.014555717 = queryNorm
             0.6036354 = fieldWeight in 1422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.4387774 = idf(docFreq=192, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.22911927 = weight(abstract_txt:errors in 1422) [ClassicSimilarity], result of:
           0.22911927 = score(doc=1422,freq=2.0), product of:
             0.2639095 = queryWeight, product of:
               2.7688606 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.014555717 = queryNorm
             0.86817366 = fieldWeight in 1422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
       0.28 = coord(7/25)
   

4. Batra, D.; Antony, S.R.: Novice errors in conceptual database design (1994) 0.19

   0.1882708 = sum of:
     0.1882708 = product of:
       0.94135404 = sum of:
         0.010793402 = weight(abstract_txt:that in 8237) [ClassicSimilarity], result of:
           0.010793402 = score(doc=8237,freq=2.0), product of:
             0.034423325 = queryWeight, product of:
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.014555717 = queryNorm
             0.31354907 = fieldWeight in 8237, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.12076425 = weight(abstract_txt:database in 8237) [ClassicSimilarity], result of:
           0.12076425 = score(doc=8237,freq=4.0), product of:
             0.15043277 = queryWeight, product of:
               2.4138715 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.014555717 = queryNorm
             0.8027789 = fieldWeight in 8237, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.28061265 = weight(abstract_txt:errors in 8237) [ClassicSimilarity], result of:
           0.28061265 = score(doc=8237,freq=3.0), product of:
             0.2639095 = queryWeight, product of:
               2.7688606 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.014555717 = queryNorm
             1.0632912 = fieldWeight in 8237, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.28111044 = weight(abstract_txt:causes in 8237) [ClassicSimilarity], result of:
           0.28111044 = score(doc=8237,freq=2.0), product of:
             0.3024581 = queryWeight, product of:
               2.964191 = boost
               7.01012 = idf(docFreq=108, maxDocs=44421)
               0.014555717 = queryNorm
             0.9294194 = fieldWeight in 8237, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               7.01012 = idf(docFreq=108, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.24807335 = weight(abstract_txt:error in 8237) [ClassicSimilarity], result of:
           0.24807335 = score(doc=8237,freq=1.0), product of:
             0.38588414 = queryWeight, product of:
               3.866085 = boost
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.014555717 = queryNorm
             0.64287007 = fieldWeight in 8237, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
       0.2 = coord(5/25)
   

5. Drabenstott, K.M.; Weller, M.S.: Handling spelling errors in online catalog searches (1996) 0.16

   0.1633996 = sum of:
     0.1633996 = product of:
       0.58357 = sum of:
         0.0143912025 = weight(abstract_txt:that in 6973) [ClassicSimilarity], result of:
           0.0143912025 = score(doc=6973,freq=8.0), product of:
             0.034423325 = queryWeight, product of:
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.014555717 = queryNorm
             0.41806543 = fieldWeight in 6973, product of:
               2.828427 = tf(freq=8.0), with freq of:
                 8.0 = termFreq=8.0
               2.3649352 = idf(docFreq=11344, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
         0.0053593037 = weight(abstract_txt:this in 6973) [ClassicSimilarity], result of:
           0.0053593037 = score(doc=6973,freq=1.0), product of:
             0.035636116 = queryWeight, product of:
               1.0174633 = boost
               2.4062347 = idf(docFreq=10885, maxDocs=44421)
               0.014555717 = queryNorm
             0.15038967 = fieldWeight in 6973, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4062347 = idf(docFreq=10885, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
         0.076138906 = weight(abstract_txt:queries in 6973) [ClassicSimilarity], result of:
           0.076138906 = score(doc=6973,freq=5.0), product of:
             0.10679119 = queryWeight, product of:
               1.4381218 = boost
               5.1015973 = idf(docFreq=734, maxDocs=44421)
               0.014555717 = queryNorm
             0.7129699 = fieldWeight in 6973, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               5.1015973 = idf(docFreq=734, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
         0.051158044 = weight(abstract_txt:user in 6973) [ClassicSimilarity], result of:
           0.051158044 = score(doc=6973,freq=4.0), product of:
             0.11118691 = queryWeight, product of:
               2.0752468 = boost
               3.6808684 = idf(docFreq=3042, maxDocs=44421)
               0.014555717 = queryNorm
             0.46010855 = fieldWeight in 6973, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.6808684 = idf(docFreq=3042, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
         0.055124592 = weight(abstract_txt:query in 6973) [ClassicSimilarity], result of:
           0.055124592 = score(doc=6973,freq=1.0), product of:
             0.18550742 = queryWeight, product of:
               2.680548 = boost
               4.754492 = idf(docFreq=1039, maxDocs=44421)
               0.014555717 = queryNorm
             0.29715574 = fieldWeight in 6973, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.754492 = idf(docFreq=1039, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
         0.21601571 = weight(abstract_txt:errors in 6973) [ClassicSimilarity], result of:
           0.21601571 = score(doc=6973,freq=4.0), product of:
             0.2639095 = queryWeight, product of:
               2.7688606 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.014555717 = queryNorm
             0.818522 = fieldWeight in 6973, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
         0.16538224 = weight(abstract_txt:error in 6973) [ClassicSimilarity], result of:
           0.16538224 = score(doc=6973,freq=1.0), product of:
             0.38588414 = queryWeight, product of:
               3.866085 = boost
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.014555717 = queryNorm
             0.42858005 = fieldWeight in 6973, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.0625 = fieldNorm(doc=6973)
       0.28 = coord(7/25)