Document (#34600)

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.14201282 = sum of:
     0.14201282 = product of:
       0.71006405 = sum of:
         0.036933143 = weight(abstract_txt:create in 5871) [ClassicSimilarity], result of:
           0.036933143 = score(doc=5871,freq=1.0), product of:
             0.09201135 = queryWeight, product of:
               1.1760734 = boost
               5.137891 = idf(docFreq=694, maxDocs=43556)
               0.015227271 = queryNorm
             0.4013977 = fieldWeight in 5871, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.137891 = idf(docFreq=694, maxDocs=43556)
               0.078125 = fieldNorm(doc=5871)
         0.0205455 = weight(abstract_txt:data in 5871) [ClassicSimilarity], result of:
           0.0205455 = score(doc=5871,freq=1.0), product of:
             0.07841244 = queryWeight, product of:
               1.535399 = boost
               3.3538349 = idf(docFreq=4137, maxDocs=43556)
               0.015227271 = queryNorm
             0.26201835 = fieldWeight in 5871, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.3538349 = idf(docFreq=4137, maxDocs=43556)
               0.078125 = fieldNorm(doc=5871)
         0.12752736 = weight(abstract_txt:specialists in 5871) [ClassicSimilarity], result of:
           0.12752736 = score(doc=5871,freq=1.0), product of:
             0.24061896 = queryWeight, product of:
               2.329294 = boost
               6.7839627 = idf(docFreq=133, maxDocs=43556)
               0.015227271 = queryNorm
             0.5299971 = fieldWeight in 5871, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.7839627 = idf(docFreq=133, maxDocs=43556)
               0.078125 = fieldNorm(doc=5871)
         0.13059056 = weight(abstract_txt:subject in 5871) [ClassicSimilarity], result of:
           0.13059056 = score(doc=5871,freq=4.0), product of:
             0.2135527 = queryWeight, product of:
               3.583408 = boost
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.015227271 = queryNorm
             0.61151445 = fieldWeight in 5871, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.078125 = fieldNorm(doc=5871)
         0.39446747 = weight(abstract_txt:guides in 5871) [ClassicSimilarity], result of:
           0.39446747 = score(doc=5871,freq=1.0), product of:
             0.70836645 = queryWeight, product of:
               6.526386 = boost
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.015227271 = queryNorm
             0.5568692 = fieldWeight in 5871, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.078125 = fieldNorm(doc=5871)
       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.13786331 = sum of:
     0.13786331 = product of:
       0.6893165 = sum of:
         0.044319775 = weight(abstract_txt:create in 1882) [ClassicSimilarity], result of:
           0.044319775 = score(doc=1882,freq=1.0), product of:
             0.09201135 = queryWeight, product of:
               1.1760734 = boost
               5.137891 = idf(docFreq=694, maxDocs=43556)
               0.015227271 = queryNorm
             0.48167726 = fieldWeight in 1882, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.137891 = idf(docFreq=694, maxDocs=43556)
               0.09375 = fieldNorm(doc=1882)
         0.057163782 = weight(abstract_txt:pages in 1882) [ClassicSimilarity], result of:
           0.057163782 = score(doc=1882,freq=1.0), product of:
             0.1090244 = queryWeight, product of:
               1.2801934 = boost
               5.5927577 = idf(docFreq=440, maxDocs=43556)
               0.015227271 = queryNorm
             0.524321 = fieldWeight in 1882, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.5927577 = idf(docFreq=440, maxDocs=43556)
               0.09375 = fieldNorm(doc=1882)
         0.036117643 = weight(abstract_txt:content in 1882) [ClassicSimilarity], result of:
           0.036117643 = score(doc=1882,freq=1.0), product of:
             0.09189384 = queryWeight, product of:
               1.4394698 = boost
               4.1923904 = idf(docFreq=1788, maxDocs=43556)
               0.015227271 = queryNorm
             0.3930366 = fieldWeight in 1882, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.1923904 = idf(docFreq=1788, maxDocs=43556)
               0.09375 = fieldNorm(doc=1882)
         0.07835434 = weight(abstract_txt:subject in 1882) [ClassicSimilarity], result of:
           0.07835434 = score(doc=1882,freq=1.0), product of:
             0.2135527 = queryWeight, product of:
               3.583408 = boost
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.015227271 = queryNorm
             0.36690867 = fieldWeight in 1882, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.09375 = fieldNorm(doc=1882)
         0.47336096 = weight(abstract_txt:guides in 1882) [ClassicSimilarity], result of:
           0.47336096 = score(doc=1882,freq=1.0), product of:
             0.70836645 = queryWeight, product of:
               6.526386 = boost
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.015227271 = queryNorm
             0.66824305 = fieldWeight in 1882, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.09375 = fieldNorm(doc=1882)
       0.2 = coord(5/25)
   

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

   0.1210065 = sum of:
     0.1210065 = product of:
       1.0083876 = sum of:
         0.08886204 = weight(abstract_txt:features in 2453) [ClassicSimilarity], result of:
           0.08886204 = score(doc=2453,freq=3.0), product of:
             0.072162956 = queryWeight, product of:
               1.0415279 = boost
               4.550104 = idf(docFreq=1250, maxDocs=43556)
               0.015227271 = queryNorm
             1.231408 = fieldWeight in 2453, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.550104 = idf(docFreq=1250, maxDocs=43556)
               0.15625 = fieldNorm(doc=2453)
         0.13059056 = weight(abstract_txt:subject in 2453) [ClassicSimilarity], result of:
           0.13059056 = score(doc=2453,freq=1.0), product of:
             0.2135527 = queryWeight, product of:
               3.583408 = boost
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.015227271 = queryNorm
             0.61151445 = fieldWeight in 2453, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.15625 = fieldNorm(doc=2453)
         0.78893495 = weight(abstract_txt:guides in 2453) [ClassicSimilarity], result of:
           0.78893495 = score(doc=2453,freq=1.0), product of:
             0.70836645 = queryWeight, product of:
               6.526386 = boost
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.015227271 = queryNorm
             1.1137384 = fieldWeight in 2453, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.15625 = fieldNorm(doc=2453)
       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.11769926 = sum of:
     0.11769926 = product of:
       1.4712408 = sum of:
         0.2089449 = weight(abstract_txt:subject in 4800) [ClassicSimilarity], result of:
           0.2089449 = score(doc=4800,freq=1.0), product of:
             0.2135527 = queryWeight, product of:
               3.583408 = boost
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.015227271 = queryNorm
             0.9784231 = fieldWeight in 4800, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9136925 = idf(docFreq=2363, maxDocs=43556)
               0.25 = fieldNorm(doc=4800)
         1.2622958 = weight(abstract_txt:guides in 4800) [ClassicSimilarity], result of:
           1.2622958 = score(doc=4800,freq=1.0), product of:
             0.70836645 = queryWeight, product of:
               6.526386 = boost
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.015227271 = queryNorm
             1.7819815 = fieldWeight in 4800, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.25 = fieldNorm(doc=4800)
       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.10350604 = sum of:
     0.10350604 = product of:
       0.5175302 = sum of:
         0.019605884 = weight(abstract_txt:purpose in 595) [ClassicSimilarity], result of:
           0.019605884 = score(doc=595,freq=1.0), product of:
             0.069999486 = queryWeight, product of:
               1.0257964 = boost
               4.481378 = idf(docFreq=1339, maxDocs=43556)
               0.015227271 = queryNorm
             0.28008613 = fieldWeight in 595, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.481378 = idf(docFreq=1339, maxDocs=43556)
               0.0625 = fieldNorm(doc=595)
         0.029546516 = weight(abstract_txt:create in 595) [ClassicSimilarity], result of:
           0.029546516 = score(doc=595,freq=1.0), product of:
             0.09201135 = queryWeight, product of:
               1.1760734 = boost
               5.137891 = idf(docFreq=694, maxDocs=43556)
               0.015227271 = queryNorm
             0.32111818 = fieldWeight in 595, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.137891 = idf(docFreq=694, maxDocs=43556)
               0.0625 = fieldNorm(doc=595)
         0.04630772 = weight(abstract_txt:solution in 595) [ClassicSimilarity], result of:
           0.04630772 = score(doc=595,freq=1.0), product of:
             0.12414793 = queryWeight, product of:
               1.3661032 = boost
               5.96807 = idf(docFreq=302, maxDocs=43556)
               0.015227271 = queryNorm
             0.37300438 = fieldWeight in 595, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.96807 = idf(docFreq=302, maxDocs=43556)
               0.0625 = fieldNorm(doc=595)
         0.10649613 = weight(abstract_txt:managing in 595) [ClassicSimilarity], result of:
           0.10649613 = score(doc=595,freq=4.0), product of:
             0.13626148 = queryWeight, product of:
               1.4311999 = boost
               6.252457 = idf(docFreq=227, maxDocs=43556)
               0.015227271 = queryNorm
             0.78155714 = fieldWeight in 595, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               6.252457 = idf(docFreq=227, maxDocs=43556)
               0.0625 = fieldNorm(doc=595)
         0.31557396 = weight(abstract_txt:guides in 595) [ClassicSimilarity], result of:
           0.31557396 = score(doc=595,freq=1.0), product of:
             0.70836645 = queryWeight, product of:
               6.526386 = boost
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.015227271 = queryNorm
             0.44549537 = fieldWeight in 595, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.127926 = idf(docFreq=94, maxDocs=43556)
               0.0625 = fieldNorm(doc=595)
       0.2 = coord(5/25)