This an implementation in JSP and Java of an adjacency list graph that uses Dijkstra's algorithm to find the shortest path between airports. An adjacency list is used that takes vertices (each of the airports) and edges (the distance between two airports) to create a graph. This graph can then be used to calculate all of the paths between the vertices and the distances between them. AJAX is used to select the airports and then run a java program to create the graph with a set list of airports and locations and then return the distance between two airports. (Continue Reading)

This is an example of the Mid Valley auto database. This database stores and manages auto listings for a dealership. This is just an example so it only has a page that lists all of the current listings and has a form for adding new listings. The full application uploads and manages multiple images for each listing and has administrative features for updating and deleting. The database used for this application contains all of the tables necessary for managing auto listings for a dealership to put their inventory online. The application uses Java Server Pages and a PostgreSQL or MySQL database. Java form beans are used for handling data securely and AJAX is used for filling in the form with information from the database as the user selects different options on the form such as selecting Acura or BMW will bring up a listing of models to select. (Continue Reading)

This systems analysis was for a mid size trucking company in the Pacific Northwest. The company was evaluating installing onboard computer/gps tracking systems in all of their trucks. The complete report was over 150 pages, a sample of the feasibility analysis matrix, candidate systems matrix, and financial analysis is available by clicking on the image to the right. A managerial report of 19 pages and containing mostly diagrams and visualizations was used for a presentation to management. (Continue Reading)

The Secret Shopper application and database was designed for secret shoppers to post evaluations online so that reps and store owners could access site evaluations electronically. The application is written with PHP and SQL and uses a MySQL database. Access is restricted and secured using JavaScript and 128bit encryption algorithms. You can access a prototype version of this application by clicking on the image and entering guest for username and guest for password. The database is fairly complex for a small application like this. AJAX is used to fill in certain forms so people do not need to enter information to post evaluations. An image of the database logical model is included below. (Continue Reading)

Show Me the Money was an information visualization tool prototype that I developed with a group of 4 people. The purpose of this project was to explore different ways to visualize data from the United States Bureau of Labor Statistics. All of the graphs are created with Tableau using actual data from the Bureau of Labor Statistics. The prototype is an HTML based wireframe using JavaScript and AJAX for interaction. Users can select filtering options and AJAX is used to fill in other filters. JavaScript is used to change the images as users select different options. (Continue Reading)