Asee peer logo

Developing A Web Enabled Database System: An Academic Project

Download Paper |

Conference

2002 Annual Conference

Location

Montreal, Canada

Publication Date

June 16, 2002

Start Date

June 16, 2002

End Date

June 19, 2002

ISSN

2153-5965

Conference Session

Web Based Laboratories and Classes

Page Count

14

Page Numbers

7.393.1 - 7.393.14

Permanent URL

https://peer.asee.org/10501

Download Count

135

Request a correction

Paper Authors

author page

Paul Lin

author page

Melissa Lin

author page

Aik Mon

Download Paper |

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

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. https://peer.asee.org/10501

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2002 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015