Alaa H Ridha

LIS 544

Spring 2011

Kuwait University

College of Social Sciences Department of Library and Information Science

Introduction

Purpose of the project

Tools

Benefits

Why MS Access

Database Requirement Phase

Database Design Phase

Summary

Outline

LIS 544

Due to he increase number of online information resources, information professional are pressured to look for more ways to maintain effective and efficient means of resources access.

LIS 544

Manage University of Arkansas Library's electronic subscription.

Provide options to create greater access including: online list of electronic resources organized by subject or discipline, book catalog, and current awareness resources.

Obtain better data management using database-driven website.

Purpose

LIS 544

Static Webpages

A static web page is one where the content is written like an ordinary document and does not tend to change.

For a static-content Web site, all content appearing on Web pages is placed manually by professional Web developer.

Dynamic Webpages

A dynamic web page is one where the content changes rapidly. It is typically provided via a scripting feature such as Microsoft's ASP. These "server side" scripts control the selection and presentation of the information and deliver a page "dynamically", that page may be unique every time it is requested.

Static vs. Dynamic Webpages

LIS 544

Centralized data source

Dynamic data

Manageability

Easier administration

Content customization

Benefits

LIS 544

How it is done?

LIS 544

Database Management Tool: Microsoft (MS) Access.

Internet Content Delivery Tool: Active Service Pages (ASP) serves as middleware (scripting language).

HTML Editor: Dreamweaver UntralDev to provide HTML development environment.

Tools

LIS 544

AdvantagesExcellent platform for sites anticipate low to medium traffic. (up to 58,000 hits/ month)

Standard and easy-to-use user interface.

Developed on Microsoft Personal Web Server (PWS) for free.

Inexpensive.

Disadvantages MS Access is limited to 255 concurrent connections.

Up to 2 gigabytes/ table.

Why MS Access?

LIS 544

Hosting platform (e.g. NT)

Programing skill (HTML)

Data storage capacity

Number of users

Requirements (1)

LIS 544

Determine what information goes in the database including subject categories and subcategories.

Construct a relation database with two tables using MS Access: ELECTRONIC RESOURCES and CATEGORY.

Load the database to a web server (Microsoft Internet Information Server IIS)

Construct ASP code to serve data to the website users.

Requirements (2)

LIS 544

Database Design

LIS 544

LIS 544

Effective Web content management is the key to providing access to numerous resources by delivering content “dynamically” through a well-constructed backend database.

Conclusion

LIS 544

Davidson, Brayan. (2001). Database driven, dynamic content delivery: providing and managing access to online resources using Microsoft access and active server pages. OCLC Systems & Services, 17(1), 34-41.

LIS 544