The Woodruff School

SUMMARY

The proliferation of low-cost sensors and industrial data solutions have continued to push the frontier of manufacturing technology.
Machine Learning and other advanced statistical techniques stand to provide tremendous advantages in production capabilities, optimization, monitoring, and efficiency.
The tremendous volume of data gathered continues to grow, and the methods for storing the data are critical underpinnings for advancing manufacturing technology.
This work aims to investigate the ramifications and design trade offs of two prominent Database Management Systems: SQL and NoSQL.
The technologies and accompanying design constraints are investigated, and a side-by-side comparison is carried out through high-fidelity industrial data simulated load tests using metrics from a major US manufacturer.

https://nam12.safelinks.protection.outlook.com/ap/t-59584e83/?url=https%3A%2F%2Fteams.microsoft.com%2Fl%2Fmeetup-join%2F19%253ameeting_MzQzNGJkNDctMTBkYS00MTA0LWFjMDgtMGE3NzBjN2QxMGYy%2540thread.v2%2F0%3Fcontext%3D%257b%2522Tid%2522%253a%2522482198bb-ae7b-4b25-8b7a-6d7f32faa083%2522%252c%2522Oid%2522%253a%2522791f3f21-9eee-4e87-9d72-7539450f63c8%2522%257d&data=04%7C01%7Cdavidgamero%40gatech.edu%7Ca95284c281d84ff4c15708d8dd9ed229%7C482198bbae7b4b258b7a6d7f32faa083%7C0%7C0%7C637503021482172316%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=PQPnZWH7PiGNVSAPK9hJy%2BN%2FY7q%2FlKhq8KPnTqxhCbE%3D&reserved=0

SUBJECT:	M.S. Thesis Presentation

BY:	David Gamero

TIME:	Wednesday, April 21, 2021, 9:00 a.m.

PLACE:	BlueJeans, REMOTE

TITLE:	Comparison of MySQL and NoSQL in IoT for Manufacturing Context using MQTT

COMMITTEE:	Dr. Katherine Fu, Chair (ME) Dr. Chris Saldana (ME) Dr. Thomas Kurfess (ME)

SUMMARY The proliferation of low-cost sensors and industrial data solutions have continued to push the frontier of manufacturing technology. Machine Learning and other advanced statistical techniques stand to provide tremendous advantages in production capabilities, optimization, monitoring, and efficiency. The tremendous volume of data gathered continues to grow, and the methods for storing the data are critical underpinnings for advancing manufacturing technology. This work aims to investigate the ramifications and design trade offs of two prominent Database Management Systems: SQL and NoSQL. The technologies and accompanying design constraints are investigated, and a side-by-side comparison is carried out through high-fidelity industrial data simulated load tests using metrics from a major US manufacturer. https://nam12.safelinks.protection.outlook.com/ap/t-59584e83/?url=https%3A%2F%2Fteams.microsoft.com%2Fl%2Fmeetup-join%2F19%253ameeting_MzQzNGJkNDctMTBkYS00MTA0LWFjMDgtMGE3NzBjN2QxMGYy%2540thread.v2%2F0%3Fcontext%3D%257b%2522Tid%2522%253a%2522482198bb-ae7b-4b25-8b7a-6d7f32faa083%2522%252c%2522Oid%2522%253a%2522791f3f21-9eee-4e87-9d72-7539450f63c8%2522%257d&data=04%7C01%7Cdavidgamero%40gatech.edu%7Ca95284c281d84ff4c15708d8dd9ed229%7C482198bbae7b4b258b7a6d7f32faa083%7C0%7C0%7C637503021482172316%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=PQPnZWH7PiGNVSAPK9hJy%2BN%2FY7q%2FlKhq8KPnTqxhCbE%3D&reserved=0