Document (#40937)

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.23477997 = sum of:
      0.23477997 = product of:
        0.8384999 = sum of:
          0.046349835 = weight(abstract_txt:2007 in 2413) [ClassicSimilarity], result of:
            0.046349835 = score(doc=2413,freq=1.0), product of:
              0.093945235 = queryWeight, product of:
                1.0737774 = boost
                6.315146 = idf(docFreq=207, maxDocs=42306)
                0.013854061 = queryNorm
              0.49337077 = fieldWeight in 2413, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.315146 = idf(docFreq=207, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
          0.046670463 = weight(abstract_txt:beginning in 2413) [ClassicSimilarity], result of:
            0.046670463 = score(doc=2413,freq=1.0), product of:
              0.09437799 = queryWeight, product of:
                1.0762477 = boost
                6.3296742 = idf(docFreq=204, maxDocs=42306)
                0.013854061 = queryNorm
              0.4945058 = fieldWeight in 2413, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.3296742 = idf(docFreq=204, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
          0.012380743 = weight(abstract_txt:research in 2413) [ClassicSimilarity], result of:
            0.012380743 = score(doc=2413,freq=1.0), product of:
              0.049092725 = queryWeight, product of:
                1.0977424 = boost
                3.228045 = idf(docFreq=4557, maxDocs=42306)
                0.013854061 = queryNorm
              0.252191 = fieldWeight in 2413, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.228045 = idf(docFreq=4557, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
          0.03185608 = weight(abstract_txt:data in 2413) [ClassicSimilarity], result of:
            0.03185608 = score(doc=2413,freq=5.0), product of:
              0.05390853 = queryWeight, product of:
                1.1503252 = boost
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.013854061 = queryNorm
              0.5909283 = fieldWeight in 2413, product of:
                2.236068 = tf(freq=5.0), with freq of:
                  5.0 = termFreq=5.0
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
          0.094661236 = weight(abstract_txt:integrating in 2413) [ClassicSimilarity], result of:
            0.094661236 = score(doc=2413,freq=1.0), product of:
              0.19053178 = queryWeight, product of:
                2.162597 = boost
                6.3593793 = idf(docFreq=198, maxDocs=42306)
                0.013854061 = queryNorm
              0.4968265 = fieldWeight in 2413, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.3593793 = idf(docFreq=198, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
          0.10904714 = weight(abstract_txt:databases in 2413) [ClassicSimilarity], result of:
            0.10904714 = score(doc=2413,freq=1.0), product of:
              0.31789583 = queryWeight, product of:
                5.225987 = boost
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.013854061 = queryNorm
              0.3430279 = fieldWeight in 2413, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
          0.4975344 = weight(abstract_txt:relational in 2413) [ClassicSimilarity], result of:
            0.4975344 = score(doc=2413,freq=2.0), product of:
              0.6940872 = queryWeight, product of:
                7.7220554 = boost
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.013854061 = queryNorm
              0.7168183 = fieldWeight in 2413, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.078125 = fieldNorm(doc=2413)
        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.20444073 = sum of:
      0.20444073 = product of:
        0.73014545 = sum of:
          0.037422962 = weight(abstract_txt:stored in 2476) [ClassicSimilarity], result of:
            0.037422962 = score(doc=2476,freq=1.0), product of:
              0.094523855 = queryWeight, product of:
                1.077079 = boost
                6.334564 = idf(docFreq=203, maxDocs=42306)
                0.013854061 = queryNorm
              0.39591026 = fieldWeight in 2476, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.334564 = idf(docFreq=203, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
          0.011397176 = weight(abstract_txt:data in 2476) [ClassicSimilarity], result of:
            0.011397176 = score(doc=2476,freq=1.0), product of:
              0.05390853 = queryWeight, product of:
                1.1503252 = boost
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.013854061 = queryNorm
              0.21141694 = fieldWeight in 2476, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
          0.05658601 = weight(abstract_txt:mappings in 2476) [ClassicSimilarity], result of:
            0.05658601 = score(doc=2476,freq=1.0), product of:
              0.12452466 = queryWeight, product of:
                1.236245 = boost
                7.2706575 = idf(docFreq=79, maxDocs=42306)
                0.013854061 = queryNorm
              0.4544161 = fieldWeight in 2476, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.2706575 = idf(docFreq=79, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
          0.009498501 = weight(abstract_txt:with in 2476) [ClassicSimilarity], result of:
            0.009498501 = score(doc=2476,freq=1.0), product of:
              0.060150515 = queryWeight, product of:
                1.7184091 = boost
                2.5265954 = idf(docFreq=9191, maxDocs=42306)
                0.013854061 = queryNorm
              0.15791221 = fieldWeight in 2476, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                2.5265954 = idf(docFreq=9191, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
          0.12337275 = weight(abstract_txt:databases in 2476) [ClassicSimilarity], result of:
            0.12337275 = score(doc=2476,freq=2.0), product of:
              0.31789583 = queryWeight, product of:
                5.225987 = boost
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.013854061 = queryNorm
              0.38809174 = fieldWeight in 2476, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
          0.09384058 = weight(abstract_txt:semantic in 2476) [ClassicSimilarity], result of:
            0.09384058 = score(doc=2476,freq=1.0), product of:
              0.33374065 = queryWeight, product of:
                5.354642 = boost
                4.4988503 = idf(docFreq=1278, maxDocs=42306)
                0.013854061 = queryNorm
              0.28117815 = fieldWeight in 2476, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.4988503 = idf(docFreq=1278, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
          0.3980275 = weight(abstract_txt:relational in 2476) [ClassicSimilarity], result of:
            0.3980275 = score(doc=2476,freq=2.0), product of:
              0.6940872 = queryWeight, product of:
                7.7220554 = boost
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.013854061 = queryNorm
              0.5734546 = fieldWeight in 2476, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.0625 = fieldNorm(doc=2476)
        0.28 = coord(7/25)
    
  3. Green, R.: ¬The design of a relational database for large-scale bibliographic retrieval (1996) 0.19
    0.18950985 = sum of:
      0.18950985 = product of:
        0.9475493 = sum of:
          0.020147553 = weight(abstract_txt:data in 782) [ClassicSimilarity], result of:
            0.020147553 = score(doc=782,freq=2.0), product of:
              0.05390853 = queryWeight, product of:
                1.1503252 = boost
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.013854061 = queryNorm
              0.37373587 = fieldWeight in 782, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.078125 = fieldNorm(doc=782)
          0.011873126 = weight(abstract_txt:with in 782) [ClassicSimilarity], result of:
            0.011873126 = score(doc=782,freq=1.0), product of:
              0.060150515 = queryWeight, product of:
                1.7184091 = boost
                2.5265954 = idf(docFreq=9191, maxDocs=42306)
                0.013854061 = queryNorm
              0.19739026 = fieldWeight in 782, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                2.5265954 = idf(docFreq=9191, maxDocs=42306)
                0.078125 = fieldNorm(doc=782)
          0.18887517 = weight(abstract_txt:databases in 782) [ClassicSimilarity], result of:
            0.18887517 = score(doc=782,freq=3.0), product of:
              0.31789583 = queryWeight, product of:
                5.225987 = boost
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.013854061 = queryNorm
              0.5941417 = fieldWeight in 782, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.078125 = fieldNorm(doc=782)
          0.11730072 = weight(abstract_txt:semantic in 782) [ClassicSimilarity], result of:
            0.11730072 = score(doc=782,freq=1.0), product of:
              0.33374065 = queryWeight, product of:
                5.354642 = boost
                4.4988503 = idf(docFreq=1278, maxDocs=42306)
                0.013854061 = queryNorm
              0.35147268 = fieldWeight in 782, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.4988503 = idf(docFreq=1278, maxDocs=42306)
                0.078125 = fieldNorm(doc=782)
          0.6093527 = weight(abstract_txt:relational in 782) [ClassicSimilarity], result of:
            0.6093527 = score(doc=782,freq=3.0), product of:
              0.6940872 = queryWeight, product of:
                7.7220554 = boost
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.013854061 = queryNorm
              0.8779195 = fieldWeight in 782, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.078125 = fieldNorm(doc=782)
        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.18598053 = sum of:
      0.18598053 = product of:
        0.7749189 = sum of:
          0.04755652 = weight(abstract_txt:integrate in 7149) [ClassicSimilarity], result of:
            0.04755652 = score(doc=7149,freq=1.0), product of:
              0.095568776 = queryWeight, product of:
                1.083016 = boost
                6.3694806 = idf(docFreq=196, maxDocs=42306)
                0.013854061 = queryNorm
              0.49761567 = fieldWeight in 7149, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.3694806 = idf(docFreq=196, maxDocs=42306)
                0.078125 = fieldNorm(doc=7149)
          0.01424647 = weight(abstract_txt:data in 7149) [ClassicSimilarity], result of:
            0.01424647 = score(doc=7149,freq=1.0), product of:
              0.05390853 = queryWeight, product of:
                1.1503252 = boost
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.013854061 = queryNorm
              0.26427117 = fieldWeight in 7149, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.078125 = fieldNorm(doc=7149)
          0.011873126 = weight(abstract_txt:with in 7149) [ClassicSimilarity], result of:
            0.011873126 = score(doc=7149,freq=1.0), product of:
              0.060150515 = queryWeight, product of:
                1.7184091 = boost
                2.5265954 = idf(docFreq=9191, maxDocs=42306)
                0.013854061 = queryNorm
              0.19739026 = fieldWeight in 7149, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                2.5265954 = idf(docFreq=9191, maxDocs=42306)
                0.078125 = fieldNorm(doc=7149)
          0.094661236 = weight(abstract_txt:integrating in 7149) [ClassicSimilarity], result of:
            0.094661236 = score(doc=7149,freq=1.0), product of:
              0.19053178 = queryWeight, product of:
                2.162597 = boost
                6.3593793 = idf(docFreq=198, maxDocs=42306)
                0.013854061 = queryNorm
              0.4968265 = fieldWeight in 7149, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.3593793 = idf(docFreq=198, maxDocs=42306)
                0.078125 = fieldNorm(doc=7149)
          0.10904714 = weight(abstract_txt:databases in 7149) [ClassicSimilarity], result of:
            0.10904714 = score(doc=7149,freq=1.0), product of:
              0.31789583 = queryWeight, product of:
                5.225987 = boost
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.013854061 = queryNorm
              0.3430279 = fieldWeight in 7149, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.078125 = fieldNorm(doc=7149)
          0.4975344 = weight(abstract_txt:relational in 7149) [ClassicSimilarity], result of:
            0.4975344 = score(doc=7149,freq=2.0), product of:
              0.6940872 = queryWeight, product of:
                7.7220554 = boost
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.013854061 = queryNorm
              0.7168183 = fieldWeight in 7149, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.078125 = fieldNorm(doc=7149)
        0.24 = coord(6/25)
    
  5. Ghosh, S.P.: Statistical databases : design of experiment structures (1993) 0.18
    0.17774227 = sum of:
      0.17774227 = product of:
        1.4811857 = sum of:
          0.029610733 = weight(abstract_txt:data in 6742) [ClassicSimilarity], result of:
            0.029610733 = score(doc=6742,freq=3.0), product of:
              0.05390853 = queryWeight, product of:
                1.1503252 = boost
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.013854061 = queryNorm
              0.5492773 = fieldWeight in 6742, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                3.382671 = idf(docFreq=3904, maxDocs=42306)
                0.09375 = fieldNorm(doc=6742)
          0.18505912 = weight(abstract_txt:databases in 6742) [ClassicSimilarity], result of:
            0.18505912 = score(doc=6742,freq=2.0), product of:
              0.31789583 = queryWeight, product of:
                5.225987 = boost
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.013854061 = queryNorm
              0.5821376 = fieldWeight in 6742, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.390757 = idf(docFreq=1424, maxDocs=42306)
                0.09375 = fieldNorm(doc=6742)
          1.2665159 = weight(abstract_txt:relational in 6742) [ClassicSimilarity], result of:
            1.2665159 = score(doc=6742,freq=9.0), product of:
              0.6940872 = queryWeight, product of:
                7.7220554 = boost
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.013854061 = queryNorm
              1.8247215 = fieldWeight in 6742, product of:
                3.0 = tf(freq=9.0), with freq of:
                  9.0 = termFreq=9.0
                6.4878983 = idf(docFreq=174, maxDocs=42306)
                0.09375 = fieldNorm(doc=6742)
        0.12 = coord(3/25)