{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,22]],"date-time":"2025-12-22T12:49:00Z","timestamp":1766407740158,"version":"3.41.2"},"reference-count":33,"publisher":"ASME International","issue":"6","license":[{"start":{"date-parts":[[2022,9,22]],"date-time":"2022-09-22T00:00:00Z","timestamp":1663804800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.asme.org\/publications-submissions\/publishing-information\/legal-policies"}],"funder":[{"DOI":"10.13039\/100000015","name":"U.S. Department of Energy","doi-asserted-by":"publisher","award":["DE-EE0008303"],"award-info":[{"award-number":["DE-EE0008303"]}],"id":[{"id":"10.13039\/100000015","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["asmedigitalcollection.asme.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,12,1]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:p>The proliferation of low-cost sensors and industrial data solutions has 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 tradeoffs within a decoupled architecture of two prominent database management systems (DBMS): 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 the latency of database management systems as a system scales up from the prototype stage into production. 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. By reviewing this work, a manufacturer can observe that the use of high-fidelity load testing can reveal tradeoffs in IoTfM write\/ingestion performance in terms of latency that are not observable through prototype-scale testing of commercially available cloud DB solutions.<\/jats:p>","DOI":"10.1115\/1.4055733","type":"journal-article","created":{"date-parts":[[2022,9,22]],"date-time":"2022-09-22T10:20:03Z","timestamp":1663842003000},"update-policy":"https:\/\/doi.org\/10.1115\/crossmarkpolicy-asme","source":"Crossref","is-referenced-by-count":5,"title":["Scalability Testing Approach for Internet of Things for Manufacturing SQL and NoSQL Database Latency and Throughput"],"prefix":"10.1115","volume":"22","author":[{"given":"David","family":"Gamero","sequence":"first","affiliation":[{"name":"Georgia Institute of Technology George W. Woodruff School of, Mechanical Engineering, , 801 Ferst Drive, Atlanta, GA 30332"}]},{"given":"Andrew","family":"Dugenske","sequence":"additional","affiliation":[{"name":"Georgia Institute of Technology Georgia Tech Manufacturing Institute, , 813 Ferst Drive, Atlanta, GA 30332"}]},{"given":"Christopher","family":"Saldana","sequence":"additional","affiliation":[{"name":"Georgia Institute of Technology George W. Woodruff School of, Mechanical Engineering, , 801 Ferst Drive, Atlanta, GA 30332"}]},{"given":"Thomas","family":"Kurfess","sequence":"additional","affiliation":[{"name":"Georgia Institute of Technology George W. Woodruff School of, Mechanical Engineering, , 801 Ferst Drive, Atlanta, GA 30332"}]},{"given":"Katherine","family":"Fu","sequence":"additional","affiliation":[{"name":"Georgia Institute of Technology George W. Woodruff School of, Mechanical Engineering, , 801 Ferst Drive, Atlanta, GA 30332"}]}],"member":"33","published-online":{"date-parts":[[2022,10,10]]},"reference":[{"key":"2023101000042721900_CIT0001","first-page":"1","volume-title":"Industrie 4.0\u2014Germany Market Report and Outlook","author":"Kagermann","year":"2016"},{"issue":"2","key":"2023101000042721900_CIT0002","doi-asserted-by":"publisher","first-page":"177","DOI":"10.1520\/SSMS20180026","article-title":"An Internet of Things for Manufacturing (IOTFM) Enterprise Software Architecture","volume":"2","author":"Nguyen","year":"2018","journal-title":"Smart Sustain. Manuf. Syst."},{"key":"2023101000042721900_CIT0003","first-page":"290","article-title":"Industrial Big Data as a Result of IoT Adoption in Manufacturing","author":"Mourtzis","year":"2016"},{"year":"2020","author":"MQTT: The Standard for IoT Messaging","key":"2023101000042721900_CIT0004"},{"key":"2023101000042721900_CIT0005","first-page":"173","article-title":"A Survey on MQTT: A Protocol of Internet of Things (IoT)","author":"Soni","year":"2017"},{"key":"2023101000042721900_CIT0006","first-page":"1","article-title":"Comparison With HTTP and MQTT on Required Network Resources for IoT","author":"Yokotani","year":"2016"},{"key":"2023101000042721900_CIT0007","doi-asserted-by":"publisher","first-page":"1","DOI":"10.17487\/RFC7252","author":"Shelby","year":"2014"},{"issue":"6","key":"2023101000042721900_CIT0008","doi-asserted-by":"publisher","first-page":"87","DOI":"10.1109\/MIC.2006.116","article-title":"Advanced Message Queuing Protocol","volume":"10","author":"Vinoski","year":"2006","journal-title":"IEEE Internet Comput."},{"key":"2023101000042721900_CIT0009","first-page":"1","article-title":"Choice of Effective Messaging Protocols for IoT Systems: MQTT, CoAP, AMQP and HTTP","author":"Naik","year":"2017"},{"issue":"7","key":"2023101000042721900_CIT0010","doi-asserted-by":"publisher","first-page":"9","DOI":"10.1145\/1364782.1364786","article-title":"Cloud Computing","volume":"51","author":"Hayes","year":"2008","journal-title":"Commun. ACM"},{"key":"2023101000042721900_CIT0011","first-page":"7","article-title":"The NIST Definition of Clouding Computing Recommendations National Inst. of Standards and Technology","volume":"145","author":"Mell","year":"2011","journal-title":"NIST Spec. Publ."},{"key":"2023101000042721900_CIT0012","first-page":"1","volume-title":"Cloud Computing: Web-Based Applications That Change the Way You Work and Collaborate Online","author":"Miller","year":"2008","edition":"1st"},{"author":"Amazon Web Services","key":"2023101000042721900_CIT0013"},{"author":"Microsoft Azure: Cloud Services","key":"2023101000042721900_CIT0014"},{"author":"Google Cloud Platform","key":"2023101000042721900_CIT0015"},{"key":"2023101000042721900_CIT0016","first-page":"17","article-title":"A Survey and Taxonomy of Infrastructure as a Service and Web Hosting Cloud Providers","author":"Prodan","year":"2009"},{"issue":"12","key":"2023101000042721900_CIT0017","doi-asserted-by":"publisher","first-page":"249","DOI":"10.1016\/j.ifacol.2016.07.608","article-title":"A Database-Centric Approach for the Modeling, Simulation and Control of Cyber-Physical Systems in the Factory of the Future","volume":"49","author":"Bonci","year":"2016","journal-title":"IFAC-PapersOnLine"},{"key":"2023101000042721900_CIT0018","doi-asserted-by":"publisher","first-page":"18","DOI":"10.1016\/j.mfglet.2014.12.001","article-title":"A Cyber-Physical Systems Architecture for Industry 4.0-Based Manufacturing Systems","volume":"3","author":"Lee","year":"2015","journal-title":"Manuf. Lett."},{"issue":"10","key":"2023101000042721900_CIT0019","doi-asserted-by":"publisher","first-page":"766","DOI":"10.1515\/auto-2015-0066","article-title":"Cyber-Physical Production Systems: Roots From Manufacturing Science and Technology","volume":"63","author":"Monostori","year":"2015","journal-title":"Automatisierungstechnik"},{"issue":"1","key":"2023101000042721900_CIT0020","first-page":"1","article-title":"Big Data: Big Gaps of Knowledge in the Field of Internet Science","volume":"7","author":"Snijders","year":"2012","journal-title":"Int. J. Internet Sci."},{"key":"2023101000042721900_CIT0021","first-page":"1","article-title":"A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database","author":"Plattner","year":"2009"},{"issue":"1","key":"2023101000042721900_CIT0022","doi-asserted-by":"publisher","first-page":"65","DOI":"10.1145\/248603.248616","article-title":"An Overview of Data Warehousing and OLAP Technology","volume":"26","author":"Chaudhuri","year":"1997","journal-title":"ACM Sigmod Record"},{"issue":"2","key":"2023101000042721900_CIT0023","doi-asserted-by":"publisher","first-page":"175001","DOI":"10.1142\/S2424862217500117","article-title":"A Review of Cyber-Physical System Research Relevant to the Emerging It Trends: Industry 4.0, IoT, Big Data, and Cloud Computing","volume":"2","author":"Kim","year":"2017","journal-title":"J. Ind. Inf. Integr."},{"issue":"1","key":"2023101000042721900_CIT0024","doi-asserted-by":"publisher","first-page":"86","DOI":"10.1109\/69.273029","article-title":"Spatial SQL: A Query and Presentation Language","volume":"6","author":"Egenhofer","year":"1994","journal-title":"IEEE Trans. Knowl. Data Eng."},{"issue":"4","key":"2023101000042721900_CIT0025","doi-asserted-by":"publisher","first-page":"10","DOI":"10.1145\/1721654.1721659","article-title":"SQL Databases v. NoSQL Databases","volume":"53","author":"Stonebraker","year":"2010","journal-title":"Commun. ACM"},{"key":"2023101000042721900_CIT0026","first-page":"235","article-title":"MySQL and NoSQL Database Comparison for IoT Application","author":"Rautmare","year":"2016"},{"key":"2023101000042721900_CIT0027","first-page":"1","article-title":"Comparison of SQL, NoSQL and NewSQL Databases for Internet of Things","author":"Fatima","year":"2016"},{"issue":"4","key":"2023101000042721900_CIT0028","doi-asserted-by":"publisher","first-page":"12","DOI":"10.1145\/1978915.1978919","article-title":"Scalable SQL and NoSQL Data Stores","volume":"39","author":"Cattell","year":"2011","journal-title":"ACM Sigmod Record"},{"year":"1999","author":"Housley","key":"2023101000042721900_CIT0029"},{"author":"Apache Kafka, Apache Software Foundation","key":"2023101000042721900_CIT0030"},{"issue":"47","key":"2023101000042721900_CIT0031","first-page":"9478","article-title":"Apache Kafka: Next Generation Distributed Messaging System","volume":"3","author":"Thein","year":"2014","journal-title":"Int. J. Sci. Res. Eng. Technol."},{"key":"2023101000042721900_CIT0032","doi-asserted-by":"crossref","DOI":"10.1145\/2996890.2996911","volume-title":"Experiences Creating a Framework for Smart Traffic Control Using AWS IoT","author":"T\u00e4rneberg","year":"2016"},{"author":"Apache JMeter","key":"2023101000042721900_CIT0033"}],"container-title":["Journal of Computing and Information Science in Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/asmedigitalcollection.asme.org\/computingengineering\/article-pdf\/22\/6\/060901\/6926886\/jcise_22_6_060901.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/asmedigitalcollection.asme.org\/computingengineering\/article-pdf\/22\/6\/060901\/6926886\/jcise_22_6_060901.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,10]],"date-time":"2023-10-10T00:05:11Z","timestamp":1696896311000},"score":1,"resource":{"primary":{"URL":"https:\/\/asmedigitalcollection.asme.org\/computingengineering\/article\/22\/6\/060901\/1146423\/Scalability-Testing-Approach-for-Internet-of"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,10,10]]},"references-count":33,"journal-issue":{"issue":"6","published-print":{"date-parts":[[2022,12,1]]}},"URL":"https:\/\/doi.org\/10.1115\/1.4055733","relation":{},"ISSN":["1530-9827","1944-7078"],"issn-type":[{"type":"print","value":"1530-9827"},{"type":"electronic","value":"1944-7078"}],"subject":[],"published":{"date-parts":[[2022,10,10]]},"article-number":"060901"}}