Document (#34603)

Author
Greene, A.
Title
Managing subject guides with SQL Server and ASP.Net
Source
Library hi tech. 26(2008) no.2, S.213-231
Year
2008
Abstract
Purpose - The purpose of this paper is to report on the content management solution for 50 subject guides maintained by librarian subject specialists at the University of Nevada, Reno Libraries. Design/methodology/approach - The Web Development Librarian designed an SQL Server database to store subject guide content and wrote ASP.Net scripts to generate dynamic web pages. Subject specialists provided input throughout the process. Hands-on workshops were held the summer before the new guides were launched. Findings - The new method has successfully produced consistent but individually customized subject guides while greatly reducing maintenance time. Simple reports reveal the association between guides and licensed resources. Using the system to create course-specific guides would be a useful follow-up project. Skills learned in training workshops should be refreshed at regular intervals to boost confidence and introduce changes in the system. Practical implications - The advantages of centralizing content and separating it from presentation cannot be overstated. More consistency and less maintenance is just the beginning. Once accomplished, a library can incorporate Web 2.0 features into the application by repurposing the data or modifying the ASP.Net template. The now-organized data is clean and ready to migrate to web services or next-generation research guides when the time is right. Originality/value - This paper uniquely reports on an SQL Server, ASP.Net solution for managing subject guides. SQL Server includes data management features that increase application security and ASP.Net offers built-in functionality for manipulating and presenting data. Utmost attention was given to creating simple user interfaces that enable subject specialists to create complex web pages without coding HTML.
Theme
Content Management System
Object
SQL Server

Similar documents (content)

  1. Fischer, T.; Neuroth, H.: SSG-FI - special subject gateways to high quality Internet resources for scientific users (2000) 0.14
    0.14245678 = sum of:
      0.14245678 = product of:
        0.7122839 = sum of:
          0.03749494 = weight(abstract_txt:create in 6287) [ClassicSimilarity], result of:
            0.03749494 = score(doc=6287,freq=1.0), product of:
              0.092819504 = queryWeight, product of:
                1.1571974 = boost
                5.170629 = idf(docFreq=647, maxDocs=41962)
                0.015512737 = queryNorm
              0.4039554 = fieldWeight in 6287, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.170629 = idf(docFreq=647, maxDocs=41962)
                0.078125 = fieldNorm(doc=6287)
          0.021275247 = weight(abstract_txt:data in 6287) [ClassicSimilarity], result of:
            0.021275247 = score(doc=6287,freq=1.0), product of:
              0.08015253 = queryWeight, product of:
                1.5207626 = boost
                3.3975618 = idf(docFreq=3815, maxDocs=41962)
                0.015512737 = queryNorm
              0.2654345 = fieldWeight in 6287, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.3975618 = idf(docFreq=3815, maxDocs=41962)
                0.078125 = fieldNorm(doc=6287)
          0.12794527 = weight(abstract_txt:specialists in 6287) [ClassicSimilarity], result of:
            0.12794527 = score(doc=6287,freq=1.0), product of:
              0.24082638 = queryWeight, product of:
                2.2828925 = boost
                6.8003325 = idf(docFreq=126, maxDocs=41962)
                0.015512737 = queryNorm
              0.531276 = fieldWeight in 6287, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.8003325 = idf(docFreq=126, maxDocs=41962)
                0.078125 = fieldNorm(doc=6287)
          0.12987728 = weight(abstract_txt:subject in 6287) [ClassicSimilarity], result of:
            0.12987728 = score(doc=6287,freq=4.0), product of:
              0.2124938 = queryWeight, product of:
                3.5017967 = boost
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.015512737 = queryNorm
              0.61120504 = fieldWeight in 6287, product of:
                2.0 = tf(freq=4.0), with freq of:
                  4.0 = termFreq=4.0
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.078125 = fieldNorm(doc=6287)
          0.39569116 = weight(abstract_txt:guides in 6287) [ClassicSimilarity], result of:
            0.39569116 = score(doc=6287,freq=1.0), product of:
              0.70889467 = queryWeight, product of:
                6.396003 = boost
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.015512737 = queryNorm
              0.55818045 = fieldWeight in 6287, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.078125 = fieldNorm(doc=6287)
        0.2 = coord(5/25)
    
  2. Duchemin, P.-Y.: ¬La recherche d'informations sur l'internet : repertoires et moteurs de recherche (1997) 0.14
    0.1381781 = sum of:
      0.1381781 = product of:
        0.69089043 = sum of:
          0.044993926 = weight(abstract_txt:create in 2298) [ClassicSimilarity], result of:
            0.044993926 = score(doc=2298,freq=1.0), product of:
              0.092819504 = queryWeight, product of:
                1.1571974 = boost
                5.170629 = idf(docFreq=647, maxDocs=41962)
                0.015512737 = queryNorm
              0.48474646 = fieldWeight in 2298, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.170629 = idf(docFreq=647, maxDocs=41962)
                0.09375 = fieldNorm(doc=2298)
          0.056642346 = weight(abstract_txt:pages in 2298) [ClassicSimilarity], result of:
            0.056642346 = score(doc=2298,freq=1.0), product of:
              0.10821749 = queryWeight, product of:
                1.2495008 = boost
                5.5830626 = idf(docFreq=428, maxDocs=41962)
                0.015512737 = queryNorm
              0.5234121 = fieldWeight in 2298, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.5830626 = idf(docFreq=428, maxDocs=41962)
                0.09375 = fieldNorm(doc=2298)
          0.036498442 = weight(abstract_txt:content in 2298) [ClassicSimilarity], result of:
            0.036498442 = score(doc=2298,freq=1.0), product of:
              0.09241659 = queryWeight, product of:
                1.4141921 = boost
                4.212628 = idf(docFreq=1688, maxDocs=41962)
                0.015512737 = queryNorm
              0.39493388 = fieldWeight in 2298, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.212628 = idf(docFreq=1688, maxDocs=41962)
                0.09375 = fieldNorm(doc=2298)
          0.07792637 = weight(abstract_txt:subject in 2298) [ClassicSimilarity], result of:
            0.07792637 = score(doc=2298,freq=1.0), product of:
              0.2124938 = queryWeight, product of:
                3.5017967 = boost
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.015512737 = queryNorm
              0.366723 = fieldWeight in 2298, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.09375 = fieldNorm(doc=2298)
          0.47482938 = weight(abstract_txt:guides in 2298) [ClassicSimilarity], result of:
            0.47482938 = score(doc=2298,freq=1.0), product of:
              0.70889467 = queryWeight, product of:
                6.396003 = boost
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.015512737 = queryNorm
              0.66981655 = fieldWeight in 2298, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.09375 = fieldNorm(doc=2298)
        0.2 = coord(5/25)
    
  3. Edwards, D.H.: Evaluating Internet search tools : a librarian's guide (1997) 0.12
    0.121333234 = sum of:
      0.121333234 = product of:
        1.0111103 = sum of:
          0.08985071 = weight(abstract_txt:features in 2869) [ClassicSimilarity], result of:
            0.08985071 = score(doc=2869,freq=3.0), product of:
              0.072601356 = queryWeight, product of:
                1.0234348 = boost
                4.5729465 = idf(docFreq=1177, maxDocs=41962)
                0.015512737 = queryNorm
              1.23759 = fieldWeight in 2869, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                4.5729465 = idf(docFreq=1177, maxDocs=41962)
                0.15625 = fieldNorm(doc=2869)
          0.12987728 = weight(abstract_txt:subject in 2869) [ClassicSimilarity], result of:
            0.12987728 = score(doc=2869,freq=1.0), product of:
              0.2124938 = queryWeight, product of:
                3.5017967 = boost
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.015512737 = queryNorm
              0.61120504 = fieldWeight in 2869, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.15625 = fieldNorm(doc=2869)
          0.7913823 = weight(abstract_txt:guides in 2869) [ClassicSimilarity], result of:
            0.7913823 = score(doc=2869,freq=1.0), product of:
              0.70889467 = queryWeight, product of:
                6.396003 = boost
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.015512737 = queryNorm
              1.1163609 = fieldWeight in 2869, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.15625 = fieldNorm(doc=2869)
        0.12 = coord(3/25)
    
  4. Lardy, J.-P.: ¬Les outils de recherche d'information sur Internet : guides, listes thematiques et index (1996) 0.12
    0.117921226 = sum of:
      0.117921226 = product of:
        1.4740154 = sum of:
          0.20780365 = weight(abstract_txt:subject in 4803) [ClassicSimilarity], result of:
            0.20780365 = score(doc=4803,freq=1.0), product of:
              0.2124938 = queryWeight, product of:
                3.5017967 = boost
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.015512737 = queryNorm
              0.97792804 = fieldWeight in 4803, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.9117122 = idf(docFreq=2281, maxDocs=41962)
                0.25 = fieldNorm(doc=4803)
          1.2662117 = weight(abstract_txt:guides in 4803) [ClassicSimilarity], result of:
            1.2662117 = score(doc=4803,freq=1.0), product of:
              0.70889467 = queryWeight, product of:
                6.396003 = boost
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.015512737 = queryNorm
              1.7861775 = fieldWeight in 4803, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.25 = fieldNorm(doc=4803)
        0.08 = coord(2/25)
    
  5. Nicholson, D.: Interpretive journeys and METS : determining requirements for the effective management of complex digital objects in a National Park (2006) 0.10
    0.10415745 = sum of:
      0.10415745 = product of:
        0.52078724 = sum of:
          0.020387411 = weight(abstract_txt:purpose in 598) [ClassicSimilarity], result of:
            0.020387411 = score(doc=598,freq=1.0), product of:
              0.0717528 = queryWeight, product of:
                1.0174363 = boost
                4.546144 = idf(docFreq=1209, maxDocs=41962)
                0.015512737 = queryNorm
              0.284134 = fieldWeight in 598, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.546144 = idf(docFreq=1209, maxDocs=41962)
                0.0625 = fieldNorm(doc=598)
          0.029995952 = weight(abstract_txt:create in 598) [ClassicSimilarity], result of:
            0.029995952 = score(doc=598,freq=1.0), product of:
              0.092819504 = queryWeight, product of:
                1.1571974 = boost
                5.170629 = idf(docFreq=647, maxDocs=41962)
                0.015512737 = queryNorm
              0.3231643 = fieldWeight in 598, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.170629 = idf(docFreq=647, maxDocs=41962)
                0.0625 = fieldNorm(doc=598)
          0.04595965 = weight(abstract_txt:solution in 598) [ClassicSimilarity], result of:
            0.04595965 = score(doc=598,freq=1.0), product of:
              0.12336216 = queryWeight, product of:
                1.3340704 = boost
                5.96094 = idf(docFreq=293, maxDocs=41962)
                0.015512737 = queryNorm
              0.37255874 = fieldWeight in 598, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.96094 = idf(docFreq=293, maxDocs=41962)
                0.0625 = fieldNorm(doc=598)
          0.10789126 = weight(abstract_txt:managing in 598) [ClassicSimilarity], result of:
            0.10789126 = score(doc=598,freq=4.0), product of:
              0.1372677 = queryWeight, product of:
                1.4072523 = boost
                6.2879333 = idf(docFreq=211, maxDocs=41962)
                0.015512737 = queryNorm
              0.78599167 = fieldWeight in 598, product of:
                2.0 = tf(freq=4.0), with freq of:
                  4.0 = termFreq=4.0
                6.2879333 = idf(docFreq=211, maxDocs=41962)
                0.0625 = fieldNorm(doc=598)
          0.31655294 = weight(abstract_txt:guides in 598) [ClassicSimilarity], result of:
            0.31655294 = score(doc=598,freq=1.0), product of:
              0.70889467 = queryWeight, product of:
                6.396003 = boost
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.015512737 = queryNorm
              0.44654438 = fieldWeight in 598, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.14471 = idf(docFreq=89, maxDocs=41962)
                0.0625 = fieldNorm(doc=598)
        0.2 = coord(5/25)