{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,4,9]],"date-time":"2024-04-09T05:59:54Z","timestamp":1712642394100},"reference-count":35,"publisher":"Walter de Gruyter GmbH","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2023,1,27]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:p>Providing data for data analysis projects is one core task of automation technology, however, it still has to be done with a lot of manual effort. One challenge is to keep the meaning of data remain interpretable within or across multiple software environments so that provider and user of data share a common understanding of the transferred data. It is acknowledged that machine interpretable metadata is one crucial building block for reaching this goal. However, in industrial automation and information systems today, exporting and utilizing data coupled with metadata is still not a common practice. Therefore, we propose a general concept for extracting metadata and utilizing it in data analytics applications, which may help with system design in the future. The concept is prototypically implemented regarding the structural metadata for tabular data.<\/jats:p>","DOI":"10.1515\/auto-2022-0107","type":"journal-article","created":{"date-parts":[[2023,1,12]],"date-time":"2023-01-12T08:07:47Z","timestamp":1673510867000},"page":"44-55","source":"Crossref","is-referenced-by-count":1,"title":["A concept for providing and utilizing metadata in data analytics applications"],"prefix":"10.1515","volume":"71","author":[{"given":"Wan","family":"Li","sequence":"first","affiliation":[{"name":"Chair of Information and Automation Systems for Process and Material Technology , RWTH Aachen University , Turmstr. 46, 52064 Aachen , Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tobias","family":"Kleinert","sequence":"additional","affiliation":[{"name":"Chair of Information and Automation Systems for Process and Material Technology , RWTH Aachen University , Turmstr. 46, 52064 Aachen , Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"374","published-online":{"date-parts":[[2023,1,13]]},"reference":[{"key":"2023033110472097046_j_auto-2022-0107_ref_001","doi-asserted-by":"crossref","unstructured":"T. Bauernhansl, \u201cIndustrie 4.0 in Produktion, Automatisierung und Logistik,\u201d in Anwendung, Technologien und Migration, Wiesbaden, Springer Vieweg, 2014.","DOI":"10.1007\/978-3-658-04682-8"},{"key":"2023033110472097046_j_auto-2022-0107_ref_002","doi-asserted-by":"crossref","unstructured":"D. Fasel and A. Meier, Big Data. Grundlagen, Systeme und Nutzungspotenziale, Wiesbaden, Springer Fachmedien Wiesbaden, 2016.","DOI":"10.1007\/978-3-658-11589-0"},{"key":"2023033110472097046_j_auto-2022-0107_ref_003","doi-asserted-by":"crossref","unstructured":"B. Vogel-Heuser, T. Bauernhansl, and M. t. Hompel, Handbuch Industrie 4.0 Bd.4. Allgemeine Grundlagen, 2nd ed. Heidelberg, Springer Vieweg Berlin, 2017.","DOI":"10.1007\/978-3-662-53254-6"},{"key":"2023033110472097046_j_auto-2022-0107_ref_004","unstructured":"J. Han, M. Kamber, and J. Pei, Data Mining - Concepts and Techniques, 3rd ed. Waltham, MA, Morgan Kaufmann, 2012."},{"key":"2023033110472097046_j_auto-2022-0107_ref_005","doi-asserted-by":"crossref","unstructured":"B. Hj\u00f8rland, \u201cData (with big data and database semantics),\u201d Knowl. Organ., vol.\u00a045, no.\u00a08, pp.\u00a0685\u2013708, 2018, https:\/\/doi.org\/10.5771\/0943-7444-2018-8-685.","DOI":"10.5771\/0943-7444-2018-8-685"},{"key":"2023033110472097046_j_auto-2022-0107_ref_006","unstructured":"C. Shearer, \u201cThe CRISP-DM model: the new blueprint for data mining,\u201d J. Data Warehous., vol.\u00a05, no.\u00a04, pp.\u00a013\u201322, 2018."},{"key":"2023033110472097046_j_auto-2022-0107_ref_007","unstructured":"NIST Big Data Public Working Group, NIST Big Data Interoperability Framework: Volume 7, Standards Roadmap, Gaithersburg, MD, National Institute of Standards and Technology, 2019."},{"key":"2023033110472097046_j_auto-2022-0107_ref_008","unstructured":"NIST Big Data Public Working Group, NIST Big Data Interoperability Framework: Volume 1, Definitions, Gaithersburg, MD, National Institute of Standards and Technology, 2019."},{"key":"2023033110472097046_j_auto-2022-0107_ref_009","unstructured":"P. Vincent, K. Iijima, M. Driver, J. Wong, and Y. Natis, Magic Quadrant for Enterprise Low-Code Application Platforms, Stamford, Connecticut, Gartner, 2019."},{"key":"2023033110472097046_j_auto-2022-0107_ref_010","doi-asserted-by":"crossref","unstructured":"M. Allen and D. Cervo, \u201cMetadata management,\u201d in Multi-Domain Master Data Management, Waltham, MA, Morgan Kaufmann, 2015, pp. 161\u2013178.","DOI":"10.1016\/B978-0-12-800835-5.00010-5"},{"key":"2023033110472097046_j_auto-2022-0107_ref_011","doi-asserted-by":"crossref","unstructured":"J. Han, M. Kamber, and J. Pei, \u201cData warehousing and online analytical processing,\u201d in Data mining - concepts and techniques, 3rd ed. Waltham, MA, Morgan Kaufmann, 2012.","DOI":"10.1016\/B978-0-12-381479-1.00004-6"},{"key":"2023033110472097046_j_auto-2022-0107_ref_012","doi-asserted-by":"crossref","unstructured":"D. Loshin, \u201cMetadata,\u201d in Business Intelligence, 2nd ed. Waltham, MA, Morgan Kaufmann, 2013, pp. 119\u2013130.","DOI":"10.1016\/B978-0-12-385889-4.00009-0"},{"key":"2023033110472097046_j_auto-2022-0107_ref_013","doi-asserted-by":"crossref","unstructured":"J. Melton and S. Buxton, \u201cMetadata \u2013 an overview,\u201d in Querying XML, San Francisco, CA, Morgan Kaufmann, 2006, pp. 67\u201384.","DOI":"10.1016\/B978-155860711-8\/50005-8"},{"key":"2023033110472097046_j_auto-2022-0107_ref_014","unstructured":"R. Pollock, J. Tennison, G. Kellogg, and I. Herman, Metadata Vocabulary for Tabular Data, W3C, 2015, [Online]. Available at: https:\/\/www.w3.org\/TR\/tabular-metadata\/."},{"key":"2023033110472097046_j_auto-2022-0107_ref_015","doi-asserted-by":"crossref","unstructured":"A. B. Zhang and D. Gourley, \u201cMetadata strategy,\u201d in Creating Digital Collections, Station Lane, Witney, Chandos Publishing, 2009, pp. 31\u201353.","DOI":"10.1016\/B978-1-84334-396-7.50004-3"},{"key":"2023033110472097046_j_auto-2022-0107_ref_016","unstructured":"Y. Gil, J. Cheney, P. Groth, et al.., Provenance XG Final Report, [Online], W3C, 2010. Available at: http:\/\/www.w3.org\/2005\/Incubator\/prov\/XGR-prov\/."},{"key":"2023033110472097046_j_auto-2022-0107_ref_017","doi-asserted-by":"crossref","unstructured":"C. Quix, R. Hai, and I. Vatov, \u201cMetadata extraction and management in data lakes with GEMMS,\u201d Complex Syst. Inf. Model. Q., vol.\u00a09, pp.\u00a067\u201383, 2016, https:\/\/doi.org\/10.7250\/csimq.2016-9.04.","DOI":"10.7250\/csimq.2016-9.04"},{"key":"2023033110472097046_j_auto-2022-0107_ref_018","unstructured":"T. Haase, R. Gl\u00fcck, P. Kaufmann, and M. Willmeroth, Shepard - Storage for Heterogeneous Product and Research Data, DLR, 2021, [Online]. Available at: https:\/\/zenodo.org\/record\/5091604 [accessed: Jul. 22, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_019","doi-asserted-by":"crossref","unstructured":"E. Kandogan, M. Roth, P. Schwarz, et al.., \u201cLabBook: metadata-driven social collaborative data analysis,\u201d in IEEE International Conference, 2015.","DOI":"10.1109\/BigData.2015.7363784"},{"key":"2023033110472097046_j_auto-2022-0107_ref_020","unstructured":"J. M. Hellerstein, V. Sreekanti, J. E. Gonzalez, et al.., \u201cGround: a data context service,\u201d in CIDR 2017, 2017."},{"key":"2023033110472097046_j_auto-2022-0107_ref_021","doi-asserted-by":"crossref","unstructured":"S. Kruse, D. Hahn, M. Walter, and F. Naumann, \u201cMetacrate: organize and analyze millions of data profiles,\u201d in Proceedings of the 2017 ACM, 2017.","DOI":"10.1145\/3132847.3133180"},{"key":"2023033110472097046_j_auto-2022-0107_ref_022","unstructured":"Matlab help center, Tables, MathWorks. [Online]. Available at: https:\/\/www.mathworks.com\/help\/matlab\/tables.html [accessed: Aug. 08, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_023","unstructured":"Pandas, API, Input\/output, Pandas. [Online]. Available: https:\/\/pandas.pydata.org\/docs\/reference\/io.html [accessed: Aug. 08, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_024","unstructured":"J. Tennison, G. Kellogg, and I. Herman, Model for Tabular Data and Metadata on the Web, W3C, 2015, [Online]. Available at: https:\/\/www.w3.org\/TR\/tabular-data-model\/."},{"key":"2023033110472097046_j_auto-2022-0107_ref_025","doi-asserted-by":"crossref","unstructured":"L. Visengeriyeva and Z. Abedjan, \u201cAnatomy of metadata for data curation,\u201d J. Data Inf. Q., vol.\u00a012, no.\u00a03, pp.\u00a016\u201330, 2020, https:\/\/doi.org\/10.1145\/3371925.","DOI":"10.1145\/3371925"},{"key":"2023033110472097046_j_auto-2022-0107_ref_026","doi-asserted-by":"crossref","unstructured":"J. Vanschoren, \u201cMeta-learning,\u201d in Automated Machine Learning, Cham, Springer, 2019.","DOI":"10.1007\/978-3-030-05318-5_2"},{"key":"2023033110472097046_j_auto-2022-0107_ref_027","unstructured":"eclass. [Online]. Available at: http:\/\/www.eclass.eu\/ [accessed: Feb. 02, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_028","unstructured":"IEC 61987 - Industrial Process Measurement and Control - Data Structures and Elements in Process Equipment Catalogues, IEC, 2016."},{"key":"2023033110472097046_j_auto-2022-0107_ref_029","unstructured":"IEC 61360-4 - IEC\/SC 3D - Common Data Dictionary (CDD\u2014V2.0015.0004). [Online]. Available at: https:\/\/cdd.iec.ch\/ [accessed: Feb. 11, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_030","unstructured":"ISO\/IEC 9075-11:2016 - Information Technology - Database Languages - SQL - Part 11: Information and Definition Schemas (SQL\/Schemata), 4th ed. Vernier, Geneva, Switzerland, International Standard ISO\/IEC, 2016."},{"key":"2023033110472097046_j_auto-2022-0107_ref_031","unstructured":"SQLite Documentation, The Schema, Table. [Online]. Available: https:\/\/www.sqlite.org\/schematab.html [accessed: Apr. 16, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_032","unstructured":"C. Winter and T. Lownds, PEP 3107 \u2013 Function Annotations, 2006, [Online]. Available at: https:\/\/peps.python.org\/pep-3107 [accessed: Jul. 04, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_033","unstructured":"CSVW.org, \u201cCSV on the Web\u201d. [Online]. Available at: https:\/\/csvw.org\/ [accessed: Aug. 20, 2022]."},{"key":"2023033110472097046_j_auto-2022-0107_ref_034","unstructured":"S. Bader, E. Barnstedt, H. Bedenbender, et al.., \u201cDetails of the asset administration shell: Part 1: the exchange of information between partners in the value chain of industrie 4.0 (version 3.0RC01),\u201d in Federal Ministry for Economic Affairs and Energy, Berlin, BMWi, 2020."},{"key":"2023033110472097046_j_auto-2022-0107_ref_035","doi-asserted-by":"crossref","unstructured":"W. Li, M. Winter, and T. Kleinert, \u201cStructure Graph of Production: a concept for process data integration and analysis with application example,\u201d in AUTOMATION 2022: 23, Baden, Leitkongress Mess- u. Automatisierungstechnik, 2022.","DOI":"10.11128\/arep.17.a17093"}],"container-title":["at - Automatisierungstechnik"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.degruyter.com\/document\/doi\/10.1515\/auto-2022-0107\/xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/www.degruyter.com\/document\/doi\/10.1515\/auto-2022-0107\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,3,31]],"date-time":"2023-03-31T13:08:19Z","timestamp":1680268099000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.degruyter.com\/document\/doi\/10.1515\/auto-2022-0107\/html"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,1,1]]},"references-count":35,"journal-issue":{"issue":"1","published-online":{"date-parts":[[2023,1,13]]},"published-print":{"date-parts":[[2023,1,27]]}},"alternative-id":["10.1515\/auto-2022-0107"],"URL":"https:\/\/doi.org\/10.1515\/auto-2022-0107","relation":{},"ISSN":["0178-2312","2196-677X"],"issn-type":[{"value":"0178-2312","type":"print"},{"value":"2196-677X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,1,1]]}}}