{"id":"https://openalex.org/W7154706215","doi":"https://doi.org/10.48550/arxiv.2604.15108","title":"Data Engineering Patterns for Cross-System Reconciliation in Regulated Enterprises: Architecture, Anomaly Detection, and Governance","display_name":"Data Engineering Patterns for Cross-System Reconciliation in Regulated Enterprises: Architecture, Anomaly Detection, and Governance","publication_year":2026,"publication_date":"2026-04-16","ids":{"openalex":"https://openalex.org/W7154706215","doi":"https://doi.org/10.48550/arxiv.2604.15108"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2604.15108","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.15108","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"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":"Preprint"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2604.15108","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5133859672","display_name":"Zhijun Qiu","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Qiu, Zhijun","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5133859672"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"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/T12127","display_name":"Software System Performance and Reliability","score":0.10159999877214432,"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"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.10159999877214432,"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.029600000008940697,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.027899999171495438,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/architecture-framework","display_name":"Architecture framework","score":0.6031000018119812},{"id":"https://openalex.org/keywords/broadband","display_name":"Broadband","score":0.4641999900341034},{"id":"https://openalex.org/keywords/corporate-governance","display_name":"Corporate governance","score":0.4505999982357025},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.4399000108242035},{"id":"https://openalex.org/keywords/asset","display_name":"Asset (computer security)","score":0.4066999852657318},{"id":"https://openalex.org/keywords/fragmentation","display_name":"Fragmentation (computing)","score":0.38909998536109924},{"id":"https://openalex.org/keywords/anomaly-detection","display_name":"Anomaly detection","score":0.3847000002861023},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.3797999918460846},{"id":"https://openalex.org/keywords/data-governance","display_name":"Data governance","score":0.3772999942302704},{"id":"https://openalex.org/keywords/supply-chain","display_name":"Supply chain","score":0.3732999861240387}],"concepts":[{"id":"https://openalex.org/C53619493","wikidata":"https://www.wikidata.org/wiki/Q4787093","display_name":"Architecture framework","level":3,"score":0.6031000018119812},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5566999912261963},{"id":"https://openalex.org/C509933004","wikidata":"https://www.wikidata.org/wiki/Q194163","display_name":"Broadband","level":2,"score":0.4641999900341034},{"id":"https://openalex.org/C39389867","wikidata":"https://www.wikidata.org/wiki/Q380767","display_name":"Corporate governance","level":2,"score":0.4505999982357025},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.4399000108242035},{"id":"https://openalex.org/C76178495","wikidata":"https://www.wikidata.org/wiki/Q4808784","display_name":"Asset (computer security)","level":2,"score":0.4066999852657318},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.39079999923706055},{"id":"https://openalex.org/C191015642","wikidata":"https://www.wikidata.org/wiki/Q1132459","display_name":"Fragmentation (computing)","level":2,"score":0.38909998536109924},{"id":"https://openalex.org/C739882","wikidata":"https://www.wikidata.org/wiki/Q3560506","display_name":"Anomaly detection","level":2,"score":0.3847000002861023},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.3797999918460846},{"id":"https://openalex.org/C196879817","wikidata":"https://www.wikidata.org/wiki/Q872685","display_name":"Data governance","level":4,"score":0.3772999942302704},{"id":"https://openalex.org/C108713360","wikidata":"https://www.wikidata.org/wiki/Q1824206","display_name":"Supply chain","level":2,"score":0.3732999861240387},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.3720000088214874},{"id":"https://openalex.org/C10590034","wikidata":"https://www.wikidata.org/wiki/Q1048431","display_name":"Enterprise architecture","level":3,"score":0.34150001406669617},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33230000734329224},{"id":"https://openalex.org/C31139447","wikidata":"https://www.wikidata.org/wiki/Q5380386","display_name":"Enterprise information security architecture","level":2,"score":0.3264999985694885},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3255000114440918},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.3246000111103058},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.31850001215934753},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.3181999921798706},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3172000050544739},{"id":"https://openalex.org/C111219384","wikidata":"https://www.wikidata.org/wiki/Q6954384","display_name":"NIST","level":2,"score":0.3147999942302704},{"id":"https://openalex.org/C98025372","wikidata":"https://www.wikidata.org/wiki/Q477538","display_name":"Systems architecture","level":3,"score":0.314300000667572},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.3109000027179718},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.30790001153945923},{"id":"https://openalex.org/C2778058735","wikidata":"https://www.wikidata.org/wiki/Q4692253","display_name":"Aggregate data","level":2,"score":0.2980000078678131},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2973000109195709},{"id":"https://openalex.org/C2776517139","wikidata":"https://www.wikidata.org/wiki/Q873442","display_name":"Asset management","level":2,"score":0.29190000891685486},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.28679999709129333},{"id":"https://openalex.org/C136227091","wikidata":"https://www.wikidata.org/wiki/Q5380376","display_name":"Enterprise data management","level":3,"score":0.2799000144004822},{"id":"https://openalex.org/C85890633","wikidata":"https://www.wikidata.org/wiki/Q929673","display_name":"Capability Maturity Model","level":3,"score":0.2766999900341034},{"id":"https://openalex.org/C10511746","wikidata":"https://www.wikidata.org/wiki/Q899388","display_name":"Data security","level":3,"score":0.27549999952316284},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.2705000042915344},{"id":"https://openalex.org/C121017731","wikidata":"https://www.wikidata.org/wiki/Q11661","display_name":"Information technology","level":2,"score":0.26409998536109924},{"id":"https://openalex.org/C55356503","wikidata":"https://www.wikidata.org/wiki/Q2136675","display_name":"Reference architecture","level":4,"score":0.2599000036716461},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.25940001010894775},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.257099986076355},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.257099986076355},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.25529998540878296}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2604.15108","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.15108","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2604.15108","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.15108","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"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":"Preprint"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.5896387100219727}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Regulated":[0],"enterprises":[1],"in":[2,57,62,161],"the":[3,37,88,104,156,188],"United":[4],"States":[5],"--":[6,13,111,173,184,218,226],"banks,":[7],"telecommunications":[8],"providers,":[9],"large":[10],"technology":[11,208],"companies":[12],"operate":[14],"across":[15,97,192],"heterogeneous":[16],"systems":[17,69],"that":[18,74,117],"were":[19],"rarely":[20],"designed":[21],"to":[22,45],"interoperate.":[23],"ERP":[24],"platforms,":[25],"billing":[26,175],"engines,":[27],"supply":[28],"chain":[29],"tools,":[30],"and":[31,72,133,152,179,185,204],"financial":[32],"reporting":[33],"infrastructure":[34],"coexist":[35],"within":[36],"same":[38],"organization,":[39],"but":[40,60],"they":[41],"do":[42],"not":[43,227],"talk":[44],"each":[46],"other":[47],"well.":[48],"The":[49,79,143,165],"resulting":[50],"fragmentation":[51],"produces":[52],"familiar":[53],"problems:":[54],"transactions":[55],"recorded":[56],"one":[58],"system":[59],"unreconciled":[61],"another,":[63],"asset":[64],"inventories":[65],"drifting":[66],"from":[67],"their":[68],"of":[70],"record,":[71],"audit-readiness":[73],"depends":[75],"on":[76,87,187],"manual":[77],"effort.":[78],"PCAOB's":[80],"2024":[81],"inspection":[82],"cycle":[83],"put":[84],"a":[85,90,112,140,197,200,205,215,228],"number":[86],"consequences:":[89],"39%":[91],"aggregate":[92],"Part":[93],"I.A":[94],"deficiency":[95],"rate":[96],"all":[98],"inspected":[99],"firms.":[100],"This":[101,213],"paper":[102,222],"introduces":[103],"GERA":[105],"Framework":[106],"(Governed":[107],"Enterprise":[108],"Reconciliation":[109],"Architecture)":[110],"vendor-neutral,":[113],"four-layer":[114],"data":[115,163],"architecture":[116,144],"integrates":[118],"deterministic":[119],"cross-system":[120],"reconciliation,":[121,176],"statistical":[122],"anomaly":[123],"detection":[124],"(baseline":[125],"Z-Score":[126],"with":[127],"robust":[128],"alternatives),":[129],"governed":[130],"semantic":[131,153],"standardization,":[132],"NIST":[134],"CSF":[135],"2.0-aligned":[136],"security":[137],"controls":[138],"into":[139],"single":[141],"methodology.":[142],"spans":[145],"four":[146],"layers":[147],"(ingestion,":[148],"staging,":[149],"core":[150],"models,":[151],"serving),":[154],"following":[155],"multi-layer":[157],"pattern":[158],"now":[159],"common":[160],"modern":[162],"platforms.":[164],"patterns":[166,225],"are":[167,181,241],"demonstrated":[168],"through":[169],"U.S.":[170],"broadband":[171,202],"operations":[172],"where":[174],"inventory":[177],"aging,":[178],"governance":[180],"tightly":[182],"coupled":[183],"draw":[186],"author's":[189],"implementation":[190],"experience":[191],"three":[193],"regulated":[194],"enterprise":[195],"environments:":[196],"regional":[198],"bank,":[199],"national":[201],"provider,":[203],"Fortune":[206],"500":[207],"company's":[209],"central":[210],"finance":[211],"organization.":[212],"is":[214],"practitioner":[216],"reference":[217],"an":[219],"architectural":[220],"framework":[221],"documenting":[223],"field-tested":[224],"controlled":[229],"experiment":[230],"or":[231,238],"benchmark":[232],"study.":[233],"No":[234],"proprietary":[235],"systems,":[236],"datasets,":[237],"internal":[239],"implementations":[240],"disclosed.":[242]},"counts_by_year":[],"updated_date":"2026-07-01T06:00:48.157686","created_date":"2026-04-18T00:00:00"}