{"id":"https://openalex.org/W7204804948","doi":"https://doi.org/10.24018/compute.2026.6.3.70578","title":"A Metadata-Driven Framework for Automated Bronze-to-Silver Data Ingestion, Validation and Loading on Databricks","display_name":"A Metadata-Driven Framework for Automated Bronze-to-Silver Data Ingestion, Validation and Loading on Databricks","alternate_titles":[],"publication_year":2026,"publication_date":"2026-08-24","ids":{"openalex":"https://openalex.org/W7204804948","doi":"https://doi.org/10.24018/compute.2026.6.3.70578"},"language":"en","primary_location":{"id":"doi:10.24018/compute.2026.6.3.70578","doi":"https://doi.org/10.24018/compute.2026.6.3.70578","is_oa":true,"landing_page_url":"https://doi.org/10.24018/compute.2026.6.3.70578","pdf_url":"https://eu-opensci.org/index.php/compute/article/download/70578/14828","source":{"id":"https://openalex.org/S4210225405","display_name":"European Journal of Information Technologies and Computer Science","issn_l":"2736-5492","issn":["2736-5492"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"European Journal of Information Technologies and Computer Science","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W7204804948"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://eu-opensci.org/index.php/compute/article/download/70578/14828","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5148788301","display_name":"Anil Kumar Kolla","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210130412","display_name":"HonorHealth","ror":"https://ror.org/03szbwj17","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210130412"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anil Kumar Kolla","raw_affiliation_strings":["Department of IT, HonorHealth, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of IT, HonorHealth, USA","institution_ids":["https://openalex.org/I4210130412"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5122927700","display_name":"Ameya Kokate","orcid":"https://orcid.org/0009-0005-9777-3273","observed_orcids":["https://orcid.org/0009-0005-9777-3273"]},"institutions":[{"id":"https://openalex.org/I162577319","display_name":"The University of Texas at Dallas","ror":"https://ror.org/049emcs32","country_code":"US","type":"education","lineage":["https://openalex.org/I162577319"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ameya Kokate","raw_affiliation_strings":["The University of Texas at Dallas, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Texas at Dallas, USA","institution_ids":["https://openalex.org/I162577319"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5148784862","display_name":"Raghavendra Vellanki","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210130412","display_name":"HonorHealth","ror":"https://ror.org/03szbwj17","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210130412"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Raghavendra Vellanki","raw_affiliation_strings":["Department of IT, HonorHealth, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of IT, HonorHealth, USA","institution_ids":["https://openalex.org/I4210130412"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5148824610","display_name":"Rituja Lolam","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210130412","display_name":"HonorHealth","ror":"https://ror.org/03szbwj17","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210130412"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rituja Lolam","raw_affiliation_strings":["Department of IT, HonorHealth, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of IT, HonorHealth, USA","institution_ids":["https://openalex.org/I4210130412"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5148776773","display_name":"Pranusha Bandi","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210130412","display_name":"HonorHealth","ror":"https://ror.org/03szbwj17","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210130412"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pranusha Bandi","raw_affiliation_strings":["Department of IT, HonorHealth, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of IT, HonorHealth, USA","institution_ids":["https://openalex.org/I4210130412"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.2615,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.94271852,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"6","issue":"3","first_page":"1","last_page":"7"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9688000082969666,"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/T11719","display_name":"Data Quality and Management","score":0.9688000082969666,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.016200000420212746,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.0038999998942017555,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/databricks","display_name":"Databricks","score":0.6470000147819519},{"id":"https://openalex.org/keywords/medallion-architecture","display_name":"Medallion architecture","score":0.8659999966621399},{"id":"https://openalex.org/keywords/data-quality-rules","display_name":"data quality rules","score":0.6710000038146973},{"id":"https://openalex.org/keywords/delta-lake","display_name":"Delta Lake","score":0.6399999856948853},{"id":"https://openalex.org/keywords/data-validation","display_name":"data validation","score":0.6140000224113464},{"id":"https://openalex.org/keywords/etl-automation","display_name":"ETL automation","score":0.6349999904632568},{"id":"https://openalex.org/keywords/data-governance","display_name":"data governance","score":0.5379999876022339}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7462000250816345},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.6316999793052673},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4832000136375427},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47620001435279846},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4154999852180481},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.412200003862381},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4065999984741211},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.4000999927520752},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.4000999927520752},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.3896999955177307},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.36649999022483826},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.3628000020980835},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3517000079154968},{"id":"https://openalex.org/C30872290","wikidata":"https://www.wikidata.org/wiki/Q1172389","display_name":"Data element","level":3,"score":0.3440000116825104},{"id":"https://openalex.org/C2777998813","wikidata":"https://www.wikidata.org/wiki/Q16869124","display_name":"Append","level":2,"score":0.3346000015735626},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.32760000228881836},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.3264000117778778},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.3248000144958496},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.3244999945163727},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3100999891757965},{"id":"https://openalex.org/C58041806","wikidata":"https://www.wikidata.org/wiki/Q1660484","display_name":"Imputation (statistics)","level":3,"score":0.3100000023841858},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.30970001220703125},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2930000126361847},{"id":"https://openalex.org/C80958533","wikidata":"https://www.wikidata.org/wiki/Q1047174","display_name":"Audit trail","level":3,"score":0.29159998893737793},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.29010000824928284},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.2833000123500824},{"id":"https://openalex.org/C2779185108","wikidata":"https://www.wikidata.org/wiki/Q7091744","display_name":"Onboarding","level":2,"score":0.27639999985694885},{"id":"https://openalex.org/C2781003394","wikidata":"https://www.wikidata.org/wiki/Q737372","display_name":"Alphanumeric","level":2,"score":0.2759999930858612},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2757999897003174},{"id":"https://openalex.org/C204495577","wikidata":"https://www.wikidata.org/wiki/Q1205349","display_name":"Callback","level":2,"score":0.27480000257492065},{"id":"https://openalex.org/C56666940","wikidata":"https://www.wikidata.org/wiki/Q788790","display_name":"Documentation","level":2,"score":0.2709999978542328},{"id":"https://openalex.org/C137314826","wikidata":"https://www.wikidata.org/wiki/Q2330408","display_name":"Data mapping","level":2,"score":0.2676999866962433},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.2671000063419342},{"id":"https://openalex.org/C98143201","wikidata":"https://www.wikidata.org/wiki/Q1147639","display_name":"Data dictionary","level":3,"score":0.2662999927997589},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.26350000500679016},{"id":"https://openalex.org/C153048206","wikidata":"https://www.wikidata.org/wiki/Q3454922","display_name":"Metadata repository","level":3,"score":0.25290000438690186}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.24018/compute.2026.6.3.70578","doi":"https://doi.org/10.24018/compute.2026.6.3.70578","is_oa":true,"landing_page_url":"https://doi.org/10.24018/compute.2026.6.3.70578","pdf_url":"https://eu-opensci.org/index.php/compute/article/download/70578/14828","source":{"id":"https://openalex.org/S4210225405","display_name":"European Journal of Information Technologies and Computer Science","issn_l":"2736-5492","issn":["2736-5492"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"European Journal of Information Technologies and Computer Science","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.24018/compute.2026.6.3.70578","doi":"https://doi.org/10.24018/compute.2026.6.3.70578","is_oa":true,"landing_page_url":"https://doi.org/10.24018/compute.2026.6.3.70578","pdf_url":"https://eu-opensci.org/index.php/compute/article/download/70578/14828","source":{"id":"https://openalex.org/S4210225405","display_name":"European Journal of Information Technologies and Computer Science","issn_l":"2736-5492","issn":["2736-5492"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"European Journal of Information Technologies and Computer Science","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7204804948.pdf","grobid_xml":"https://content.openalex.org/works/W7204804948.grobid-xml"},"referenced_works_count":3,"referenced_works":["https://openalex.org/W2166906463","https://openalex.org/W2542459869","https://openalex.org/W3085477028"],"related_works":["https://openalex.org/W7123934887","https://openalex.org/W4412394398","https://openalex.org/W4414879155","https://openalex.org/W7168125236","https://openalex.org/W7198759437","https://openalex.org/W4416294176","https://openalex.org/W7157573249","https://openalex.org/W7094945888","https://openalex.org/W7223116779","https://openalex.org/W7163418017"],"abstract_inverted_index":{"Bronze-to-Silver":[0,67,218],"transformation":[1,84],"is":[2,34],"a":[3,50,61,109,224],"critical":[4],"and":[5,22,49,83,108,122,152,159,162,186,195,207,220,227],"repetitive":[6],"stage":[7,33,219],"of":[8,111],"the":[9,66,90,98,127,130,141,164,180,183,187,217],"Databricks":[10],"medallion":[11],"architecture,":[12,182],"where":[13],"raw,":[14],"ungoverned":[15],"data":[16,80,137,154,196],"must":[17],"be":[18],"cleaned,":[19],"type-cast,":[20],"validated,":[21],"merged":[23],"into":[24,150,168],"curated":[25],"Delta":[26,170],"tables.":[27],"In":[28],"most":[29],"production":[30],"environments":[31],"this":[32],"implemented":[35],"through":[36],"per-table":[37],"notebooks":[38],"or":[39,95,106,135,174],"jobs,":[40],"which":[41],"leads":[42],"to":[43],"duplicated":[44],"logic,":[45],"inconsistent":[46],"quality":[47],"enforcement,":[48],"slow,":[51],"error-prone":[52],"onboarding":[53],"process":[54,190],"for":[55],"new":[56,94],"datasets.":[57],"This":[58],"paper":[59],"presents":[60],"metadata-driven":[62],"framework":[63,128],"that":[64,92],"automates":[65],"pipeline":[68],"on":[69],"Databricks.":[70],"A":[71],"central":[72],"metadata":[73,184],"repository":[74],"defines":[75],"source-to-target":[76],"column":[77,160],"mappings,":[78],"target":[79],"types,":[81],"default":[82],"rules,":[85],"incremental":[86,136],"(delta,":[87],"i.e.,":[88],"only":[89],"records":[91,149,167],"are":[93],"changed":[96],"since":[97],"last":[99],"run)":[100],"watermark":[101],"columns,":[102],"load":[103],"strategy":[104],"(append":[105],"upsert),":[107],"set":[110],"declarative":[112],"data-quality":[113,143,205],"(DQX-style)":[114],"rules":[115,144],"such":[116],"as":[117],"null":[118],"checks,":[119,121],"date-format":[120],"alphanumeric":[123],"checks.":[124],"At":[125],"runtime,":[126],"reads":[129],"active":[131],"metadata,":[132],"fetches":[133],"full":[134],"from":[138,216],"Bronze,":[139],"evaluates":[140],"configured":[142],"against":[145],"every":[146],"column,":[147],"splits":[148],"valid":[151,166],"quarantined":[153],"frames,":[155],"performs":[156],"type":[157],"conversion":[158],"projection,":[161],"writes":[163],"resulting":[165],"Silver":[169],"tables":[171],"using":[172],"append":[173],"merge":[175],"(upsert)":[176],"semantics.":[177],"We":[178],"describe":[179],"system":[181],"model,":[185],"three":[188],"core":[189],"flows\u2014data":[191],"fetch,":[192],"rule-based":[193],"validation,":[194],"conversion/load\u2014and":[197],"outline":[198],"an":[199],"evaluation":[200],"plan":[201],"covering":[202],"engineering":[203],"effort,":[204],"outcomes,":[206],"performance.":[208],"The":[209],"approach":[210],"removes":[211],"hand-written,":[212],"table-specific":[213],"ETL":[214],"code":[215],"replaces":[221],"it":[222],"with":[223],"governed,":[225],"auditable,":[226],"reusable":[228],"configuration":[229],"layer.":[230]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7204804948","counts_by_year":[{"year":2026,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2026-09-01T00:00:00"}
