Paper Authors

Abstract

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Main Menu

Session 1658

Developing a Web-Enabled Database System: An Academic Project

Paul I-Hai Lin - Indiana University-Purdue University Fort Wayne Melissa Lin - University of Florida Aik Mon - GE Industrial Systems

ABSTRACT

Database and Web integration offers a cost effective way to provide value added access to data stored at multiple locations through a Web browser. This paper discusses two methodologies for implementing a remote database query systems using Web browsers.

I. Introduction

In May 2000, we developed a Web-enabled alumni database for remote access by our faculty and staff. The alumni database was created from a spread sheet that contains the following fields: Title, Last Name, First Name, Middle Initial, Degree Received, Major, Graduation Date, Address, City, State, Zip code, Email address, Phone, Employer, ID, Last Gift Amount, Last Gift date, and Total Gift Amount. The developed Web-based alumni database has the following capabilities: • View data records for all alumni (20 records per screen) • Find a specific alumnus or group of alumni by their Last Name, First Name, Graduation Date, City, State, or Employer • Update specific fields on alumni data records • Update, delete, and add alumni records to database

Although the data warehouse and Web-enabled databases are well known and matured in commercial sector, for us, this is a new challenging and requires additional research. This paper is not intended to provide a comprehensive study report of tools and architectures for building database and Web integration systems. However, the Internet protocols, languages and tools, databases, Web servers, CGI, and server-side scripting are highlighted in various sections to help the selections of programming tools, system platform, Web servers, and databases for this Web- enabled alumni database system.

In this paper, we first review Web programming languages and tools needed for implementing a Web-based database in Section II. Section III gives an overview of Web-enabled database architecture. Section IV addresses Web-enabled database design. Section V presents two

Proceedings of the 2002 American Society for Engineering Education Annual Conference & Exposition Copyright  2002, American Society for Engineering Education

Main Menu

• Citation

• Format
  • APA
  • APA - LaTeX bibitem
  • MLA
  • MLA - LaTeX bibitem
  • Bibtex
  • EndNote - RIS

Lin, P., & Lin, M., & Mon, A. (2002, June), Developing A Web Enabled Database System: An Academic Project Paper presented at 2002 Annual Conference, Montreal, Canada. 10.18260/1-2--10501