Back to search

Georgia Institute of Technology

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

Abstract

dc:description.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.

Degree

thesis:*
Level thesis:degree_level
Masters
Department dc:contributor.department
Mechanical Engineering
Grantor dc:publisher
Georgia Institute of Technology
Year dc:date.issued
2021

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Gamero, David
Advisor dc:contributor.advisor
  • Fu, Katherine
Committee members dc:contributor.committeemember
  • Saldana, Christopher
  • Kurfess, Thomas

Subjects

dc:subject × 9

Rights

Language dc:language.iso
en_US

Identifiers

dc:identifier.*
Handle dc:identifier.uri
http://hdl.handle.net/1853/64678

Chain of custody

source
Harvested from
Georgia Tech
Base URL
repository.gatech.edu/server/oai/request
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Gamero, David. SQL And NoSQL Databases for Cyber Physical Production Systems in Internet of Things for Manufacturing (IoTfM). Masters thesis, Georgia Institute of Technology, 2021. http://hdl.handle.net/1853/64678