Download - Database presentation
![Page 1: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/1.jpg)
Alaa H Ridha
LIS 544
Spring 2011
Kuwait University
College of Social Sciences Department of Library and Information Science
![Page 2: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/2.jpg)
Introduction
Purpose of the project
Tools
Benefits
Why MS Access
Database Requirement Phase
Database Design Phase
Summary
Outline
LIS 544
![Page 3: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/3.jpg)
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
![Page 4: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/4.jpg)
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
![Page 5: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/5.jpg)
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
![Page 6: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/6.jpg)
Centralized data source
Dynamic data
Manageability
Easier administration
Content customization
Benefits
LIS 544
![Page 7: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/7.jpg)
How it is done?
LIS 544
![Page 8: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/8.jpg)
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
![Page 9: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/9.jpg)
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
![Page 10: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/10.jpg)
Hosting platform (e.g. NT)
Programing skill (HTML)
Data storage capacity
Number of users
Requirements (1)
LIS 544
![Page 11: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/11.jpg)
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
![Page 12: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/12.jpg)
Database Design
LIS 544
![Page 13: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/13.jpg)
LIS 544
![Page 14: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/14.jpg)
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
![Page 15: Database presentation](https://reader033.vdocuments.us/reader033/viewer/2022060205/55a1ab771a28ab6c6c8b4590/html5/thumbnails/15.jpg)
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