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.23435019 = sum of:
     0.23435019 = product of:
       0.83696496 = sum of:
         0.011695107 = weight(abstract_txt:research in 1412) [ClassicSimilarity], result of:
           0.011695107 = score(doc=1412,freq=1.0), product of:
             0.047378857 = queryWeight, product of:
               1.0765946 = boost
               3.159582 = idf(docFreq=5124, maxDocs=44421)
               0.01392845 = queryNorm
             0.24684234 = fieldWeight in 1412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.159582 = idf(docFreq=5124, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
         0.046833906 = weight(abstract_txt:beginning in 1412) [ClassicSimilarity], result of:
           0.046833906 = score(doc=1412,freq=1.0), product of:
             0.09482992 = queryWeight, product of:
               1.0770047 = boost
               6.3215704 = idf(docFreq=216, maxDocs=44421)
               0.01392845 = queryNorm
             0.4938727 = fieldWeight in 1412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.3215704 = idf(docFreq=216, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
         0.04704 = weight(abstract_txt:2007 in 1412) [ClassicSimilarity], result of:
           0.04704 = score(doc=1412,freq=1.0), product of:
             0.09510791 = queryWeight, product of:
               1.0785822 = boost
               6.3308296 = idf(docFreq=214, maxDocs=44421)
               0.01392845 = queryNorm
             0.49459606 = fieldWeight in 1412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.3308296 = idf(docFreq=214, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
         0.030621134 = weight(abstract_txt:data in 1412) [ClassicSimilarity], result of:
           0.030621134 = score(doc=1412,freq=5.0), product of:
             0.052634757 = queryWeight, product of:
               1.1347396 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.01392845 = queryNorm
             0.5817664 = fieldWeight in 1412, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
         0.09326058 = weight(abstract_txt:integrating in 1412) [ClassicSimilarity], result of:
           0.09326058 = score(doc=1412,freq=1.0), product of:
             0.18910971 = queryWeight, product of:
               2.1508832 = boost
               6.312396 = idf(docFreq=218, maxDocs=44421)
               0.01392845 = queryNorm
             0.49315596 = fieldWeight in 1412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.312396 = idf(docFreq=218, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
         0.11159712 = weight(abstract_txt:databases in 1412) [ClassicSimilarity], result of:
           0.11159712 = score(doc=1412,freq=1.0), product of:
             0.3236233 = queryWeight, product of:
               5.263975 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.01392845 = queryNorm
             0.34483647 = fieldWeight in 1412, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
         0.4959171 = weight(abstract_txt:relational in 1412) [ClassicSimilarity], result of:
           0.4959171 = score(doc=1412,freq=2.0), product of:
             0.6942787 = queryWeight, product of:
               7.710115 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.01392845 = queryNorm
             0.7142911 = fieldWeight in 1412, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.078125 = fieldNorm(doc=1412)
       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.20469241 = sum of:
     0.20469241 = product of:
       0.7310443 = sum of:
         0.038138986 = weight(abstract_txt:stored in 1475) [ClassicSimilarity], result of:
           0.038138986 = score(doc=1475,freq=1.0), product of:
             0.095960215 = queryWeight, product of:
               1.0834042 = boost
               6.3591332 = idf(docFreq=208, maxDocs=44421)
               0.01392845 = queryNorm
             0.39744583 = fieldWeight in 1475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.3591332 = idf(docFreq=208, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
         0.0109553505 = weight(abstract_txt:data in 1475) [ClassicSimilarity], result of:
           0.0109553505 = score(doc=1475,freq=1.0), product of:
             0.052634757 = queryWeight, product of:
               1.1347396 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.01392845 = queryNorm
             0.20813909 = fieldWeight in 1475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
         0.05672477 = weight(abstract_txt:mappings in 1475) [ClassicSimilarity], result of:
           0.05672477 = score(doc=1475,freq=1.0), product of:
             0.12503366 = queryWeight, product of:
               1.236683 = boost
               7.2588162 = idf(docFreq=84, maxDocs=44421)
               0.01392845 = queryNorm
             0.45367602 = fieldWeight in 1475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.2588162 = idf(docFreq=84, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
         0.009226609 = weight(abstract_txt:with in 1475) [ClassicSimilarity], result of:
           0.009226609 = score(doc=1475,freq=1.0), product of:
             0.059141617 = queryWeight, product of:
               1.7010673 = boost
               2.4961398 = idf(docFreq=9949, maxDocs=44421)
               0.01392845 = queryNorm
             0.15600874 = fieldWeight in 1475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4961398 = idf(docFreq=9949, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
         0.12625773 = weight(abstract_txt:databases in 1475) [ClassicSimilarity], result of:
           0.12625773 = score(doc=1475,freq=2.0), product of:
             0.3236233 = queryWeight, product of:
               5.263975 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.01392845 = queryNorm
             0.39013794 = fieldWeight in 1475, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
         0.093007125 = weight(abstract_txt:semantic in 1475) [ClassicSimilarity], result of:
           0.093007125 = score(doc=1475,freq=1.0), product of:
             0.33257425 = queryWeight, product of:
               5.3362756 = boost
               4.4745317 = idf(docFreq=1375, maxDocs=44421)
               0.01392845 = queryNorm
             0.27965823 = fieldWeight in 1475, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4745317 = idf(docFreq=1375, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
         0.3967337 = weight(abstract_txt:relational in 1475) [ClassicSimilarity], result of:
           0.3967337 = score(doc=1475,freq=2.0), product of:
             0.6942787 = queryWeight, product of:
               7.710115 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.01392845 = queryNorm
             0.5714329 = fieldWeight in 1475, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.0625 = fieldNorm(doc=1475)
       0.28 = coord(7/25)
   

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

   0.18956451 = sum of:
     0.18956451 = product of:
       0.9478226 = sum of:
         0.019366506 = weight(abstract_txt:data in 781) [ClassicSimilarity], result of:
           0.019366506 = score(doc=781,freq=2.0), product of:
             0.052634757 = queryWeight, product of:
               1.1347396 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.01392845 = queryNorm
             0.3679414 = fieldWeight in 781, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.011533261 = weight(abstract_txt:with in 781) [ClassicSimilarity], result of:
           0.011533261 = score(doc=781,freq=1.0), product of:
             0.059141617 = queryWeight, product of:
               1.7010673 = boost
               2.4961398 = idf(docFreq=9949, maxDocs=44421)
               0.01392845 = queryNorm
             0.19501092 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4961398 = idf(docFreq=9949, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.19329189 = weight(abstract_txt:databases in 781) [ClassicSimilarity], result of:
           0.19329189 = score(doc=781,freq=3.0), product of:
             0.3236233 = queryWeight, product of:
               5.263975 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.01392845 = 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.116258904 = weight(abstract_txt:semantic in 781) [ClassicSimilarity], result of:
           0.116258904 = score(doc=781,freq=1.0), product of:
             0.33257425 = queryWeight, product of:
               5.3362756 = boost
               4.4745317 = idf(docFreq=1375, maxDocs=44421)
               0.01392845 = queryNorm
             0.34957278 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4745317 = idf(docFreq=1375, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.607372 = weight(abstract_txt:relational in 781) [ClassicSimilarity], result of:
           0.607372 = score(doc=781,freq=3.0), product of:
             0.6942787 = queryWeight, product of:
               7.710115 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.01392845 = 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.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.18550532 = sum of:
     0.18550532 = product of:
       0.77293885 = sum of:
         0.046936635 = weight(abstract_txt:integrate in 7148) [ClassicSimilarity], result of:
           0.046936635 = score(doc=7148,freq=1.0), product of:
             0.094968535 = queryWeight, product of:
               1.0777916 = boost
               6.326189 = idf(docFreq=215, maxDocs=44421)
               0.01392845 = queryNorm
             0.49423352 = fieldWeight in 7148, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.326189 = idf(docFreq=215, maxDocs=44421)
               0.078125 = fieldNorm(doc=7148)
         0.013694188 = weight(abstract_txt:data in 7148) [ClassicSimilarity], result of:
           0.013694188 = score(doc=7148,freq=1.0), product of:
             0.052634757 = queryWeight, product of:
               1.1347396 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.01392845 = queryNorm
             0.26017386 = fieldWeight in 7148, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.078125 = fieldNorm(doc=7148)
         0.011533261 = weight(abstract_txt:with in 7148) [ClassicSimilarity], result of:
           0.011533261 = score(doc=7148,freq=1.0), product of:
             0.059141617 = queryWeight, product of:
               1.7010673 = boost
               2.4961398 = idf(docFreq=9949, maxDocs=44421)
               0.01392845 = queryNorm
             0.19501092 = fieldWeight in 7148, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               2.4961398 = idf(docFreq=9949, maxDocs=44421)
               0.078125 = fieldNorm(doc=7148)
         0.09326058 = weight(abstract_txt:integrating in 7148) [ClassicSimilarity], result of:
           0.09326058 = score(doc=7148,freq=1.0), product of:
             0.18910971 = queryWeight, product of:
               2.1508832 = boost
               6.312396 = idf(docFreq=218, maxDocs=44421)
               0.01392845 = queryNorm
             0.49315596 = fieldWeight in 7148, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.312396 = idf(docFreq=218, maxDocs=44421)
               0.078125 = fieldNorm(doc=7148)
         0.11159712 = weight(abstract_txt:databases in 7148) [ClassicSimilarity], result of:
           0.11159712 = score(doc=7148,freq=1.0), product of:
             0.3236233 = queryWeight, product of:
               5.263975 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.01392845 = queryNorm
             0.34483647 = fieldWeight in 7148, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.078125 = fieldNorm(doc=7148)
         0.4959171 = weight(abstract_txt:relational in 7148) [ClassicSimilarity], result of:
           0.4959171 = score(doc=7148,freq=2.0), product of:
             0.6942787 = queryWeight, product of:
               7.710115 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.01392845 = queryNorm
             0.7142911 = fieldWeight in 7148, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.078125 = fieldNorm(doc=7148)
       0.24 = coord(6/25)
   

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

   0.17762981 = sum of:
     0.17762981 = product of:
       1.4802485 = sum of:
         0.028462837 = weight(abstract_txt:data in 6741) [ClassicSimilarity], result of:
           0.028462837 = score(doc=6741,freq=3.0), product of:
             0.052634757 = queryWeight, product of:
               1.1347396 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.01392845 = queryNorm
             0.54076123 = fieldWeight in 6741, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.09375 = fieldNorm(doc=6741)
         0.18938659 = weight(abstract_txt:databases in 6741) [ClassicSimilarity], result of:
           0.18938659 = score(doc=6741,freq=2.0), product of:
             0.3236233 = queryWeight, product of:
               5.263975 = boost
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.01392845 = queryNorm
             0.5852069 = fieldWeight in 6741, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.413907 = idf(docFreq=1461, maxDocs=44421)
               0.09375 = fieldNorm(doc=6741)
         1.262399 = weight(abstract_txt:relational in 6741) [ClassicSimilarity], result of:
           1.262399 = score(doc=6741,freq=9.0), product of:
             0.6942787 = queryWeight, product of:
               7.710115 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.01392845 = queryNorm
             1.8182884 = fieldWeight in 6741, product of:
               3.0 = tf(freq=9.0), with freq of:
                 9.0 = termFreq=9.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.09375 = fieldNorm(doc=6741)
       0.12 = coord(3/25)