Document (#8238)

Author

Batra, D.
Antony, S.R.

Title

Novice errors in conceptual database design

Source

European journal of information systems. 3(1994) no.1, S.57-69

Year

1994

Abstract

Conceptual and logical database modelling are difficult tasks for designers, and the potential for committing and correction errors is significant. Reports on two laboratory experiments that investigated the underlying causes or errors committed by novice designers engaged in conceptual database modelling tasks. These causes can be traced to combinatorial complexity of the task, biases resulting from misapplication of heuristics, and incomplete knowledge about database design. The most common error was that subjects translated their initial understanding of the application into final database structures and did not consider alternative hypotheses and solutions. Includes recommendations to reduce the occurrence of errors

Similar documents (author)

1. Batra, D.; Davis, J.G.: Conceptual data modelling in database design : similarities and differences between expert and novice designers (1992) 4.88

   4.8777785 = sum of:
     4.8777785 = weight(author_txt:batra in 3004) [ClassicSimilarity], result of:
       4.8777785 = fieldWeight in 3004, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.755557 = idf(docFreq=6, maxDocs=44421)
         0.5 = fieldNorm(doc=3004)
   

2. Batra, D.; Sein, M.K.: Improving conceptual database design through feedback (1994) 4.88

   4.8777785 = sum of:
     4.8777785 = weight(author_txt:batra in 177) [ClassicSimilarity], result of:
       4.8777785 = fieldWeight in 177, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.755557 = idf(docFreq=6, maxDocs=44421)
         0.5 = fieldNorm(doc=177)
   

3. Batra, D.; Zanakis, S.H.: ¬A conceptual database design approach based on rules and heuristics (1994) 4.88

   4.8777785 = sum of:
     4.8777785 = weight(author_txt:batra in 854) [ClassicSimilarity], result of:
       4.8777785 = fieldWeight in 854, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.755557 = idf(docFreq=6, maxDocs=44421)
         0.5 = fieldNorm(doc=854)
   

4. Batra, D.; Marakas, G.M.: Conceptual data modelling in theory and practice (1995) 4.88

   4.8777785 = sum of:
     4.8777785 = weight(author_txt:batra in 4177) [ClassicSimilarity], result of:
       4.8777785 = fieldWeight in 4177, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.755557 = idf(docFreq=6, maxDocs=44421)
         0.5 = fieldNorm(doc=4177)
   

5. Jindal, V.; Bawa, S.; Batra, S.: ¬A review of ranking approaches for semantic search on Web (2014) 3.66

   3.6583338 = sum of:
     3.6583338 = weight(author_txt:batra in 3799) [ClassicSimilarity], result of:
       3.6583338 = fieldWeight in 3799, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.755557 = idf(docFreq=6, maxDocs=44421)
         0.375 = fieldNorm(doc=3799)
   

Similar documents (content)

1. Batra, D.; Sein, M.K.: Improving conceptual database design through feedback (1994) 0.35

   0.35155013 = sum of:
     0.35155013 = product of:
       1.0985942 = sum of:
         0.050731156 = weight(abstract_txt:logical in 177) [ClassicSimilarity], result of:
           0.050731156 = score(doc=177,freq=1.0), product of:
             0.1053447 = queryWeight, product of:
               6.1641335 = idf(docFreq=253, maxDocs=44421)
               0.017089944 = queryNorm
             0.48157293 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.1641335 = idf(docFreq=253, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.05211862 = weight(abstract_txt:design in 177) [ClassicSimilarity], result of:
           0.05211862 = score(doc=177,freq=4.0), product of:
             0.08512977 = queryWeight, product of:
               1.2713039 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.017089944 = queryNorm
             0.6122256 = fieldWeight in 177, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.12386121 = weight(abstract_txt:committed in 177) [ClassicSimilarity], result of:
           0.12386121 = score(doc=177,freq=1.0), product of:
             0.19100866 = queryWeight, product of:
               1.3465428 = boost
               8.30027 = idf(docFreq=29, maxDocs=44421)
               0.017089944 = queryNorm
             0.6484586 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.30027 = idf(docFreq=29, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.11216086 = weight(abstract_txt:designers in 177) [ClassicSimilarity], result of:
           0.11216086 = score(doc=177,freq=1.0), product of:
             0.22525118 = queryWeight, product of:
               2.0679603 = boost
               6.3735914 = idf(docFreq=205, maxDocs=44421)
               0.017089944 = queryNorm
             0.49793684 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.3735914 = idf(docFreq=205, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.177742 = weight(abstract_txt:modelling in 177) [ClassicSimilarity], result of:
           0.177742 = score(doc=177,freq=2.0), product of:
             0.2430093 = queryWeight, product of:
               2.14793 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.017089944 = queryNorm
             0.7314206 = fieldWeight in 177, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.07563421 = weight(abstract_txt:conceptual in 177) [ClassicSimilarity], result of:
           0.07563421 = score(doc=177,freq=1.0), product of:
             0.19828147 = queryWeight, product of:
               2.3762677 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.017089944 = queryNorm
             0.38144872 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.084998764 = weight(abstract_txt:database in 177) [ClassicSimilarity], result of:
           0.084998764 = score(doc=177,freq=1.0), product of:
             0.2541136 = queryWeight, product of:
               3.4729028 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.017089944 = queryNorm
             0.3344912 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.42134735 = weight(abstract_txt:errors in 177) [ClassicSimilarity], result of:
           0.42134735 = score(doc=177,freq=3.0), product of:
             0.47552052 = queryWeight, product of:
               4.249211 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.017089944 = queryNorm
             0.88607603 = fieldWeight in 177, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
       0.32 = coord(8/25)
   

2. Batra, D.; Davis, J.G.: Conceptual data modelling in database design : similarities and differences between expert and novice designers (1992) 0.26

   0.2554752 = sum of:
     0.2554752 = product of:
       0.91241145 = sum of:
         0.072377644 = weight(abstract_txt:engaged in 3004) [ClassicSimilarity], result of:
           0.072377644 = score(doc=3004,freq=1.0), product of:
             0.1335055 = queryWeight, product of:
               1.1257533 = boost
               6.939294 = idf(docFreq=116, maxDocs=44421)
               0.017089944 = queryNorm
             0.5421323 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.939294 = idf(docFreq=116, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.02605931 = weight(abstract_txt:design in 3004) [ClassicSimilarity], result of:
           0.02605931 = score(doc=3004,freq=1.0), product of:
             0.08512977 = queryWeight, product of:
               1.2713039 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.017089944 = queryNorm
             0.3061128 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.2176886 = weight(abstract_txt:modelling in 3004) [ClassicSimilarity], result of:
           0.2176886 = score(doc=3004,freq=3.0), product of:
             0.2430093 = queryWeight, product of:
               2.14793 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.017089944 = queryNorm
             0.8958036 = fieldWeight in 3004, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.16105919 = weight(abstract_txt:novice in 3004) [ClassicSimilarity], result of:
           0.16105919 = score(doc=3004,freq=1.0), product of:
             0.2867014 = queryWeight, product of:
               2.3330474 = boost
               7.190608 = idf(docFreq=90, maxDocs=44421)
               0.017089944 = queryNorm
             0.56176627 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.190608 = idf(docFreq=90, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.10696293 = weight(abstract_txt:conceptual in 3004) [ClassicSimilarity], result of:
           0.10696293 = score(doc=3004,freq=2.0), product of:
             0.19828147 = queryWeight, product of:
               2.3762677 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.017089944 = queryNorm
             0.53944993 = fieldWeight in 3004, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.084998764 = weight(abstract_txt:database in 3004) [ClassicSimilarity], result of:
           0.084998764 = score(doc=3004,freq=1.0), product of:
             0.2541136 = queryWeight, product of:
               3.4729028 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.017089944 = queryNorm
             0.3344912 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.243265 = weight(abstract_txt:errors in 3004) [ClassicSimilarity], result of:
           0.243265 = score(doc=3004,freq=1.0), product of:
             0.47552052 = queryWeight, product of:
               4.249211 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.017089944 = queryNorm
             0.51157624 = fieldWeight in 3004, 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=3004)
       0.28 = coord(7/25)
   

3. Batra, D.; Zanakis, S.H.: ¬A conceptual database design approach based on rules and heuristics (1994) 0.21

   0.21108465 = sum of:
     0.21108465 = product of:
       0.75387377 = sum of:
         0.08786893 = weight(abstract_txt:logical in 854) [ClassicSimilarity], result of:
           0.08786893 = score(doc=854,freq=3.0), product of:
             0.1053447 = queryWeight, product of:
               6.1641335 = idf(docFreq=253, maxDocs=44421)
               0.017089944 = queryNorm
             0.8341087 = fieldWeight in 854, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.1641335 = idf(docFreq=253, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.14477484 = weight(abstract_txt:heuristics in 854) [ClassicSimilarity], result of:
           0.14477484 = score(doc=854,freq=2.0), product of:
             0.16822153 = queryWeight, product of:
               1.2636722 = boost
               7.7894444 = idf(docFreq=49, maxDocs=44421)
               0.017089944 = queryNorm
             0.86062014 = fieldWeight in 854, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               7.7894444 = idf(docFreq=49, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.05211862 = weight(abstract_txt:design in 854) [ClassicSimilarity], result of:
           0.05211862 = score(doc=854,freq=4.0), product of:
             0.08512977 = queryWeight, product of:
               1.2713039 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.017089944 = queryNorm
             0.6122256 = fieldWeight in 854, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.05928322 = weight(abstract_txt:tasks in 854) [ClassicSimilarity], result of:
           0.05928322 = score(doc=854,freq=1.0), product of:
             0.14725183 = queryWeight, product of:
               1.6720105 = boost
               5.1532483 = idf(docFreq=697, maxDocs=44421)
               0.017089944 = queryNorm
             0.40259752 = fieldWeight in 854, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1532483 = idf(docFreq=697, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.1586194 = weight(abstract_txt:designers in 854) [ClassicSimilarity], result of:
           0.1586194 = score(doc=854,freq=2.0), product of:
             0.22525118 = queryWeight, product of:
               2.0679603 = boost
               6.3735914 = idf(docFreq=205, maxDocs=44421)
               0.017089944 = queryNorm
             0.704189 = fieldWeight in 854, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.3735914 = idf(docFreq=205, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.1310023 = weight(abstract_txt:conceptual in 854) [ClassicSimilarity], result of:
           0.1310023 = score(doc=854,freq=3.0), product of:
             0.19828147 = queryWeight, product of:
               2.3762677 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.017089944 = queryNorm
             0.6606886 = fieldWeight in 854, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.12020641 = weight(abstract_txt:database in 854) [ClassicSimilarity], result of:
           0.12020641 = score(doc=854,freq=2.0), product of:
             0.2541136 = queryWeight, product of:
               3.4729028 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.017089944 = queryNorm
             0.47304198 = fieldWeight in 854, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
       0.28 = coord(7/25)
   

4. Rantanen, E.M.; Palmer, B.O.; Wiegmann, D.A.; Musiorski, K.M.: Five-dimensional taxonomy to relate human errors and technological interventions in a human factors literature database (2006) 0.18

   0.18421325 = sum of:
     0.18421325 = product of:
       0.76755524 = sum of:
         0.043026946 = weight(abstract_txt:reduce in 311) [ClassicSimilarity], result of:
           0.043026946 = score(doc=311,freq=1.0), product of:
             0.10952919 = queryWeight, product of:
               1.0196675 = boost
               6.285367 = idf(docFreq=224, maxDocs=44421)
               0.017089944 = queryNorm
             0.39283544 = fieldWeight in 311, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.285367 = idf(docFreq=224, maxDocs=44421)
               0.0625 = fieldNorm(doc=311)
         0.053695254 = weight(abstract_txt:occurrence in 311) [ClassicSimilarity], result of:
           0.053695254 = score(doc=311,freq=1.0), product of:
             0.12695801 = queryWeight, product of:
               1.0978012 = boost
               6.7669935 = idf(docFreq=138, maxDocs=44421)
               0.017089944 = queryNorm
             0.4229371 = fieldWeight in 311, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.7669935 = idf(docFreq=138, maxDocs=44421)
               0.0625 = fieldNorm(doc=311)
         0.12493653 = weight(abstract_txt:error in 311) [ClassicSimilarity], result of:
           0.12493653 = score(doc=311,freq=5.0), product of:
             0.13036844 = queryWeight, product of:
               1.1124485 = boost
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.017089944 = queryNorm
             0.95833415 = fieldWeight in 311, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.0625 = fieldNorm(doc=311)
         0.06050737 = weight(abstract_txt:conceptual in 311) [ClassicSimilarity], result of:
           0.06050737 = score(doc=311,freq=1.0), product of:
             0.19828147 = queryWeight, product of:
               2.3762677 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.017089944 = queryNorm
             0.30515897 = fieldWeight in 311, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.0625 = fieldNorm(doc=311)
         0.09616513 = weight(abstract_txt:database in 311) [ClassicSimilarity], result of:
           0.09616513 = score(doc=311,freq=2.0), product of:
             0.2541136 = queryWeight, product of:
               3.4729028 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.017089944 = queryNorm
             0.3784336 = fieldWeight in 311, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.0625 = fieldNorm(doc=311)
         0.389224 = weight(abstract_txt:errors in 311) [ClassicSimilarity], result of:
           0.389224 = score(doc=311,freq=4.0), product of:
             0.47552052 = queryWeight, product of:
               4.249211 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.017089944 = queryNorm
             0.818522 = fieldWeight in 311, 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=311)
       0.24 = coord(6/25)
   

5. Smelcer, J.B.: User errors in database query composition (1995) 0.14

   0.14230613 = sum of:
     0.14230613 = product of:
       0.88941336 = sum of:
         0.13968328 = weight(abstract_txt:error in 3202) [ClassicSimilarity], result of:
           0.13968328 = score(doc=3202,freq=4.0), product of:
             0.13036844 = queryWeight, product of:
               1.1124485 = boost
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.017089944 = queryNorm
             1.0714501 = fieldWeight in 3202, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.8572807 = idf(docFreq=126, maxDocs=44421)
               0.078125 = fieldNorm(doc=3202)
         0.2584792 = weight(abstract_txt:causes in 3202) [ClassicSimilarity], result of:
           0.2584792 = score(doc=3202,freq=3.0), product of:
             0.27248934 = queryWeight, product of:
               2.2744868 = boost
               7.01012 = idf(docFreq=108, maxDocs=44421)
               0.017089944 = queryNorm
             0.9485847 = fieldWeight in 3202, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               7.01012 = idf(docFreq=108, maxDocs=44421)
               0.078125 = fieldNorm(doc=3202)
         0.14722219 = weight(abstract_txt:database in 3202) [ClassicSimilarity], result of:
           0.14722219 = score(doc=3202,freq=3.0), product of:
             0.2541136 = queryWeight, product of:
               3.4729028 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.017089944 = queryNorm
             0.5793558 = fieldWeight in 3202, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.078125 = fieldNorm(doc=3202)
         0.34402868 = weight(abstract_txt:errors in 3202) [ClassicSimilarity], result of:
           0.34402868 = score(doc=3202,freq=2.0), product of:
             0.47552052 = queryWeight, product of:
               4.249211 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.017089944 = queryNorm
             0.7234781 = fieldWeight in 3202, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.078125 = fieldNorm(doc=3202)
       0.16 = coord(4/25)