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.096318506 = sum of:
     0.096318506 = product of:
       0.48159254 = sum of:
         0.012612193 = weight(abstract_txt:library in 7712) [ClassicSimilarity], result of:
           0.012612193 = score(doc=7712,freq=1.0), product of:
             0.050659027 = queryWeight, product of:
               1.0622761 = boost
               3.1867187 = idf(docFreq=4964, maxDocs=44218)
               0.014964964 = queryNorm
             0.2489624 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.1867187 = idf(docFreq=4964, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.017856644 = weight(abstract_txt:based in 7712) [ClassicSimilarity], result of:
           0.017856644 = score(doc=7712,freq=2.0), product of:
             0.050697476 = queryWeight, product of:
               1.0626792 = boost
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.014964964 = queryNorm
             0.35221958 = fieldWeight in 7712, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.020468611 = weight(abstract_txt:data in 7712) [ClassicSimilarity], result of:
           0.020468611 = score(doc=7712,freq=2.0), product of:
             0.055528 = queryWeight, product of:
               1.1121542 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.014964964 = 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.06481401 = weight(abstract_txt:database in 7712) [ClassicSimilarity], result of:
           0.06481401 = score(doc=7712,freq=2.0), product of:
             0.13706592 = queryWeight, product of:
               2.1400275 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.014964964 = 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.36584106 = weight(abstract_txt:relational in 7712) [ClassicSimilarity], result of:
           0.36584106 = score(doc=7712,freq=3.0), product of:
             0.41779283 = queryWeight, product of:
               4.314242 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.014964964 = 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)
   

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

   0.09471784 = sum of:
     0.09471784 = product of:
       0.5919865 = sum of:
         0.017677175 = weight(abstract_txt:based in 3608) [ClassicSimilarity], result of:
           0.017677175 = score(doc=3608,freq=1.0), product of:
             0.050697476 = queryWeight, product of:
               1.0626792 = boost
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.014964964 = queryNorm
             0.3486796 = fieldWeight in 3608, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.109375 = fieldNorm(doc=3608)
         0.07475011 = weight(abstract_txt:document in 3608) [ClassicSimilarity], result of:
           0.07475011 = score(doc=3608,freq=3.0), product of:
             0.0919204 = queryWeight, product of:
               1.4309187 = boost
               4.2926083 = idf(docFreq=1642, maxDocs=44218)
               0.014964964 = queryNorm
             0.8132048 = fieldWeight in 3608, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.2926083 = idf(docFreq=1642, maxDocs=44218)
               0.109375 = fieldNorm(doc=3608)
         0.21936385 = weight(abstract_txt:middleware in 3608) [ClassicSimilarity], result of:
           0.21936385 = score(doc=3608,freq=1.0), product of:
             0.21568063 = queryWeight, product of:
               1.5498854 = boost
               9.298992 = idf(docFreq=10, maxDocs=44218)
               0.014964964 = queryNorm
             1.0170772 = fieldWeight in 3608, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               9.298992 = idf(docFreq=10, maxDocs=44218)
               0.109375 = fieldNorm(doc=3608)
         0.28019536 = weight(abstract_txt:centric in 3608) [ClassicSimilarity], result of:
           0.28019536 = score(doc=3608,freq=1.0), product of:
             0.31990305 = queryWeight, product of:
               2.6694279 = boost
               8.008008 = idf(docFreq=39, maxDocs=44218)
               0.014964964 = queryNorm
             0.8758759 = fieldWeight in 3608, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.008008 = idf(docFreq=39, maxDocs=44218)
               0.109375 = fieldNorm(doc=3608)
       0.16 = coord(4/25)
   

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

   0.084711835 = sum of:
     0.084711835 = product of:
       0.529449 = sum of:
         0.058920488 = weight(abstract_txt:librarian in 340) [ClassicSimilarity], result of:
           0.058920488 = score(doc=340,freq=1.0), product of:
             0.08978669 = queryWeight, product of:
               5.9997935 = idf(docFreq=297, maxDocs=44218)
               0.014964964 = queryNorm
             0.6562274 = fieldWeight in 340, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.9997935 = idf(docFreq=297, maxDocs=44218)
               0.109375 = fieldNorm(doc=340)
         0.017657071 = weight(abstract_txt:library in 340) [ClassicSimilarity], result of:
           0.017657071 = score(doc=340,freq=1.0), product of:
             0.050659027 = queryWeight, product of:
               1.0622761 = boost
               3.1867187 = idf(docFreq=4964, maxDocs=44218)
               0.014964964 = queryNorm
             0.34854737 = fieldWeight in 340, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.1867187 = idf(docFreq=4964, maxDocs=44218)
               0.109375 = fieldNorm(doc=340)
         0.15716563 = weight(abstract_txt:database in 340) [ClassicSimilarity], result of:
           0.15716563 = score(doc=340,freq=6.0), product of:
             0.13706592 = queryWeight, product of:
               2.1400275 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.014964964 = queryNorm
             1.1466427 = fieldWeight in 340, product of:
               2.4494898 = tf(freq=6.0), with freq of:
                 6.0 = termFreq=6.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.109375 = fieldNorm(doc=340)
         0.2957058 = weight(abstract_txt:relational in 340) [ClassicSimilarity], result of:
           0.2957058 = score(doc=340,freq=1.0), product of:
             0.41779283 = queryWeight, product of:
               4.314242 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.014964964 = queryNorm
             0.70778096 = fieldWeight in 340, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.109375 = fieldNorm(doc=340)
       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.08014227 = sum of:
     0.08014227 = product of:
       0.6678522 = sum of:
         0.014285314 = weight(abstract_txt:based in 1223) [ClassicSimilarity], result of:
           0.014285314 = score(doc=1223,freq=2.0), product of:
             0.050697476 = queryWeight, product of:
               1.0626792 = boost
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.014964964 = queryNorm
             0.28177565 = fieldWeight in 1223, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.0625 = fieldNorm(doc=1223)
         0.071980976 = weight(abstract_txt:framework in 1223) [ClassicSimilarity], result of:
           0.071980976 = score(doc=1223,freq=6.0), product of:
             0.10331527 = queryWeight, product of:
               1.5170199 = boost
               4.550903 = idf(docFreq=1268, maxDocs=44218)
               0.014964964 = queryNorm
             0.6967119 = fieldWeight in 1223, product of:
               2.4494898 = tf(freq=6.0), with freq of:
                 6.0 = termFreq=6.0
               4.550903 = idf(docFreq=1268, maxDocs=44218)
               0.0625 = fieldNorm(doc=1223)
         0.58158594 = weight(abstract_txt:openurl in 1223) [ClassicSimilarity], result of:
           0.58158594 = score(doc=1223,freq=6.0), product of:
             0.4160019 = queryWeight, product of:
               3.044084 = boost
               9.131938 = idf(docFreq=12, maxDocs=44218)
               0.014964964 = queryNorm
             1.3980368 = fieldWeight in 1223, product of:
               2.4494898 = tf(freq=6.0), with freq of:
                 6.0 = termFreq=6.0
               9.131938 = idf(docFreq=12, maxDocs=44218)
               0.0625 = fieldNorm(doc=1223)
       0.12 = coord(3/25)
   

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

   0.07760192 = sum of:
     0.07760192 = product of:
       0.485012 = sum of:
         0.020202486 = weight(abstract_txt:based in 7514) [ClassicSimilarity], result of:
           0.020202486 = score(doc=7514,freq=1.0), product of:
             0.050697476 = queryWeight, product of:
               1.0626792 = boost
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.014964964 = queryNorm
             0.39849097 = fieldWeight in 7514, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.1879277 = idf(docFreq=4958, maxDocs=44218)
               0.125 = fieldNorm(doc=7514)
         0.023157591 = weight(abstract_txt:data in 7514) [ClassicSimilarity], result of:
           0.023157591 = score(doc=7514,freq=1.0), product of:
             0.055528 = queryWeight, product of:
               1.1121542 = boost
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.014964964 = queryNorm
             0.41704348 = fieldWeight in 7514, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3363478 = idf(docFreq=4274, maxDocs=44218)
               0.125 = fieldNorm(doc=7514)
         0.10370242 = weight(abstract_txt:database in 7514) [ClassicSimilarity], result of:
           0.10370242 = score(doc=7514,freq=2.0), product of:
             0.13706592 = queryWeight, product of:
               2.1400275 = boost
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.014964964 = queryNorm
             0.7565879 = fieldWeight in 7514, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2799077 = idf(docFreq=1663, maxDocs=44218)
               0.125 = fieldNorm(doc=7514)
         0.3379495 = weight(abstract_txt:relational in 7514) [ClassicSimilarity], result of:
           0.3379495 = score(doc=7514,freq=1.0), product of:
             0.41779283 = queryWeight, product of:
               4.314242 = boost
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.014964964 = queryNorm
             0.80889255 = fieldWeight in 7514, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.4711404 = idf(docFreq=185, maxDocs=44218)
               0.125 = fieldNorm(doc=7514)
       0.16 = coord(4/25)