CSG: Creating Tools to Assist Clients in Moving From Oracle to Snowflake

Authors

Reid Jones, University of Nebraska - LincolnFollow
Sean Fitzgerald, University of Nebraska - LincolnFollow
Daniel Guo, University of Nebraska - LincolnFollow
Jared Ladd, University of Nebraska - LincolnFollow
Emma Clausen, University of Nebraska - LincolnFollow

Date of this Version

5-2020

Document Type

Thesis

Citation

Jones, R., Fitzgerald, S., Guo, D., Ladd, J., & Clausen, E. 2020. CSG: Creating Tools to Assist Clients in Moving From Oracle to Snowflake. Undergraduate Honors Thesis. University of Nebraska-Lincoln.

Comments

Copyright Reid Jones, Sean Fitzgerald, Daniel Guo, Jared Ladd, Emma Clausen 2020.

Abstract

This year-long project focuses on creating two tools for CSG to assist them in their transition from an Oracle Exadata database to a cloud-based Snowflake database. The first tool is a web site with a dashboard displaying tables and charts containing data about the SQL queries still active on the Exadata system. The second tool is a command-line application that detects Oracle-specific keywords in SQL queries and attempts to make partial translations for certain common Oracle SQL keywords. By combining these tools, the team has created a dashboard that will ease CSG's transition to a cloud-based database.