Document (#34602)

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.14169732 = sum of:
     0.14169732 = product of:
       0.70848656 = sum of:
         0.036707234 = weight(abstract_txt:create in 5873) [ClassicSimilarity], result of:
           0.036707234 = score(doc=5873,freq=1.0), product of:
             0.0917035 = queryWeight, product of:
               1.1836984 = boost
               5.123606 = idf(docFreq=718, maxDocs=44421)
               0.015120602 = queryNorm
             0.40028173 = fieldWeight in 5873, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.123606 = idf(docFreq=718, maxDocs=44421)
               0.078125 = fieldNorm(doc=5873)
         0.020159295 = weight(abstract_txt:data in 5873) [ClassicSimilarity], result of:
           0.020159295 = score(doc=5873,freq=1.0), product of:
             0.07748394 = queryWeight, product of:
               1.5387532 = boost
               3.3302255 = idf(docFreq=4320, maxDocs=44421)
               0.015120602 = queryNorm
             0.26017386 = fieldWeight in 5873, 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=5873)
         0.12767047 = weight(abstract_txt:specialists in 5873) [ClassicSimilarity], result of:
           0.12767047 = score(doc=5873,freq=1.0), product of:
             0.24097694 = queryWeight, product of:
               2.3500738 = boost
               6.7814865 = idf(docFreq=136, maxDocs=44421)
               0.015120602 = queryNorm
             0.52980363 = fieldWeight in 5873, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.7814865 = idf(docFreq=136, maxDocs=44421)
               0.078125 = fieldNorm(doc=5873)
         0.13050476 = weight(abstract_txt:subject in 5873) [ClassicSimilarity], result of:
           0.13050476 = score(doc=5873,freq=4.0), product of:
             0.21361692 = queryWeight, product of:
               3.6132329 = boost
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.015120602 = queryNorm
             0.6109289 = fieldWeight in 5873, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.078125 = fieldNorm(doc=5873)
         0.39344478 = weight(abstract_txt:guides in 5873) [ClassicSimilarity], result of:
           0.39344478 = score(doc=5873,freq=1.0), product of:
             0.7076643 = queryWeight, product of:
               6.5764537 = boost
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.015120602 = queryNorm
             0.55597657 = fieldWeight in 5873, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.078125 = fieldNorm(doc=5873)
       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.1376081 = sum of:
     0.1376081 = product of:
       0.6880405 = sum of:
         0.04404868 = weight(abstract_txt:create in 1884) [ClassicSimilarity], result of:
           0.04404868 = score(doc=1884,freq=1.0), product of:
             0.0917035 = queryWeight, product of:
               1.1836984 = boost
               5.123606 = idf(docFreq=718, maxDocs=44421)
               0.015120602 = queryNorm
             0.4803381 = fieldWeight in 1884, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.123606 = idf(docFreq=718, maxDocs=44421)
               0.09375 = fieldNorm(doc=1884)
         0.05768754 = weight(abstract_txt:pages in 1884) [ClassicSimilarity], result of:
           0.05768754 = score(doc=1884,freq=1.0), product of:
             0.10977042 = queryWeight, product of:
               1.2950627 = boost
               5.6056433 = idf(docFreq=443, maxDocs=44421)
               0.015120602 = queryNorm
             0.525529 = fieldWeight in 1884, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.6056433 = idf(docFreq=443, maxDocs=44421)
               0.09375 = fieldNorm(doc=1884)
         0.035867713 = weight(abstract_txt:content in 1884) [ClassicSimilarity], result of:
           0.035867713 = score(doc=1884,freq=1.0), product of:
             0.091537036 = queryWeight, product of:
               1.4484122 = boost
               4.1796083 = idf(docFreq=1847, maxDocs=44421)
               0.015120602 = queryNorm
             0.39183828 = fieldWeight in 1884, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.1796083 = idf(docFreq=1847, maxDocs=44421)
               0.09375 = fieldNorm(doc=1884)
         0.078302845 = weight(abstract_txt:subject in 1884) [ClassicSimilarity], result of:
           0.078302845 = score(doc=1884,freq=1.0), product of:
             0.21361692 = queryWeight, product of:
               3.6132329 = boost
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.015120602 = queryNorm
             0.36655733 = fieldWeight in 1884, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.09375 = fieldNorm(doc=1884)
         0.4721337 = weight(abstract_txt:guides in 1884) [ClassicSimilarity], result of:
           0.4721337 = score(doc=1884,freq=1.0), product of:
             0.7076643 = queryWeight, product of:
               6.5764537 = boost
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.015120602 = queryNorm
             0.66717184 = fieldWeight in 1884, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.09375 = fieldNorm(doc=1884)
       0.2 = coord(5/25)
   

3. Edwards, D.H.: Evaluating Internet search tools : a librarian's guide (1997) 0.12

   0.12070776 = sum of:
     0.12070776 = product of:
       1.005898 = sum of:
         0.08850362 = weight(abstract_txt:features in 2455) [ClassicSimilarity], result of:
           0.08850362 = score(doc=2455,freq=3.0), product of:
             0.07202198 = queryWeight, product of:
               1.0490124 = boost
               4.5406218 = idf(docFreq=1287, maxDocs=44421)
               0.015120602 = queryNorm
             1.2288418 = fieldWeight in 2455, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.5406218 = idf(docFreq=1287, maxDocs=44421)
               0.15625 = fieldNorm(doc=2455)
         0.13050476 = weight(abstract_txt:subject in 2455) [ClassicSimilarity], result of:
           0.13050476 = score(doc=2455,freq=1.0), product of:
             0.21361692 = queryWeight, product of:
               3.6132329 = boost
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.015120602 = queryNorm
             0.6109289 = fieldWeight in 2455, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.15625 = fieldNorm(doc=2455)
         0.78688955 = weight(abstract_txt:guides in 2455) [ClassicSimilarity], result of:
           0.78688955 = score(doc=2455,freq=1.0), product of:
             0.7076643 = queryWeight, product of:
               6.5764537 = boost
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.015120602 = queryNorm
             1.1119531 = fieldWeight in 2455, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.15625 = fieldNorm(doc=2455)
       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.11742647 = sum of:
     0.11742647 = product of:
       1.4678309 = sum of:
         0.20880759 = weight(abstract_txt:subject in 4802) [ClassicSimilarity], result of:
           0.20880759 = score(doc=4802,freq=1.0), product of:
             0.21361692 = queryWeight, product of:
               3.6132329 = boost
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.015120602 = queryNorm
             0.9774862 = fieldWeight in 4802, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9099448 = idf(docFreq=2419, maxDocs=44421)
               0.25 = fieldNorm(doc=4802)
         1.2590233 = weight(abstract_txt:guides in 4802) [ClassicSimilarity], result of:
           1.2590233 = score(doc=4802,freq=1.0), product of:
             0.7076643 = queryWeight, product of:
               6.5764537 = boost
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.015120602 = queryNorm
             1.779125 = fieldWeight in 4802, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.25 = fieldNorm(doc=4802)
       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.10324126 = sum of:
     0.10324126 = product of:
       0.51620626 = sum of:
         0.019417634 = weight(abstract_txt:purpose in 597) [ClassicSimilarity], result of:
           0.019417634 = score(doc=597,freq=1.0), product of:
             0.0696021 = queryWeight, product of:
               1.0312389 = boost
               4.4636893 = idf(docFreq=1390, maxDocs=44421)
               0.015120602 = queryNorm
             0.27898058 = fieldWeight in 597, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4636893 = idf(docFreq=1390, maxDocs=44421)
               0.0625 = fieldNorm(doc=597)
         0.029365787 = weight(abstract_txt:create in 597) [ClassicSimilarity], result of:
           0.029365787 = score(doc=597,freq=1.0), product of:
             0.0917035 = queryWeight, product of:
               1.1836984 = boost
               5.123606 = idf(docFreq=718, maxDocs=44421)
               0.015120602 = queryNorm
             0.3202254 = fieldWeight in 597, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.123606 = idf(docFreq=718, maxDocs=44421)
               0.0625 = fieldNorm(doc=597)
         0.046038326 = weight(abstract_txt:solution in 597) [ClassicSimilarity], result of:
           0.046038326 = score(doc=597,freq=1.0), product of:
             0.12375739 = queryWeight, product of:
               1.3750981 = boost
               5.9520745 = idf(docFreq=313, maxDocs=44421)
               0.015120602 = queryNorm
             0.37200466 = fieldWeight in 597, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.9520745 = idf(docFreq=313, maxDocs=44421)
               0.0625 = fieldNorm(doc=597)
         0.10662866 = weight(abstract_txt:managing in 597) [ClassicSimilarity], result of:
           0.10662866 = score(doc=597,freq=4.0), product of:
             0.13647531 = queryWeight, product of:
               1.4440265 = boost
               6.250429 = idf(docFreq=232, maxDocs=44421)
               0.015120602 = queryNorm
             0.78130364 = fieldWeight in 597, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.250429 = idf(docFreq=232, maxDocs=44421)
               0.0625 = fieldNorm(doc=597)
         0.31475583 = weight(abstract_txt:guides in 597) [ClassicSimilarity], result of:
           0.31475583 = score(doc=597,freq=1.0), product of:
             0.7076643 = queryWeight, product of:
               6.5764537 = boost
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.015120602 = queryNorm
             0.44478124 = fieldWeight in 597, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.1165 = idf(docFreq=97, maxDocs=44421)
               0.0625 = fieldNorm(doc=597)
       0.2 = coord(5/25)