Document (#8564)

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.7473463 = sum of:
     1.7473463 = product of:
       3.4946926 = sum of:
         3.4946926 = weight(author_txt:batra in 3005) [ClassicSimilarity], result of:
           3.4946926 = score(doc=3005,freq=1.0), product of:
             0.7167882 = queryWeight, product of:
               1.0138843 = boost
               9.7509775 = idf(docFreq=6, maxDocs=44218)
               0.07250272 = queryNorm
             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)
       0.5 = coord(1/2)
   

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

   1.7473463 = sum of:
     1.7473463 = product of:
       3.4946926 = sum of:
         3.4946926 = weight(author_txt:batra in 8238) [ClassicSimilarity], result of:
           3.4946926 = score(doc=8238,freq=1.0), product of:
             0.7167882 = queryWeight, product of:
               1.0138843 = boost
               9.7509775 = idf(docFreq=6, maxDocs=44218)
               0.07250272 = queryNorm
             4.8754888 = fieldWeight in 8238, 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=8238)
       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.7473463 = sum of:
     1.7473463 = product of:
       3.4946926 = sum of:
         3.4946926 = weight(author_txt:batra in 786) [ClassicSimilarity], result of:
           3.4946926 = score(doc=786,freq=1.0), product of:
             0.7167882 = queryWeight, product of:
               1.0138843 = boost
               9.7509775 = idf(docFreq=6, maxDocs=44218)
               0.07250272 = queryNorm
             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)
       0.5 = coord(1/2)
   

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

   1.7473463 = sum of:
     1.7473463 = product of:
       3.4946926 = sum of:
         3.4946926 = weight(author_txt:batra in 4109) [ClassicSimilarity], result of:
           3.4946926 = score(doc=4109,freq=1.0), product of:
             0.7167882 = queryWeight, product of:
               1.0138843 = boost
               9.7509775 = idf(docFreq=6, maxDocs=44218)
               0.07250272 = queryNorm
             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)
       0.5 = coord(1/2)
   

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

   1.4669721 = sum of:
     1.4669721 = product of:
       2.9339442 = sum of:
         2.9339442 = weight(author_txt:sein in 5207) [ClassicSimilarity], result of:
           2.9339442 = score(doc=5207,freq=1.0), product of:
             0.69729096 = queryWeight, product of:
               9.617446 = idf(docFreq=7, maxDocs=44218)
               0.07250272 = queryNorm
             4.2076325 = fieldWeight in 5207, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               9.617446 = idf(docFreq=7, maxDocs=44218)
               0.4375 = fieldNorm(doc=5207)
       0.5 = coord(1/2)
   

Similar documents (content)

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

   0.25165227 = sum of:
     0.25165227 = product of:
       1.0485512 = sum of:
         0.15771767 = weight(abstract_txt:committed in 8238) [ClassicSimilarity], result of:
           0.15771767 = score(doc=8238,freq=1.0), product of:
             0.20279469 = queryWeight, product of:
               1.2369709 = boost
               8.29569 = idf(docFreq=29, maxDocs=44218)
               0.019762622 = queryNorm
             0.7777209 = fieldWeight in 8238, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.29569 = idf(docFreq=29, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.08663354 = weight(abstract_txt:database in 8238) [ClassicSimilarity], result of:
           0.08663354 = score(doc=8238,freq=4.0), product of:
             0.107956894 = queryWeight, product of:
               1.2763548 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.019762622 = 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.09143336 = weight(abstract_txt:conceptual in 8238) [ClassicSimilarity], result of:
           0.09143336 = score(doc=8238,freq=2.0), product of:
             0.14099579 = queryWeight, product of:
               1.4586439 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.019762622 = queryNorm
             0.6484829 = fieldWeight in 8238, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.22623117 = weight(abstract_txt:modelling in 8238) [ClassicSimilarity], result of:
           0.22623117 = score(doc=8238,freq=2.0), product of:
             0.25793165 = queryWeight, product of:
               1.9728703 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.019762622 = queryNorm
             0.87709737 = fieldWeight in 8238, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.08325447 = weight(abstract_txt:design in 8238) [ClassicSimilarity], result of:
           0.08325447 = score(doc=8238,freq=1.0), product of:
             0.22649817 = queryWeight, product of:
               2.923133 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.019762622 = queryNorm
             0.36757237 = fieldWeight in 8238, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.09375 = fieldNorm(doc=8238)
         0.40328103 = weight(abstract_txt:errors in 8238) [ClassicSimilarity], result of:
           0.40328103 = score(doc=8238,freq=3.0), product of:
             0.3792057 = queryWeight, product of:
               2.9297414 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.019762622 = 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.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.16709864 = sum of:
     0.16709864 = product of:
       0.69624436 = sum of:
         0.08964897 = weight(abstract_txt:binary in 3005) [ClassicSimilarity], result of:
           0.08964897 = score(doc=3005,freq=1.0), product of:
             0.15714023 = queryWeight, product of:
               1.0888672 = boost
               7.3024383 = idf(docFreq=80, maxDocs=44218)
               0.019762622 = queryNorm
             0.570503 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.3024383 = idf(docFreq=80, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.036097307 = weight(abstract_txt:database in 3005) [ClassicSimilarity], result of:
           0.036097307 = score(doc=3005,freq=1.0), product of:
             0.107956894 = queryWeight, product of:
               1.2763548 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.019762622 = 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.07619447 = weight(abstract_txt:conceptual in 3005) [ClassicSimilarity], result of:
           0.07619447 = score(doc=3005,freq=2.0), product of:
             0.14099579 = queryWeight, product of:
               1.4586439 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.019762622 = 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.23089622 = weight(abstract_txt:modelling in 3005) [ClassicSimilarity], result of:
           0.23089622 = score(doc=3005,freq=3.0), product of:
             0.25793165 = queryWeight, product of:
               1.9728703 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.019762622 = 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.06937872 = weight(abstract_txt:design in 3005) [ClassicSimilarity], result of:
           0.06937872 = score(doc=3005,freq=1.0), product of:
             0.22649817 = queryWeight, product of:
               2.923133 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.019762622 = 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.19402868 = weight(abstract_txt:errors in 3005) [ClassicSimilarity], result of:
           0.19402868 = score(doc=3005,freq=1.0), product of:
             0.3792057 = queryWeight, product of:
               2.9297414 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.019762622 = 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.24 = coord(6/25)
   

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

   0.16414703 = sum of:
     0.16414703 = product of:
       0.683946 = sum of:
         0.051049303 = weight(abstract_txt:database in 7712) [ClassicSimilarity], result of:
           0.051049303 = score(doc=7712,freq=2.0), product of:
             0.107956894 = queryWeight, product of:
               1.2763548 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.019762622 = queryNorm
             0.47286746 = fieldWeight in 7712, 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=7712)
         0.06852688 = weight(abstract_txt:databases in 7712) [ClassicSimilarity], result of:
           0.06852688 = score(doc=7712,freq=3.0), product of:
             0.11476269 = queryWeight, product of:
               1.3159717 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.019762622 = queryNorm
             0.5971181 = fieldWeight in 7712, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.07619447 = weight(abstract_txt:conceptual in 7712) [ClassicSimilarity], result of:
           0.07619447 = score(doc=7712,freq=2.0), product of:
             0.14099579 = queryWeight, product of:
               1.4586439 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.019762622 = queryNorm
             0.5404025 = fieldWeight in 7712, 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=7712)
         0.2161099 = weight(abstract_txt:relational in 7712) [ClassicSimilarity], result of:
           0.2161099 = score(doc=7712,freq=3.0), product of:
             0.24679889 = queryWeight, product of:
               1.9298245 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.019762622 = queryNorm
             0.87565184 = fieldWeight in 7712, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.13330801 = weight(abstract_txt:modelling in 7712) [ClassicSimilarity], result of:
           0.13330801 = score(doc=7712,freq=1.0), product of:
             0.25793165 = queryWeight, product of:
               1.9728703 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.019762622 = queryNorm
             0.5168346 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.13875744 = weight(abstract_txt:design in 7712) [ClassicSimilarity], result of:
           0.13875744 = score(doc=7712,freq=4.0), product of:
             0.22649817 = queryWeight, product of:
               2.923133 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.019762622 = queryNorm
             0.6126206 = fieldWeight in 7712, 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=7712)
       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.15060699 = sum of:
     0.15060699 = product of:
       0.62752914 = sum of:
         0.051049303 = weight(abstract_txt:database in 786) [ClassicSimilarity], result of:
           0.051049303 = score(doc=786,freq=2.0), product of:
             0.107956894 = queryWeight, product of:
               1.2763548 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.019762622 = 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.05595196 = weight(abstract_txt:databases in 786) [ClassicSimilarity], result of:
           0.05595196 = score(doc=786,freq=2.0), product of:
             0.11476269 = queryWeight, product of:
               1.3159717 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.019762622 = queryNorm
             0.48754486 = fieldWeight in 786, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.07234176 = weight(abstract_txt:relationships in 786) [ClassicSimilarity], result of:
           0.07234176 = score(doc=786,freq=2.0), product of:
             0.13620192 = queryWeight, product of:
               1.4336325 = boost
               4.807296 = idf(docFreq=981, maxDocs=44218)
               0.019762622 = queryNorm
             0.53113616 = fieldWeight in 786, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.807296 = idf(docFreq=981, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.09331878 = weight(abstract_txt:conceptual in 786) [ClassicSimilarity], result of:
           0.09331878 = score(doc=786,freq=3.0), product of:
             0.14099579 = queryWeight, product of:
               1.4586439 = boost
               4.891165 = idf(docFreq=902, maxDocs=44218)
               0.019762622 = 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.2161099 = weight(abstract_txt:relational in 786) [ClassicSimilarity], result of:
           0.2161099 = score(doc=786,freq=3.0), product of:
             0.24679889 = queryWeight, product of:
               1.9298245 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.019762622 = queryNorm
             0.87565184 = fieldWeight in 786, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.078125 = fieldNorm(doc=786)
         0.13875744 = weight(abstract_txt:design in 786) [ClassicSimilarity], result of:
           0.13875744 = score(doc=786,freq=4.0), product of:
             0.22649817 = queryWeight, product of:
               2.923133 = boost
               3.9207718 = idf(docFreq=2382, maxDocs=44218)
               0.019762622 = 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.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.14266805 = sum of:
     0.14266805 = product of:
       0.89167535 = sum of:
         0.04331677 = weight(abstract_txt:database in 4849) [ClassicSimilarity], result of:
           0.04331677 = score(doc=4849,freq=1.0), product of:
             0.107956894 = queryWeight, product of:
               1.2763548 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.019762622 = queryNorm
             0.40124136 = fieldWeight in 4849, 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=4849)
         0.27206907 = weight(abstract_txt:corrected in 4849) [ClassicSimilarity], result of:
           0.27206907 = score(doc=4849,freq=2.0), product of:
             0.23151499 = queryWeight, product of:
               1.3216631 = boost
               8.863674 = idf(docFreq=16, maxDocs=44218)
               0.019762622 = queryNorm
             1.1751683 = fieldWeight in 4849, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               8.863674 = idf(docFreq=16, maxDocs=44218)
               0.09375 = fieldNorm(doc=4849)
         0.055655908 = weight(abstract_txt:quality in 4849) [ClassicSimilarity], result of:
           0.055655908 = score(doc=4849,freq=1.0), product of:
             0.12759115 = queryWeight, product of:
               1.387575 = boost
               4.6528544 = idf(docFreq=1145, maxDocs=44218)
               0.019762622 = queryNorm
             0.4362051 = fieldWeight in 4849, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.6528544 = idf(docFreq=1145, maxDocs=44218)
               0.09375 = fieldNorm(doc=4849)
         0.5206336 = weight(abstract_txt:errors in 4849) [ClassicSimilarity], result of:
           0.5206336 = score(doc=4849,freq=5.0), product of:
             0.3792057 = queryWeight, product of:
               2.9297414 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.019762622 = queryNorm
             1.3729582 = fieldWeight in 4849, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.09375 = fieldNorm(doc=4849)
       0.16 = coord(4/25)