Logo do repositório
 
Publicação

Unified Data Governance in Heterogeneous Database Environments: An API-Driven Architecture for Multi-Platform Policy Enforcement

2026Texto Acesso aberto
Ver registo simples
datacite.subject.fosCiências Naturais::Ciências da Computação e da Informação
datacite.subject.sdg09:Indústria, Inovação e Infraestruturas
dc.contributor.authorAbbasi, Maryam
dc.contributor.authorANTUNES VAZ, PAULO JOAQUIM
dc.contributor.authorSilva, José
dc.contributor.authorCardoso, Filipe
dc.contributor.authorSá, Filipe
dc.contributor.authorMartins, Pedro
dc.contributor.editorCardoso, Filipe
dc.contributor.editorSá, Filipe
dc.contributor.editorMartins, Pedro
dc.date.accessioned2026-03-11T09:41:10Z
dc.date.available2026-03-11T09:41:10Z
dc.date.issued2026
dc.description.abstractModern organizations increasingly rely on heterogeneous database environments that combine relational, document-oriented, and key-value storage systems to optimize performance for diverse application requirements. However, this technological diversity creates significant challenges for implementing consistent data governance policies, regulatory compliance, and access control across disparate systems. Traditional governance approaches that operate within individual database silos fail to provide unified policy enforcement and create compliance gaps that expose organizations to regulatory and operational risks. This paper presents a novel API-driven architecture that enables unified data governance across heterogeneous database environments without requiring database-specific modifications or vendor lock-in. The proposed framework implements a centralized governance layer that coordinates policy enforcement across PostgreSQL, MongoDB, and Amazon DynamoDB systems through RESTful API interfaces. Key architectural components include differentiated access control through hierarchical API key management, automated compliance workflows for regulatory requirements such as GDPR, real-time audit trail generation, and comprehensive data quality monitoring with automated improvement mechanisms. Comprehensive experimental evaluation demonstrates the framework’s effectiveness across multiple operational dimensions. The system achieved 95.2% accuracy in access control enforcement across different data classification levels, while automated GDPR compliance workflows demonstrated 98.6% success rates with average processing times of 2.9 h. Performance evaluation reveals acceptable overhead characteristics with linear scaling patterns for PostgreSQL operations (R2 = 0.89), consistent sub-20ms response times for MongoDB logging operations, and sustained throughput rates ranging from 38.9 to 142.7 requests per second across the integrated system. Data quality improvements ranged from 16.1% to 34.3% across accuracy, completeness, consistency, and timeliness dimensions over a 12-week monitoring period, with accuracy improving by 17.8 percentage points, completeness by 13.2 percentage points, consistency by 19.7 percentage points, and timeliness by 24.5 percentage points. The duplicate detection system achieved 94.6% precision and 95.6% recall across various duplicate types, including cross-database redundancy identification. The results demonstrate that API-driven governance architectures can effectively address the persistent challenges of policy fragmentation in multi-database environments while maintaining operational performance and enabling measurable improvements in data quality and regulatory compliance. The framework provides a practical migration path for organizations seeking to implement comprehensive governance capabilities without replacing existing database infrastructure investments.por
dc.identifier.citationAbbasi, M., Váz, P., Silva, J., Cardoso, F., Sá, F., & Martins, P. (2026). Unified Data Governance in Heterogeneous Database Environments: An API-Driven Architecture for Multi-Platform Policy Enforcement. Data, 11(3), 54. https://doi.org/10.3390/data11030054
dc.identifier.doihttps://doi.org/10.3390/data11030054
dc.identifier.urihttp://hdl.handle.net/10400.19/9735
dc.language.isoeng
dc.peerreviewedyes
dc.publisherMDPI
dc.relation.hasversionhttps://www.mdpi.com/2306-5729/11/3/54
dc.rights.urihttp://creativecommons.org/licenses/by/4.0/
dc.subjectdata governance
dc.subjectmulti-database architecture
dc.subjectAPI-driven systems
dc.subjectregulatory compliance
dc.subjectheterogeneous databases
dc.subjectGDPR automation
dc.subjectaccess control
dc.subjectdata quality management
dc.titleUnified Data Governance in Heterogeneous Database Environments: An API-Driven Architecture for Multi-Platform Policy Enforcementpor
dc.typetext
dspace.entity.typePublication
oaire.citation.issue3
oaire.citation.startPage54
oaire.citation.titleData
oaire.citation.volume11
oaire.versionhttp://purl.org/coar/version/c_970fb48d4fbd8a85
person.familyNameANTUNES VAZ
person.familyNameSilva
person.givenNamePAULO JOAQUIM
person.givenNameJosé
person.identifier.ciencia-id351C-9899-0EE7
person.identifier.ciencia-id4A14-D3E7-5B32
person.identifier.orcid0000-0002-1745-8937
person.identifier.orcid0000-0001-7285-8282
person.identifier.scopus-author-id55447844100
relation.isAuthorOfPublication702e79ee-5b0b-47ff-989d-12e6d8ea1e89
relation.isAuthorOfPublicatione9d8719e-af47-4008-b854-817801bb3964
relation.isAuthorOfPublication.latestForDiscovery702e79ee-5b0b-47ff-989d-12e6d8ea1e89

Ficheiros

Principais
A mostrar 1 - 1 de 1
Miniatura
Nome:
Unified Data Governance in Heterogeneous Database.pdf
Tamanho:
408.57 KB
Formato:
Adobe Portable Document Format
Ver/Abrir
Licença
A mostrar 1 - 1 de 1
Miniatura indisponível
Nome:
license.txt
Tamanho:
1.79 KB
Formato:
Item-specific license agreed upon to submission
Descrição:
Ver/Abrir

Coleções

ESTGV - DEMGI - Artigo em revista científica, indexada ao WoS/Scopus
CISeD - Artigo em revista científica, indexada ao WoS/Scopus
ESTGV - DI - Artigo em revista científica, indexada ao WoS/Scopus