Skip to main content
Top

2021 | OriginalPaper | Chapter

Automated Profiling of Energy Data in Manufacturing

Authors : C. Kaymakci, A. Sauer

Published in: Production at the leading edge of technology

Publisher: Springer Berlin Heidelberg

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

In order to offer energy flexibility in energy markets in short time slots a fast and efficient processing and analysis of data from shop floor to production planning and control is necessary. To this end and to gain more knowledge, different datasets and sources have to be integrated. This paper proposes a conceptual architecture and a method for profiling energy data of manufacturing systems. This includes datasets from information systems as well as physical sources such as sensors, actuators or machine data. Real-life data often come with quality problems like missing and invalid values, outliers or duplicates. The key concept is to automatically identify the necessary metadata for including the dataset in an environment where further analysis and integration of datasets can take place. Moreover, a web service for profiling and visualizing data is implemented.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference Bundesumweltamt: Erneuerbare Energien in Deutschland. Daten zur Entwicklung im Jahr 2018 (2018) Bundesumweltamt: Erneuerbare Energien in Deutschland. Daten zur Entwicklung im Jahr 2018 (2018)
2.
go back to reference Roesch, M., Bauer, D., Haupt, L., Keller, R., Bauernhansl, T., Fridgen, G., Reinhart, G., Sauer, A.: Harnessing the full potential of industrial demand-side flexibility: an end-to-end approach connecting machines with markets through service-oriented IT platforms. Appl. Sci. 9(18), 37 (2019)CrossRef Roesch, M., Bauer, D., Haupt, L., Keller, R., Bauernhansl, T., Fridgen, G., Reinhart, G., Sauer, A.: Harnessing the full potential of industrial demand-side flexibility: an end-to-end approach connecting machines with markets through service-oriented IT platforms. Appl. Sci. 9(18), 37 (2019)CrossRef
3.
go back to reference Palensky, P., Dietrich, D.: Demand side management: demand response, intelligent energy systems, and smart loads. IEEE Trans. Industr. Inform. 7(3), 381–388 (2011)CrossRef Palensky, P., Dietrich, D.: Demand side management: demand response, intelligent energy systems, and smart loads. IEEE Trans. Industr. Inform. 7(3), 381–388 (2011)CrossRef
4.
go back to reference O’Donovan, P., Leahy, K., Bruton, K., O’Sullivan, D.T.J.: Big data in manufacturing: a systematic mapping study. J. Big Data 2(1), 20 (2015) CrossRef O’Donovan, P., Leahy, K., Bruton, K., O’Sullivan, D.T.J.: Big data in manufacturing: a systematic mapping study. J. Big Data 2(1), 20 (2015) CrossRef
5.
go back to reference Harding, J.A., Shahbaz, M., Srinivas, Kusiak, A.: Data mining in manufacturing: a review. J. Manuf. Sci. Eng. 128(4):969–976 (2006) Harding, J.A., Shahbaz, M., Srinivas, Kusiak, A.: Data mining in manufacturing: a review. J. Manuf. Sci. Eng. 128(4):969–976 (2006)
6.
go back to reference Cui, Y., Kara, S., Chan, K.C.: Manufacturing big data ecosystem: a systematic literature review. Robot. Comput. Integr. Manuf. 62 (2020) Cui, Y., Kara, S., Chan, K.C.: Manufacturing big data ecosystem: a systematic literature review. Robot. Comput. Integr. Manuf. 62 (2020)
7.
go back to reference Westkämper, E., Löffler, C.: Visionen und strategische Konzepte für das System Produktion Grenzen überwinden mit Strategie und Technologie. In: Westkämper, E., Löffler, C. (eds.) Strategien der Produktion, pp. 71–237. Springer Vieweg, Berlin (2016) CrossRef Westkämper, E., Löffler, C.: Visionen und strategische Konzepte für das System Produktion Grenzen überwinden mit Strategie und Technologie. In: Westkämper, E., Löffler, C. (eds.) Strategien der Produktion, pp. 71–237. Springer Vieweg, Berlin (2016) CrossRef
8.
go back to reference Castro Fernandez, R., Abedjan, Z., Koko, F., Yuan, G., Madden, S., Stonebraker, M.: Aurum: a data discovery system. In: Proceedings – IEEE 34th International Conference on Data Engineering, ICDE 2018, pp. 1001–1012. Institute of Electrical and Electronics Engineers Inc. (2018) Castro Fernandez, R., Abedjan, Z., Koko, F., Yuan, G., Madden, S., Stonebraker, M.: Aurum: a data discovery system. In: Proceedings – IEEE 34th International Conference on Data Engineering, ICDE 2018, pp. 1001–1012. Institute of Electrical and Electronics Engineers Inc. (2018)
9.
go back to reference International Organisation for Standardization: ISO 50001 – Energy Management (2011) International Organisation for Standardization: ISO 50001 – Energy Management (2011)
10.
go back to reference Sauer, A., Weckmann, S., Zimmermann, F.: Softwarelösungen für das Energiemanagement von morgen. Stuttgart (2016) Sauer, A., Weckmann, S., Zimmermann, F.: Softwarelösungen für das Energiemanagement von morgen. Stuttgart (2016)
11.
go back to reference Dirk, B., Marko, E., Olaf, G., Schulze, J.: Energiemanagement. Springer Vieweg, Wiesbaden (2019) Dirk, B., Marko, E., Olaf, G., Schulze, J.: Energiemanagement. Springer Vieweg, Wiesbaden (2019)
12.
go back to reference Ziegel, E.R., Box, G., Jenkins, G., Reinsel, G.: Time series analysis, forecasting, and control. Technometrics 37(2), 238 (1995) Ziegel, E.R., Box, G., Jenkins, G., Reinsel, G.: Time series analysis, forecasting, and control. Technometrics 37(2), 238 (1995)
13.
go back to reference Abedjan, Z., Golab, L., Naumann, F.: Data profiling (2018) Abedjan, Z., Golab, L., Naumann, F.: Data profiling (2018)
14.
go back to reference Halevy, A., Noy, N.F., Olston, C., Polyzotis, N., Roy, S., Whang, S.E.: Goods: organizing Google’s datasets (2016) Halevy, A., Noy, N.F., Olston, C., Polyzotis, N., Roy, S., Whang, S.E.: Goods: organizing Google’s datasets (2016)
15.
go back to reference Fernandez, R.C., Madden, S.: Termite: a system for tunneling through heterogeneous data. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 1–8. Association for Computing Machinery, New York, USA (2019) Fernandez, R.C., Madden, S.: Termite: a system for tunneling through heterogeneous data. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 1–8. Association for Computing Machinery, New York, USA (2019)
16.
go back to reference Maccioni, A., Torlone, R.: KAYAK: a framework for just-in-time data preparation in a data lake. In: Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), pp. 474–489. Springer (2018) Maccioni, A., Torlone, R.: KAYAK: a framework for just-in-time data preparation in a data lake. In: Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), pp. 474–489. Springer (2018)
17.
go back to reference Gschwandtner, T., Erhart, O.: Know your enemy: identifying quality problems of time series data. IEEE Pacific Vis. Symp. 1, 205–214 (2018) Gschwandtner, T., Erhart, O.: Know your enemy: identifying quality problems of time series data. IEEE Pacific Vis. Symp. 1, 205–214 (2018)
18.
go back to reference Gschwandtner, T., Gärtner, J., Aigner, W., Miksch, S.: A taxonomy of dirty time-oriented data. Lect. Notes Comput. Sci. 7465, 58–72 (2012)CrossRef Gschwandtner, T., Gärtner, J., Aigner, W., Miksch, S.: A taxonomy of dirty time-oriented data. Lect. Notes Comput. Sci. 7465, 58–72 (2012)CrossRef
19.
go back to reference Aigner, W., Gärtner, J., Kriglstein, S., Pohl, M., Suchy, N.: TimeCleanser : A visual analytics approach for data cleansing of time-oriented data categories and subject descriptors. In: Proceedings of the 14th International Conference on Knowledge Technologies and Data-Driven Business (2014) Aigner, W., Gärtner, J., Kriglstein, S., Pohl, M., Suchy, N.: TimeCleanser : A visual analytics approach for data cleansing of time-oriented data categories and subject descriptors. In: Proceedings of the 14th International Conference on Knowledge Technologies and Data-Driven Business (2014)
20.
go back to reference Bors, C., Gschwandtner, T., Miksch, S.: Capturing and visualizing provenance from data wrangling. IEEE Comput. Graph. Appl. 39(6), 61–75 (2019)CrossRef Bors, C., Gschwandtner, T., Miksch, S.: Capturing and visualizing provenance from data wrangling. IEEE Comput. Graph. Appl. 39(6), 61–75 (2019)CrossRef
21.
go back to reference Kusumasari, T.F., Fitria: Data profiling for data quality improvement with OpenRefine. In: International Conference on Information Technology Systems and Innovation (2017) Kusumasari, T.F., Fitria: Data profiling for data quality improvement with OpenRefine. In: International Conference on Information Technology Systems and Innovation (2017)
22.
go back to reference Arbesser, C., Spechtenhauser, F., Mühlbacher, T., Piringer, H.: Visplause: visual data quality assessment of many time series using plausibility checks. IEEE Trans. Vis. Comput. Graph. 23(1), 641–65 (2017)CrossRef Arbesser, C., Spechtenhauser, F., Mühlbacher, T., Piringer, H.: Visplause: visual data quality assessment of many time series using plausibility checks. IEEE Trans. Vis. Comput. Graph. 23(1), 641–65 (2017)CrossRef
23.
go back to reference Schatten, A., Demolsky, M., Winkler, D., Biffl, S., Gostischa-Franta, E., Östreicher, T.: Software-Architektur. In: Best Practice Software-Engineering: Eine praxiserprobte Zusammenstellung von komponentenorientierten Konzepten, Methoden und Werkzeugen, pp. 199–227. Spektrum Akademischer Verlag, Heidelberg (2010)CrossRef Schatten, A., Demolsky, M., Winkler, D., Biffl, S., Gostischa-Franta, E., Östreicher, T.: Software-Architektur. In: Best Practice Software-Engineering: Eine praxiserprobte Zusammenstellung von komponentenorientierten Konzepten, Methoden und Werkzeugen, pp. 199–227. Spektrum Akademischer Verlag, Heidelberg (2010)CrossRef
Metadata
Title
Automated Profiling of Energy Data in Manufacturing
Authors
C. Kaymakci
A. Sauer
Copyright Year
2021
Publisher
Springer Berlin Heidelberg
DOI
https://doi.org/10.1007/978-3-662-62138-7_56

Premium Partners