Abstract
At present, the level of process automation in conjunction with modern information technology provides large data files that can serve for deeper process analysis. The aim is to obtain relevant information about the process under investigation. For these purposes, data analysis is used. It allows users to convert source data into a comprehensive format, which is then used to support decision-making, draw conclusions and allow predictive analysis too. However, data processing often encounters some problems. Only a large amount of data can be a problem in a point of view of its suitability for analysis. Missing values are another major problem in terms of analysis. In technical measurements, this condition can occur even if the monitored process is equipped with modern sensors.
The paper describes the application of data modelling knowledge to real data obtained by monitoring the heating process, where the process control is used based on weather compensation. Data have been collected from different interfaces, and it has been analysed from different views.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Data management. https://www.sas.com/content/dam/SAS/en_us/doc/other1/data-management-why-is-it-important-107421.pdf. Accessed 12 Nov 2019
Lenhardt, W.C., Ahalt, S., Blanton, B., Christopherson, L., Idaszak, R.: Data management lifecycle and software lifecycle management in the context of conducting science. J. Open Res. Soft. 2(1), e15. https://doi.org/10.5334/jors.ax. pp. 1–4. Accessed 13 Nov 2019
Piteľ, J., Mižáková, J., Mižák, J.: Control systems of the heat production and supply for concept of industry 4.0. In: Vykurovanie 2017, Podbanské, 6.3.-10.3.2017, pp. 391–394. SSTP, Bratislava (2017)
Židek, K., Piteľ, J., Hošovský, A.: Machine learning algorithms implementation into embedded systems with web application user interface. In: Proceedings of the IEEE 21st International Conference on Intelligent Engineering Systems 2017 (INES 2017). October 20–23, 2017, pp. 77–81, Larnaca, Cyprus. IEEE, Budapest (2017)
Saloky, T., Piteľ, J.: Adaptive Control of Heating Process with Outdoor Temperature Compensation, XXX. In: ASR ‘2005 Seminar, Instruments and Control, Ostrava, April 29. Available from http://akce.fs.vsb.cz/2005/asr2005/Proceedings/papers/383.pdf (2005). Accessed 15 July 2019
Mižáková, J., Piteľ, J.: An analytical dynamic model of heat transfer from the heating body to the heated room. In: 21st International Conference on Circuits, Systems, Communications and Computers (CSCC 2017). Crete Island, Greece, July 14–17, 2017. MATEC Web of Conferences 125, 02047, 5p
Čorný, I.: Overview of progressive evaluation methods for monitoring of heat production and distribution. Process. Eng. 619–626 (2017)
Russo, A., Ferrari, M.: Microsoft Excel 2013: Building Data Models with Power Pivot, Published by Microsoft Press. http://index-of.co.uk/OFIMATICA/Microsoft%20Press%20Excel%202013,%20Building%20Data%20Models%20with%20PowerPivot.pdf (2013). Accessed 5 Nov 2019
Singh, A, Collie, R.: Power Pivot and Power BI. Independent Publishers Group, Chicago, IL. http://www.allitebooks.in/power-pivot-and-power-bi/. Accessed 5 Nov 2019
Pratama, I.; Permanasari, A. E.; Ardiyanto, I.; Indrayani, R. A review of missing values handling methods on time-series data. In: International Conference on Information Technology Systems and Innovation, Bandung—Bali, October 24–27, 2016
Custodio, C. Y.; Walter T.; Dunn, L.; Mercado, A.; Brown, A. E.; Mathew, P. Data Preparation Process for the Buildings Performance Database. https://www.energy.gov/sites/prod/files/2015/09/f26/bto_Data_Preparation_for_BPD_Aug2015.pdf (2015). Accessed 25 Jul 2019
Polong, L.: The Data Science Process. Available from https://www.01.ibm.com/events/wwe/grp/grp304.nsf/vLookupPDFs/Polong%20Lin%20Presentation/$file/Polong%20Lin%20Presentation.pdf. Accessed 25 July 2019
Tamilselvi, J.J., Gifta, C.B.: Handling duplicate data in data warehouse for data mining. Int. J. Comput. Appl. 15(4), 975–8887 (2011). Available from https://pdfs.semanticscholar.org/be0c/a2a8054c2778c2dc2f8c6bbbc1707db34fff.pdf. Accessed 5 Nov 2019
Graham, J.W., Cumsille, P.E., Elek-Fisk, E.: Methods for handling missing data. In: Schinka, J.A., Velicer, W.F., Weiner, I.B. (eds.) Handbook of Psychology, Research Methods in Psychology, vol. 2, pp. 87–114. John Wiley and Sons, Hoboken, NJ
Berkery, E.M.: Missing data analysis with the Mahalanobis distance, 2016 Available form https://ulir.ul.ie/bitstream/handle/10344/5235/Berkery_2016_missing.pdf?sequence=6
Sitaram, D.; Dalwani, A.; Narang, A.; Das, M.; Auradkar, P. A Measure of similarity of time series containing missing data using the Mahalanobis distance. In: Proc. 2015, 2nd International Conference on Advances in Computing and Communication Engineering ICACCE 2015, pp. 622–627 (2015)
Aydilek, I.B., Arslan, A.: A hybrid method for imputation of missing values using optimized fuzzy c-means with support vector regression and a genetic algorithm. Inf. Sci. 233, 25–35 (2013)
Soley-Bori, M. Dealing with missing data: key assumptions and methods for applied analysis. Technical report no. 4. Boston University. Available from https://www.bu.edu/sph/files/2014/05/Marina-tech-report.pdf. Accessed 12 Nov 2019
Rubin, D.B.: Inference and missing data. Biometrika. 63(3), 581–592 (1976)
Graham, J.W.: Missing data analysis: making it work in the real world. Ann. Rev. Psychol. 60, 549–576 (2009). by Pennsylvania State University
Enders, C.K.: Applied Missing Data Analysis. The Guilford Press, New York (2010). Available from http://hsta559s12.pbworks.com/w/file/fetch/52112520/enders.applied. Accessed 8 July 2019
Little, R.J., Rubin, D.B.: Statistical Analysis with Missing Data, Probability and Statistics, 2nd edn. Wiley, Hoboken, NJ (2002)
Buuren, S.: Flexible Imputation of Missing Data. CRC Press, Boca Raton, FL (2012). http://pzs.dstu.dp.ua/DataMining/preprocessing/bibl/fimd.pdf. . Accessed 25 July 2019, Accessed 8 July 2019
Klenke, M.: What is standard about deviation? (2015). Available from http://www.qatc.org/winter-2015-connection/what-is-standard-about-deviation/
Rumsey, D.B.: How to interpret standard deviation in a statistical data set. Available from http://www.dummies.com/education/math/statistics/how-to-interpret-standard-deviation-in-a-statistical-data-set/. Accessed 2 Nov 2019
Benková, M., Floreková, Ľ., Bogdanovská, G.: Variability of quality parameters and loss function. Acta Montan. Slovaca. 10(1), 57–61 (2005)
Acknowledgement
This work was supported by the Slovak Research and Development Agency under the contract no. APVV-15-0602.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this chapter
Cite this chapter
Hrehová, S. (2020). Description of Possible Approaches to Create and Analyse Data Model. In: Knapcikova, L., Balog, M., Peraković, D., Periša, M. (eds) New Approaches in Management of Smart Manufacturing Systems. EAI/Springer Innovations in Communication and Computing. Springer, Cham. https://doi.org/10.1007/978-3-030-40176-4_5
Download citation
DOI: https://doi.org/10.1007/978-3-030-40176-4_5
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-40175-7
Online ISBN: 978-3-030-40176-4
eBook Packages: EngineeringEngineering (R0)