Databases and Information Systems Commons^™

Cleaning Data Helps Clean The Air, Kelley Donalds, Xiangrong Liu

Management Faculty Publications

In this project, students use a real-world, complex database and experience firsthand the consequences of inadequate data modeling. The U.S. Environmental Protection Agency created the database as part of a multimillion dollar data collection effort undertaken in order to set limits on air pollutants from electric power plants. First, students explore the database to identify design limitations from the perspective of a data analyst with a specific goal. Second, students create a new database design which overcomes identified problems. Through this case study, students develop the skill to infer usage implications by studying the design of an existing database. This …

Designing An Mis Database For Selection And Recruitment, Umakant Mishra

Umakant Mishra

Selection and recruitment is a key HR function and it is often necessary to maintain at least a small database of all the candidates who have been invited in past interviews. This information may be considered as a part of HR MIS and may be maintained by HR department along with other HR MIS such as employee information, transfers, performance appraisals, trainings etc.

This recruitment MIS database includes all the candidates after the preliminary scrutiny is over. When the candidates go through different stages of interviews, the MIS also captures all their interview results. Maintaining this information not only helps …

Development Of A Comprehensive Database System For A Highway Safety Engineering And Management, Naveen Veeramisti, Justin Baker, Indira Khanal, Kenny Moupita, Alexander Paz

College of Engineering: Graduate Celebration Programs

In simple words, the objective of this study is to develop a comprehensive database system to provide a data for highway safety engineering and management.

Merging Schemas In A Collaborative Faceted Classification System, Jianxiang Li

Computer Science Theses & Dissertations

We have developed a system that improves access to a large, growing image collection by allowing users to collaboratively build a global faceted (multi-perspective) classification schema. We are extending our system to support both global and local schemas, where global schema provides a complete and uniform view of the collection whereas local schema provides a personal, possibly incomplete and idiosyncratic view of the collection. We argue that although users usually focus on their personal schemas, it is still desirable to have a global schema for the entire collection even if such local schemas are available. In order to keep the …

Animated Courseware Support For Teaching Database Design, Meg C. Murray, Mario Guimaraes

Faculty and Research Publications

Database technologies are a core component of computing technology curricula. Their importance will only continue to expand as more and more data are retained in database systems. An effective database system is predicated on a good data model. Database design is the conceptualization of an underlying data model that progresses from identifying user requirements to graphically depicting those requirements and finally mapping the graphical models to a set of tables implemented in a physical database system. The abstract nature of much of database design makes it challenging to teach. This paper presents a set of software animations designed to support …

College Of Extended Learning Online Registration System, Chai-Ching Tsai

Theses Digitization Project

The purpose of this project is to provide staff and future students at College of Extended Learning a web based interface to process course registration online. This system is called College of Extended Learning Online Registration System C♯ (CELORS-C♯). This project is a revision of a previous version of College of Extended Learning Online Registration System. The previous version of CELORS has been used by College of Extended Learning as of March 2007. The difference between the previous CELORS and CELORS-C♯ is that the previous CELORS is coded in JAVA but CELORS-C♯ is coded in C. Also, CELORS-C♯ has a …

Offline Searchable Database, James Howard Klein

Theses Digitization Project

The purpose of this project was to develop a database that can be accessed on any platform regardless of operating system with or without an internet connection. Javascript, Visual Basic, NET, and HTML were used in this project.

International Extension Program Online Registration System, Hau Yu

Theses Digitization Project

The International Extension Program Online Registration System (IEPORS) allows prospective international students to apply over the Web to the programs offered through the International Extension Program of the College of Extended Learning. The system is comprised of two separate systems: a web application and a desktop application. In this project, Hibernate technique is used to reduce code size and system architecture. Security schema was also modified to be simple and solidly secure. All the private information could be interceped on the Internet are protected by SSL (secure Sockets Layer).

Traditional Chinese Medicine On-Line Diagnosis System, Chuan-Ting Chou

Theses Digitization Project

The project developed a web-based application that provides a user-friendly interface to assist practitioners of traditional Chinese medicine in determining the correct diagnosis. Traditional Chinese Medicine On-line Diagnosis System (TCMODS) allows a diagnostician to enter a patient's symptoms using a series of questionnaires to determine health status, which will then be stored in the database as part of the patient's medical records. The database will also differentiate among the patterns of syndromes known in traditional Chinese medicine and search and match these with the patient's data to the known uses of Chinese herbs. TCMODS will then generate that patient's medical …

Improvement And Deployment Of The Web-Based Database Management System For Computer Science Graduate Program, Li-Chuan Fang

Theses Digitization Project

In 2005 Mr. Dung Tien Vu completed a master's project for the California State University, San Bernardino Computer Science Department in which he designed a web-based database of department graduate student information. This project was designed to alter the system so that it conforms with current campus regulations, to make some improvements to the system, and to deploy it.

Web-Based Independent Study Program, Darryl Dwaine Scroggins

Theses Digitization Project

The Web-based Independent Study Program (WISP) is an on-line database program used to create and store educational records for members of Dikaios. (Dikaios is a Christian educators association that offers an independent study program.) The database allows home educators to create, store, edit, view, and print the forms and records that are required by Dakaios administrators and by the state of California. Further, the database helps students and home educators monitor student progress towards meeting high school graduation requirements.

Dynamic Report Generator, Liquan Xie

Theses Digitization Project

This project describes DRG (Dynamic Report Generator). This program can be used on the internet to summarize the content of a database based on user criteria. DRG allows the user to choose a database, input the data, and generate a report based on user input, and print out the results in a new format. This paper describes the design and analysis of the DRG program.

The Web-Based Database Management System For The Computer Science Graduate Program, Dung Tien Vu

Theses Digitization Project

The purpose of this project is to provide faculty and students a secure access to graduate student resources and it will also cover database design, web development, security, migration, and deployment of the new system.

White Board, Getahun Alemu

Theses Digitization Project

This project designs and implements a tool to enhance the current means of availing coursework information in educational systems.

Data Warehouse Applications In Modern Day Business, Carla Mounir Issa

Theses Digitization Project

Data warehousing provides organizations with strategic tools to achieve the competitive advantage that organazations are constantly seeking. The use of tools such as data mining, indexing and summaries enables management to retrieve information and perform thorough analysis, planning and forcasting to meet the changes in the market environment. in addition, The data warehouse is providing security measures that, if properly implemented and planned, are helping organizations ensure that their data quality and validity remain intact.

A System For Structured Management Of Hypermedia Resources For The World Wide Web, Kevin L. Marlowe

Computer Science Theses & Dissertations

The World Wide Web (WWW) is arguably the preferred method for disseminating information across the Internet. Most of the work to support the advancement of WWW technology has focused on servers used in storing and retrieving information, browsers for viewing this information, and editors or filters for creating the information.

One area which has received little attention is that of actually managing this information at the local host. This thesis describes the development of a means for organizing local data prior to its publishing on the WWW, a method for gathering local pages together and preparing them for distribution, and …

Quality Of Service Specification For Multimedia Presentations, Richard Staehli, Jonathan Walpole, David Maier

Computer Science Faculty Publications and Presentations

The bandwidth limitations of multimedia systems force tradeoffs between presentation data fidelity and real-time performance. For example, digital video is commonly encoded with lossy compression to reduce bandwidth and frames may be skipped during playback to maintain synchronization. These tradeoffs depend on device performance and physical data representations that are hidden by a database system. If a multimedia database is to support digital video and other continuous media data types, we argue that the database should provide a Quality of Service (QOS) interface to allow application control of presentation timing and information loss tradeoffs.

This paper proposes a data model …

A Distributed Object-Oriented Database Application Design, Hsin-Feng Edward Wu

Theses and Dissertations

The purpose of this study is to analyze and develop a distributed object-oriented database management system (DOODBMS) application to support parallel software development of the Parallel Algorithms and Applications Group (PAAG) at AFIT. By following the software lifecycle of object-oriented paradigm, this thesis investigation is intended to generate requirements analysis, design, implementation, user interface design and implementation, and integration of the database application with the user interface. ITASCA, an existing DOODBMS platform, has been chosen to prototype the application for its distribution functionalities and object-oriented modeling power. The user interface of the database application is based on X-window OSF/Motif front-end …