Physical Sciences and Mathematics Commons^™

Databases And Deliberation, Britany Orozco, Quentin Jensen

WWU Honors College Senior Projects

This paper describes the process taken to build a digital form-collection system in a business context. By starting with the motivation for the project, we can gather the requirements necessary to complete before we can consider the project complete. From there, we start discussing the client-server-database architecture principles that must be reviewed before we can design our database. Database design fundamentals are reviewed, such as what a schema or entity relationship diagram is, and those fundamentals are used to design the database. Next, we show how a development environment is chosen. With the environment set up, we then discuss how …

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 …

Oracle Cost Based Optimizer Correlations, Robert Apple

Regis University Student Publications (comprehensive collection)

Database systems use optimizers on queries to select execution pathways that are supposed to provide optimal performance. The Oracle database version of this technology is called the Cost Based Optimizer (CBO). Researchers have studied whether Oracle optimizer estimates could be correlated to execution speeds with a high degree of confidence, but have found that correlating optimizer cost estimates with actual execution speed to be problematic and unreliable. If possible, however, such correlations would be helpful to developers who are tasked with query creation and optimization. Although much has been written on databases, the academic literature on optimizers was sparse. To …

A Study Of Mongodb And Oracle In An E-Commerce Environment, Aaron Ploetz

Regis University Student Publications (comprehensive collection)

As worldwide e-commerce expands, businesses continue to look for better ways to meet their evolving needs with web solutions that scale and perform adequately. Several online retailers have been able to address scaling challenges through the implementation of NoSQL databases. While architecturally different from their relational database counterparts, NoSQL databases typically achieve performance gains by relaxing one or more of the essential transaction processing attributes of atomicity, consistency, isolation, and durability (ACID). As with any emerging technology, there are both critics and supporters of NoSQL databases. The detractors claim that NoSQL is not safe and is at a greater risk …

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.

Development Of An Api As A Solution To Data Insularity Amongst Dietary-Need Applications, Raphael Lapuma

Regis University Student Publications (comprehensive collection)

When multiple competing applications in the same field use only their own sets of user-generated review data and do not collaborate with other applications, data is used in isolation. This factor, which the author will refer to as "data insularity," segregates each application's community of users from other applications' communities, thus creating a limited and fragmented set of data, which discourages the creation of new applications in the industry, and adversely affects the end user. This study will propose a prototype API for applications in the restaurant industry as a solution to the limited and insular use of data amongst …

Social Networking Site, Navis Amalraj

All Capstone Projects

Social Networking site is designed in Visual Studio 2008 and the database used is SQL Server 2008. Database has three tables: User table, Friends table and Scraps table. New User can register by Signing Up. Once the registration is completed, the User can log into his/her account and search for friends and send a friend request. Users can accept or deny the friend request. Users can send messages to their friends.

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 …

Develop Best Practices For Designing Internal Business Database-Driven Web Applications, Stephen C. Rash

Regis University Student Publications (comprehensive collection)

When developing using newer technology, it is important for smaller information technology organizations to have universally accepted set of best practices to be able to successfully complete that type of endeavor. How can these universally accepted set of best practices be developed? Conducting research on accepted best practices can build the basis for your theories and assumptions. Next, in the context of your applications, develop an example application in the newer technology to test your theories and assumptions. Build the application like a construction project, the initial design is the blueprint, the database is the foundation and the user interface …

Databases In Courts: The Kenyan Experience, Samwel Otieno Oyuuh

Regis University Student Publications (comprehensive collection)

One of the most significant challenges faced by courts today is managing the performance of their case management system to meet growing case loads efficiently and effectively. There are many different types of technology to help in developing an electronic courtroom, but the underlying technology is the database. Databases are used by courts for maintaining case records, personnel and other court management data. But many conditions such as training and technological infrastructure need to be in place to support successful systems. This work presents the results of a survey of case management operations and practices in Kenya. Current state of …

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.

Meeting The Challenges Of Met Data With Mysql, Thomas S. Ciolek

Regis University Student Publications (comprehensive collection)

The objective of this project is to develop a relational database housing meteorological data used in direct support of emergency response activities for an atmospheric consulting firm, hereon referred to by the pseudonym WindInc. The intent is to demonstrate to WindInc how a relational database system would be superior to their present flat-file approach by providing the flexibility, performance, and reliability needed to meet their ever-increasing business demands, while simultaneously boosting the performance of their atmospheric dispersion modeling system.

Development Of A Custom Call Management System For The Service Department Of Premiere Copier Inc., Markas Korotkovas

Regis University Student Publications (comprehensive collection)

Premiere Copier needs a system that will facilitate the functionality required by the current business process as well as being more robust, reliable and scalable. The new system has to mitigate all the problem areas mentioned in the section 1.2.3. The complete list of the requirements is presented in the Section 3.1.1. This project is the first real life experience for the one man developing team as well. Working through the whole development life cycle of the application, fulfilling the roles of project manager, developer and designer at the same time presents an excellent educational opportunity as well.

Volunteer System Project: Regis University Networking Lab Practicum, Desirea Duarte Ulibarri

Regis University Student Publications (comprehensive collection)

The Regis University Networking Lab Practicum (NLP) allows MSCIT graduate students the opportunity to gain hands-on experience in IT topics in a controlled computer network environment. The NLP also introduces students to a wide range of external IT projects such as the Volunteer System Project. The Volunteer System Project was the construction of a database system for a non-profit organization. The Volunteer System captures all of the personnel data, work time and project affiliation information and is a critical tool in managing and maintaining a successful volunteer workforce. The performance of the original spreadsheet-based Volunteer System was declining and could …

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.

Conceptual Model Builder, Chia-Yang Lin

Theses Digitization Project

Whenever one designs a new database system, an Entity-Relationship Diagram (ER diagram) is always needed to present the structure of this database. Using the graphically well-arranged ER Diagram helps you to easily understand the entities, attributes, domains, primary keys, foreign keys, constraints, and relationships inside a database. This data-modeling tool is an ideal choice for companies and developers.

Designing And Implementing A User-Focused Web-Based Database System, Rachel Noiseux

Honors Theses

The goal of this project was to combine two different fields within computer science to produce a system that would be beneficial to a wide variety of people. The first area, user-centered design, studies how users interact with an interface and the motivation behind the decisions they make when interacting with the interface. The second area, databases, explores different techniques for storing and retrieving large amounts of data.

A Book Management System Elibrary, Shanpeng Song

Theses Digitization Project

"eLibrary" is a book management software application that runs on Microsoft Windows platforms. The software incorporates a Windows Explorer like interface and XML/XSL to display book details. The purpose of this project is to build a full-featured, commerical-quality software package to help people manage their books (either printed or electronic). The goal is for eLibrary to be a complete solution for people who wish to build their own personal electronic library catalog.

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 …