Document (#29149)

Author

Rhyno, A.

Title

XML and relational databases : uses and opportunities for libraries

Source

OCLC systems and services. 18(2002) no.2, S.97-103

Year

2002

Abstract

Art is the Systems Librarian at the Leddy Library, University of Windsor, Ontario, Canada. His article describes how an XML encoded document can be transported to a relational database management system (RDBMS). Once transported, SQL (Structured Query Language) can be used to retrieve the desired information. Choice of database type (relational or object-oriented) may be different depending on whether the data is data-centric or document-centric. Many middleware are available for mapping MARC to XML-based relational database. Art continues on with the applications of OpenURL. Because the framework is encoded in XML, it can take advantages of Xinclude, Xpath, and Xlink mechanisms. He compares the Web to a growing RDBMS, which contains rows of Web links. When encoded with the OpenURL framework, it is possible to provide extensive search and retrieval functions in web-based library services.

Object

XML
SQL

Similar documents (content)

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

   0.09613501 = sum of:
     0.09613501 = product of:
       0.48067504 = sum of:
         0.01778318 = weight(abstract_txt:based in 781) [ClassicSimilarity], result of:
           0.01778318 = score(doc=781,freq=2.0), product of:
             0.050565872 = queryWeight, product of:
               1.0637839 = boost
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.014933349 = queryNorm
             0.35168344 = fieldWeight in 781, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.012643586 = weight(abstract_txt:library in 781) [ClassicSimilarity], result of:
           0.012643586 = score(doc=781,freq=1.0), product of:
             0.050750624 = queryWeight, product of:
               1.0657254 = boost
               3.188885 = idf(docFreq=4976, maxDocs=44421)
               0.014933349 = queryNorm
             0.24913163 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.188885 = idf(docFreq=4976, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.020365246 = weight(abstract_txt:data in 781) [ClassicSimilarity], result of:
           0.020365246 = score(doc=781,freq=2.0), product of:
             0.055349153 = queryWeight, product of:
               1.1129614 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.014933349 = 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.06491484 = weight(abstract_txt:database in 781) [ClassicSimilarity], result of:
           0.06491484 = score(doc=781,freq=2.0), product of:
             0.13722849 = queryWeight, product of:
               2.1463099 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.014933349 = 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.3649682 = weight(abstract_txt:relational in 781) [ClassicSimilarity], result of:
           0.3649682 = score(doc=781,freq=3.0), product of:
             0.41719025 = queryWeight, product of:
               4.3212233 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.014933349 = 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)
   

2. Friedrich, M.; Schimkat, R.-D.; Küchlin, W.: Information retrieval in distributed environments based on context-aware, proactive documents (2002) 0.09

   0.09447504 = sum of:
     0.09447504 = product of:
       0.590469 = sum of:
         0.01760445 = weight(abstract_txt:based in 4608) [ClassicSimilarity], result of:
           0.01760445 = score(doc=4608,freq=1.0), product of:
             0.050565872 = queryWeight, product of:
               1.0637839 = boost
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.014933349 = queryNorm
             0.34814885 = fieldWeight in 4608, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.109375 = fieldNorm(doc=4608)
         0.07486416 = weight(abstract_txt:document in 4608) [ClassicSimilarity], result of:
           0.07486416 = score(doc=4608,freq=3.0), product of:
             0.0920276 = queryWeight, product of:
               1.4351051 = boost
               4.29415 = idf(docFreq=1647, maxDocs=44421)
               0.014933349 = queryNorm
             0.8134968 = fieldWeight in 4608, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.29415 = idf(docFreq=1647, maxDocs=44421)
               0.109375 = fieldNorm(doc=4608)
         0.21978651 = weight(abstract_txt:middleware in 4608) [ClassicSimilarity], result of:
           0.21978651 = score(doc=4608,freq=1.0), product of:
             0.21598978 = queryWeight, product of:
               1.5546272 = boost
               9.303573 = idf(docFreq=10, maxDocs=44421)
               0.014933349 = queryNorm
             1.0175782 = fieldWeight in 4608, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               9.303573 = idf(docFreq=10, maxDocs=44421)
               0.109375 = fieldNorm(doc=4608)
         0.27821392 = weight(abstract_txt:centric in 4608) [ClassicSimilarity], result of:
           0.27821392 = score(doc=4608,freq=1.0), product of:
             0.3184406 = queryWeight, product of:
               2.669555 = boost
               7.9878955 = idf(docFreq=40, maxDocs=44421)
               0.014933349 = queryNorm
             0.87367606 = fieldWeight in 4608, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.9878955 = idf(docFreq=40, maxDocs=44421)
               0.109375 = fieldNorm(doc=4608)
       0.16 = coord(4/25)
   

3. Boeder, R.: Database applications for libraries : an introduction (1996) 0.08

   0.084670946 = sum of:
     0.084670946 = product of:
       0.5291934 = sum of:
         0.059081968 = weight(abstract_txt:librarian in 1340) [ClassicSimilarity], result of:
           0.059081968 = score(doc=1340,freq=1.0), product of:
             0.089964084 = queryWeight, product of:
               1.003331 = boost
               6.004374 = idf(docFreq=297, maxDocs=44421)
               0.014933349 = queryNorm
             0.6567284 = fieldWeight in 1340, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.004374 = idf(docFreq=297, maxDocs=44421)
               0.109375 = fieldNorm(doc=1340)
         0.01770102 = weight(abstract_txt:library in 1340) [ClassicSimilarity], result of:
           0.01770102 = score(doc=1340,freq=1.0), product of:
             0.050750624 = queryWeight, product of:
               1.0657254 = boost
               3.188885 = idf(docFreq=4976, maxDocs=44421)
               0.014933349 = queryNorm
             0.3487843 = fieldWeight in 1340, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.188885 = idf(docFreq=4976, maxDocs=44421)
               0.109375 = fieldNorm(doc=1340)
         0.15741013 = weight(abstract_txt:database in 1340) [ClassicSimilarity], result of:
           0.15741013 = score(doc=1340,freq=6.0), product of:
             0.13722849 = queryWeight, product of:
               2.1463099 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.014933349 = queryNorm
             1.147066 = fieldWeight in 1340, product of:
               2.4494898 = tf(freq=6.0), with freq of:
                 6.0 = termFreq=6.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.109375 = fieldNorm(doc=1340)
         0.29500028 = weight(abstract_txt:relational in 1340) [ClassicSimilarity], result of:
           0.29500028 = score(doc=1340,freq=1.0), product of:
             0.41719025 = queryWeight, product of:
               4.3212233 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.014933349 = queryNorm
             0.70711213 = fieldWeight in 1340, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.109375 = fieldNorm(doc=1340)
       0.16 = coord(4/25)
   

4. Van de Sompel, H.; Beit-Arie, O.: Generalizing the OpenURL framework beyond references to scholarly works : the Bison-Futé model (2001) 0.08

   0.080239065 = sum of:
     0.080239065 = product of:
       0.6686589 = sum of:
         0.014226544 = weight(abstract_txt:based in 2223) [ClassicSimilarity], result of:
           0.014226544 = score(doc=2223,freq=2.0), product of:
             0.050565872 = queryWeight, product of:
               1.0637839 = boost
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.014933349 = queryNorm
             0.28134674 = fieldWeight in 2223, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.0625 = fieldNorm(doc=2223)
         0.0717102 = weight(abstract_txt:framework in 2223) [ClassicSimilarity], result of:
           0.0717102 = score(doc=2223,freq=6.0), product of:
             0.10307138 = queryWeight, product of:
               1.5187758 = boost
               4.5445113 = idf(docFreq=1282, maxDocs=44421)
               0.014933349 = queryNorm
             0.69573337 = fieldWeight in 2223, product of:
               2.4494898 = tf(freq=6.0), with freq of:
                 6.0 = termFreq=6.0
               4.5445113 = idf(docFreq=1282, maxDocs=44421)
               0.0625 = fieldNorm(doc=2223)
         0.5827222 = weight(abstract_txt:openurl in 2223) [ClassicSimilarity], result of:
           0.5827222 = score(doc=2223,freq=6.0), product of:
             0.41660568 = queryWeight, product of:
               3.0534248 = boost
               9.1365185 = idf(docFreq=12, maxDocs=44421)
               0.014933349 = queryNorm
             1.398738 = fieldWeight in 2223, product of:
               2.4494898 = tf(freq=6.0), with freq of:
                 6.0 = termFreq=6.0
               9.1365185 = idf(docFreq=12, maxDocs=44421)
               0.0625 = fieldNorm(doc=2223)
       0.12 = coord(3/25)
   

5. Multimedia, knowledge-based and object-oriented databases (1996) 0.08

   0.07746671 = sum of:
     0.07746671 = product of:
       0.48416698 = sum of:
         0.02011937 = weight(abstract_txt:based in 583) [ClassicSimilarity], result of:
           0.02011937 = score(doc=583,freq=1.0), product of:
             0.050565872 = queryWeight, product of:
               1.0637839 = boost
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.014933349 = queryNorm
             0.3978844 = fieldWeight in 583, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.1830752 = idf(docFreq=5005, maxDocs=44421)
               0.125 = fieldNorm(doc=583)
         0.023040645 = weight(abstract_txt:data in 583) [ClassicSimilarity], result of:
           0.023040645 = score(doc=583,freq=1.0), product of:
             0.055349153 = queryWeight, product of:
               1.1129614 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.014933349 = queryNorm
             0.41627818 = fieldWeight in 583, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.125 = fieldNorm(doc=583)
         0.10386374 = weight(abstract_txt:database in 583) [ClassicSimilarity], result of:
           0.10386374 = score(doc=583,freq=2.0), product of:
             0.13722849 = queryWeight, product of:
               2.1463099 = boost
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.014933349 = queryNorm
             0.7568672 = fieldWeight in 583, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2814875 = idf(docFreq=1668, maxDocs=44421)
               0.125 = fieldNorm(doc=583)
         0.3371432 = weight(abstract_txt:relational in 583) [ClassicSimilarity], result of:
           0.3371432 = score(doc=583,freq=1.0), product of:
             0.41719025 = queryWeight, product of:
               4.3212233 = boost
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.014933349 = queryNorm
             0.8081282 = fieldWeight in 583, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.4650254 = idf(docFreq=187, maxDocs=44421)
               0.125 = fieldNorm(doc=583)
       0.16 = coord(4/25)