Databases and Information Systems Commons^™

Web Repository Of Southern’S Research Projects, Rebecca Zaldivar, Siegwart Mayr

Campus Research Day

A research repository was created so that Southern Adventist University has a central place for all past, current, and future research projects. This repository is a web application created with the use of the Yii framework that utilizes PHP and SQL. The repository has a user-friendly interface to let authorized users upload the information about their projects. Also, professors and students from different departments can see the list of projects per department.

Creating Characters In A Game Based Learning System, Jaehyun Park, Siegwart Mayr

Campus Research Day

Gamification is the idea of adding video game elements into a non-gaming context, such as for educational or business purposes. Game-based learning takes that idea one step further by not only adding elements of video games, but turning the whole process into a game-like structure.

The Center for Innovation and Research in Computing (CIRC) is currently developing a game-based learning system that can be used in place of a traditional classroom setting. The focus of this research work is on the relationship between users and characters within a course in the Character Module. The Character Module encompasses everything to do …

Generating University Course Catalogs Via A Php Based Module, Chileleko Chileya, Siegwart Mayr

Campus Research Day

Catalogs are a requirement at any university. The current academic system at Southern Adventist University entails creating catalogs for the school by hand. The current model is very outdated and time consuming especially considering the database of all related school records available. The solution is a module using the PHP based framework called Yii to construct a module that will be integrated into the Southern Adventist University website that will automatically generate formatted catalogs through the frontend of the website. The previous module uses Kuali to store academic data as well as provide an API for third-party applications but was …

A Study Of A Collaborative Task Management Application Built On React Native Using The Basic Ux Framework, Andrei Modiga

Campus Research Day

Many times it can be difficult to accomplish all this is proposed in a meeting. This project aimed to build a simple planner application using React Native that allows groups of people to collaborate and stay organized. The application was built using the BASIC Framework as a guide, and featured a collaboration feature that enabled users to share tasks, projects, and communicate with one another in order to stay coordinated and productive. The user interface was designed for easy use, allowing for quick and efficient task management within a group. The goal of the application was to provide a useful …

Visualizing Literary Narratives With A Graph-Centered Approach., Meg Ermer

Campus Research Day

The art of storytelling is multifaceted and nonlinear, involving multiple characters, themes, and symbols while often jumping between the present and past. While media forms such as novels can encapsulate these complexities, it is often difficult to visualize a narrative in an easy-to-understand format. Our contribution is a graph-based system to let users organize and visualize those narratives. Events and characters are represented as nodes and their relationships are represented as edges. Neo4J is used as a database management system to store the graph and to run queries on it, and Streamlit and Pyvis are used to represent the database …

Performance Comparison Of The Filesystem And Embedded Key-Value Databases, Jesse Hines, Nicholas Cunningham

Campus Research Day

A common scenario when developing local applications is storing many records and then retrieving them by ID. A developer can simply save the records as files or use an embedded database. Large numbers of files can slow down filesystems, but developers may want to avoid a dependency on an embedded database if it offers little benefit for their use case. We will compare the performance for the insert, update, get and delete operations and the space efficiency of storing records as files vs. using key-value embedded databases including RocksDB, LevelDB, Berkley DB, and SQLite.

Database Query Execution Through Virtual Reality, Logan Bateman, Marc Butler

Campus Research Day

Building database queries often requires technical knowledge of a query language. However, company employees, such as executives, managers, and others (outside of software research and development, generally) may not have the pre-required knowledge to accurately construct and execute database queries. This paper proposes an approach to constructing database queries using virtual reality. This approach utilizes natural hand or controller gestures which map to various components of building and visualizing database queries.

Realtime Visualization Of Kafka Architectures, Matthew Jensen, Miro Manestar

Campus Research Day

Apache Kafka specializes in the transfer of incredibly large amounts of data in real-time between devices. However, it can be difficult to comprehend the inner workings of Kafka. Often, to get real-time data, a user must run complicated commands from within the Kafka CLI. Our contribution is a tool that monitors Kafka consumers, producers, and topics, and displays the flow of events between them in a web-based dashboard. This dashboard serves to reduce the complexity of Kafka and enables users unfamiliar with the platform and protocol to better understand how their architecture is configured.