EUVIMEDEUVIMED entdecken
Crossref

Compliance in SQL Databases: Enforcing GDPR and HIPAA through Schema and Policy Design

Arooj Basharat, Atika Nishat

Euro Vantage Journal of Artificial Intelligence · 23.04.2025 · 2 (2)

DOI: 10.65923/hdfy9j42 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Euro Vantage Journal of Artificial Intelligence, online erschienen am 23.04.2025. Verfasst von Arooj Basharat und 1 weiteren Autor:innen.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Data compliance has emerged as a cornerstone of modern data management, driven by regulations such as the General Data Protection Regulation (GDPR) in the European Union and the Health Insurance Portability and Accountability Act (HIPAA) in the United States. SQL databases, which serve as foundational elements in storing and managing sensitive information, must adapt to enforce these regulatory requirements effectively. This paper explores how SQL schema design, policy enforcement, and access control mechanisms can be leveraged to meet GDPR and HIPAA obligations. It examines structural strategies such as data minimization, pseudonymization, encryption at rest and in transit, and audit logging. Additionally, it delves into procedural enforcement using SQL-based access control lists, row-level security, data retention policies, and automated compliance checks. Through practical design principles and real-world examples, this paper provides a comprehensive guide to embedding privacy and security requirements into the relational database layer, ensuring both legal compliance and system integrity.

Zitieren

APA

Basharat, A., & Nishat, A. (2025). Compliance in SQL Databases: Enforcing GDPR and HIPAA through Schema and Policy Design. Euro Vantage Journal of Artificial Intelligence, 2(2). https://doi.org/10.65923/hdfy9j42

Vancouver

Basharat A, Nishat A. Compliance in SQL Databases: Enforcing GDPR and HIPAA through Schema and Policy Design. Euro Vantage Journal of Artificial Intelligence. 2025;2(2). doi:10.65923/hdfy9j42

BibTeX
@article{Basharat2025,
  author = {Basharat, Arooj and Nishat, Atika},
  title = {Compliance in SQL Databases: Enforcing GDPR and HIPAA through Schema and Policy Design},
  journal = {Euro Vantage Journal of Artificial Intelligence},
  year = {2025},
  volume = {2},
  number = {2},
  doi = {10.65923/hdfy9j42}
}
Kostenlos starten →