{"id":196993,"date":"2024-09-20T09:26:30","date_gmt":"2024-09-20T07:26:30","guid":{"rendered":"https:\/\/www.rse-web.it\/rapporti\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/"},"modified":"2024-09-20T09:28:17","modified_gmt":"2024-09-20T07:28:17","slug":"fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments","status":"publish","type":"rapporti","link":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/","title":{"rendered":"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"<p>TThe document describes the process of porting the Functional Principal Components Analysis (FPCA) methodology\u2014developed and validated in previous activities\u2014to a single Big Data platform. The report introduces the concept of real-time Big Data (streaming) through a concrete example, such as the charging of electric vehicles.<\/p>\n","protected":false},"author":464,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"tags":[652,1315],"targets":[1317],"rapporti_tipologie":[762],"class_list":["post-196993","rapporti","type-rapporti","status-publish","hentry","tag-active-networks","tag-smart-grids-en","targets-research","rapporti_tipologie-report-en"],"acf":{"dont_show_hompage":true,"projects":{"ID":191051,"post_author":"464","post_date":"2024-07-10 16:51:29","post_date_gmt":"2024-07-10 14:51:29","post_content":"","post_title":"Application of Information Technology, Internet of Things, Peer-to-peer, to the electrical system in order to improve security and resilience","post_excerpt":"The project develops methods, tools, demonstrators and experiments to evaluate the application potential of the latest information and communication technologies for the benefit of the electro-energy system.","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"application-of-information-technology-internet-of-things-peer-to-peer-to-the-electrical-system-in-order-to-improve-security-and-resilience","to_ping":"","pinged":"","post_modified":"2024-08-09 15:59:29","post_modified_gmt":"2024-08-09 13:59:29","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.rse-web.it\/progetti\/application-of-information-technology-internet-of-things-peer-to-peer-to-the-electrical-system-in-order-to-improve-security-and-resilience\/","menu_order":0,"post_type":"progetti","post_mime_type":"","comment_count":"0","filter":"raw"},"order_posts":"","dont_show_search":false,"related_posts":false,"show_on_slider":false,"single_post_data":{"titolo_spot":"","post_content":"<p>The digitalization of the electrical system is leading to significant transformations at various levels of the system itself. The proliferation of sensors generates large amounts of data, which can provide many useful insights if interpreted and analyzed correctly. This data is characterized by typical Big Data attributes, including both structured and unstructured data. For these reasons, it is necessary to change the paradigm for analyzing such data, using computing architectures based on clusters and software tools that allow not only statistical analysis but also the application of machine learning techniques. This shift compels utilities to confront methodologies previously unused and to acquire new expertise, which they typically lack, to manage this transition.<\/p>\n<p>This report presents and applies several techniques and tools necessary to address the challenges of analyzing and processing Big Data. A primary example described is the analysis and prediction of electricity consumption based on Functional Principal Components Analysis (FPCA). Starting from a data processing workflow that involved mostly manual actions performed on different, mostly non-scalable platforms unsuitable for managing Big Data, the activity has consolidated the entire process onto a single Databricks platform, more suitable for handling Big Data processing, with a high degree of automation in the entire ETL (Extract, Transform, Load) pipeline. The entire process has also been implemented to be applicable to different datasets from the one originally created for, demonstrating the potential of the tools used. The report demonstrates the application of the ETL pipeline in a real-world case, such as the LANPRIS monitoring system.<\/p>\n<p>Batch Big Data analysis is shown to be very useful in various fields but is not always sufficient. For this reason, the report introduces the concept of real-time Big Data (streaming), describing some open-source tools currently used for real-time analysis of Big Data streams. As a practical example, the design of a monitoring system for a distributed electric vehicle charging system based on home charging points and\/or collective charging stations is described.<\/p>\n<p>The results presented in this report contribute to utilities in implementing the digitalization of the electrical system, with a particular focus on managing Big Data through both historical and real-time analysis, in order to provide users with a more resilient network and better services.<\/p>\n","link_estreno":false,"scarica_file":[{"download_option":"download","file_name":"Download Report","download":{"ID":105814,"id":105814,"title":"19012896-319178.pdf","filename":"19012896-319178.pdf","filesize":2973590,"url":"https:\/\/www.rse-web.it\/wp-content\/uploads\/2021\/03\/19012896-319178.pdf","link":"https:\/\/www.rse-web.it\/en\/rapporti\/19012896\/19012896-319178\/","alt":"","author":"464","description":"19012896-319178.pdf","caption":"","name":"19012896-319178","status":"inherit","uploaded_to":132821,"date":"2021-12-31 00:00:00","modified":"2021-03-17 12:49:36","menu_order":0,"mime_type":"application\/pdf","type":"application","subtype":"pdf","icon":"https:\/\/www.rse-web.it\/wp-includes\/images\/media\/document.png"}}],"button":{"text":"","link":""},"referente_group":false,"data_emissione":"2019-12-31","autori":"E. Bionda, S. Grillo \"Politecnico di Milano\"","rapporto":"","rif_rse":"19012896"},"satellite_post_url":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments - RSE<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments - RSE\" \/>\n<meta property=\"og:description\" content=\"TThe document describes the process of porting the Functional Principal Components Analysis (FPCA) methodology\u2014developed and validated in previous activities\u2014to a single Big Data platform. The report introduces the concept of real-time Big Data (streaming) through a concrete example, such as the charging of electric vehicles.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/\" \/>\n<meta property=\"og:site_name\" content=\"RSE\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-20T07:28:17+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/en\\\/reports\\\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\\\/\",\"url\":\"https:\\\/\\\/www.rse-web.it\\\/en\\\/reports\\\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\\\/\",\"name\":\"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments - RSE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/#website\"},\"datePublished\":\"2024-09-20T07:26:30+00:00\",\"dateModified\":\"2024-09-20T07:28:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/en\\\/reports\\\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rse-web.it\\\/en\\\/reports\\\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/en\\\/reports\\\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rse-web.it\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/#website\",\"url\":\"https:\\\/\\\/www.rse-web.it\\\/\",\"name\":\"RSE\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rse-web.it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/#organization\",\"name\":\"RSE\",\"url\":\"https:\\\/\\\/www.rse-web.it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rse-web.it\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/cropped-logo_rse_2022.png\",\"contentUrl\":\"https:\\\/\\\/www.rse-web.it\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/cropped-logo_rse_2022.png\",\"width\":734,\"height\":164,\"caption\":\"RSE\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rse-web.it\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments - RSE","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/","og_locale":"en_US","og_type":"article","og_title":"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments - RSE","og_description":"TThe document describes the process of porting the Functional Principal Components Analysis (FPCA) methodology\u2014developed and validated in previous activities\u2014to a single Big Data platform. The report introduces the concept of real-time Big Data (streaming) through a concrete example, such as the charging of electric vehicles.","og_url":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/","og_site_name":"RSE","article_modified_time":"2024-09-20T07:28:17+00:00","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/","url":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/","name":"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments - RSE","isPartOf":{"@id":"https:\/\/www.rse-web.it\/#website"},"datePublished":"2024-09-20T07:26:30+00:00","dateModified":"2024-09-20T07:28:17+00:00","breadcrumb":{"@id":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.rse-web.it\/en\/reports\/fpca-analysis-tools-and-study-for-real-time-data-management-in-big-data-environments\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rse-web.it\/en\/"},{"@type":"ListItem","position":2,"name":"FPCA Analysis Tools and Study for Real-Time Data Management in Big Data Environments"}]},{"@type":"WebSite","@id":"https:\/\/www.rse-web.it\/#website","url":"https:\/\/www.rse-web.it\/","name":"RSE","description":"","publisher":{"@id":"https:\/\/www.rse-web.it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rse-web.it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rse-web.it\/#organization","name":"RSE","url":"https:\/\/www.rse-web.it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rse-web.it\/#\/schema\/logo\/image\/","url":"https:\/\/www.rse-web.it\/wp-content\/uploads\/2024\/01\/cropped-logo_rse_2022.png","contentUrl":"https:\/\/www.rse-web.it\/wp-content\/uploads\/2024\/01\/cropped-logo_rse_2022.png","width":734,"height":164,"caption":"RSE"},"image":{"@id":"https:\/\/www.rse-web.it\/#\/schema\/logo\/image\/"}}]}},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/rapporti\/196993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/rapporti"}],"about":[{"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/types\/rapporti"}],"author":[{"embeddable":true,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/users\/464"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/comments?post=196993"}],"version-history":[{"count":2,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/rapporti\/196993\/revisions"}],"predecessor-version":[{"id":196996,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/rapporti\/196993\/revisions\/196996"}],"wp:attachment":[{"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/media?parent=196993"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/tags?post=196993"},{"taxonomy":"targets","embeddable":true,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/targets?post=196993"},{"taxonomy":"rapporti_tipologie","embeddable":true,"href":"https:\/\/www.rse-web.it\/en\/wp-json\/wp\/v2\/rapporti_tipologie?post=196993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}