{"id":"https://openalex.org/W4415683730","doi":"https://doi.org/10.3390/info16110932","title":"Data Integration and Storage Strategies in Heterogeneous Analytical Systems: Architectures, Methods, and Interoperability Challenges","display_name":"Data Integration and Storage Strategies in Heterogeneous Analytical Systems: Architectures, Methods, and Interoperability Challenges","publication_year":2025,"publication_date":"2025-10-26","ids":{"openalex":"https://openalex.org/W4415683730","doi":"https://doi.org/10.3390/info16110932"},"language":"en","primary_location":{"id":"doi:10.3390/info16110932","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info16110932","pdf_url":"https://www.mdpi.com/2078-2489/16/11/932/pdf?version=1761639185","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/16/11/932/pdf?version=1761639185","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5077173629","display_name":"Paraskevas Koukaras","orcid":"https://orcid.org/0000-0002-1183-9878"},"institutions":[{"id":"https://openalex.org/I183898223","display_name":"International Hellenic University","ror":"https://ror.org/00708jp83","country_code":"GR","type":"education","lineage":["https://openalex.org/I183898223"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Paraskevas Koukaras","raw_affiliation_strings":["School of Science and Technology, International Hellenic University, 14th km Thessaloniki-Moudania, 57001 Thessaloniki, Greece"],"raw_orcid":"https://orcid.org/0000-0002-1183-9878","affiliations":[{"raw_affiliation_string":"School of Science and Technology, International Hellenic University, 14th km Thessaloniki-Moudania, 57001 Thessaloniki, Greece","institution_ids":["https://openalex.org/I183898223"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5077173629"],"corresponding_institution_ids":["https://openalex.org/I183898223"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1782},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1782},"fwci":10.889,"has_fulltext":true,"cited_by_count":10,"citation_normalized_percentile":{"value":0.98406885,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"16","issue":"11","first_page":"932","last_page":"932"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.3610999882221222,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.3610999882221222,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.1152999997138977,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.07620000094175339,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/interoperability","display_name":"Interoperability","score":0.652899980545044},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5478000044822693},{"id":"https://openalex.org/keywords/orchestration","display_name":"Orchestration","score":0.4970000088214874},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.4952999949455261},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.4690000116825104},{"id":"https://openalex.org/keywords/traceability","display_name":"Traceability","score":0.43540000915527344},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.39959999918937683},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.39430001378059387},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3603000044822693},{"id":"https://openalex.org/keywords/cloud-storage","display_name":"Cloud storage","score":0.3411000072956085}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7583000063896179},{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.652899980545044},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5582000017166138},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5478000044822693},{"id":"https://openalex.org/C199168358","wikidata":"https://www.wikidata.org/wiki/Q3367000","display_name":"Orchestration","level":3,"score":0.4970000088214874},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.4952999949455261},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.4690000116825104},{"id":"https://openalex.org/C153876917","wikidata":"https://www.wikidata.org/wiki/Q899704","display_name":"Traceability","level":2,"score":0.43540000915527344},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.39959999918937683},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.39430001378059387},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3603000044822693},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3474000096321106},{"id":"https://openalex.org/C2777059624","wikidata":"https://www.wikidata.org/wiki/Q914359","display_name":"Cloud storage","level":3,"score":0.3411000072956085},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.33809998631477356},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.3352000117301941},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.3345000147819519},{"id":"https://openalex.org/C110903229","wikidata":"https://www.wikidata.org/wiki/Q7449064","display_name":"Semantic integration","level":4,"score":0.33320000767707825},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.3310000002384186},{"id":"https://openalex.org/C2778180026","wikidata":"https://www.wikidata.org/wiki/Q18378163","display_name":"Semantic heterogeneity","level":4,"score":0.33090001344680786},{"id":"https://openalex.org/C192800085","wikidata":"https://www.wikidata.org/wiki/Q5258530","display_name":"Semantic interoperability","level":3,"score":0.3230000138282776},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.32280001044273376},{"id":"https://openalex.org/C80344994","wikidata":"https://www.wikidata.org/wiki/Q5227369","display_name":"Data virtualization","level":4,"score":0.3215000033378601},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.31859999895095825},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.29280000925064087},{"id":"https://openalex.org/C188087704","wikidata":"https://www.wikidata.org/wiki/Q369577","display_name":"Standardization","level":2,"score":0.273499995470047},{"id":"https://openalex.org/C6881194","wikidata":"https://www.wikidata.org/wiki/Q7449091","display_name":"Semantic technology","level":4,"score":0.2703000009059906},{"id":"https://openalex.org/C196879817","wikidata":"https://www.wikidata.org/wiki/Q872685","display_name":"Data governance","level":4,"score":0.26440000534057617},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.2621000111103058},{"id":"https://openalex.org/C2777516300","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data discovery","level":3,"score":0.26089999079704285},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.25920000672340393},{"id":"https://openalex.org/C187691185","wikidata":"https://www.wikidata.org/wiki/Q2020720","display_name":"Grid","level":2,"score":0.25859999656677246},{"id":"https://openalex.org/C22550185","wikidata":"https://www.wikidata.org/wiki/Q7095047","display_name":"Ontology-based data integration","level":3,"score":0.2574999928474426},{"id":"https://openalex.org/C33326189","wikidata":"https://www.wikidata.org/wiki/Q17092450","display_name":"Information integration","level":2,"score":0.2563999891281128},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.25600001215934753},{"id":"https://openalex.org/C69075417","wikidata":"https://www.wikidata.org/wiki/Q515701","display_name":"Linked data","level":3,"score":0.2549000084400177}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3390/info16110932","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info16110932","pdf_url":"https://www.mdpi.com/2078-2489/16/11/932/pdf?version=1761639185","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:2b8c16422c8943eeba160b943745a289","is_oa":true,"landing_page_url":"https://doaj.org/article/2b8c16422c8943eeba160b943745a289","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"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 16, Iss 11, p 932 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/info16110932","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info16110932","pdf_url":"https://www.mdpi.com/2078-2489/16/11/932/pdf?version=1761639185","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":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4415683730.pdf","grobid_xml":"https://content.openalex.org/works/W4415683730.grobid-xml"},"referenced_works_count":88,"referenced_works":["https://openalex.org/W1679882079","https://openalex.org/W1970026646","https://openalex.org/W2003012803","https://openalex.org/W2005112390","https://openalex.org/W2006296837","https://openalex.org/W2008896880","https://openalex.org/W2029021214","https://openalex.org/W2048672894","https://openalex.org/W2068739275","https://openalex.org/W2074489032","https://openalex.org/W2080133951","https://openalex.org/W2083755493","https://openalex.org/W2102639991","https://openalex.org/W2102729946","https://openalex.org/W2106019582","https://openalex.org/W2119738171","https://openalex.org/W2123686039","https://openalex.org/W2145195191","https://openalex.org/W2153225416","https://openalex.org/W2153704625","https://openalex.org/W2167541073","https://openalex.org/W2180737804","https://openalex.org/W2265297126","https://openalex.org/W2276530525","https://openalex.org/W2295240344","https://openalex.org/W2302501749","https://openalex.org/W2341655714","https://openalex.org/W2602620885","https://openalex.org/W2613215397","https://openalex.org/W2763178752","https://openalex.org/W2766945679","https://openalex.org/W2790625403","https://openalex.org/W2798434712","https://openalex.org/W2799059383","https://openalex.org/W2889249015","https://openalex.org/W2939328059","https://openalex.org/W2949762319","https://openalex.org/W2972702295","https://openalex.org/W2981117684","https://openalex.org/W3014295153","https://openalex.org/W3015457380","https://openalex.org/W3048871918","https://openalex.org/W3085477028","https://openalex.org/W3112600195","https://openalex.org/W3139115194","https://openalex.org/W3176153696","https://openalex.org/W3192755710","https://openalex.org/W3194187125","https://openalex.org/W3197174867","https://openalex.org/W3199469221","https://openalex.org/W3200572611","https://openalex.org/W3201472123","https://openalex.org/W3216676973","https://openalex.org/W4207055316","https://openalex.org/W4224290816","https://openalex.org/W4239670432","https://openalex.org/W4241410814","https://openalex.org/W4242744113","https://openalex.org/W4282570649","https://openalex.org/W4282585030","https://openalex.org/W4300456194","https://openalex.org/W4312292115","https://openalex.org/W4312760522","https://openalex.org/W4318818298","https://openalex.org/W4367032190","https://openalex.org/W4375928209","https://openalex.org/W4381511740","https://openalex.org/W4383710649","https://openalex.org/W4386128176","https://openalex.org/W4386636320","https://openalex.org/W4389539860","https://openalex.org/W4389606903","https://openalex.org/W4392093235","https://openalex.org/W4394720620","https://openalex.org/W4394932854","https://openalex.org/W4396227507","https://openalex.org/W4399208169","https://openalex.org/W4399261722","https://openalex.org/W4400909484","https://openalex.org/W4401009345","https://openalex.org/W4401624027","https://openalex.org/W4404181190","https://openalex.org/W4404181225","https://openalex.org/W4405047605","https://openalex.org/W4406870755","https://openalex.org/W4410202920","https://openalex.org/W4411403517","https://openalex.org/W4412571065"],"related_works":[],"abstract_inverted_index":{"In":[0,59],"the":[1,102,117,131,137,201,240],"current":[2],"scenario":[3],"of":[4,7,21,139,173,203,242,281],"universal":[5],"accessibility":[6],"data,":[8],"organisations":[9],"face":[10],"highly":[11],"complex":[12],"challenges":[13,103],"related":[14],"to":[15,25,76,119,153,193,272],"integrating":[16],"and":[17,35,42,53,73,83,89,94,123,150,157,164,188,237,245,258,263],"processing":[18],"diverse":[19],"sets":[20],"data":[22,40,247],"in":[23,182,206,231],"order":[24],"meet":[26],"their":[27,48],"analytical":[28,57,208,266],"needs.":[29],"This":[30,249],"review":[31,250],"paper":[32],"analyses":[33],"traditional":[34,113],"innovative":[36],"methods":[37],"used":[38],"for":[39,50,136,212,221,235],"storage":[41,109,114,121],"integration,":[43],"with":[44,86,142,168,210,216,219,227,288],"particular":[45],"focus":[46,144],"on":[47,145],"implications":[49],"scalability,":[51],"consistency,":[52],"interoperability":[54],"within":[55],"an":[56,232],"ecosystem.":[58],"particular,":[60],"it":[61],"contributes":[62],"a":[63,143,278],"cross-layer":[64],"taxonomy":[65],"linking":[66],"integration":[67,126],"mechanisms":[68],"(schema":[69],"matching,":[70],"entity":[71],"resolution,":[72],"semantic":[74,146],"enrichment)":[75],"storage/query":[77],"substrates":[78],"(row/column":[79],"stores,":[80],"NoSQL,":[81],"lakehouse,":[82],"federation),":[84],"together":[85],"comparative":[87],"tables":[88],"figures":[90],"that":[91],"synthesise":[92],"trade-offs":[93,170],"performance/governance":[95],"levers.":[96],"Through":[97],"schema":[98],"mapping":[99],"solutions":[100,115],"addressing":[101],"brought":[104],"about":[105],"by":[106,275],"structural":[107],"heterogeneity,":[108],"architectures":[110],"varying":[111],"from":[112,179],"all":[116],"way":[118],"cloud":[120],"solutions,":[122],"ETL":[124],"pipeline":[125],"using":[127,148],"federated":[128],"query":[129],"processors,":[130],"research":[132],"provides":[133],"specific":[134],"attention":[135],"application":[138],"metadata":[140],"management,":[141],"enrichment":[147],"ontologies":[149],"lineage":[151],"management":[152],"enable":[154],"end-to-end":[155],"traceability":[156],"governance.":[158],"It":[159,268],"also":[160,269],"covers":[161],"performance":[162],"hotspots":[163],"caching":[165],"techniques,":[166],"along":[167,215],"consistency":[169],"arising":[171],"out":[172],"distributed":[174],"systems.":[175],"Empirical":[176],"case":[177],"studies":[178],"real":[180],"applications":[181,191],"enterprise":[183],"lakehouses,":[184],"scientific":[185],"exploration":[186],"activities,":[187],"public":[189],"governance":[190],"serve":[192],"invoke":[194],"this":[195,198],"review.":[196],"Following":[197],"work":[199],"is":[200,251],"possibility":[202],"future":[204],"directions":[205],"convergent":[207],"platforms":[209],"support":[211],"multiple":[213],"workloads,":[214],"metadata-centric":[217],"orchestration":[218],"provisions":[220],"AI-based":[222],"integration.":[223],"Combining":[224],"technological":[225],"advancement":[226],"practical":[228],"considerations":[229],"results":[230],"enabling":[233],"resource":[234],"researchers":[236],"practitioners":[238,260],"seeking":[239],"creation":[241],"fault-tolerant,":[243],"reliable,":[244],"future-ready":[246],"infrastructure.":[248],"primarily":[252],"aimed":[253],"at":[254],"researchers,":[255],"system":[256],"architects,":[257],"advanced":[259],"who":[261],"design":[262],"evaluate":[264],"heterogeneous":[265],"platforms.":[267],"offers":[270],"value":[271],"graduate":[273],"students":[274],"serving":[276],"as":[277],"structured":[279],"overview":[280],"contemporary":[282],"methods,":[283],"thereby":[284],"bridging":[285],"academic":[286],"knowledge":[287],"industrial":[289],"practice.":[290]},"counts_by_year":[{"year":2026,"cited_by_count":10}],"updated_date":"2026-08-08T01:25:22.217667","created_date":"2025-10-30T00:00:00"}