Document (#8563)

Author

Batra, D.
Sein, M.K.

Title

Improving conceptual database design through feedback

Source

International journal of human-computer studies. 40(1994) no.4, S.653-676

Year

1994

Abstract

Design aids can improve the quality of systems developed by end users and non-expert designers. Reports a study undertaken to establish the concept validation of a design aid that is based on feedback to improve the quality of conceptual and logical relational databases. Describes the design of SERFER (Simulated ER based FEedback system for Relational databases) and test its results show that feedback can help users detect and correct certain types of database design errors in modelling ternary relationships. However, no improvements seems possible in the case of unary relationship. The experiment could not determine whether errors can be corrected in modelling binary relationships, since the subjects were reasonably adept and rarely committed serious errors in this case

Similar documents (author)

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

   1.7481558 = sum of:
     1.7481558 = product of:
       3.4963117 = sum of:
         3.4963117 = weight(author_txt:batra in 3004) [ClassicSimilarity], result of:
           3.4963117 = score(doc=3004,freq=1.0), product of:
             0.7167836 = queryWeight, product of:
               1.0138776 = boost
               9.755557 = idf(docFreq=6, maxDocs=44421)
               0.0724687 = queryNorm
             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)
       0.5 = coord(1/2)
   

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

   1.7481558 = sum of:
     1.7481558 = product of:
       3.4963117 = sum of:
         3.4963117 = weight(author_txt:batra in 8237) [ClassicSimilarity], result of:
           3.4963117 = score(doc=8237,freq=1.0), product of:
             0.7167836 = queryWeight, product of:
               1.0138776 = boost
               9.755557 = idf(docFreq=6, maxDocs=44421)
               0.0724687 = queryNorm
             4.8777785 = fieldWeight in 8237, 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=8237)
       0.5 = coord(1/2)
   

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

   1.7481558 = sum of:
     1.7481558 = product of:
       3.4963117 = sum of:
         3.4963117 = weight(author_txt:batra in 854) [ClassicSimilarity], result of:
           3.4963117 = score(doc=854,freq=1.0), product of:
             0.7167836 = queryWeight, product of:
               1.0138776 = boost
               9.755557 = idf(docFreq=6, maxDocs=44421)
               0.0724687 = queryNorm
             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)
       0.5 = coord(1/2)
   

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

   1.7481558 = sum of:
     1.7481558 = product of:
       3.4963117 = sum of:
         3.4963117 = weight(author_txt:batra in 4177) [ClassicSimilarity], result of:
           3.4963117 = score(doc=4177,freq=1.0), product of:
             0.7167836 = queryWeight, product of:
               1.0138776 = boost
               9.755557 = idf(docFreq=6, maxDocs=44421)
               0.0724687 = queryNorm
             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)
       0.5 = coord(1/2)
   

5. Am Ziel sollte etwas sein: Hier ist nix 1.47

   1.4676808 = sum of:
     1.4676808 = product of:
       2.9353616 = sum of:
         2.9353616 = weight(author_txt:sein in 5206) [ClassicSimilarity], result of:
           2.9353616 = score(doc=5206,freq=1.0), product of:
             0.6972957 = queryWeight, product of:
               9.622026 = idf(docFreq=7, maxDocs=44421)
               0.0724687 = queryNorm
             4.2096367 = fieldWeight in 5206, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               9.622026 = idf(docFreq=7, maxDocs=44421)
               0.4375 = fieldNorm(doc=5206)
       0.5 = coord(1/2)
   

Similar documents (content)

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

   0.25201884 = sum of:
     0.25201884 = product of:
       1.0500785 = sum of:
         0.1582153 = weight(abstract_txt:committed in 8237) [ClassicSimilarity], result of:
           0.1582153 = score(doc=8237,freq=1.0), product of:
             0.20332228 = queryWeight, product of:
               1.23806 = boost
               8.30027 = idf(docFreq=29, maxDocs=44421)
               0.019785682 = queryNorm
             0.7781503 = fieldWeight in 8237, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.30027 = idf(docFreq=29, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.08685919 = weight(abstract_txt:database in 8237) [ClassicSimilarity], result of:
           0.08685919 = score(doc=8237,freq=4.0), product of:
             0.10819815 = queryWeight, product of:
               1.2772448 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.019785682 = 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.09108674 = weight(abstract_txt:conceptual in 8237) [ClassicSimilarity], result of:
           0.09108674 = score(doc=8237,freq=2.0), product of:
             0.14070928 = queryWeight, product of:
               1.4565506 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.019785682 = queryNorm
             0.64733994 = fieldWeight in 8237, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.22704044 = weight(abstract_txt:modelling in 8237) [ClassicSimilarity], result of:
           0.22704044 = score(doc=8237,freq=2.0), product of:
             0.2586752 = queryWeight, product of:
               1.974884 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.019785682 = queryNorm
             0.87770474 = fieldWeight in 8237, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.08321778 = weight(abstract_txt:design in 8237) [ClassicSimilarity], result of:
           0.08321778 = score(doc=8237,freq=1.0), product of:
             0.22654442 = queryWeight, product of:
               2.9222066 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.019785682 = queryNorm
             0.36733535 = fieldWeight in 8237, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.09375 = fieldNorm(doc=8237)
         0.40365902 = weight(abstract_txt:errors in 8237) [ClassicSimilarity], result of:
           0.40365902 = score(doc=8237,freq=3.0), product of:
             0.37963167 = queryWeight, product of:
               2.9301581 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.019785682 = 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.24 = coord(6/25)
   

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

   0.16735916 = sum of:
     0.16735916 = product of:
       0.6973298 = sum of:
         0.08995205 = weight(abstract_txt:binary in 3004) [ClassicSimilarity], result of:
           0.08995205 = score(doc=3004,freq=1.0), product of:
             0.15757266 = queryWeight, product of:
               1.0899075 = boost
               7.3070183 = idf(docFreq=80, maxDocs=44421)
               0.019785682 = queryNorm
             0.5708608 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.3070183 = idf(docFreq=80, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.03619133 = weight(abstract_txt:database in 3004) [ClassicSimilarity], result of:
           0.03619133 = score(doc=3004,freq=1.0), product of:
             0.10819815 = queryWeight, product of:
               1.2772448 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.019785682 = 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.07590561 = weight(abstract_txt:conceptual in 3004) [ClassicSimilarity], result of:
           0.07590561 = score(doc=3004,freq=2.0), product of:
             0.14070928 = queryWeight, product of:
               1.4565506 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.019785682 = 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.23172216 = weight(abstract_txt:modelling in 3004) [ClassicSimilarity], result of:
           0.23172216 = score(doc=3004,freq=3.0), product of:
             0.2586752 = queryWeight, product of:
               1.974884 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.019785682 = 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.06934815 = weight(abstract_txt:design in 3004) [ClassicSimilarity], result of:
           0.06934815 = score(doc=3004,freq=1.0), product of:
             0.22654442 = queryWeight, product of:
               2.9222066 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.019785682 = 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.19421054 = weight(abstract_txt:errors in 3004) [ClassicSimilarity], result of:
           0.19421054 = score(doc=3004,freq=1.0), product of:
             0.37963167 = queryWeight, product of:
               2.9301581 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.019785682 = 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.24 = coord(6/25)
   

3. Green, R.: ¬The design of a relational database for large-scale bibliographic retrieval (1996) 0.16

   0.16417736 = sum of:
     0.16417736 = product of:
       0.6840723 = sum of:
         0.051182266 = weight(abstract_txt:database in 781) [ClassicSimilarity], result of:
           0.051182266 = score(doc=781,freq=2.0), product of:
             0.10819815 = queryWeight, product of:
               1.2772448 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.019785682 = queryNorm
             0.47304198 = fieldWeight in 781, 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=781)
         0.06868322 = weight(abstract_txt:databases in 781) [ClassicSimilarity], result of:
           0.06868322 = score(doc=781,freq=3.0), product of:
             0.11499444 = queryWeight, product of:
               1.3167479 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.019785682 = queryNorm
             0.5972743 = fieldWeight in 781, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.07590561 = weight(abstract_txt:conceptual in 781) [ClassicSimilarity], result of:
           0.07590561 = score(doc=781,freq=2.0), product of:
             0.14070928 = queryWeight, product of:
               1.4565506 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.019785682 = queryNorm
             0.53944993 = fieldWeight in 781, 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=781)
         0.21582007 = weight(abstract_txt:relational in 781) [ClassicSimilarity], result of:
           0.21582007 = score(doc=781,freq=3.0), product of:
             0.24670102 = queryWeight, product of:
               1.9286335 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.019785682 = queryNorm
             0.8748244 = fieldWeight in 781, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.13378485 = weight(abstract_txt:modelling in 781) [ClassicSimilarity], result of:
           0.13378485 = score(doc=781,freq=1.0), product of:
             0.2586752 = queryWeight, product of:
               1.974884 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.019785682 = queryNorm
             0.5171924 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.1386963 = weight(abstract_txt:design in 781) [ClassicSimilarity], result of:
           0.1386963 = score(doc=781,freq=4.0), product of:
             0.22654442 = queryWeight, product of:
               2.9222066 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.019785682 = queryNorm
             0.6122256 = fieldWeight in 781, 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=781)
       0.24 = coord(6/25)
   

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

   0.1504444 = sum of:
     0.1504444 = product of:
       0.6268517 = sum of:
         0.051182266 = weight(abstract_txt:database in 854) [ClassicSimilarity], result of:
           0.051182266 = score(doc=854,freq=2.0), product of:
             0.10819815 = queryWeight, product of:
               1.2772448 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.019785682 = 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.056079615 = weight(abstract_txt:databases in 854) [ClassicSimilarity], result of:
           0.056079615 = score(doc=854,freq=2.0), product of:
             0.11499444 = queryWeight, product of:
               1.3167479 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.019785682 = queryNorm
             0.48767242 = fieldWeight in 854, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.07210842 = weight(abstract_txt:relationships in 854) [ClassicSimilarity], result of:
           0.07210842 = score(doc=854,freq=2.0), product of:
             0.13597658 = queryWeight, product of:
               1.4318459 = boost
               4.7997303 = idf(docFreq=993, maxDocs=44421)
               0.019785682 = queryNorm
             0.53030026 = fieldWeight in 854, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.7997303 = idf(docFreq=993, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.092965014 = weight(abstract_txt:conceptual in 854) [ClassicSimilarity], result of:
           0.092965014 = score(doc=854,freq=3.0), product of:
             0.14070928 = queryWeight, product of:
               1.4565506 = boost
               4.8825436 = idf(docFreq=914, maxDocs=44421)
               0.019785682 = 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.21582007 = weight(abstract_txt:relational in 854) [ClassicSimilarity], result of:
           0.21582007 = score(doc=854,freq=3.0), product of:
             0.24670102 = queryWeight, product of:
               1.9286335 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.019785682 = queryNorm
             0.8748244 = fieldWeight in 854, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.078125 = fieldNorm(doc=854)
         0.1386963 = weight(abstract_txt:design in 854) [ClassicSimilarity], result of:
           0.1386963 = score(doc=854,freq=4.0), product of:
             0.22654442 = queryWeight, product of:
               2.9222066 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.019785682 = 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.24 = coord(6/25)
   

5. Beall, J.; Kafadar, K.: ¬The effectiveness of copy cotaloging at eliminating typographical errors in shared bibliographic records (2004) 0.14

   0.14286186 = sum of:
     0.14286186 = product of:
       0.89288664 = sum of:
         0.043429594 = weight(abstract_txt:database in 5849) [ClassicSimilarity], result of:
           0.043429594 = score(doc=5849,freq=1.0), product of:
             0.10819815 = queryWeight, product of:
               1.2772448 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.019785682 = queryNorm
             0.40138945 = fieldWeight in 5849, 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=5849)
         0.27289855 = weight(abstract_txt:corrected in 5849) [ClassicSimilarity], result of:
           0.27289855 = score(doc=5849,freq=2.0), product of:
             0.23210089 = queryWeight, product of:
               1.32278 = boost
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.019785682 = queryNorm
             1.1757755 = fieldWeight in 5849, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.09375 = fieldNorm(doc=5849)
         0.055436935 = weight(abstract_txt:quality in 5849) [ClassicSimilarity], result of:
           0.055436935 = score(doc=5849,freq=1.0), product of:
             0.12731965 = queryWeight, product of:
               1.3855172 = boost
               4.6444306 = idf(docFreq=1160, maxDocs=44421)
               0.019785682 = queryNorm
             0.4354154 = fieldWeight in 5849, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.6444306 = idf(docFreq=1160, maxDocs=44421)
               0.09375 = fieldNorm(doc=5849)
         0.52112156 = weight(abstract_txt:errors in 5849) [ClassicSimilarity], result of:
           0.52112156 = score(doc=5849,freq=5.0), product of:
             0.37963167 = queryWeight, product of:
               2.9301581 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.019785682 = queryNorm
             1.3727031 = fieldWeight in 5849, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.09375 = fieldNorm(doc=5849)
       0.16 = coord(4/25)