Document (#12204)

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.20670739 = sum of:
     0.20670739 = product of:
       0.8612808 = sum of:
         0.010856962 = weight(abstract_txt:that in 5150) [ClassicSimilarity], result of:
           0.010856962 = score(doc=5150,freq=2.0), product of:
             0.034559693 = queryWeight, product of:
               1.0023559 = boost
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.014551098 = queryNorm
             0.314151 = fieldWeight in 5150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.09375 = fieldNorm(doc=5150)
         0.011466564 = weight(abstract_txt:this in 5150) [ClassicSimilarity], result of:
           0.011466564 = score(doc=5150,freq=2.0), product of:
             0.035841532 = queryWeight, product of:
               1.0207757 = boost
               2.4130175 = idf(docFreq=10762, maxDocs=44218)
               0.014551098 = queryNorm
             0.31992394 = fieldWeight in 5150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.4130175 = idf(docFreq=10762, maxDocs=44218)
               0.09375 = fieldNorm(doc=5150)
         0.06032243 = weight(abstract_txt:database in 5150) [ClassicSimilarity], result of:
           0.06032243 = score(doc=5150,freq=1.0), product of:
             0.15033951 = queryWeight, product of:
               2.4140317 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.014551098 = queryNorm
             0.40124136 = fieldWeight in 5150, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.09375 = fieldNorm(doc=5150)
         0.2292741 = weight(abstract_txt:errors in 5150) [ClassicSimilarity], result of:
           0.2292741 = score(doc=5150,freq=2.0), product of:
             0.26403877 = queryWeight, product of:
               2.7705812 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.014551098 = queryNorm
             0.86833495 = fieldWeight in 5150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.09375 = fieldNorm(doc=5150)
         0.1991933 = weight(abstract_txt:causes in 5150) [ClassicSimilarity], result of:
           0.1991933 = score(doc=5150,freq=1.0), product of:
             0.30289412 = queryWeight, product of:
               2.9674435 = boost
               7.014756 = idf(docFreq=107, maxDocs=44218)
               0.014551098 = queryNorm
             0.6576334 = fieldWeight in 5150, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.014756 = idf(docFreq=107, maxDocs=44218)
               0.09375 = fieldNorm(doc=5150)
         0.35016748 = weight(abstract_txt:error in 5150) [ClassicSimilarity], result of:
           0.35016748 = score(doc=5150,freq=2.0), product of:
             0.3854143 = queryWeight, product of:
               3.8651853 = boost
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.014551098 = queryNorm
             0.90854824 = fieldWeight in 5150, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.09375 = fieldNorm(doc=5150)
       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.20115706 = sum of:
     0.20115706 = product of:
       0.62861586 = sum of:
         0.009047468 = weight(abstract_txt:that in 4296) [ClassicSimilarity], result of:
           0.009047468 = score(doc=4296,freq=2.0), product of:
             0.034559693 = queryWeight, product of:
               1.0023559 = boost
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.014551098 = queryNorm
             0.26179248 = fieldWeight in 4296, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.0117030125 = weight(abstract_txt:this in 4296) [ClassicSimilarity], result of:
           0.0117030125 = score(doc=4296,freq=3.0), product of:
             0.035841532 = queryWeight, product of:
               1.0207757 = boost
               2.4130175 = idf(docFreq=10762, maxDocs=44218)
               0.014551098 = queryNorm
             0.32652098 = fieldWeight in 4296, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               2.4130175 = idf(docFreq=10762, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.04269297 = weight(abstract_txt:queries in 4296) [ClassicSimilarity], result of:
           0.04269297 = score(doc=4296,freq=1.0), product of:
             0.10701279 = queryWeight, product of:
               1.440155 = boost
               5.106586 = idf(docFreq=727, maxDocs=44218)
               0.014551098 = queryNorm
             0.39895204 = fieldWeight in 4296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.106586 = idf(docFreq=727, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.03046099 = weight(abstract_txt:model in 4296) [ClassicSimilarity], result of:
           0.03046099 = score(doc=4296,freq=1.0), product of:
             0.09781179 = queryWeight, product of:
               1.6862915 = boost
               3.986234 = idf(docFreq=2231, maxDocs=44218)
               0.014551098 = queryNorm
             0.31142452 = fieldWeight in 4296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.986234 = idf(docFreq=2231, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.055507626 = weight(abstract_txt:user in 4296) [ClassicSimilarity], result of:
           0.055507626 = score(doc=4296,freq=3.0), product of:
             0.11136177 = queryWeight, product of:
               2.0776598 = boost
               3.6835442 = idf(docFreq=3020, maxDocs=44218)
               0.014551098 = queryNorm
             0.49844417 = fieldWeight in 4296, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               3.6835442 = idf(docFreq=3020, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.13776453 = weight(abstract_txt:query in 4296) [ClassicSimilarity], result of:
           0.13776453 = score(doc=4296,freq=4.0), product of:
             0.18547258 = queryWeight, product of:
               2.6813052 = boost
               4.7537646 = idf(docFreq=1035, maxDocs=44218)
               0.014551098 = queryNorm
             0.74277574 = fieldWeight in 4296, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.7537646 = idf(docFreq=1035, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.13510107 = weight(abstract_txt:errors in 4296) [ClassicSimilarity], result of:
           0.13510107 = score(doc=4296,freq=1.0), product of:
             0.26403877 = queryWeight, product of:
               2.7705812 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.014551098 = queryNorm
             0.5116713 = fieldWeight in 4296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
         0.20633817 = weight(abstract_txt:error in 4296) [ClassicSimilarity], result of:
           0.20633817 = score(doc=4296,freq=1.0), product of:
             0.3854143 = queryWeight, product of:
               3.8651853 = boost
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.014551098 = queryNorm
             0.5353672 = fieldWeight in 4296, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.078125 = fieldNorm(doc=4296)
       0.32 = coord(8/25)
   

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

   0.19543329 = sum of:
     0.19543329 = product of:
       0.69797605 = sum of:
         0.007677031 = weight(abstract_txt:that in 422) [ClassicSimilarity], result of:
           0.007677031 = score(doc=422,freq=1.0), product of:
             0.034559693 = queryWeight, product of:
               1.0023559 = boost
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.014551098 = queryNorm
             0.22213829 = fieldWeight in 422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.072452374 = weight(abstract_txt:queries in 422) [ClassicSimilarity], result of:
           0.072452374 = score(doc=422,freq=2.0), product of:
             0.10701279 = queryWeight, product of:
               1.440155 = boost
               5.106586 = idf(docFreq=727, maxDocs=44218)
               0.014551098 = queryNorm
             0.67704403 = fieldWeight in 422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               5.106586 = idf(docFreq=727, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.03655319 = weight(abstract_txt:model in 422) [ClassicSimilarity], result of:
           0.03655319 = score(doc=422,freq=1.0), product of:
             0.09781179 = queryWeight, product of:
               1.6862915 = boost
               3.986234 = idf(docFreq=2231, maxDocs=44218)
               0.014551098 = queryNorm
             0.37370944 = fieldWeight in 422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.986234 = idf(docFreq=2231, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.054386146 = weight(abstract_txt:user in 422) [ClassicSimilarity], result of:
           0.054386146 = score(doc=422,freq=2.0), product of:
             0.11136177 = queryWeight, product of:
               2.0776598 = boost
               3.6835442 = idf(docFreq=3020, maxDocs=44218)
               0.014551098 = queryNorm
             0.48837358 = fieldWeight in 422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.6835442 = idf(docFreq=3020, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.1431691 = weight(abstract_txt:query in 422) [ClassicSimilarity], result of:
           0.1431691 = score(doc=422,freq=3.0), product of:
             0.18547258 = queryWeight, product of:
               2.6813052 = boost
               4.7537646 = idf(docFreq=1035, maxDocs=44218)
               0.014551098 = queryNorm
             0.7719152 = fieldWeight in 422, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.7537646 = idf(docFreq=1035, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.15446413 = weight(abstract_txt:writing in 422) [ClassicSimilarity], result of:
           0.15446413 = score(doc=422,freq=1.0), product of:
             0.25565803 = queryWeight, product of:
               2.7262566 = boost
               6.444614 = idf(docFreq=190, maxDocs=44218)
               0.014551098 = queryNorm
             0.60418254 = fieldWeight in 422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.444614 = idf(docFreq=190, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.2292741 = weight(abstract_txt:errors in 422) [ClassicSimilarity], result of:
           0.2292741 = score(doc=422,freq=2.0), product of:
             0.26403877 = queryWeight, product of:
               2.7705812 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.014551098 = queryNorm
             0.86833495 = fieldWeight in 422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
       0.28 = coord(7/25)
   

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

   0.18832235 = sum of:
     0.18832235 = product of:
       0.94161177 = sum of:
         0.010856962 = weight(abstract_txt:that in 8238) [ClassicSimilarity], result of:
           0.010856962 = score(doc=8238,freq=2.0), product of:
             0.034559693 = queryWeight, product of:
               1.0023559 = boost
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.014551098 = queryNorm
             0.314151 = fieldWeight in 8238, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.12064486 = weight(abstract_txt:database in 8238) [ClassicSimilarity], result of:
           0.12064486 = score(doc=8238,freq=4.0), product of:
             0.15033951 = queryWeight, product of:
               2.4140317 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.014551098 = queryNorm
             0.8024827 = fieldWeight in 8238, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.28080228 = weight(abstract_txt:errors in 8238) [ClassicSimilarity], result of:
           0.28080228 = score(doc=8238,freq=3.0), product of:
             0.26403877 = queryWeight, product of:
               2.7705812 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.014551098 = queryNorm
             1.0634888 = fieldWeight in 8238, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.28170183 = weight(abstract_txt:causes in 8238) [ClassicSimilarity], result of:
           0.28170183 = score(doc=8238,freq=2.0), product of:
             0.30289412 = queryWeight, product of:
               2.9674435 = boost
               7.014756 = idf(docFreq=107, maxDocs=44218)
               0.014551098 = queryNorm
             0.93003404 = fieldWeight in 8238, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               7.014756 = idf(docFreq=107, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.24760583 = weight(abstract_txt:error in 8238) [ClassicSimilarity], result of:
           0.24760583 = score(doc=8238,freq=1.0), product of:
             0.3854143 = queryWeight, product of:
               3.8651853 = boost
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.014551098 = queryNorm
             0.6424407 = fieldWeight in 8238, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
       0.2 = coord(5/25)
   

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

   0.16348267 = sum of:
     0.16348267 = product of:
       0.58386666 = sum of:
         0.014475949 = weight(abstract_txt:that in 5973) [ClassicSimilarity], result of:
           0.014475949 = score(doc=5973,freq=8.0), product of:
             0.034559693 = queryWeight, product of:
               1.0023559 = boost
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.014551098 = queryNorm
             0.41886798 = fieldWeight in 5973, product of:
               2.828427 = tf(freq=8.0), with freq of:
                 8.0 = termFreq=8.0
               2.3694751 = idf(docFreq=11241, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
         0.00540539 = weight(abstract_txt:this in 5973) [ClassicSimilarity], result of:
           0.00540539 = score(doc=5973,freq=1.0), product of:
             0.035841532 = queryWeight, product of:
               1.0207757 = boost
               2.4130175 = idf(docFreq=10762, maxDocs=44218)
               0.014551098 = queryNorm
             0.1508136 = fieldWeight in 5973, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4130175 = idf(docFreq=10762, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
         0.076371506 = weight(abstract_txt:queries in 5973) [ClassicSimilarity], result of:
           0.076371506 = score(doc=5973,freq=5.0), product of:
             0.10701279 = queryWeight, product of:
               1.440155 = boost
               5.106586 = idf(docFreq=727, maxDocs=44218)
               0.014551098 = queryNorm
             0.7136671 = fieldWeight in 5973, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               5.106586 = idf(docFreq=727, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
         0.05127575 = weight(abstract_txt:user in 5973) [ClassicSimilarity], result of:
           0.05127575 = score(doc=5973,freq=4.0), product of:
             0.11136177 = queryWeight, product of:
               2.0776598 = boost
               3.6835442 = idf(docFreq=3020, maxDocs=44218)
               0.014551098 = queryNorm
             0.46044302 = fieldWeight in 5973, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.6835442 = idf(docFreq=3020, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
         0.055105813 = weight(abstract_txt:query in 5973) [ClassicSimilarity], result of:
           0.055105813 = score(doc=5973,freq=1.0), product of:
             0.18547258 = queryWeight, product of:
               2.6813052 = boost
               4.7537646 = idf(docFreq=1035, maxDocs=44218)
               0.014551098 = queryNorm
             0.2971103 = fieldWeight in 5973, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.7537646 = idf(docFreq=1035, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
         0.2161617 = weight(abstract_txt:errors in 5973) [ClassicSimilarity], result of:
           0.2161617 = score(doc=5973,freq=4.0), product of:
             0.26403877 = queryWeight, product of:
               2.7705812 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.014551098 = queryNorm
             0.8186741 = fieldWeight in 5973, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
         0.16507055 = weight(abstract_txt:error in 5973) [ClassicSimilarity], result of:
           0.16507055 = score(doc=5973,freq=1.0), product of:
             0.3854143 = queryWeight, product of:
               3.8651853 = boost
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.014551098 = queryNorm
             0.42829376 = fieldWeight in 5973, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.0625 = fieldNorm(doc=5973)
       0.28 = coord(7/25)