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

Author(s):  
David Gamero ◽  
Andrew Dugenske ◽  
Thomas Kurfess ◽  
Christopher Saldana ◽  
Katherine Fu

Abstract In this paper, the design and performance differences between Relational Database Management Systems (RDBMS) and NoSQL Database Systems are examined, with attention to their applicability for real-world Internet of Things for manufacturing (IoTfM) data. While previous work has extensively compared SQL and NoSQL for both generalized and IoT uses, this work specifically examines the tradeoffs and performance differences for manufacturing applications by using a high-fidelity data set collected from a large US manufacturing firm. Growing an IoT system beyond the pilot stage requires scalable data storage; this work seeks to determine the impact of selected database systems on data write performance at scale. Payload size and message frequency were used as the primary characteristics to maintain model fidelity in simulated clients. As the number of simulated asset clients grow, the data write latency was calculated to determine how both database systems’ performance were affected. To isolate the RDBMS and NoSQL differences, a cloud environment was created using Amazon Web Services (AWS) with two identical data ingestion pipelines: writing data to an RDMBS (1) using AWS Aurora MySQL, and (2) using AWS DynamoDB NoSQL. The findings may provide guidance for further experimentation in large-scale manufacturing IoT implementations.

2019 ◽  
Vol 63 (1) ◽  
pp. 74-97 ◽  
Author(s):  
Susan-Marie Harding ◽  
Narelle English ◽  
Nives Nibali ◽  
Patrick Griffin ◽  
Lorraine Graham ◽  
...  

Students who can regulate their own learning are proposed to gain the most out of education, yet research into the impact of self-regulated learning skills on performance shows mixed results. This study supports the link between self-regulated learning and performance, while providing evidence of grade- or age-related differences. Australian students from Grades 5 to 8 completed mathematics or reading comprehension assessments and self-regulated learning questionnaires, with each response ranked on a hierarchy of quality. All assessments were psychometrically analysed and validated. In each cohort and overall, higher performing students reported higher levels of self-regulated learning. Still, age-related differences outweighed performance differences, resulting in significantly lower reported usage of self-regulated learning skills in Grade 7 students compared to those in Grades 5, 6 and 8. These findings suggest that either age or school organisational differences mediate students’ self-regulated learning, counteracting ability-related associations.


2015 ◽  
Vol 42 (12) ◽  
pp. 1071-1089
Author(s):  
Alan Chan ◽  
Bruce G. Fawcett ◽  
Shu-Kam Lee

Purpose – Church giving and attendance are two important indicators of church health and performance. In the literature, they are usually understood to be simultaneously determined. The purpose of this paper is to estimate if there a sustainable church congregation size using Wintrobe’s (1998) dictatorship model. The authors want to examine the impact of youth and adult ministry as well. Design/methodology/approach – Using the data collected from among Canadian Baptist churches in Eastern Canada, this study investigates the factors affecting the level of the two indicators by the panel-instrumental variable technique. Applying Wintrobe’s (1998) political economy model on dictatorship, the equilibrium level of worship attendance and giving is predicted. Findings – Through various simulation exercises, the actual church congregation sizes is approximately 50 percent of the predicted value, implying inefficiency and misallocation of church resources. The paper concludes with insights on effective ways church leaders can allocate scarce resources to promote growth within churches. Originality/value – The authors are the only researchers getting the permission from the Atlantic Canada Baptist Convention to use their mega data set on church giving and congregation sizes as per the authors’ knowledge. The authors are also applying a theoretical model on dictatorship to religious/not for profits organizations.


2015 ◽  
Vol 8 (1) ◽  
pp. 421-434 ◽  
Author(s):  
M. P. Jensen ◽  
T. Toto ◽  
D. Troyan ◽  
P. E. Ciesielski ◽  
D. Holdridge ◽  
...  

Abstract. The Midlatitude Continental Convective Clouds Experiment (MC3E) took place during the spring of 2011 centered in north-central Oklahoma, USA. The main goal of this field campaign was to capture the dynamical and microphysical characteristics of precipitating convective systems in the US Central Plains. A major component of the campaign was a six-site radiosonde array designed to capture the large-scale variability of the atmospheric state with the intent of deriving model forcing data sets. Over the course of the 46-day MC3E campaign, a total of 1362 radiosondes were launched from the enhanced sonde network. This manuscript provides details on the instrumentation used as part of the sounding array, the data processing activities including quality checks and humidity bias corrections and an analysis of the impacts of bias correction and algorithm assumptions on the determination of convective levels and indices. It is found that corrections for known radiosonde humidity biases and assumptions regarding the characteristics of the surface convective parcel result in significant differences in the derived values of convective levels and indices in many soundings. In addition, the impact of including the humidity corrections and quality controls on the thermodynamic profiles that are used in the derivation of a large-scale model forcing data set are investigated. The results show a significant impact on the derived large-scale vertical velocity field illustrating the importance of addressing these humidity biases.


2014 ◽  
Vol 2014 ◽  
pp. 1-15 ◽  
Author(s):  
Kwang-il Hwang ◽  
Sung-wook Nam

In order to construct a successful Internet of things (IoT), reliable network construction and maintenance in a sensor domain should be supported. However, IEEE 802.15.4, which is the most representative wireless standard for IoT, still has problems in constructing a large-scale sensor network, such as beacon collision. To overcome some problems in IEEE 802.15.4, the 15.4e task group proposed various different modes of operation. Particularly, the IEEE 802.15.4e deterministic and synchronous multichannel extension (DSME) mode presents a novel scheduling model to solve beacon collision problems. However, the DSME model specified in the 15.4e draft does not present a concrete design model but a conceptual abstract model. Therefore, in this paper we introduce a DSME beacon scheduling model and present a concrete design model. Furthermore, validity and performance of DSME are evaluated through experiments. Based on experiment results, we analyze the problems and limitations of DSME, present solutions step by step, and finally propose an enhanced DSME beacon scheduling model. Through additional experiments, we prove the performance superiority of enhanced DSME.


2018 ◽  
Vol 19 (5) ◽  
pp. 915-934 ◽  
Author(s):  
Gianluca Ginesti ◽  
Adele Caldarelli ◽  
Annamaria Zampella

Purpose The purpose of this paper is to analyse the impact of intellectual capital (IC) on the reputation and performance of Italian companies. Design/methodology/approach The paper exploits a unique data set of 452 non-listed companies that obtained a reputational assessment from the Italian Competition Authority (ICA). To test the hypotheses, this study implemented several regression analyses. Findings Results support the argument that human capital efficiency is a key driver of corporate reputation. Findings also reveal that companies, which obtained reputational rating under ICA scrutiny, show a positive relationship between IC elements and various measures of financial performance. Research limitations/implications The study focuses on a single country; it is not free from the imprecisions of Pulic’s VAIC model. Practical implications This paper recommends companies that are interested to achieve a robust reputation should consider the human capital as a strategic intangible asset. Second, the results suggest that companies with an ICA reputational rating are able to leverage their intangibles to potentiate performance and competitiveness. Originality/value This is the first empirical investigation on the contribution of IC in generating value for corporate reputation. Additionally, the study contributes to the literature on the link between IC and performance by examining a sample of firms not yet explored in prior research.


2017 ◽  
Vol 10 (5) ◽  
pp. 2031-2055 ◽  
Author(s):  
Thomas Schwitalla ◽  
Hans-Stefan Bauer ◽  
Volker Wulfmeyer ◽  
Kirsten Warrach-Sagi

Abstract. Increasing computational resources and the demands of impact modelers, stake holders, and society envision seasonal and climate simulations with the convection-permitting resolution. So far such a resolution is only achieved with a limited-area model whose results are impacted by zonal and meridional boundaries. Here, we present the setup of a latitude-belt domain that reduces disturbances originating from the western and eastern boundaries and therefore allows for studying the impact of model resolution and physical parameterization. The Weather Research and Forecasting (WRF) model coupled to the NOAH land–surface model was operated during July and August 2013 at two different horizontal resolutions, namely 0.03 (HIRES) and 0.12° (LOWRES). Both simulations were forced by the European Centre for Medium-Range Weather Forecasts (ECMWF) operational analysis data at the northern and southern domain boundaries, and the high-resolution Operational Sea Surface Temperature and Sea Ice Analysis (OSTIA) data at the sea surface.The simulations are compared to the operational ECMWF analysis for the representation of large-scale features. To analyze the simulated precipitation, the operational ECMWF forecast, the CPC MORPHing (CMORPH), and the ENSEMBLES gridded observation precipitation data set (E-OBS) were used as references.Analyzing pressure, geopotential height, wind, and temperature fields as well as precipitation revealed (1) a benefit from the higher resolution concerning the reduction of monthly biases, root mean square error, and an improved Pearson skill score, and (2) deficiencies in the physical parameterizations leading to notable biases in distinct regions like the polar Atlantic for the LOWRES simulation, the North Pacific, and Inner Mongolia for both resolutions.In summary, the application of a latitude belt on a convection-permitting resolution shows promising results that are beneficial for future seasonal forecasting.


2009 ◽  
Vol 2 (1) ◽  
pp. 87-98 ◽  
Author(s):  
C. Lerot ◽  
M. Van Roozendael ◽  
J. van Geffen ◽  
J. van Gent ◽  
C. Fayt ◽  
...  

Abstract. Total O3 columns have been retrieved from six years of SCIAMACHY nadir UV radiance measurements using SDOAS, an adaptation of the GDOAS algorithm previously developed at BIRA-IASB for the GOME instrument. GDOAS and SDOAS have been implemented by the German Aerospace Center (DLR) in the version 4 of the GOME Data Processor (GDP) and in version 3 of the SCIAMACHY Ground Processor (SGP), respectively. The processors are being run at the DLR processing centre on behalf of the European Space Agency (ESA). We first focus on the description of the SDOAS algorithm with particular attention to the impact of uncertainties on the reference O3 absorption cross-sections. Second, the resulting SCIAMACHY total ozone data set is globally evaluated through large-scale comparisons with results from GOME and OMI as well as with ground-based correlative measurements. The various total ozone data sets are found to agree within 2% on average. However, a negative trend of 0.2–0.4%/year has been identified in the SCIAMACHY O3 columns; this probably originates from instrumental degradation effects that have not yet been fully characterized.


2014 ◽  
Vol 7 (4) ◽  
pp. 5087-5139 ◽  
Author(s):  
R. Pommrich ◽  
R. Müller ◽  
J.-U. Grooß ◽  
P. Konopka ◽  
F. Ploeger ◽  
...  

Abstract. Variations in the mixing ratio of trace gases of tropospheric origin entering the stratosphere in the tropics are of interest for assessing both troposphere to stratosphere transport fluxes in the tropics and the impact of these transport fluxes on the composition of the tropical lower stratosphere. Anomaly patterns of carbon monoxide (CO) and long-lived tracers in the lower tropical stratosphere allow conclusions about the rate and the variability of tropical upwelling to be drawn. Here, we present a simplified chemistry scheme for the Chemical Lagrangian Model of the Stratosphere (CLaMS) for the simulation, at comparatively low numerical cost, of CO, ozone, and long-lived trace substances (CH4, N2O, CCl3F (CFC-11), CCl2F2 (CFC-12), and CO2) in the lower tropical stratosphere. For the long-lived trace substances, the boundary conditions at the surface are prescribed based on ground-based measurements in the lowest model level. The boundary condition for CO in the free troposphere is deduced from MOPITT measurements (at ≈ 700–200 hPa). Due to the lack of a specific representation of mixing and convective uplift in the troposphere in this model version, enhanced CO values, in particular those resulting from convective outflow are underestimated. However, in the tropical tropopause layer and the lower tropical stratosphere, there is relatively good agreement of simulated CO with in-situ measurements (with the exception of the TROCCINOX campaign, where CO in the simulation is biased low ≈ 10–20 ppbv). Further, the model results are of sufficient quality to describe large scale anomaly patterns of CO in the lower stratosphere. In particular, the zonally averaged tropical CO anomaly patterns (the so called "tape recorder" patterns) simulated by this model version of CLaMS are in good agreement with observations. The simulations show a too rapid upwelling compared to observations as a consequence of the overestimated vertical velocities in the ERA-interim reanalysis data set. Moreover, the simulated tropical anomaly patterns of N2O are in good agreement with observations. In the simulations, anomaly patterns for CH4 and CFC-11 were found to be consistent with those of N2O; for all long-lived tracers, positive anomalies are simulated because of the enhanced tropical upwelling in the easterly phase of the quasi-biennial oscillation.


2021 ◽  
Vol 17 ◽  
pp. 47-55
Author(s):  
Olusegun Osho ◽  
Alexander Ehimare Omankhanlen ◽  
Mojisola Fasanmi ◽  
Victoria Akinjare

Considering the possibility of finding a gap and a room for improvement, so much have been written about liquidity and performance. Notwithstanding, the emphasis has been on profitability as a yardstick for performance and little has been done on other areas of performance measurement. The emphasis has also been more on various economic sectors with the exception of the manufacturing industry. This paper intends to look at the impact, if any, of liquidity provision and availability on Nigeria’s manufacturing firm’s performance from the perspective of Economic Value Added (EVA). Economic value-adding is beyond just profitability or liquidity. The firm's value to the stakeholders, its sustainability and long-term values are defined. The study would apply liquidity theories, profitability and the economic value-added theories as it applies to a manufacturing firm in a developing economy like Nigeria. On its methodology, the article data is obtained from the World Bank’s World Development Indicators-WDI and then a regression analysis will be run on the data using the SPSS software and then an analysis of the results of the regression. The last section of the article would conclude and make recommendations from the study outcome and the empirical analysis with respect to the theories.


2021 ◽  
Author(s):  
Ahmed Alghamdi ◽  
Olakunle Ayoola ◽  
Khalid Mulhem ◽  
Mutlaq Otaibi ◽  
Abdulazeez Abdulraheem

Abstract Chokes are an integral part of production systems and are crucial surface equipment that faces rough conditions such as high-pressure drops and erosion due to solids. Predicting choke health is usually achieved by analyzing the relationship of choke size, pressure, and flow rate. In large-scale fields, this process requires extensive-time and effort using the conventional techniques. This paper presents a real-time proactive approach to detect choke wear utilizing production data integrated with AI analytics. Flowing parameters data were collected for more than 30 gas wells. These wells are producing gas with slight solids production from a high-pressure high-temperature field. In addition, these wells are equipped with a multi-stage choke system. The approach of determining choke wear relies on training the AI model on a dataset constructed by comparison of the choke valve rate of change with respect to a smoother slope of the production rate. If the rate of change is not within a tolerated range of divergence, an abnormal choke behavior is detected. The data set was divided into 70% for training and 30% for testing. Artificial Neural Network (ANN) was trained on data that has the following inputs: gas specific gravity, upstream & downstream pressure and temperature, and choke size. This ANN model achieved a correlation coefficient above 0.9 with an excellent prediction on the data points exhibiting normal or abnormal choke behaviors. Piloting this application on large fields, where manual analysis is often impractical, saves a substantial man-hour and generates significant cost-avoidance. Areas for improvement in such an application depends on equipping the ANN network with long-term production profile prediction abilities, such as water production, and this analysis relies on having an accurate reading from the venturi meters, which is often the case in single-phase flow. The application of this AI-driven analytics provides tremendous improvement for remote offshore production operations surveillance. The novel approach presented in this paper capitalizes on the AI analytics for estimating proactively detecting choke health conditions. The advantages of such a model are that it harnesses AI analytics to help operators improve asset integrity and production monitoring compliance. In addition, this approach can be expanded to estimate sand production as choke wear is a strong function of sand production.


Sign in / Sign up

Export Citation Format

Share Document