{"id":"https://openalex.org/W7134176438","doi":"https://doi.org/10.3390/data11030054","title":"Unified Data Governance in Heterogeneous Database Environments: An API-Driven Architecture for Multi-Platform Policy Enforcement","display_name":"Unified Data Governance in Heterogeneous Database Environments: An API-Driven Architecture for Multi-Platform Policy Enforcement","publication_year":2026,"publication_date":"2026-03-07","ids":{"openalex":"https://openalex.org/W7134176438","doi":"https://doi.org/10.3390/data11030054"},"language":"en","primary_location":{"id":"doi:10.3390/data11030054","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data11030054","pdf_url":"https://www.mdpi.com/2306-5729/11/3/54/pdf?version=1773053984","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"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":"Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2306-5729/11/3/54/pdf?version=1773053984","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5128347963","display_name":"Maryam Abbasi","orcid":null},"institutions":[{"id":"https://openalex.org/I4210108271","display_name":"Instituto Superior de Gest\u00e3o e Administra\u00e7\u00e3o de Santar\u00e9m","ror":"https://ror.org/01g2xkw11","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210108271"]},{"id":"https://openalex.org/I4210114793","display_name":"Instituto Polit\u00e9cnico de Santar\u00e9m","ror":"https://ror.org/02bbx2g30","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210114793"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Maryam Abbasi","raw_affiliation_strings":["Escola Superior de Gest\u00e3o e Tecnologia de Santar\u00e9m, Polytechnic Institute of Santar\u00e9m, 2001-904 Santarem, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escola Superior de Gest\u00e3o e Tecnologia de Santar\u00e9m, Polytechnic Institute of Santar\u00e9m, 2001-904 Santarem, Portugal","institution_ids":["https://openalex.org/I4210114793","https://openalex.org/I4210108271"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069470015","display_name":"Paulo V\u00e1z","orcid":"https://orcid.org/0000-0002-1745-8937"},"institutions":[{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Paulo V\u00e1z","raw_affiliation_strings":["Research Center in Digital Services, Polytechnic Institute of Viseu, 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-1745-8937","affiliations":[{"raw_affiliation_string":"Research Center in Digital Services, Polytechnic Institute of Viseu, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006073600","display_name":"Jos\u00e9 Fernando Modesto da Silva","orcid":null},"institutions":[{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Silva","raw_affiliation_strings":["Research Center in Digital Services, Polytechnic Institute of Viseu, 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0001-7285-8282","affiliations":[{"raw_affiliation_string":"Research Center in Digital Services, Polytechnic Institute of Viseu, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067746692","display_name":"Filipe Cardoso","orcid":"https://orcid.org/0000-0002-3916-5182"},"institutions":[{"id":"https://openalex.org/I4210108271","display_name":"Instituto Superior de Gest\u00e3o e Administra\u00e7\u00e3o de Santar\u00e9m","ror":"https://ror.org/01g2xkw11","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210108271"]},{"id":"https://openalex.org/I4210114793","display_name":"Instituto Polit\u00e9cnico de Santar\u00e9m","ror":"https://ror.org/02bbx2g30","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210114793"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Filipe Cardoso","raw_affiliation_strings":["Escola Superior de Gest\u00e3o e Tecnologia de Santar\u00e9m, Polytechnic Institute of Santar\u00e9m, 2001-904 Santarem, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-3916-5182","affiliations":[{"raw_affiliation_string":"Escola Superior de Gest\u00e3o e Tecnologia de Santar\u00e9m, Polytechnic Institute of Santar\u00e9m, 2001-904 Santarem, Portugal","institution_ids":["https://openalex.org/I4210114793","https://openalex.org/I4210108271"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054134720","display_name":"Filipe S\u00e1","orcid":"https://orcid.org/0000-0002-7846-8397"},"institutions":[{"id":"https://openalex.org/I293362453","display_name":"Polytechnic Institute of Coimbra","ror":"https://ror.org/01n8x4993","country_code":"PT","type":"education","lineage":["https://openalex.org/I293362453"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Filipe S\u00e1","raw_affiliation_strings":["ISEC\u2014Coimbra Institute of Engineering, Polytechnic University of Coimbra, 3030-199 Coimbra, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-7846-8397","affiliations":[{"raw_affiliation_string":"ISEC\u2014Coimbra Institute of Engineering, Polytechnic University of Coimbra, 3030-199 Coimbra, Portugal","institution_ids":["https://openalex.org/I293362453"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5128344320","display_name":"Pedro Martins","orcid":null},"institutions":[{"id":"https://openalex.org/I56125125","display_name":"Polytechnic Institute of Viseu","ror":"https://ror.org/0235kxk33","country_code":"PT","type":"education","lineage":["https://openalex.org/I56125125"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Pedro Martins","raw_affiliation_strings":["Research Center in Digital Services, Polytechnic Institute of Viseu, 3504-510 Viseu, Portugal"],"raw_orcid":"https://orcid.org/0000-0002-2118-1440","affiliations":[{"raw_affiliation_string":"Research Center in Digital Services, Polytechnic Institute of Viseu, 3504-510 Viseu, Portugal","institution_ids":["https://openalex.org/I56125125"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5128344320"],"corresponding_institution_ids":["https://openalex.org/I56125125"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1732},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1732},"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.33241088,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"11","issue":"3","first_page":"54","last_page":"54"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11614","display_name":"Cloud Data Security Solutions","score":0.14350000023841858,"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/T11614","display_name":"Cloud Data Security Solutions","score":0.14350000023841858,"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/T10927","display_name":"Access Control and Trust","score":0.12860000133514404,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.08259999752044678,"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/workflow","display_name":"Workflow","score":0.656499981880188},{"id":"https://openalex.org/keywords/data-governance","display_name":"Data governance","score":0.49720001220703125},{"id":"https://openalex.org/keywords/enforcement","display_name":"Enforcement","score":0.46549999713897705},{"id":"https://openalex.org/keywords/access-control","display_name":"Access control","score":0.44530001282691956},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.4361000061035156},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.42089998722076416},{"id":"https://openalex.org/keywords/corporate-governance","display_name":"Corporate governance","score":0.4138000011444092},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.39649999141693115}],"concepts":[{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.656499981880188},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6087999939918518},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5120999813079834},{"id":"https://openalex.org/C196879817","wikidata":"https://www.wikidata.org/wiki/Q872685","display_name":"Data governance","level":4,"score":0.49720001220703125},{"id":"https://openalex.org/C2779777834","wikidata":"https://www.wikidata.org/wiki/Q4202277","display_name":"Enforcement","level":2,"score":0.46549999713897705},{"id":"https://openalex.org/C527821871","wikidata":"https://www.wikidata.org/wiki/Q228502","display_name":"Access control","level":2,"score":0.44530001282691956},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.4361000061035156},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.42089998722076416},{"id":"https://openalex.org/C39389867","wikidata":"https://www.wikidata.org/wiki/Q380767","display_name":"Corporate governance","level":2,"score":0.4138000011444092},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.4117000102996826},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.39649999141693115},{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.38659998774528503},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.3237000107765198},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.30559998750686646},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.3027999997138977},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.27799999713897705},{"id":"https://openalex.org/C2777338717","wikidata":"https://www.wikidata.org/wiki/Q1762621","display_name":"Vendor","level":2,"score":0.2752000093460083},{"id":"https://openalex.org/C53619493","wikidata":"https://www.wikidata.org/wiki/Q4787093","display_name":"Architecture framework","level":3,"score":0.26989999413490295},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2676999866962433},{"id":"https://openalex.org/C98025372","wikidata":"https://www.wikidata.org/wiki/Q477538","display_name":"Systems architecture","level":3,"score":0.2599000036716461},{"id":"https://openalex.org/C189922023","wikidata":"https://www.wikidata.org/wiki/Q17056348","display_name":"Information governance","level":4,"score":0.25859999656677246},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.2540999948978424},{"id":"https://openalex.org/C2775924081","wikidata":"https://www.wikidata.org/wiki/Q55608371","display_name":"Control (management)","level":2,"score":0.2540999948978424},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.2517000138759613}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/data11030054","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data11030054","pdf_url":"https://www.mdpi.com/2306-5729/11/3/54/pdf?version=1773053984","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"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":"Data","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:1edb1d58ac9c43a4891ab6da6a68220a","is_oa":true,"landing_page_url":"https://doaj.org/article/1edb1d58ac9c43a4891ab6da6a68220a","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":"Data, Vol 11, Iss 3, p 54 (2026)","raw_type":"article"},{"id":"pmh:oai:repositorio.ipv.pt:10400.19/9735","is_oa":true,"landing_page_url":"http://hdl.handle.net/10400.19/9735","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","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","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.3390/data11030054","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data11030054","pdf_url":"https://www.mdpi.com/2306-5729/11/3/54/pdf?version=1773053984","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"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":"Data","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth","score":0.41079384088516235}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7134176438.pdf","grobid_xml":"https://content.openalex.org/works/W7134176438.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Modern":[0],"organizations":[1,65,334],"increasingly":[2],"rely":[3],"on":[4],"heterogeneous":[5,84],"database":[6,51,85,344],"environments":[7,86,311],"that":[8,47,63,78,102,296],"combine":[9],"relational,":[10],"document-oriented,":[11],"and":[12,38,59,68,109,142,216,244,269,282,316,323],"key-value":[13],"storage":[14],"systems":[15,112],"to":[16,54,66,223,238,336],"optimize":[17],"performance":[18,315],"for":[19,30,132,202,212,333],"diverse":[20],"application":[21],"requirements.":[22],"However,":[23],"this":[24],"technological":[25],"diversity":[26],"creates":[27],"significant":[28],"challenges":[29,305],"implementing":[31],"consistent":[32,208],"data":[33,81,144,173,321],"governance":[34,45,82,100,298,339],"policies,":[35],"regulatory":[36,67,133,324],"compliance,":[37],"access":[39,122,168],"control":[40,123,169],"across":[41,83,106,158,171,228,240,285],"disparate":[42],"systems.":[43],"Traditional":[44],"approaches":[46],"operate":[48],"within":[49],"individual":[50],"silos":[52],"fail":[53],"provide":[55],"unified":[56,80],"policy":[57,104,307],"enforcement":[58,105,170],"create":[60],"compliance":[61,130,179],"gaps":[62],"expose":[64],"operational":[69,160,314],"risks.":[70],"This":[71],"paper":[72],"presents":[73],"a":[74,98,248,329],"novel":[75],"API-driven":[76,297],"architecture":[77],"enables":[79],"without":[87,341],"requiring":[88],"database-specific":[89],"modifications":[90],"or":[91],"vendor":[92],"lock-in.":[93],"The":[94,162,275,293,326],"proposed":[95],"framework":[96,327],"implements":[97],"centralized":[99],"layer":[101],"coordinates":[103],"PostgreSQL,":[107],"MongoDB,":[108],"Amazon":[110],"DynamoDB":[111],"through":[113,124],"RESTful":[114],"API":[115,126],"interfaces.":[116],"Key":[117],"architectural":[118],"components":[119],"include":[120],"differentiated":[121],"hierarchical":[125],"key":[127],"management,":[128],"automated":[129,148,177],"workflows":[131,180],"requirements":[134],"such":[135],"as":[136],"GDPR,":[137],"real-time":[138],"audit":[139],"trail":[140],"generation,":[141],"comprehensive":[143,338],"quality":[145,233,322],"monitoring":[146,250],"with":[147,185,198,252],"improvement":[149],"mechanisms.":[150],"Comprehensive":[151],"experimental":[152],"evaluation":[153,193],"demonstrates":[154],"the":[155,229,303],"framework\u2019s":[156],"effectiveness":[157],"multiple":[159],"dimensions.":[161],"system":[163,278],"achieved":[164,279],"95.2%":[165],"accuracy":[166,253],"in":[167,309,320],"different":[172],"classification":[174],"levels,":[175],"while":[176,312],"GDPR":[178],"demonstrated":[181],"98.6%":[182],"success":[183],"rates":[184,219],"average":[186],"processing":[187],"times":[188,211],"of":[189,306],"2.9":[190],"h.":[191],"Performance":[192],"reveals":[194],"acceptable":[195],"overhead":[196],"characteristics":[197],"linear":[199],"scaling":[200],"patterns":[201],"PostgreSQL":[203],"operations":[204],"(R2":[205],"=":[206],"0.89),":[207],"sub-20ms":[209],"response":[210],"MongoDB":[213],"logging":[214],"operations,":[215],"sustained":[217],"throughput":[218],"ranging":[220],"from":[221,236],"38.9":[222],"142.7":[224],"requests":[225],"per":[226],"second":[227],"integrated":[230],"system.":[231],"Data":[232],"improvements":[234,319],"ranged":[235],"16.1%":[237],"34.3%":[239],"accuracy,":[241],"completeness,":[242],"consistency,":[243],"timeliness":[245,270],"dimensions":[246],"over":[247],"12-week":[249],"period,":[251],"improving":[254],"by":[255,260,265,271],"17.8":[256],"percentage":[257,262,267,273],"points,":[258,263,268],"completeness":[259],"13.2":[261],"consistency":[264],"19.7":[266],"24.5":[272],"points.":[274],"duplicate":[276,287],"detection":[277],"94.6%":[280],"precision":[281],"95.6%":[283],"recall":[284],"various":[286],"types,":[288],"including":[289],"cross-database":[290],"redundancy":[291],"identification.":[292],"results":[294],"demonstrate":[295],"architectures":[299],"can":[300],"effectively":[301],"address":[302],"persistent":[304],"fragmentation":[308],"multi-database":[310],"maintaining":[313],"enabling":[317],"measurable":[318],"compliance.":[325],"provides":[328],"practical":[330],"migration":[331],"path":[332],"seeking":[335],"implement":[337],"capabilities":[340],"replacing":[342],"existing":[343],"infrastructure":[345],"investments.":[346]},"counts_by_year":[],"updated_date":"2026-05-06T08:25:59.206177","created_date":"2026-03-09T00:00:00"}