{"id":"https://openalex.org/W3016092890","doi":"https://doi.org/10.3390/info11040204","title":"Applying the ETL Process to Blockchain Data. Prospect and Findings","display_name":"Applying the ETL Process to Blockchain Data. Prospect and Findings","publication_year":2020,"publication_date":"2020-04-10","ids":{"openalex":"https://openalex.org/W3016092890","doi":"https://doi.org/10.3390/info11040204","mag":"3016092890"},"language":"en","primary_location":{"id":"doi:10.3390/info11040204","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info11040204","pdf_url":"https://www.mdpi.com/2078-2489/11/4/204/pdf?version=1586531664","source":{"id":"https://openalex.org/S4210219776","display_name":"Information","issn_l":"2078-2489","issn":["2078-2489"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2078-2489/11/4/204/pdf?version=1586531664","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5063140272","display_name":"Roberta Galici","orcid":"https://orcid.org/0000-0002-1492-3514"},"institutions":[{"id":"https://openalex.org/I172446870","display_name":"University of Cagliari","ror":"https://ror.org/003109y17","country_code":"IT","type":"education","lineage":["https://openalex.org/I172446870"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Roberta Galici","raw_affiliation_strings":["Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy","institution_ids":["https://openalex.org/I172446870"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081334362","display_name":"Laura Ordile","orcid":null},"institutions":[{"id":"https://openalex.org/I172446870","display_name":"University of Cagliari","ror":"https://ror.org/003109y17","country_code":"IT","type":"education","lineage":["https://openalex.org/I172446870"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Laura Ordile","raw_affiliation_strings":["Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy","institution_ids":["https://openalex.org/I172446870"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073485643","display_name":"Michele Marchesi","orcid":"https://orcid.org/0000-0003-3745-4324"},"institutions":[{"id":"https://openalex.org/I172446870","display_name":"University of Cagliari","ror":"https://ror.org/003109y17","country_code":"IT","type":"education","lineage":["https://openalex.org/I172446870"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Michele Marchesi","raw_affiliation_strings":["Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy","institution_ids":["https://openalex.org/I172446870"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043520448","display_name":"Andrea Pinna","orcid":"https://orcid.org/0000-0002-7530-0521"},"institutions":[{"id":"https://openalex.org/I172446870","display_name":"University of Cagliari","ror":"https://ror.org/003109y17","country_code":"IT","type":"education","lineage":["https://openalex.org/I172446870"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Andrea Pinna","raw_affiliation_strings":["Department of Electrical and Electronic Engineering (DIEE), University of Cagliari, Piazza D\u2019Armi, 09100 Cagliari, Italy","Department of Electrical and Electronic Engineering (DIEE), University of Cagliari, Piazza D'Armi, 09100 Cagliari, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Electrical and Electronic Engineering (DIEE), University of Cagliari, Piazza D\u2019Armi, 09100 Cagliari, Italy","institution_ids":["https://openalex.org/I172446870"]},{"raw_affiliation_string":"Department of Electrical and Electronic Engineering (DIEE), University of Cagliari, Piazza D'Armi, 09100 Cagliari, Italy","institution_ids":["https://openalex.org/I172446870"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076859372","display_name":"Roberto Tonelli","orcid":"https://orcid.org/0000-0002-9090-7698"},"institutions":[{"id":"https://openalex.org/I172446870","display_name":"University of Cagliari","ror":"https://ror.org/003109y17","country_code":"IT","type":"education","lineage":["https://openalex.org/I172446870"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Roberto Tonelli","raw_affiliation_strings":["Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics and Computer Science, University of Cagliari, Via Ospedale 72, 09124 Cagliari, Italy","institution_ids":["https://openalex.org/I172446870"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5043520448"],"corresponding_institution_ids":["https://openalex.org/I172446870"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":5.0074,"has_fulltext":true,"cited_by_count":22,"citation_normalized_percentile":{"value":0.95664473,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"11","issue":"4","first_page":"204","last_page":"204"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10270","display_name":"Blockchain Technology Applications and Security","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10270","display_name":"Blockchain Technology Applications and Security","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9909999966621399,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9882000088691711,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8350211977958679},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6424199342727661},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.638543426990509},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6180544495582581},{"id":"https://openalex.org/keywords/blockchain","display_name":"Blockchain","score":0.5596122741699219},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5197648406028748},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.5080966949462891},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.4964333176612854},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.48368769884109497},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4715331196784973},{"id":"https://openalex.org/keywords/external-data-representation","display_name":"External Data Representation","score":0.46397385001182556},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4635469317436218},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.45959362387657166},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.4362298548221588},{"id":"https://openalex.org/keywords/transaction-data","display_name":"Transaction data","score":0.42529821395874023}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8350211977958679},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6424199342727661},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.638543426990509},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6180544495582581},{"id":"https://openalex.org/C2779687700","wikidata":"https://www.wikidata.org/wiki/Q20514253","display_name":"Blockchain","level":2,"score":0.5596122741699219},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5197648406028748},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.5080966949462891},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.4964333176612854},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.48368769884109497},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4715331196784973},{"id":"https://openalex.org/C116409475","wikidata":"https://www.wikidata.org/wiki/Q1385056","display_name":"External Data Representation","level":2,"score":0.46397385001182556},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4635469317436218},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.45959362387657166},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.4362298548221588},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.42529821395874023},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.3390/info11040204","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info11040204","pdf_url":"https://www.mdpi.com/2078-2489/11/4/204/pdf?version=1586531664","source":{"id":"https://openalex.org/S4210219776","display_name":"Information","issn_l":"2078-2489","issn":["2078-2489"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:231bce2b9358458aa80278e93b7be95d","is_oa":true,"landing_page_url":"https://doaj.org/article/231bce2b9358458aa80278e93b7be95d","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Information, Vol 11, Iss 4, p 204 (2020)","raw_type":"article"},{"id":"pmh:oai:iris.unica.it:11584/291938","is_oa":true,"landing_page_url":"http://hdl.handle.net/11584/291938","pdf_url":null,"source":{"id":"https://openalex.org/S4377196293","display_name":"UNICA IRIS Institutional Research Information System (University of Cagliari)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I172446870","host_organization_name":"University of Cagliari","host_organization_lineage":["https://openalex.org/I172446870"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:mdpi.com:/2078-2489/11/4/204/","is_oa":true,"landing_page_url":"http://dx.doi.org/10.3390/info11040204","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"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":"Information","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/info11040204","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info11040204","pdf_url":"https://www.mdpi.com/2078-2489/11/4/204/pdf?version=1586531664","source":{"id":"https://openalex.org/S4210219776","display_name":"Information","issn_l":"2078-2489","issn":["2078-2489"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.4300000071525574,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[{"id":"https://openalex.org/G453067482","display_name":null,"funder_award_id":"014-2020","funder_id":"https://openalex.org/F4320335322","funder_display_name":"European Regional Development Fund"},{"id":"https://openalex.org/G5634946813","display_name":null,"funder_award_id":"2014-2020","funder_id":"https://openalex.org/F4320335322","funder_display_name":"European Regional Development Fund"},{"id":"https://openalex.org/G8364729396","display_name":null,"funder_award_id":"POR FESR Sardegna 2014-2020","funder_id":"https://openalex.org/F4320326069","funder_display_name":"Regione Autonoma della Sardegna"}],"funders":[{"id":"https://openalex.org/F4320326069","display_name":"Regione Autonoma della Sardegna","ror":null},{"id":"https://openalex.org/F4320335322","display_name":"European Regional Development Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3016092890.pdf","grobid_xml":"https://content.openalex.org/works/W3016092890.grobid-xml"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W179922057","https://openalex.org/W1454642304","https://openalex.org/W1482268585","https://openalex.org/W2022932831","https://openalex.org/W2072266282","https://openalex.org/W2213201020","https://openalex.org/W2404740077","https://openalex.org/W2429791812","https://openalex.org/W2468345220","https://openalex.org/W2758539126","https://openalex.org/W2762598207","https://openalex.org/W2769810605","https://openalex.org/W2770272410","https://openalex.org/W2770856063","https://openalex.org/W2783786631","https://openalex.org/W2799589291","https://openalex.org/W2886106885","https://openalex.org/W2908300355","https://openalex.org/W2949743818","https://openalex.org/W2950280458","https://openalex.org/W2963010231","https://openalex.org/W2971652208","https://openalex.org/W2989129917","https://openalex.org/W3005879580","https://openalex.org/W3106122107","https://openalex.org/W6763978587"],"related_works":["https://openalex.org/W2364409751","https://openalex.org/W1616165289","https://openalex.org/W2359411520","https://openalex.org/W1503556420","https://openalex.org/W2363759074","https://openalex.org/W2361930117","https://openalex.org/W2527710332","https://openalex.org/W337676661","https://openalex.org/W3217213345","https://openalex.org/W1820952504"],"abstract_inverted_index":{"We":[0,148,175],"present":[1,247],"a":[2,18,53,69,100,131,159,251,263,301],"novel":[3],"strategy,":[4],"based":[5],"on":[6,150,262],"the":[7,33,58,74,84,92,96,105,110,117,120,139,151,165,169,177,185,189,201,205,210,219,229,248,266,269,283],"Extract,":[8],"Transform":[9],"and":[10,21,41,64,66,78,91,127,134,168,188,193,196,235,274,303,317],"Load":[11],"(ETL)":[12],"process,":[13,225,307],"to":[14,31,55,67,86,94,162,191,197,218,290,296,299],"collect":[15,192],"data":[16,38,62,98,106,123,125,128,132,137,195,207,216,280,293,305,312],"from":[17,130],"blockchain,":[19],"elaborate":[20],"make":[22,56],"it":[23],"available":[24,313],"for":[25,35,45,142,146,184,314],"further":[26,315],"analysis.":[27],"The":[28,80,285],"study":[29],"aims":[30],"satisfy":[32],"need":[34,85,93],"increasingly":[36],"efficient":[37],"extraction":[39,63],"strategies":[40],"effective":[42],"representation":[43],"methods":[44],"blockchain":[46,61,153,187,215,259,279,292],"data.":[47,244],"For":[48],"this":[49],"reason,":[50],"we":[51,156,213,226,237,246,288],"conceived":[52],"system":[54,82],"scalable":[57,304],"process":[59,190,287],"of":[60,119,122,172,179,233,250,268,272,277],"clustering,":[65],"provide":[68],"SQL":[70],"database":[71,161],"which":[72,155,254],"preserves":[73],"distinction":[75],"between":[76,164,265],"transaction":[77],"addresses.":[79],"proposed":[81],"satisfies":[83],"cluster":[87],"addresses":[88],"in":[89,99,138,158,200,231,282],"entities,":[90],"store":[95],"extracted":[97],"conventional":[101],"database,":[102],"making":[103],"possible":[104],"analysis":[107,316],"by":[108,241],"querying":[109],"database.":[111,202],"In":[112],"general,":[113],"ETL":[114,286],"processes":[115],"allow":[116],"automation":[118],"operation":[121],"selection,":[124],"collection":[126],"conditioning":[129],"warehouse,":[133],"produce":[135],"output":[136,170],"best":[140],"format":[141],"subsequent":[143],"processing":[144],"or":[145],"business.":[147,318],"focus":[149],"Bitcoin":[152,186],"transactions,":[154,273],"organized":[157],"relational":[160],"distinguish":[163],"input":[166,206],"section":[167,171],"each":[173],"transaction.":[174],"describe":[176],"implementation":[178],"address":[180],"clustering":[181],"algorithms":[182],"specific":[183],"transform":[194],"load":[198],"them":[199],"To":[203,222],"balance":[204],"rate":[208],"with":[209],"elaboration":[211],"time,":[212],"manage":[214],"according":[217],"lambda":[220],"architecture.":[221],"evaluate":[223],"our":[224],"first":[227],"analyzed":[228],"performances":[230],"terms":[232],"scalability,":[234],"then":[236],"checked":[238],"its":[239],"usability":[240],"analyzing":[242],"loaded":[243],"Finally,":[245],"results":[249,276],"toy":[252],"analysis,":[253],"provides":[255],"some":[256],"findings":[257],"about":[258],"data,":[260],"focusing":[261],"comparison":[264],"statistics":[267],"last":[270],"year":[271],"previous":[275],"historical":[278],"found":[281],"literature.":[284],"realized":[289],"analyze":[291],"is":[294],"proven":[295],"be":[297],"able":[298],"perform":[300],"reliable":[302],"acquisition":[306],"whose":[308],"result":[309],"makes":[310],"stored":[311]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":3}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}