Document (#8236)

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.87

   4.867946 = sum of:
     4.867946 = weight(author_txt:batra in 3005) [ClassicSimilarity], result of:
       4.867946 = fieldWeight in 3005, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.735892 = idf(docFreq=6, maxDocs=43556)
         0.5 = fieldNorm(doc=3005)
   

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

   4.867946 = sum of:
     4.867946 = weight(author_txt:batra in 560) [ClassicSimilarity], result of:
       4.867946 = fieldWeight in 560, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.735892 = idf(docFreq=6, maxDocs=43556)
         0.5 = fieldNorm(doc=560)
   

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

   4.867946 = sum of:
     4.867946 = weight(author_txt:batra in 852) [ClassicSimilarity], result of:
       4.867946 = fieldWeight in 852, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.735892 = idf(docFreq=6, maxDocs=43556)
         0.5 = fieldNorm(doc=852)
   

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

   4.867946 = sum of:
     4.867946 = weight(author_txt:batra in 4175) [ClassicSimilarity], result of:
       4.867946 = fieldWeight in 4175, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.735892 = idf(docFreq=6, maxDocs=43556)
         0.5 = fieldNorm(doc=4175)
   

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

   3.6509595 = sum of:
     3.6509595 = weight(author_txt:batra in 4797) [ClassicSimilarity], result of:
       3.6509595 = fieldWeight in 4797, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.735892 = idf(docFreq=6, maxDocs=43556)
         0.375 = fieldNorm(doc=4797)
   

Similar documents (content)

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

   0.35160476 = sum of:
     0.35160476 = product of:
       1.0987649 = sum of:
         0.05143597 = weight(abstract_txt:logical in 560) [ClassicSimilarity], result of:
           0.05143597 = score(doc=560,freq=1.0), product of:
             0.106241696 = queryWeight, product of:
               6.1970057 = idf(docFreq=240, maxDocs=43556)
               0.017144037 = queryNorm
             0.48414108 = fieldWeight in 560, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.1970057 = idf(docFreq=240, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.052402873 = weight(abstract_txt:design in 560) [ClassicSimilarity], result of:
           0.052402873 = score(doc=560,freq=4.0), product of:
             0.08537757 = queryWeight, product of:
               1.2677668 = boost
               3.9281793 = idf(docFreq=2329, maxDocs=43556)
               0.017144037 = queryNorm
             0.613778 = fieldWeight in 560, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9281793 = idf(docFreq=2329, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.12271778 = weight(abstract_txt:committed in 560) [ClassicSimilarity], result of:
           0.12271778 = score(doc=560,freq=1.0), product of:
             0.18969478 = queryWeight, product of:
               1.3362268 = boost
               8.280605 = idf(docFreq=29, maxDocs=43556)
               0.017144037 = queryNorm
             0.6469223 = fieldWeight in 560, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.280605 = idf(docFreq=29, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.11324159 = weight(abstract_txt:designers in 560) [ClassicSimilarity], result of:
           0.11324159 = score(doc=560,freq=1.0), product of:
             0.22653276 = queryWeight, product of:
               2.0650616 = boost
               6.398599 = idf(docFreq=196, maxDocs=43556)
               0.017144037 = queryNorm
             0.49989057 = fieldWeight in 560, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.398599 = idf(docFreq=196, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.17780066 = weight(abstract_txt:modelling in 560) [ClassicSimilarity], result of:
           0.17780066 = score(doc=560,freq=2.0), product of:
             0.24288794 = queryWeight, product of:
               2.138309 = boost
               6.625557 = idf(docFreq=156, maxDocs=43556)
               0.017144037 = queryNorm
             0.73202753 = fieldWeight in 560, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.625557 = idf(docFreq=156, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.076852895 = weight(abstract_txt:conceptual in 560) [ClassicSimilarity], result of:
           0.076852895 = score(doc=560,freq=1.0), product of:
             0.20026158 = queryWeight, product of:
               2.3780005 = boost
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.017144037 = queryNorm
             0.38376257 = fieldWeight in 560, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.08429237 = weight(abstract_txt:database in 560) [ClassicSimilarity], result of:
           0.08429237 = score(doc=560,freq=1.0), product of:
             0.252522 = queryWeight, product of:
               3.4473636 = boost
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.017144037 = queryNorm
             0.33380207 = fieldWeight in 560, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
         0.4200207 = weight(abstract_txt:errors in 560) [ClassicSimilarity], result of:
           0.4200207 = score(doc=560,freq=3.0), product of:
             0.47418058 = queryWeight, product of:
               4.2252693 = boost
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.017144037 = queryNorm
             0.8857822 = fieldWeight in 560, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.078125 = fieldNorm(doc=560)
       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.25546598 = sum of:
     0.25546598 = product of:
       0.91237855 = sum of:
         0.07354181 = weight(abstract_txt:engaged in 3005) [ClassicSimilarity], result of:
           0.07354181 = score(doc=3005,freq=1.0), product of:
             0.13483623 = queryWeight, product of:
               1.1265638 = boost
               6.9813223 = idf(docFreq=109, maxDocs=43556)
               0.017144037 = queryNorm
             0.5454158 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.9813223 = idf(docFreq=109, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
         0.026201436 = weight(abstract_txt:design in 3005) [ClassicSimilarity], result of:
           0.026201436 = score(doc=3005,freq=1.0), product of:
             0.08537757 = queryWeight, product of:
               1.2677668 = boost
               3.9281793 = idf(docFreq=2329, maxDocs=43556)
               0.017144037 = queryNorm
             0.306889 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9281793 = idf(docFreq=2329, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
         0.21776044 = weight(abstract_txt:modelling in 3005) [ClassicSimilarity], result of:
           0.21776044 = score(doc=3005,freq=3.0), product of:
             0.24288794 = queryWeight, product of:
               2.138309 = boost
               6.625557 = idf(docFreq=156, maxDocs=43556)
               0.017144037 = queryNorm
             0.89654696 = fieldWeight in 3005, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.625557 = idf(docFreq=156, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
         0.15939698 = weight(abstract_txt:novice in 3005) [ClassicSimilarity], result of:
           0.15939698 = score(doc=3005,freq=1.0), product of:
             0.28452063 = queryWeight, product of:
               2.314325 = boost
               7.1709433 = idf(docFreq=90, maxDocs=43556)
               0.017144037 = queryNorm
             0.56022996 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1709433 = idf(docFreq=90, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
         0.10868641 = weight(abstract_txt:conceptual in 3005) [ClassicSimilarity], result of:
           0.10868641 = score(doc=3005,freq=2.0), product of:
             0.20026158 = queryWeight, product of:
               2.3780005 = boost
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.017144037 = queryNorm
             0.5427222 = fieldWeight in 3005, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
         0.08429237 = weight(abstract_txt:database in 3005) [ClassicSimilarity], result of:
           0.08429237 = score(doc=3005,freq=1.0), product of:
             0.252522 = queryWeight, product of:
               3.4473636 = boost
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.017144037 = queryNorm
             0.33380207 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
         0.24249908 = weight(abstract_txt:errors in 3005) [ClassicSimilarity], result of:
           0.24249908 = score(doc=3005,freq=1.0), product of:
             0.47418058 = queryWeight, product of:
               4.2252693 = boost
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.017144037 = queryNorm
             0.5114066 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.078125 = fieldNorm(doc=3005)
       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.21224365 = sum of:
     0.21224365 = product of:
       0.758013 = sum of:
         0.089089714 = weight(abstract_txt:logical in 852) [ClassicSimilarity], result of:
           0.089089714 = score(doc=852,freq=3.0), product of:
             0.106241696 = queryWeight, product of:
               6.1970057 = idf(docFreq=240, maxDocs=43556)
               0.017144037 = queryNorm
             0.83855695 = fieldWeight in 852, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.1970057 = idf(docFreq=240, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
         0.14337133 = weight(abstract_txt:heuristics in 852) [ClassicSimilarity], result of:
           0.14337133 = score(doc=852,freq=2.0), product of:
             0.16701235 = queryWeight, product of:
               1.2537957 = boost
               7.7697797 = idf(docFreq=49, maxDocs=43556)
               0.017144037 = queryNorm
             0.8584475 = fieldWeight in 852, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               7.7697797 = idf(docFreq=49, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
         0.052402873 = weight(abstract_txt:design in 852) [ClassicSimilarity], result of:
           0.052402873 = score(doc=852,freq=4.0), product of:
             0.08537757 = queryWeight, product of:
               1.2677668 = boost
               3.9281793 = idf(docFreq=2329, maxDocs=43556)
               0.017144037 = queryNorm
             0.613778 = fieldWeight in 852, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9281793 = idf(docFreq=2329, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
         0.060680807 = weight(abstract_txt:tasks in 852) [ClassicSimilarity], result of:
           0.060680807 = score(doc=852,freq=1.0), product of:
             0.14944956 = queryWeight, product of:
               1.6773157 = boost
               5.1971674 = idf(docFreq=654, maxDocs=43556)
               0.017144037 = queryNorm
             0.4060287 = fieldWeight in 852, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1971674 = idf(docFreq=654, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
         0.16014779 = weight(abstract_txt:designers in 852) [ClassicSimilarity], result of:
           0.16014779 = score(doc=852,freq=2.0), product of:
             0.22653276 = queryWeight, product of:
               2.0650616 = boost
               6.398599 = idf(docFreq=196, maxDocs=43556)
               0.017144037 = queryNorm
             0.706952 = fieldWeight in 852, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.398599 = idf(docFreq=196, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
         0.13311312 = weight(abstract_txt:conceptual in 852) [ClassicSimilarity], result of:
           0.13311312 = score(doc=852,freq=3.0), product of:
             0.20026158 = queryWeight, product of:
               2.3780005 = boost
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.017144037 = queryNorm
             0.6646962 = fieldWeight in 852, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
         0.119207405 = weight(abstract_txt:database in 852) [ClassicSimilarity], result of:
           0.119207405 = score(doc=852,freq=2.0), product of:
             0.252522 = queryWeight, product of:
               3.4473636 = boost
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.017144037 = queryNorm
             0.47206742 = fieldWeight in 852, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.078125 = fieldNorm(doc=852)
       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.18391445 = sum of:
     0.18391445 = product of:
       0.7663102 = sum of:
         0.043273978 = weight(abstract_txt:reduce in 1309) [ClassicSimilarity], result of:
           0.043273978 = score(doc=1309,freq=1.0), product of:
             0.10986894 = queryWeight, product of:
               1.0169275 = boost
               6.301905 = idf(docFreq=216, maxDocs=43556)
               0.017144037 = queryNorm
             0.39386907 = fieldWeight in 1309, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.301905 = idf(docFreq=216, maxDocs=43556)
               0.0625 = fieldNorm(doc=1309)
         0.054162595 = weight(abstract_txt:occurrence in 1309) [ClassicSimilarity], result of:
           0.054162595 = score(doc=1309,freq=1.0), product of:
             0.12760177 = queryWeight, product of:
               1.0959251 = boost
               6.791454 = idf(docFreq=132, maxDocs=43556)
               0.017144037 = queryNorm
             0.42446586 = fieldWeight in 1309, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.791454 = idf(docFreq=132, maxDocs=43556)
               0.0625 = fieldNorm(doc=1309)
         0.12402687 = weight(abstract_txt:error in 1309) [ClassicSimilarity], result of:
           0.12402687 = score(doc=1309,freq=5.0), product of:
             0.12964156 = queryWeight, product of:
               1.1046498 = boost
               6.845521 = idf(docFreq=125, maxDocs=43556)
               0.017144037 = queryNorm
             0.95669067 = fieldWeight in 1309, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               6.845521 = idf(docFreq=125, maxDocs=43556)
               0.0625 = fieldNorm(doc=1309)
         0.061482318 = weight(abstract_txt:conceptual in 1309) [ClassicSimilarity], result of:
           0.061482318 = score(doc=1309,freq=1.0), product of:
             0.20026158 = queryWeight, product of:
               2.3780005 = boost
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.017144037 = queryNorm
             0.30701005 = fieldWeight in 1309, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.912161 = idf(docFreq=870, maxDocs=43556)
               0.0625 = fieldNorm(doc=1309)
         0.09536592 = weight(abstract_txt:database in 1309) [ClassicSimilarity], result of:
           0.09536592 = score(doc=1309,freq=2.0), product of:
             0.252522 = queryWeight, product of:
               3.4473636 = boost
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.017144037 = queryNorm
             0.37765393 = fieldWeight in 1309, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.0625 = fieldNorm(doc=1309)
         0.38799852 = weight(abstract_txt:errors in 1309) [ClassicSimilarity], result of:
           0.38799852 = score(doc=1309,freq=4.0), product of:
             0.47418058 = queryWeight, product of:
               4.2252693 = boost
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.017144037 = queryNorm
             0.81825054 = fieldWeight in 1309, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.0625 = fieldNorm(doc=1309)
       0.24 = coord(6/25)
   

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

   0.14166494 = sum of:
     0.14166494 = product of:
       0.88540584 = sum of:
         0.13866626 = weight(abstract_txt:error in 3200) [ClassicSimilarity], result of:
           0.13866626 = score(doc=3200,freq=4.0), product of:
             0.12964156 = queryWeight, product of:
               1.1046498 = boost
               6.845521 = idf(docFreq=125, maxDocs=43556)
               0.017144037 = queryNorm
             1.0696126 = fieldWeight in 3200, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.845521 = idf(docFreq=125, maxDocs=43556)
               0.078125 = fieldNorm(doc=3200)
         0.25779545 = weight(abstract_txt:causes in 3200) [ClassicSimilarity], result of:
           0.25779545 = score(doc=3200,freq=3.0), product of:
             0.27181295 = queryWeight, product of:
               2.2620518 = boost
               7.008974 = idf(docFreq=106, maxDocs=43556)
               0.017144037 = queryNorm
             0.94842964 = fieldWeight in 3200, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               7.008974 = idf(docFreq=106, maxDocs=43556)
               0.078125 = fieldNorm(doc=3200)
         0.14599866 = weight(abstract_txt:database in 3200) [ClassicSimilarity], result of:
           0.14599866 = score(doc=3200,freq=3.0), product of:
             0.252522 = queryWeight, product of:
               3.4473636 = boost
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.017144037 = queryNorm
             0.57816213 = fieldWeight in 3200, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.2726665 = idf(docFreq=1650, maxDocs=43556)
               0.078125 = fieldNorm(doc=3200)
         0.34294546 = weight(abstract_txt:errors in 3200) [ClassicSimilarity], result of:
           0.34294546 = score(doc=3200,freq=2.0), product of:
             0.47418058 = queryWeight, product of:
               4.2252693 = boost
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.017144037 = queryNorm
             0.7232381 = fieldWeight in 3200, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.5460043 = idf(docFreq=169, maxDocs=43556)
               0.078125 = fieldNorm(doc=3200)
       0.16 = coord(4/25)