Database projects

JagWarz Expansion Project

JagWarz is a gaming website with a functioning and interactive game database designed for individuals interested in network security. In development around 2013, the scope for the project was to complete a functioning Red vs. Blue game that allows the admin to assign users to teams and store the information in a database. When assigned to the JagWarz project, a working RvB game was implemented into the website. However, the progress for allowing admins to assign users to teams was still incomplete. In addition to the LivingLab’s request to complete the team assignment, many, if not all, bugs and issues needed to be resolved.

ASP.NET 4.0 Website

A local company in central Indiana used to utilize spreadsheets to track all their company data. For this project, their data was moved to an SQL server interfaced with an ASP.NET website written in C#. Database security has been implemented using Microsoft.NET membership profiles and roles. To ensure all connections are secure, the site uses Secure Socket Layer encryption to ensure all connections are secure.

Fake News DB

A university course started a Fake News project, where a system was being developed to automatically identify fake news articles. As part of the project, a database server needed to be configured to store news articles that would be captured by a web scraper. The project solution included a machine running MongoDB, a database software. This scalable, document-based NoSQL database was to be used as a repository for fake news articles. The project team managed user authentication and roles on the database servers. They also conducted server hardening to reduce the attack surface. Lastly, the Fake News database was deployed on the campus network.

Fake News Article Analysis

The project goal was to perform data analysis on the data set containing the fake news articles. This is to help gain meaningful insight on how leading news agencies write the articles. Data analysis tools, such as Python and R, were used to analyze the data. Different types of data were able to be classified based on the type of data and the goal of the analysis.

Security System Monitoring with OSQuery

This project involved monitoring a security system with OSQuery for a university lab. Important system information, such as running processes, programs, open ports, services, and events, were tracked. Using OSQuery allowed for Powershell automated queries to write reports using the task scheduler. This ended up being very useful for companies and organizations as it helped make their processes more efficient.

TOR Search Engine Using Apache Nutch

A local educational institution requested assistance with their TOR web crawler project. The objective was to create a database of malicious files found through visiting websites on The Onion Router network. The software used for this project was Apache Nutch, Elasticsearch, and Kibana. The overall problem was that Nutch wouldn’t send crawled data to its specified location, and the team had to find a method for indexing this information properly and modify configurations to index specific file extensions. The end result included a dedicated server consistently scanning TOR pages to form a large search engine.

JagWarz Development

The JagWarz website is designed for interested students as a fun way to practice network security. There are currently two games on the website: Capture the Flag and Red vs. Blue. One of the previous goals for the project was to update the code to PHP7 from PHP5 for better performance. The other goal was to resolve any potential database or code issues on both the administrative and user sites.

Database Game

The university was in need of a complete database for students to practice on. The front-end portion was designed in the form of a game with query results. The game was meant to be beginner-friendly but allow for more advanced query methods. Students would need to rewrite the queries to complete each level. Additionally, instructors would have the option to use the database to create tests and assignments. This project utilized the API offered by themoviedb.org to download the database on local SQL server. The game then interacted with the database on the server.