Document (#8239)

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.8754888 = sum of:
     4.8754888 = weight(author_txt:batra in 3005) [ClassicSimilarity], result of:
       4.8754888 = fieldWeight in 3005, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.7509775 = idf(docFreq=6, maxDocs=44218)
         0.5 = fieldNorm(doc=3005)
   

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

   4.8754888 = sum of:
     4.8754888 = weight(author_txt:batra in 8563) [ClassicSimilarity], result of:
       4.8754888 = fieldWeight in 8563, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.7509775 = idf(docFreq=6, maxDocs=44218)
         0.5 = fieldNorm(doc=8563)
   

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

   4.8754888 = sum of:
     4.8754888 = weight(author_txt:batra in 786) [ClassicSimilarity], result of:
       4.8754888 = fieldWeight in 786, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.7509775 = idf(docFreq=6, maxDocs=44218)
         0.5 = fieldNorm(doc=786)
   

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

   4.8754888 = sum of:
     4.8754888 = weight(author_txt:batra in 4109) [ClassicSimilarity], result of:
       4.8754888 = fieldWeight in 4109, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.7509775 = idf(docFreq=6, maxDocs=44218)
         0.5 = fieldNorm(doc=4109)
   

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

   3.6566167 = sum of:
     3.6566167 = weight(author_txt:batra in 2799) [ClassicSimilarity], result of:
       3.6566167 = fieldWeight in 2799, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.7509775 = idf(docFreq=6, maxDocs=44218)
         0.375 = fieldNorm(doc=2799)
   

Similar documents (content)

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

   0.35149986 = sum of:
     0.35149986 = product of:
       1.0984371 = sum of:
         0.05086807 = weight(abstract_txt:logical in 8563) [ClassicSimilarity], result of:
           0.05086807 = score(doc=8563,freq=1.0), product of:
             0.10550405 = queryWeight, product of:
               6.1714344 = idf(docFreq=250, maxDocs=44218)
               0.017095547 = queryNorm
             0.4821433 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.1714344 = idf(docFreq=250, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.052174896 = weight(abstract_txt:design in 8563) [ClassicSimilarity], result of:
           0.052174896 = score(doc=8563,freq=4.0), product of:
             0.08516674 = queryWeight, product of:
               1.2706193 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.017095547 = queryNorm
             0.6126206 = fieldWeight in 8563, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.12355047 = weight(abstract_txt:committed in 8563) [ClassicSimilarity], result of:
           0.12355047 = score(doc=8563,freq=1.0), product of:
             0.19063467 = queryWeight, product of:
               1.3442076 = boost
               8.29569 = idf(docFreq=29, maxDocs=44218)
               0.017095547 = queryNorm
             0.64810073 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.29569 = idf(docFreq=29, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.112597965 = weight(abstract_txt:designers in 8563) [ClassicSimilarity], result of:
           0.112597965 = score(doc=8563,freq=1.0), product of:
             0.22577159 = queryWeight, product of:
               2.0687838 = boost
               6.3836813 = idf(docFreq=202, maxDocs=44218)
               0.017095547 = queryNorm
             0.49872512 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.3836813 = idf(docFreq=202, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.17722157 = weight(abstract_txt:modelling in 8563) [ClassicSimilarity], result of:
           0.17722157 = score(doc=8563,freq=2.0), product of:
             0.24246553 = queryWeight, product of:
               2.1439044 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.017095547 = queryNorm
             0.7309145 = fieldWeight in 8563, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.075970516 = weight(abstract_txt:conceptual in 8563) [ClassicSimilarity], result of:
           0.075970516 = score(doc=8563,freq=1.0), product of:
             0.19881207 = queryWeight, product of:
               2.3776474 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.017095547 = queryNorm
             0.38212225 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.08483208 = weight(abstract_txt:database in 8563) [ClassicSimilarity], result of:
           0.08483208 = score(doc=8563,freq=1.0), product of:
             0.2537089 = queryWeight, product of:
               3.4675145 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.017095547 = queryNorm
             0.33436778 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.42122155 = weight(abstract_txt:errors in 8563) [ClassicSimilarity], result of:
           0.42122155 = score(doc=8563,freq=3.0), product of:
             0.47529027 = queryWeight, product of:
               4.2449727 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.017095547 = queryNorm
             0.88624066 = fieldWeight in 8563, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
       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.25533983 = sum of:
     0.25533983 = product of:
       0.911928 = sum of:
         0.072712295 = weight(abstract_txt:engaged in 3005) [ClassicSimilarity], result of:
           0.072712295 = score(doc=3005,freq=1.0), product of:
             0.1338785 = queryWeight, product of:
               1.1264732 = boost
               6.9519553 = idf(docFreq=114, maxDocs=44218)
               0.017095547 = queryNorm
             0.5431215 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.9519553 = idf(docFreq=114, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.026087448 = weight(abstract_txt:design in 3005) [ClassicSimilarity], result of:
           0.026087448 = score(doc=3005,freq=1.0), product of:
             0.08516674 = queryWeight, product of:
               1.2706193 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.017095547 = queryNorm
             0.3063103 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.2170512 = weight(abstract_txt:modelling in 3005) [ClassicSimilarity], result of:
           0.2170512 = score(doc=3005,freq=3.0), product of:
             0.24246553 = queryWeight, product of:
               2.1439044 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.017095547 = queryNorm
             0.89518374 = fieldWeight in 3005, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.16061406 = weight(abstract_txt:novice in 3005) [ClassicSimilarity], result of:
           0.16061406 = score(doc=3005,freq=1.0), product of:
             0.2860913 = queryWeight, product of:
               2.328803 = boost
               7.1860275 = idf(docFreq=90, maxDocs=44218)
               0.017095547 = queryNorm
             0.5614084 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1860275 = idf(docFreq=90, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.107438534 = weight(abstract_txt:conceptual in 3005) [ClassicSimilarity], result of:
           0.107438534 = score(doc=3005,freq=2.0), product of:
             0.19881207 = queryWeight, product of:
               2.3776474 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.017095547 = queryNorm
             0.5404025 = fieldWeight in 3005, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.08483208 = weight(abstract_txt:database in 3005) [ClassicSimilarity], result of:
           0.08483208 = score(doc=3005,freq=1.0), product of:
             0.2537089 = queryWeight, product of:
               3.4675145 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.017095547 = queryNorm
             0.33436778 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.24319239 = weight(abstract_txt:errors in 3005) [ClassicSimilarity], result of:
           0.24319239 = score(doc=3005,freq=1.0), product of:
             0.47529027 = queryWeight, product of:
               4.2449727 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.017095547 = queryNorm
             0.5116713 = fieldWeight in 3005, 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=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.21141198 = sum of:
     0.21141198 = product of:
       0.7550428 = sum of:
         0.08810609 = weight(abstract_txt:logical in 786) [ClassicSimilarity], result of:
           0.08810609 = score(doc=786,freq=3.0), product of:
             0.10550405 = queryWeight, product of:
               6.1714344 = idf(docFreq=250, maxDocs=44218)
               0.017095547 = queryNorm
             0.8350967 = fieldWeight in 786, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.1714344 = idf(docFreq=250, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.14439596 = weight(abstract_txt:heuristics in 786) [ClassicSimilarity], result of:
           0.14439596 = score(doc=786,freq=2.0), product of:
             0.16788001 = queryWeight, product of:
               1.2614352 = boost
               7.7848644 = idf(docFreq=49, maxDocs=44218)
               0.017095547 = queryNorm
             0.8601141 = fieldWeight in 786, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               7.7848644 = idf(docFreq=49, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.052174896 = weight(abstract_txt:design in 786) [ClassicSimilarity], result of:
           0.052174896 = score(doc=786,freq=4.0), product of:
             0.08516674 = queryWeight, product of:
               1.2706193 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.017095547 = queryNorm
             0.6126206 = fieldWeight in 786, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.05957281 = weight(abstract_txt:tasks in 786) [ClassicSimilarity], result of:
           0.05957281 = score(doc=786,freq=1.0), product of:
             0.14768884 = queryWeight, product of:
               1.6732247 = boost
               5.1630983 = idf(docFreq=687, maxDocs=44218)
               0.017095547 = queryNorm
             0.40336704 = fieldWeight in 786, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1630983 = idf(docFreq=687, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.15923756 = weight(abstract_txt:designers in 786) [ClassicSimilarity], result of:
           0.15923756 = score(doc=786,freq=2.0), product of:
             0.22577159 = queryWeight, product of:
               2.0687838 = boost
               6.3836813 = idf(docFreq=202, maxDocs=44218)
               0.017095547 = queryNorm
             0.7053038 = fieldWeight in 786, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.3836813 = idf(docFreq=202, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.13158478 = weight(abstract_txt:conceptual in 786) [ClassicSimilarity], result of:
           0.13158478 = score(doc=786,freq=3.0), product of:
             0.19881207 = queryWeight, product of:
               2.3776474 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.017095547 = queryNorm
             0.6618551 = fieldWeight in 786, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.11997068 = weight(abstract_txt:database in 786) [ClassicSimilarity], result of:
           0.11997068 = score(doc=786,freq=2.0), product of:
             0.2537089 = queryWeight, product of:
               3.4675145 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.017095547 = queryNorm
             0.47286746 = fieldWeight in 786, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
       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.18421924 = sum of:
     0.18421924 = product of:
       0.7675802 = sum of:
         0.04307942 = weight(abstract_txt:reduce in 186) [ClassicSimilarity], result of:
           0.04307942 = score(doc=186,freq=1.0), product of:
             0.109586954 = queryWeight, product of:
               1.0191659 = boost
               6.2897153 = idf(docFreq=222, maxDocs=44218)
               0.017095547 = queryNorm
             0.3931072 = fieldWeight in 186, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.2897153 = idf(docFreq=222, maxDocs=44218)
               0.0625 = fieldNorm(doc=186)
         0.05406037 = weight(abstract_txt:occurrence in 186) [ClassicSimilarity], result of:
           0.05406037 = score(doc=186,freq=1.0), product of:
             0.12749651 = queryWeight, product of:
               1.0992959 = boost
               6.784232 = idf(docFreq=135, maxDocs=44218)
               0.017095547 = queryNorm
             0.4240145 = fieldWeight in 186, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.784232 = idf(docFreq=135, maxDocs=44218)
               0.0625 = fieldNorm(doc=186)
         0.124579646 = weight(abstract_txt:error in 186) [ClassicSimilarity], result of:
           0.124579646 = score(doc=186,freq=5.0), product of:
             0.13008294 = queryWeight, product of:
               1.1103902 = boost
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.017095547 = queryNorm
             0.957694 = fieldWeight in 186, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.0625 = fieldNorm(doc=186)
         0.060776412 = weight(abstract_txt:conceptual in 186) [ClassicSimilarity], result of:
           0.060776412 = score(doc=186,freq=1.0), product of:
             0.19881207 = queryWeight, product of:
               2.3776474 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.017095547 = queryNorm
             0.3056978 = fieldWeight in 186, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.0625 = fieldNorm(doc=186)
         0.09597655 = weight(abstract_txt:database in 186) [ClassicSimilarity], result of:
           0.09597655 = score(doc=186,freq=2.0), product of:
             0.2537089 = queryWeight, product of:
               3.4675145 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.017095547 = queryNorm
             0.37829396 = fieldWeight in 186, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.0625 = fieldNorm(doc=186)
         0.38910782 = weight(abstract_txt:errors in 186) [ClassicSimilarity], result of:
           0.38910782 = score(doc=186,freq=4.0), product of:
             0.47529027 = queryWeight, product of:
               4.2449727 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.017095547 = queryNorm
             0.8186741 = fieldWeight in 186, 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=186)
       0.24 = coord(6/25)
   

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

   0.14222631 = sum of:
     0.14222631 = product of:
       0.88891447 = sum of:
         0.13928427 = weight(abstract_txt:error in 3134) [ClassicSimilarity], result of:
           0.13928427 = score(doc=3134,freq=4.0), product of:
             0.13008294 = queryWeight, product of:
               1.1103902 = boost
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.017095547 = queryNorm
             1.0707344 = fieldWeight in 3134, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.8527 = idf(docFreq=126, maxDocs=44218)
               0.078125 = fieldNorm(doc=3134)
         0.2587708 = weight(abstract_txt:causes in 3134) [ClassicSimilarity], result of:
           0.2587708 = score(doc=3134,freq=3.0), product of:
             0.27261645 = queryWeight, product of:
               2.2732985 = boost
               7.014756 = idf(docFreq=107, maxDocs=44218)
               0.017095547 = queryNorm
             0.949212 = fieldWeight in 3134, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               7.014756 = idf(docFreq=107, maxDocs=44218)
               0.078125 = fieldNorm(doc=3134)
         0.14693347 = weight(abstract_txt:database in 3134) [ClassicSimilarity], result of:
           0.14693347 = score(doc=3134,freq=3.0), product of:
             0.2537089 = queryWeight, product of:
               3.4675145 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.017095547 = queryNorm
             0.579142 = fieldWeight in 3134, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.078125 = fieldNorm(doc=3134)
         0.34392595 = weight(abstract_txt:errors in 3134) [ClassicSimilarity], result of:
           0.34392595 = score(doc=3134,freq=2.0), product of:
             0.47529027 = queryWeight, product of:
               4.2449727 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.017095547 = queryNorm
             0.7236124 = fieldWeight in 3134, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.078125 = fieldNorm(doc=3134)
       0.16 = coord(4/25)