{"id":"https://openalex.org/W7225320554","doi":"https://doi.org/10.5281/zenodo.23920860","title":"Integra\u00e7\u00e3o de dados energ\u00e9ticos e meteorol\u00f3gicos por meio de um pipeline ETL aplicado ao monitoramento fotovoltaico","display_name":"Integra\u00e7\u00e3o de dados energ\u00e9ticos e meteorol\u00f3gicos por meio de um pipeline ETL aplicado ao monitoramento fotovoltaico","publication_year":2026,"publication_date":"2026-10-06","ids":{"openalex":"https://openalex.org/W7225320554","doi":"https://doi.org/10.5281/zenodo.23920860"},"language":"pt","primary_location":{"id":"pmh:oai:zenodo.org:23920861","doi":null,"is_oa":true,"landing_page_url":"http://gconf.com.br/meet/anais/2026/conprofi-2026/artigo2978","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"CONPROFI 2026, CONPROFI - SISTEMAS PRODUTIVOS 2026","raw_type":"info:eu-repo/semantics/conferencePaper"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://gconf.com.br/meet/anais/2026/conprofi-2026/artigo2978","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5132978145","display_name":"Antonio Marcos Fonseca de Jesus","orcid":"https://orcid.org/0009-0004-3313-829X","observed_orcids":["https://orcid.org/0009-0004-3313-829X"]},"institutions":[{"id":"https://openalex.org/I4405253594","display_name":"Centro Paula Souza","ror":"https://ror.org/00vvaxp92","country_code":"BR","type":"education","lineage":["https://openalex.org/I4405253594"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Jesus, Antonio Marcos Fonseca De","raw_affiliation_strings":["Coordenadoria Geral de P\u00f3s-Gradua\u00e7\u00e3o, Extens\u00e3o e Pesquisa do Centro Paula Souza"],"raw_orcid":"https://orcid.org/0009-0004-3313-829X","affiliations":[{"raw_affiliation_string":"Coordenadoria Geral de P\u00f3s-Gradua\u00e7\u00e3o, Extens\u00e3o e Pesquisa do Centro Paula Souza","institution_ids":["https://openalex.org/I4405253594"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5160648487","display_name":"Luiz Fernando Miguel Higino Do Bonfim","orcid":"https://orcid.org/0009-0001-3526-6111","observed_orcids":["https://orcid.org/0009-0001-3526-6111"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bonfim, Luiz Fernando Miguel Higino Do","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0009-0001-3526-6111","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5160573793","display_name":"Guilherme Vilanova De Lima","orcid":"https://orcid.org/0009-0003-8068-4624","observed_orcids":["https://orcid.org/0009-0003-8068-4624"]},"institutions":[{"id":"https://openalex.org/I1329807341","display_name":"Servi\u00e7o Nacional de Aprendizagem Industrial","ror":"https://ror.org/035c3nf67","country_code":"BR","type":"nonprofit","lineage":["https://openalex.org/I1329807341"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Lima, Guilherme Vilanova De","raw_affiliation_strings":["SENAI"],"raw_orcid":"https://orcid.org/0009-0003-8068-4624","affiliations":[{"raw_affiliation_string":"SENAI","institution_ids":["https://openalex.org/I1329807341"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005926981","display_name":"Rafael Nobre Orsi","orcid":"https://orcid.org/0000-0003-4719-0131","observed_orcids":["https://orcid.org/0000-0003-4719-0131"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Orsi, Rafael Nobre","raw_affiliation_strings":["Upep-Unidade de P\u00f3s Gradua\u00e7\u00e3o Pesquisa e Extens\u00e3o do CPS"],"raw_orcid":"https://orcid.org/0000-0003-4719-0131","affiliations":[{"raw_affiliation_string":"Upep-Unidade de P\u00f3s Gradua\u00e7\u00e3o Pesquisa e Extens\u00e3o do CPS","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085183716","display_name":"Vanessa Montoro Taborianski","orcid":"https://orcid.org/0000-0001-8711-4729","observed_orcids":["https://orcid.org/0000-0001-8711-4729"]},"institutions":[{"id":"https://openalex.org/I4405253594","display_name":"Centro Paula Souza","ror":"https://ror.org/00vvaxp92","country_code":"BR","type":"education","lineage":["https://openalex.org/I4405253594"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Taborianski, Vanessa Montoro","raw_affiliation_strings":["CGPEP CEETEPS"],"raw_orcid":"https://orcid.org/0000-0001-8711-4729","affiliations":[{"raw_affiliation_string":"CGPEP CEETEPS","institution_ids":["https://openalex.org/I4405253594"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070755040","display_name":"S\u00edlvia Pierre Irazusta","orcid":"https://orcid.org/0000-0002-6856-4035","observed_orcids":["https://orcid.org/0000-0002-6856-4035"]},"institutions":[{"id":"https://openalex.org/I3131263933","display_name":"S\u00e3o Paulo State Technological College","ror":"https://ror.org/04z64b609","country_code":"BR","type":"education","lineage":["https://openalex.org/I3131263933"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Irazusta, S\u00edlvia Pierre","raw_affiliation_strings":["Fatec Sorocaba"],"raw_orcid":"https://orcid.org/0000-0002-6856-4035","affiliations":[{"raw_affiliation_string":"Fatec Sorocaba","institution_ids":["https://openalex.org/I3131263933"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11276","display_name":"Solar Radiation and Photovoltaics","score":0.33980000019073486,"subfield":{"id":"https://openalex.org/subfields/2105","display_name":"Renewable Energy, Sustainability and the Environment"},"field":{"id":"https://openalex.org/fields/21","display_name":"Energy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11276","display_name":"Solar Radiation and Photovoltaics","score":0.33980000019073486,"subfield":{"id":"https://openalex.org/subfields/2105","display_name":"Renewable Energy, Sustainability and the Environment"},"field":{"id":"https://openalex.org/fields/21","display_name":"Energy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T14427","display_name":"Environmental Monitoring and Data Management","score":0.11829999834299088,"subfield":{"id":"https://openalex.org/subfields/2308","display_name":"Management, Monitoring, Policy and Law"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10468","display_name":"Photovoltaic System Optimization Techniques","score":0.09679999947547913,"subfield":{"id":"https://openalex.org/subfields/2105","display_name":"Renewable Energy, Sustainability and the Environment"},"field":{"id":"https://openalex.org/fields/21","display_name":"Energy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/etl-pipeline","display_name":"ETL pipeline","score":0.9440000057220459},{"id":"https://openalex.org/keywords/photovoltaic-system-monitoring","display_name":"photovoltaic system monitoring","score":0.8619999885559082},{"id":"https://openalex.org/keywords/energy-data-integration","display_name":"energy data integration","score":0.640999972820282},{"id":"https://openalex.org/keywords/meteorological-observations","display_name":"meteorological observations","score":0.8730000257492065},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.5090000033378601},{"id":"https://openalex.org/keywords/web-scraping","display_name":"web scraping","score":0.875},{"id":"https://openalex.org/keywords/reverse-engineering","display_name":"reverse engineering","score":0.531000018119812},{"id":"https://openalex.org/keywords/data-deduplication","display_name":"data deduplication","score":0.6690000295639038},{"id":"https://openalex.org/keywords/centralized-database","display_name":"centralized database","score":0.5730000138282776},{"id":"https://openalex.org/keywords/php","display_name":"PHP","score":0.4519999921321869},{"id":"https://openalex.org/keywords/mariadb","display_name":"MariaDB","score":0.9649999737739563},{"id":"https://openalex.org/keywords/virtual-private-server","display_name":"virtual private server","score":0.6060000061988831}],"concepts":[{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.611299991607666},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.42089998722076416},{"id":"https://openalex.org/C15708023","wikidata":"https://www.wikidata.org/wiki/Q80083","display_name":"Humanities","level":1,"score":0.36910000443458557},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.34139999747276306},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24969999492168427},{"id":"https://openalex.org/C2985179714","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Work flow","level":2,"score":0.22830000519752502},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.22609999775886536},{"id":"https://openalex.org/C92446256","wikidata":"https://www.wikidata.org/wiki/Q3306762","display_name":"Data validation","level":2,"score":0.20389999449253082},{"id":"https://openalex.org/C2778315783","wikidata":"https://www.wikidata.org/wiki/Q5227240","display_name":"Data archive","level":2,"score":0.19619999825954437},{"id":"https://openalex.org/C2982933515","wikidata":"https://www.wikidata.org/wiki/Q104381823","display_name":"Public access","level":2,"score":0.1899999976158142}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:zenodo.org:23920861","doi":null,"is_oa":true,"landing_page_url":"http://gconf.com.br/meet/anais/2026/conprofi-2026/artigo2978","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"CONPROFI 2026, CONPROFI - SISTEMAS PRODUTIVOS 2026","raw_type":"info:eu-repo/semantics/conferencePaper"},{"id":"doi:10.5281/zenodo.23920860","doi":"https://doi.org/10.5281/zenodo.23920860","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.23920860","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"ConferencePaper"},{"id":"doi:10.5281/zenodo.23920861","doi":"https://doi.org/10.5281/zenodo.23920861","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.23920861","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"ConferencePaper"}],"best_oa_location":{"id":"pmh:oai:zenodo.org:23920861","doi":null,"is_oa":true,"landing_page_url":"http://gconf.com.br/meet/anais/2026/conprofi-2026/artigo2978","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"CONPROFI 2026, CONPROFI - SISTEMAS PRODUTIVOS 2026","raw_type":"info:eu-repo/semantics/conferencePaper"},"sustainable_development_goals":[{"score":0.9853000044822693,"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy"},{"score":0.8970999717712402,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"},{"score":0.821399986743927,"id":"https://metadata.un.org/sdg/13","display_name":"Climate action"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7225234215","https://openalex.org/W7215255548","https://openalex.org/W2948191658","https://openalex.org/W7009049297","https://openalex.org/W3083059820","https://openalex.org/W7207246215","https://openalex.org/W3126347111","https://openalex.org/W4283796691","https://openalex.org/W7009038798","https://openalex.org/W2946108689"],"abstract_inverted_index":{"A":[0],"integra\u00e7\u00e3o":[1,71,180,325],"de":[2,8,21,42,47,55,62,72,74,76,85,100,115,120,133,154,162,179,181,189,206,235,240,254,261,283,285,308,310,334,342,345,357],"dados":[3,61,73,79,86,116,163,190,229,343],"energ\u00e9ticos":[4],"e":[5,19,31,58,113,132,166,187,215,223,243,256,275,294,327,340,360],"meteorol\u00f3gicos":[6,80],"provenientes":[7,117,344],"plataformas":[9],"distintas":[10,205],"apresenta":[11,97],"desafios":[12],"relacionados":[13],"\u00e0":[14,45,220,332],"heterogeneidade":[15],"dos":[16,93,228,245],"formatos,":[17],"estruturas":[18],"mecanismos":[20],"acesso,":[22],"principalmente":[23],"quando":[24],"as":[25,209],"fontes":[26,157,346],"n\u00e3o":[27],"disponibilizam":[28],"interfaces":[29],"p\u00fablicas":[30],"documentadas,":[32],"dessa":[33],"maneira":[34],"constitui":[35],"uma":[36,83,134,160,194,281],"etapa":[37,234],"fundamental":[38],"para":[39,108,168,218,226,259,337],"a":[40,70,88,110,200,248,264,280,321,329],"consolida\u00e7\u00e3o":[41],"informa\u00e7\u00f5es":[43],"destinadas":[44],"an\u00e1lise":[46],"sistemas":[48],"fotovoltaicos,":[49],"onde":[50],"deve-se":[51],"estabelecer":[52],"procedimentos":[53],"capazes":[54],"extrair,":[56],"padronizar":[57],"armazenar":[59],"os":[60],"forma":[63],"consistente.":[64],"No":[65],"contexto":[66],"do":[67,91,118,291],"monitoramento":[68,121],"fotovoltaico,":[69],"gera\u00e7\u00e3o":[75],"energia":[77],"com":[78,208,273,277,305],"possibilita":[81],"estruturar":[82],"base":[84,161],"destinada":[87],"an\u00e1lises":[89,169],"posteriores":[90],"comportamento":[92],"sistemas.":[94],"Este":[95],"trabalho":[96],"o":[98,172,175,318],"desenvolvimento":[99,176],"um":[101,150],"pipeline":[102,151,349],"ETL":[103,152],"(Extract,":[104],"Transform":[105],"and":[106],"Load)":[107],"automatizar":[109],"extra\u00e7\u00e3o,":[111,201,338],"transforma\u00e7\u00e3o":[112,236,339],"carga":[114,249],"sistema":[119,292],"fotovoltaico":[122,293],"da":[123,126,177,296,324,362],"FATEC":[124],"Franco":[125],"Rocha,":[127],"disponibilizados":[128,230],"pela":[129,141,231],"plataforma":[130,142,221],"Growatt,":[131],"esta\u00e7\u00e3o":[135,297],"meteorol\u00f3gica":[136],"localizada":[137],"em":[138,148,159,193,351],"Cajamar,":[139],"disponibilizada":[140],"Meteoservice.":[143,232],"O":[144,348],"objetivo":[145],"geral":[146],"consiste":[147],"desenvolver":[149],"capaz":[153],"integrar":[155],"essas":[156],"heterog\u00eaneas":[158],"centralizada,":[164],"estruturada":[165],"adequada":[167],"posteriores.":[170],"Metodologicamente,":[171],"estudo":[173],"constituiu":[174],"camada":[178],"dados,":[182,246],"utilizando":[183],"PHP":[184],"no":[185,303],"Back-end":[186],"banco":[188],"MariaDB":[191],"hospedado":[192],"Virtual":[195],"Private":[196],"Server":[197],"(VPS).":[198],"Para":[199],"foram":[202,237,266],"empregadas":[203],"estrat\u00e9gias":[204,335],"acordo":[207],"caracter\u00edsticas":[210],"das":[211],"fontes:":[212],"engenharia":[213],"reversa":[214],"autentica\u00e7\u00e3o":[216],"program\u00e1tica":[217],"acesso":[219],"Growatt":[222],"Web":[224],"Scraping":[225],"obten\u00e7\u00e3o":[227],"Na":[233],"implementadas":[238],"rotinas":[239],"limpeza,":[241],"normaliza\u00e7\u00e3o":[242],"convers\u00e3o":[244],"enquanto":[247],"utilizou":[250],"conex\u00e3o":[251],"PDO,":[252],"tratamento":[253],"exce\u00e7\u00f5es":[255],"opera\u00e7\u00f5es":[257],"UPSERT":[258],"controle":[260],"duplicidades.":[262],"Durante":[263],"valida\u00e7\u00e3o":[265],"realizadas":[267],"20":[268],"execu\u00e7\u00f5es,":[269],"sendo":[270,353],"16":[271,289],"conclu\u00eddas":[272],"sucesso":[274,284],"quatro":[276],"falhas,":[278],"correspondendo":[279],"taxa":[282],"80%.":[286],"Foram":[287],"extra\u00eddos":[288],"registros":[290,301],"10":[295],"meteorol\u00f3gica,":[298],"totalizando":[299],"26":[300],"carregados":[302],"banco,":[304],"tempo":[306],"m\u00e9dio":[307],"execu\u00e7\u00e3o":[309],"aproximadamente":[311],"4,5":[312],"segundos.":[313],"Os":[314],"resultados":[315],"obtidos":[316],"at\u00e9":[317],"momento":[319],"demonstram":[320],"viabilidade":[322],"t\u00e9cnica":[323],"proposta":[326],"corroboram":[328],"literatura":[330],"quanto":[331],"necessidade":[333],"espec\u00edficas":[336],"armazenamento":[341],"heterog\u00eaneas.":[347],"permanece":[350],"desenvolvimento,":[352],"necess\u00e1rias":[354],"novas":[355],"etapas":[356],"valida\u00e7\u00e3o,":[358],"aperfei\u00e7oamento":[359],"amplia\u00e7\u00e3o":[361],"solu\u00e7\u00e3o.":[363]},"counts_by_year":[],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2026-11-06T00:00:00"}