SSPiN Database Prototype

SSPiN is a prototype database that uses a scalable mutating database that I designed as a back end system for a content management system combining versioning, tagging, social networking, and rating features. The interface is very simple because nearly all of the development time was spent investigating database models that could handle a user created structure to represent anything. The database allows users to create all of their own categories and the data model adapts to accomodate however users would like to use the sytem. There is a built in security and user management area where administrators and moderators have different permissions to modify content and change structure categories that users can use.

(Continue Reading)

Mid Valley Chrysler Dodge Jeep Website

The Mid Valley Chrysler Dodge Jeep website incorporates a content management system so that employees can update all of the site content without knowing how to work on websites. They can also post special deals and communicate with customers. The site uses CSS and XHTML with optimized images for quick download speeds and a sleek look. There is also built in inventory search capabilities that are automatically updated with their vehicle inventory daily. As part of this project I also did in page and out of page search engine optimization to increase traffic.

(Continue Reading)

General Transport Website

General Transport is a Northwest fuel common carrier delivering bulk fuel to convenience stores and other customers with large load needs. This is a simple website to give a web prescence and contact information for General Transport, a fuel common carrier in the Northwest. The site uses images of the actual company to convey a theme and present an image of the actual business. (Continue Reading)

Adjacency List Graph

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)

Mid Valley Auto Database

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)