Databases and Information Systems Commons^™

Lessons From The Club Homeschool Capstone: Testing, Data Discipline, And The Computer Science Curriculum, Shane Brown

University Honors Theses

This thesis looks at the CLUB Homeschool Capstone project to argue that Portland State University's Computer Science curriculum should introduce testing and data quality discipline earlier and more intentionally than it does now. As team lead of a seven-person team, I coordinated sprint planning, communicated with the sponsor, and developed custom Discourse plugins that enhanced an existing forum platform instead of creating a separate application database, as requested by the sponsor. The project's requirements document called for a formal testing plan, but our team lacked the practical experience to implement one. This gap became evident through my internships as a …

Machine Learning For Predictive Energy And Emissions Modeling Of Vehicles And Power Grids In The United States, S M Tanvir Faysal Alam Chowdhoury

Dissertations

The environmental benefits of electric vehicle (EV) adoption depend on more than replacing internal combustion engine vehicles with electric powertrains. EV adoption reshapes electricity demand, interacts with regional generation mixes, and influences travel behavior and congestion, creating a coupled transportation-energy system in which vehicle and power-plant emissions must be evaluated together. This dissertation develops machine-learning frameworks for predicting energy consumption and emissions from vehicles and power grids under rising EV adoption. The first component forecasts grid emissions from EV charging. Using simulation data from NREL's Cambium database, a Prophet-based time-series framework predicts carbon dioxide, nitrous oxide, and methane emission rates …

“Alexa, Do Not Say That In Front Of My Boss!” A Cross-Cultural Comparison Of User And Ai Preferences For Privacy-Aware Smart Speaker Interactions Across Contexts, Lynne Warin, Emily Aurelia, Anthony Tang, Emily Aurelia, Delphine Reinhardt

Research Collection School Of Computing and Information Systems

Due to their limited ability to reason about the social context in which they are used, smart speakers pose significant privacy risks by responding in ways that may violate people's implicit social boundaries. We conducted a cross-cultural vignette study (N = 944) in Germany and Singapore to investigate how situational factors—specifically social context (bystander relationships and closeness), physical context (location), and interaction context (topic and deceptive intent)—regulate user preferences for smart speaker responses. Our results demonstrate that these factors are superior predictors of response preferences than dispositional user traits (i.e., intrinsic personal traits). We identify two distinct social dynamics: a …

Political Inconsistency Detection Across Legislative Speech And Public Communications, Scott M. Pramuk

Master's Theses

Political actors communicate about legislation across multiple contexts, including committee hearings, recorded votes, and public-facing press releases. Differences between these forms of communication can provide useful signals for journalists and researchers seeking to understand how legislators present policy positions to different audiences.

This thesis extends the Digital Democracy Project, a legislative transparency initiative that provides access to California state legislative hearing transcripts, voting records, and related legislative data. Specifically, this work incorporates publicly accessible, legislator-authored news releases into the Digital Democracy Database and develops a pipeline for analyzing legislative communication across multiple sources. The system collects news releases from California …

Development And Launch Of Abn: An Adventist Freelance Web Application, Abishur Moses-Pakkianathan

MS in Computer Science Project Reports

The Seventh-day Adventist community often relies on personal networks and word-of-mouth for Adventist business services. Many of these businesses meet and provide services to their clients primarily through church connections and community recommendations. As the community and businesses grow, traditional networking methods become increasingly difficult to maintain. General marketplaces lack the trust framework shared by Adventists, and faith-based directories are often static or outdated without booking capabilities. Our solution provides a reliable and modern platform for Adventists to create service listings, receive and manage bookings, and connect with faith-aligned clients.

Developing Narrative-Based Stem Learning Tool For K-6 Visually Impaired Students, Daniel Tsivkovski, Dylan Ravel, Jeffrey Kraskouskas, Brandon Foley, Maryam Etezad, Franceli Cibrian, Rajeev Joshi, Ariel Han

Student Scholar Symposium Abstracts and Posters

This research develops a free, accessible web application that enables K-6 students who are blind or visually impaired (BVI) to learn STEM concepts using refreshable braille displays. Currently, most online learning tools are not designed for BVI students, creating a significant educational barrier.

The application interfaces with commercial braille displays and uses narrative-based learning to make STEM content approachable and engaging. By presenting material as personalized interactive stories generated with the help of Artificial Intellligence (AI), students can connect with concepts while developing braille reading skills. The curriculum design prioritizes accessibility through the Accessible Rich Internet Applications (ARIA) standards and …

Sql Query Optimization - Human Vs. Chatgpt, Hailey Dennis

All Graduate Reports and Creative Projects, Fall 2023 to Present

Large Language Models (LLMs) such as ChatGPT have become ubiquitous tools for working professionals in the software industry. Many engineers are finding new ways to increase productivity by offloading tasks onto LLMs, while others are finding it difficult to trust code produced artificially, even after review. Taking a look at both perspectives, this study aims to compare a human’s ability to optimize SQL queries to that of an LLM and assess the experience using both methods.

Manual query optimization is a tedious task that relies heavily on statistics, heuristics, and good intuition. The SQL developer must search for the optimal …

A Study Of Visualized Diagnostics In Early Stage Digital Twin Implementation Of An Industrial Control System, Michael R. Kinzel

All-Inclusive List of Electronic Theses and Dissertations

Industrial Control Systems (ICS) are used for process control in almost all industries. An ICS combines Operational Technologies (OT) with Information Technologies (IT) to allow human supervision of a process through surveillance of process variables and manipulation of controlling elements such as valves to maintain stable process conditions. ICSs have been in-service for several decades and may remain operational past their technological service life. Organizational personnel interact with the ICS through visual displays that both indicate the process variables and also the controlling elements. The Human Machine Interface (HMI) allows visibility of the process and the ability to manipulate controlling …

A Backend Database Architecture For Persistent Epilepsy Classification Records, Attiksh A. Panda, Deep Desai, Artem Zabarov, Katrina D. Prantzalos, Satya S. Sahoo, Shuai Xu

Student Scholarship

Epilepsy affects over five million people globally each year, yet consistent clinical diagnosis remains a persistent challenge due to the lack of standardized classification workflows across medical institutions. The Four-Dimensional Epilepsy Classification (4D-EC) framework, developed by Lüders et al., provides a comprehensive structure for characterizing paroxysmal events across four dimensions: seizure semiology, epileptogenic zone, etiology, and comorbidities. Despite its clinical and educational value, no dedicated informatics platform existed to support its routine use until recently, limiting widespread adoption among clinicians and trainees. This project addresses that gap by implementing a full-stack web application that operationalizes the 4D-EC framework for clinical …

Digitizing Transportation Operations At Safe Haven, Luke S. Garrett, William B. Turk, Clay A. Curtis, Aiden H. Behler

ATU Scholars Symposium

Safe Haven’s transportation department currently relies on a paper-based documentation process that requires physical transfer of records between buildings and repeated manual uploading of documents into storage systems. This workflow creates delays, redundant administrative tasks, and increased risk of misplaced or inconsistent records. Drivers, transportation coordinators, reviewers, and clients all interact with this process, making efficiency and data accuracy critical to daily operations.

This project develops a web-based transportation scheduling system designed to digitize documentation workflows and automate many of the repetitive tasks. The system replaces physical records with digital data management, reducing unnecessary manual handling and improving information accessibility …

Moneyup: A Predictive Financial Management System For College Students, Isaiah J. Adams, Malaya E. Wilburd, Dan V. Le, Joshua P. Golden

ATU Scholars Symposium

College students often lack accessible tools that combine real-time financial tracking, mobile accessibility, predictive analytics, and secure system design, leaving many without structured insight into their spending behavior. MoneyUP is a full-stack financial management platform developed to address these challenges through a secure, data-driven budgeting system deployed as both a web application and a cross-platform Flutter mobile application. The system integrates the Plaid API in its Sandbox environment to synchronize simulated banking data for secure testing without exposing live financial credentials. Transaction data is processed and stored using Supabase with a relational PostgreSQL database structured to enforce normalization, referential integrity, …

Llm-Based Stock Sentiment And Market Intelligence Platform, Joshua Thrower, Andrew Pinkerton, Ian Duggan, Wyatt Lester

ATU Scholars Symposium

Financial markets increasingly react to social media discourse, yet investors lack tools to translate this unstructured commentary into measurable indicators. Platforms such as YouTube host extensive discussions about publicly traded equities, but extracting reliable sentiment trends from high-volume, noisy comment streams remains technically challenging. This project develops a stock sentiment and market intelligence platform that transforms YouTube comment data into aggregated sentiment indicators aligned to specific equities. Comments are mapped to equities using ticker specific keyword identification combined with contextual filtering to reduce false associations from ambiguous or off-topic mentions. The system assigns numerical sentiment scores to individual comments and …

Harvest Scanner, Alexander Murphy

Posters - 2026

In current times, people can find themselves at the whims of markets and may be spending more than they realize or want to on regular, everyday goods. New tools can help users keep track of the goods they are paying for. Harvest Scanner was developed to scan and track local grocery prices from stores using their publicly available website information. It was developed in Python using PyQt5 for GUI. The database is stored as an SQL file with Python using SQLite engine. Users will be able to view local grocery prices in a database interface (GUI). There are many features …

Topshelf, Ayden Jay Soliz

Posters - 2026

With so many great video games releasing each year, it becomes challenging to keep up with the latest. Players find it difficult to maintain an updated list of future games to play, and many existing online trackers have become too complicated to use. TopShelf is designed to be a simple video game backlogging website that will track games for the player. By connecting to an online video game database API, users can add/drop games from their personal list and enable tracking and receive emails for platform releasing. Gamers can leave all the tracking and updates responsibilities to TopShelf

Foxbuddy, Luis Eduardo Garza Jr.

Presentations - 2026

Problem:
•Many people are still unprepared incase of an emergency. (42%-46% are prepared for an emergency)
•Supplies can be scattered, expired, or forgotten.   •Reliable guidance is often not easy to access.

Fisheasy, Jake Ryan Rankin

Posters - 2026

The purpose of FishEasy is to create an all-in-one fishing application that supports both beginner and experienced anglers through education, recommendations, and data tracking. Many new anglers struggle with understanding gear, knots, bait, and locations, while existing tools often limit access through paid features. FishEasy addresses these gaps by providing:

• Educational Tutorials for knots, rigs, and beginner guidance • Smart Recommendations based on location, species, and conditions • Catch Logging & Analytics to track performance • Regulation Awareness for legal fishing practices


Overall, FishEasy aims to make fishing more accessible, efficient, and easy to learn for all users.

Synapse, Nicolas Diaz, Alexander Murphy, Sonia Cerrillo, Naomi Ramirez, Jesse Kemmer

Posters - 2026

People tend to accumulate a great deal of notes throughout their lives with no coherent way to organize them. Even with the built-in notes app, the notes eventually accumulate until it becomes borderline impossible to find what is needed. Our proposed solution is Synapse, an LLM powered notes app with a tagging system that allows notes to be sorted by topic. The LLM will be able to read the user's notes and recommend tags

Chopchop: The Digital Cookbook, Dominc Mcdevitt, Shane Misley, Katie Cerda, Kobie Henson, Adolfo Duran

Presentations - 2026

Problem With traditional recipe organization methods,

● Recipes are scattered across paper, PDFs, Word docs, and notes

● Paper recipes can be lost, damaged, or left at home

● Digital recipes are difficult to edit, store, and organize

● Manually typing or updating recipes is time-consuming

● Sharing recipes is inconvenient and often confusing

● Limited or inconsistent cloud access reduces accessibility

● Formatting is messy and inconsistent across platforms

● No simple, centralized system for managing recipes

Match-A-Fit, Adan Diaz De Leon, Juan Marco Saca Dada, Brianna Mendoza, Arsalan Kataneh, Theophile Nsabimana, Pedro Jacobo

Presentations - 2026

Welcome to Match-a-Fit! Match-a-Fit is an iOS application that allows the user to create a digital closet by uploading images of their clothing items. With AI, the program can generate outfits based on the digital closet, the time, and the occasion. Match-a-Fit’s purpose is designed to help users who struggle to get ready, run out of time, or can’t decide on an outfit, by easily generating outfit options based on the occasion.

Trace: Securing Smart Contract Repository Against Access Control Vulnerability, Chong Chen, Lingfeng Bao, David Lo, Yanlin Wang, Zhenyu Shan, Ting Chen, Guangqiang Yin, Jianxing Yu, Zibin Zheng, Jiachi Chen

Research Collection School Of Computing and Information Systems

Smart contract vulnerabilities have led to billions of dollars in economic losses. Among these, improper Access Control, which allows unauthorized users to execute restricted functions, is particularly prevalent and has caused significant financial damage. Smart contract repositories contain source code, documentation, configuration files, and other artifacts necessary for building and deploying smart contracts. GitHub hosts numerous open-source repositories of this kind, which serve as intermediate artifacts in development and require compilation and packaging to produce deployable contracts. Third-party developers often reference, reuse, or fork code from these repositories during custom development. However, if the referenced code contains vulnerabilities, it can …

Large-Scale File Fragment Classification Via Multi-View Learning, Samuel Hildebrand

LSU Master's Theses

File reassembly is one of the most fundamental tasks in digital forensics, enabling recovery of data from potentially damaged storage media even when file system metadata is unavailable. This thesis reviews more than two decades of work in the realm of file carving, with a particular focus on fragmented file carving, which remains a focus of research, and file fragment classification, a principal component of fragmented file carving. This thesis serves a literature review of both file carving and fragmented file carving, surveys the massive amounts of data needed for the task of fragment classification and the datasets that serve …

The Feelit System: Application Content-Aware Perspectives And Challenges On Understanding User Likes In Social Network Posts, Konstantinos Theocharidis, Hady W. Lauw, Panagiotis Karras

Research Collection School Of Computing and Information Systems

In a series of our prior works, we study influence and subscription maximization problems in social networks that are based on posts having influential content; as content we consider a set of features where each feature corresponds to a specific social network page, whereas influence and subscription relate to gaining the postlike and subscription-to-brand page of targeted users, respectively; subscription is conceptually achieved as repetitive influence on users. So, both influence and subscription depend on content that gains the likes of users; however, to be realistic, modeling and estimating such likes is a complex problem that has not been adequately …

Dual-Lora And Quality-Enhanced Pseudo Replay For Multimodal Continual Food Learning, Xinlan Wu, Bin Zhu, Feng Han, Pengkun Jiao, Jingling Chen

Research Collection School Of Computing and Information Systems

Food analysis has become increasingly critical for health-related tasks such as personalized nutrition and chronic disease prevention. However, existing large multimodal models (LMMs) in food analysis suffer from catastrophic forgetting when learning new tasks, requiring costly retraining from scratch. To address this, we propose a novel continual learning framework for multimodal food learning, integrating a Dual-LoRA architecture with Quality-Enhanced Pseudo Replay. We introduce two complementary low-rank adapters for each task: a specialized LoRA that learns task-specific knowledge with orthogonal constraints to previous tasks’ subspaces, and a cooperative LoRA that consolidates shared knowledge across tasks via pseudo replay. To improve the …

Performance Enhancement For Rufa: Rapid Urban Forest Assessment, Nicholas Tan

Master's Theses

Urban forests are crucial to the livability and resilience of cities, offering critical ecosystem benefits such as air quality enhancement, temperature regulation, and biodiversity. Managing said urban forests is essential to ensure their sustainability and adaptability to rapidly changing environmental and climate conditions. The Rapid Urban Forest Assessment (RUFA) tool was developed to address the need for a standardized approach to evaluating and comparing urban and community forestry programs. By analyzing and aggregating tree-specific data across California, such as canopy cover, tree counts, and diversity scores, RUFA assigns a comprehensive urban forestry score for each city. This score allows for …

When Deep Learning Meets Information Retrieval-Based Bug Localization: A Survey, Feifei Niu, Chuanyi Li, Kui Liu, Xin Xia, David Lo

Research Collection School Of Computing and Information Systems

Bug localization is a crucial aspect of software maintenance, running through the entire software lifecycle. Information retrieval-based bug localization (IRBL) identifies buggy code based on bug reports, expediting the bug resolution process for developers. Recent years have witnessed significant achievements in IRBL, propelled by the widespread adoption of deep learning (DL). To provide a comprehensive overview of the current state of the art and delve into key issues, we conduct a survey encompassing 61 IRBL studies leveraging DL. We summarize best practices in each phase of the IRBL workflow, undertake a meta-analysis of prior studies, and suggest future research directions. …

Ponzilens+: Visualizing Bytecode Actions For Smart Ponzi Scheme Identification, Xiaolin Wen, Tai D. Nguyen, Shaolun Ruan, Qiaomu Shen, Jun Sun, Feida Zhu, Yong Wang

Research Collection School Of Computing and Information Systems

With the prevalence of smart contracts, smart Ponzi schemes have become a common fraud on blockchain and have caused significant financial loss to cryptocurrency investors in the past few years. Despite the critical importance of detecting smart Ponzi schemes, a reliable and transparent identification approach adaptive to various smart Ponzi schemes is still missing. To fill the research gap, we first extract semantic-meaningful actions to represent the execution behaviors specified in smart contract bytecodes, which are derived from a literature review and in-depth interviews with domain experts. We then propose PonziLens+, a novel visual analytic approach that provides an intuitive …

The Integration Of Agile Methodologies In Devops Practices Within The Information Technology Industry, Ashley Hourigan, Ridewaan Hanslo

African Conference on Information Systems and Technology

The demand for rapid software delivery in the Information Technology (IT) industry has significantly intensified, emphasising the need for faster software products and service releases with enhanced features to meet customer expectations. Agile methodologies are replacing traditional approaches such as Waterfall, where flexibility, iterative development and adaptation to change are favoured over rigid planning and execution. DevOps, a subsequent evolution from Agile, emphasises collaborative efforts in development and operations teams, focusing on continuous integration and deployment to deliver resilient and high-quality software products and services. This study aims to critically assess both Agile and DevOps practices in the IT industry …

Anomalygfm: Graph Foundation Model For Zero/Few-Shot Anomaly Detection, Hezhe Qiao, Chaoxi Niu, Ling Chen, Guansong Pang

Research Collection School Of Computing and Information Systems

Graph anomaly detection (GAD) aims to identify abnormal nodes that differ from the majority of the nodes in a graph, which has been attracting significant attention in recent years. Existing generalist graph models have achieved remarkable success in different graph tasks but struggle to generalize to the GAD task. This limitation arises from their difficulty in learning generalized knowledge for capturing the inherently infrequent, irregular and heterogeneous abnormality patterns in graphs from different domains. To address this challenge, we propose AnomalyGFM, a GAD-oriented graph foundation model that supports zero-shot inference and few-shot prompt tuning for GAD in diverse graph datasets. …

Syntax-Enhanced Boundary-Aware Named Entity Recognition Model, Chuanming Yu, Bin Deng, Zhengang Zhang

Journal of Scientific Information Research

[Purpose/significance] This study addresses the issue of inadequate perception of entity boundaries in traditional character-level modeling-based named entity recognition models by integrating syntax information containing entity boundary features into the task using a multi-head graph attention network with dense connections. This integration enhances the effectiveness of named entity recognition.

[Method/process] This study proposes a Syntax-enhanced Boundary-aware Named Entity Recognition Model (SynBNER), which utilizes BERT for text semantic representation and integrates syntax information using a dense-connected graph attention network. This integration incorporates implicit entity boundary information from syntax information into word representations, thereby enhancing the model's entity boundary perception capability.

[Result/conclusion] …

Less Is More: On The Importance Of Data Quality For Unit Test Generation, Junwei Zhang, Xing Hu, Shan Gao, Xin Xia, David Lo, Shanping Li

Research Collection School Of Computing and Information Systems

Unit testing is crucial for software development and maintenance. Effective unit testing ensures and improves software quality, but writing unit tests is time-consuming and labor-intensive. Recent studies have proposed deep learning (DL) techniques or large language models (LLMs) to automate unit test generation. These models are usually trained or fine-tuned on large-scale datasets. Despite growing awareness of the importance of data quality, there has been limited research on the quality of datasets used for test generation. To bridge this gap, we systematically examine the impact of noise on the performance of learning-based test generation models. We first apply the open …