Managing subject guides with SQL Server and ASP.Net

• Published in: Library hi tech Vol. 26; no. 2; pp. 213 - 231
• Main Author: Greene, Araby
• Format: Journal Article
• Language: English
• Published: Bingley Emerald Group Publishing Limited 13.06.2008; Emerald
• Subjects: Academic libraries; Content management software; Data base management systems; Database management systems; Documentation institutions; Exact sciences and technology; Hierarchies; High education and university libraries; History education; Information and communication sciences; Information science. Documentation; Librarians; Libraries. Documentation centres; Libraries. Virtual and electronic libraries. Media centers. Documentation centers; Library resources; Sciences and techniques of general use; Servers; Social networks; Software; Structured Query Language-SQL; Studies; University libraries; Web content management; Web site design; Guides and handbooks; Content management; Database management systems; Academic libraries; Higher education library; Handbook; Database management system
• ISSN: 0737-8831; 2054-166X
• DOI: 10.1108/07378830810880324

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.