Document (#40936)

Author

Sequeda, J.F.

Title

Integrating relational databases with the Semantic Web : a reflection

Source

Reasoning Web: Semantic Interoperability on the Web, 13th International Summer School 2017, London, UK, July 7-11, 2017, Tutorial Lectures. Eds.: Ianni, G. et al

Imprint

Cham : Springer International Publishing

Year

2017

Pages

S.68-120

Series

Lecture Notes in Computer Scienc;10370) (Information Systems and Applications, incl. Internet/Web, and HCI

Abstract

From the beginning it was understood that the success of the Semantic Web hinges on integrating the vast amount of data stored in Relational Databases. This manuscript reflects on the last 10 years of our research results to integrate Relational Databases with the Semantic Web. Since 2007, our research has led us to answer the following question: How and to what extent can Relational Databases be Integrated with the Semantic Web? The answer comes in two parts. We start by presenting how to get from Relational Databases to the Semantic Web via mappings, such as the W3C Direct Mapping and R2RML standards. Subsequently, we present how the Semantic Web can access Relational Databases. We finalize with how Relational Databases and Semantic Web technologies are being used practice for data integration and discuss open challenges.

Theme

Semantic Web

Similar documents (content)

1. Hassanzadeh, O.; Kementsietsidis, A.; Lim, L.; Miller, R.J.; Wang, M.: Semantic link discovery over relational data (2012) 0.23

   0.23467794 = sum of:
     0.23467794 = product of:
       0.8381355 = sum of:
         0.046775743 = weight(abstract_txt:beginning in 412) [ClassicSimilarity], result of:
           0.046775743 = score(doc=412,freq=1.0), product of:
             0.09471157 = queryWeight, product of:
               1.0756882 = boost
               6.321609 = idf(docFreq=215, maxDocs=44218)
               0.013928007 = queryNorm
             0.4938757 = fieldWeight in 412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.321609 = idf(docFreq=215, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
         0.046982534 = weight(abstract_txt:2007 in 412) [ClassicSimilarity], result of:
           0.046982534 = score(doc=412,freq=1.0), product of:
             0.0949905 = queryWeight, product of:
               1.077271 = boost
               6.330911 = idf(docFreq=213, maxDocs=44218)
               0.013928007 = queryNorm
             0.49460244 = fieldWeight in 412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.330911 = idf(docFreq=213, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
         0.011800067 = weight(abstract_txt:research in 412) [ClassicSimilarity], result of:
           0.011800067 = score(doc=412,freq=1.0), product of:
             0.047641877 = queryWeight, product of:
               1.0789326 = boost
               3.170338 = idf(docFreq=5046, maxDocs=44218)
               0.013928007 = queryNorm
             0.24768265 = fieldWeight in 412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.170338 = idf(docFreq=5046, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
         0.030751532 = weight(abstract_txt:data in 412) [ClassicSimilarity], result of:
           0.030751532 = score(doc=412,freq=5.0), product of:
             0.052761897 = queryWeight, product of:
               1.1354293 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.013928007 = queryNorm
             0.582836 = fieldWeight in 412, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
         0.09375764 = weight(abstract_txt:integrating in 412) [ClassicSimilarity], result of:
           0.09375764 = score(doc=412,freq=1.0), product of:
             0.18970132 = queryWeight, product of:
               2.1529555 = boost
               6.326249 = idf(docFreq=214, maxDocs=44218)
               0.013928007 = queryNorm
             0.4942382 = fieldWeight in 412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.326249 = idf(docFreq=214, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
         0.111369066 = weight(abstract_txt:databases in 412) [ClassicSimilarity], result of:
           0.111369066 = score(doc=412,freq=1.0), product of:
             0.32304645 = queryWeight, product of:
               5.2561336 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.013928007 = queryNorm
             0.3447463 = fieldWeight in 412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
         0.49669892 = weight(abstract_txt:relational in 412) [ClassicSimilarity], result of:
           0.49669892 = score(doc=412,freq=2.0), product of:
             0.69471616 = queryWeight, product of:
               7.707927 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.013928007 = queryNorm
             0.7149667 = fieldWeight in 412, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.078125 = fieldNorm(doc=412)
       0.28 = coord(7/25)
   

2. Bozzato, L.; Braghin, S.; Trombetta, A.: ¬A method and guidelines for the cooperation of ontologies and relational databases in Semantic Web applications (2012) 0.20

   0.20477088 = sum of:
     0.20477088 = product of:
       0.73132455 = sum of:
         0.03800868 = weight(abstract_txt:stored in 475) [ClassicSimilarity], result of:
           0.03800868 = score(doc=475,freq=1.0), product of:
             0.095701285 = queryWeight, product of:
               1.081294 = boost
               6.3545527 = idf(docFreq=208, maxDocs=44218)
               0.013928007 = queryNorm
             0.39715955 = fieldWeight in 475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.3545527 = idf(docFreq=208, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
         0.011002002 = weight(abstract_txt:data in 475) [ClassicSimilarity], result of:
           0.011002002 = score(doc=475,freq=1.0), product of:
             0.052761897 = queryWeight, product of:
               1.1354293 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.013928007 = queryNorm
             0.20852174 = fieldWeight in 475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
         0.056823317 = weight(abstract_txt:mappings in 475) [ClassicSimilarity], result of:
           0.056823317 = score(doc=475,freq=1.0), product of:
             0.12512583 = queryWeight, product of:
               1.2363982 = boost
               7.2660704 = idf(docFreq=83, maxDocs=44218)
               0.013928007 = queryNorm
             0.4541294 = fieldWeight in 475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.2660704 = idf(docFreq=83, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
         0.009254839 = weight(abstract_txt:with in 475) [ClassicSimilarity], result of:
           0.009254839 = score(doc=475,freq=1.0), product of:
             0.059237286 = queryWeight, product of:
               1.7014236 = boost
               2.4997334 = idf(docFreq=9868, maxDocs=44218)
               0.013928007 = queryNorm
             0.15623334 = fieldWeight in 475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4997334 = idf(docFreq=9868, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
         0.1259997 = weight(abstract_txt:databases in 475) [ClassicSimilarity], result of:
           0.1259997 = score(doc=475,freq=2.0), product of:
             0.32304645 = queryWeight, product of:
               5.2561336 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.013928007 = queryNorm
             0.3900359 = fieldWeight in 475, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
         0.09287683 = weight(abstract_txt:semantic in 475) [ClassicSimilarity], result of:
           0.09287683 = score(doc=475,freq=1.0), product of:
             0.33212394 = queryWeight, product of:
               5.3294697 = boost
               4.4743214 = idf(docFreq=1369, maxDocs=44218)
               0.013928007 = queryNorm
             0.2796451 = fieldWeight in 475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4743214 = idf(docFreq=1369, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
         0.39735916 = weight(abstract_txt:relational in 475) [ClassicSimilarity], result of:
           0.39735916 = score(doc=475,freq=2.0), product of:
             0.69471616 = queryWeight, product of:
               7.707927 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.013928007 = queryNorm
             0.5719734 = fieldWeight in 475, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.0625 = fieldNorm(doc=475)
       0.28 = coord(7/25)
   

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

   0.18966798 = sum of:
     0.18966798 = product of:
       0.94833994 = sum of:
         0.019448977 = weight(abstract_txt:data in 7712) [ClassicSimilarity], result of:
           0.019448977 = score(doc=7712,freq=2.0), product of:
             0.052761897 = queryWeight, product of:
               1.1354293 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.013928007 = queryNorm
             0.36861783 = fieldWeight in 7712, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.011568548 = weight(abstract_txt:with in 7712) [ClassicSimilarity], result of:
           0.011568548 = score(doc=7712,freq=1.0), product of:
             0.059237286 = queryWeight, product of:
               1.7014236 = boost
               2.4997334 = idf(docFreq=9868, maxDocs=44218)
               0.013928007 = queryNorm
             0.19529167 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4997334 = idf(docFreq=9868, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.19289687 = weight(abstract_txt:databases in 7712) [ClassicSimilarity], result of:
           0.19289687 = score(doc=7712,freq=3.0), product of:
             0.32304645 = queryWeight, product of:
               5.2561336 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.013928007 = 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.116096035 = weight(abstract_txt:semantic in 7712) [ClassicSimilarity], result of:
           0.116096035 = score(doc=7712,freq=1.0), product of:
             0.33212394 = queryWeight, product of:
               5.3294697 = boost
               4.4743214 = idf(docFreq=1369, maxDocs=44218)
               0.013928007 = queryNorm
             0.34955636 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4743214 = idf(docFreq=1369, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.6083295 = weight(abstract_txt:relational in 7712) [ClassicSimilarity], result of:
           0.6083295 = score(doc=7712,freq=3.0), product of:
             0.69471616 = queryWeight, product of:
               7.707927 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.013928007 = 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.2 = coord(5/25)
   

4. Hoogeveen, M.J.; Meer, K. van der: Integration of information retrieval and database management in support of multimedia police work (1994) 0.19

   0.18576612 = sum of:
     0.18576612 = product of:
       0.7740255 = sum of:
         0.04687882 = weight(abstract_txt:integrate in 7149) [ClassicSimilarity], result of:
           0.04687882 = score(doc=7149,freq=1.0), product of:
             0.09485066 = queryWeight, product of:
               1.0764778 = boost
               6.326249 = idf(docFreq=214, maxDocs=44218)
               0.013928007 = queryNorm
             0.4942382 = fieldWeight in 7149, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.326249 = idf(docFreq=214, maxDocs=44218)
               0.078125 = fieldNorm(doc=7149)
         0.013752504 = weight(abstract_txt:data in 7149) [ClassicSimilarity], result of:
           0.013752504 = score(doc=7149,freq=1.0), product of:
             0.052761897 = queryWeight, product of:
               1.1354293 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.013928007 = queryNorm
             0.26065218 = fieldWeight in 7149, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.078125 = fieldNorm(doc=7149)
         0.011568548 = weight(abstract_txt:with in 7149) [ClassicSimilarity], result of:
           0.011568548 = score(doc=7149,freq=1.0), product of:
             0.059237286 = queryWeight, product of:
               1.7014236 = boost
               2.4997334 = idf(docFreq=9868, maxDocs=44218)
               0.013928007 = queryNorm
             0.19529167 = fieldWeight in 7149, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4997334 = idf(docFreq=9868, maxDocs=44218)
               0.078125 = fieldNorm(doc=7149)
         0.09375764 = weight(abstract_txt:integrating in 7149) [ClassicSimilarity], result of:
           0.09375764 = score(doc=7149,freq=1.0), product of:
             0.18970132 = queryWeight, product of:
               2.1529555 = boost
               6.326249 = idf(docFreq=214, maxDocs=44218)
               0.013928007 = queryNorm
             0.4942382 = fieldWeight in 7149, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.326249 = idf(docFreq=214, maxDocs=44218)
               0.078125 = fieldNorm(doc=7149)
         0.111369066 = weight(abstract_txt:databases in 7149) [ClassicSimilarity], result of:
           0.111369066 = score(doc=7149,freq=1.0), product of:
             0.32304645 = queryWeight, product of:
               5.2561336 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.013928007 = queryNorm
             0.3447463 = fieldWeight in 7149, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.078125 = fieldNorm(doc=7149)
         0.49669892 = weight(abstract_txt:relational in 7149) [ClassicSimilarity], result of:
           0.49669892 = score(doc=7149,freq=2.0), product of:
             0.69471616 = queryWeight, product of:
               7.707927 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.013928007 = queryNorm
             0.7149667 = fieldWeight in 7149, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.078125 = fieldNorm(doc=7149)
       0.24 = coord(6/25)
   

5. Ghosh, S.P.: Statistical databases : design of experiment structures (1993) 0.18

   0.17783672 = sum of:
     0.17783672 = product of:
       1.4819727 = sum of:
         0.028584039 = weight(abstract_txt:data in 6742) [ClassicSimilarity], result of:
           0.028584039 = score(doc=6742,freq=3.0), product of:
             0.052761897 = queryWeight, product of:
               1.1354293 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.013928007 = queryNorm
             0.5417553 = fieldWeight in 6742, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.09375 = fieldNorm(doc=6742)
         0.18899956 = weight(abstract_txt:databases in 6742) [ClassicSimilarity], result of:
           0.18899956 = score(doc=6742,freq=2.0), product of:
             0.32304645 = queryWeight, product of:
               5.2561336 = boost
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.013928007 = queryNorm
             0.58505386 = fieldWeight in 6742, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.4127526 = idf(docFreq=1456, maxDocs=44218)
               0.09375 = fieldNorm(doc=6742)
         1.2643892 = weight(abstract_txt:relational in 6742) [ClassicSimilarity], result of:
           1.2643892 = score(doc=6742,freq=9.0), product of:
             0.69471616 = queryWeight, product of:
               7.707927 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.013928007 = queryNorm
             1.8200083 = fieldWeight in 6742, product of:
               3.0 = tf(freq=9.0), with freq of:
                 9.0 = termFreq=9.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.09375 = fieldNorm(doc=6742)
       0.12 = coord(3/25)