SQL And NoSQL Databases for Cyber Physical Production Systems in Internet of Things for Manufacturing (IoTfM)

Files
GAMERO-THESIS-2021.pdf (2.27 MB)
Author(s)
Gamero, David
Advisor(s)
Editor(s)
Associated Organization(s)
Organizational Unit
Organizational Unit
Series
Collections
Theses and Dissertations
Supplementary to:
Permanent Link
http://hdl.handle.net/1853/64678
Abstract
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 within a decoupled architecture of two prominent Database Management Systems: SQL and NoSQL. A representative comparison is carried out with Amazon Web Services (AWS) DynamoDB and AWS Aurora MySQL. 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. The results support the use of simulated client load testing for comparing latency and throughput of database management systems as a system scales. As a result of complex query support, MySQL is favored for higher order insights, while NoSQL can reduce system latency for known access patterns at the expense of integrated query flexibility.
Sponsor
Date
2021-04-27
Extent
Resource Type
Text
Resource Subtype
Thesis
Rights Statement
Rights URI