From 48efa2dfde7c263f84ee5bb0872747034908d607 Mon Sep 17 00:00:00 2001 From: muqiuhan Date: Tue, 9 Sep 2025 06:04:57 +0000 Subject: deploy: 8bc5af8c3c1f0fc88407ba7d5df886ea71fdb12a --- 2025/09/09/database-fk-design-in-clinical-medicine/index.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to '2025') diff --git a/2025/09/09/database-fk-design-in-clinical-medicine/index.html b/2025/09/09/database-fk-design-in-clinical-medicine/index.html index 04de22de..78b23495 100644 --- a/2025/09/09/database-fk-design-in-clinical-medicine/index.html +++ b/2025/09/09/database-fk-design-in-clinical-medicine/index.html @@ -245,7 +245,7 @@

核心原则是：外键的存在与否取决于业务操作的后果严重性，而非单纯的技术指标。当数据断裂可能直接伤害患者时，必须用外键，当系统响应速度关乎生命时，则需设计更智能的补偿机制。

-

值得注意的是，现代云医疗数据库（如AWS HealthLake）已内置此类混合策略：在 OLTP 层保留关键外键，同时提供 FHIR 资源引用的逻辑一致性检查[^aws_healthlake]。开发者可以定期通过 Chaos Engineering 测试数据断裂场景，模拟删除患者记录后检查系统恢复能力。

+

不过现代云医疗数据库（如AWS HealthLake）已内置此类混合策略：在 OLTP 层保留关键外键，同时提供 FHIR 资源引用的逻辑一致性检查[^aws_healthlake]。开发者可以定期通过 Chaos Engineering 测试数据断裂场景，模拟删除患者记录后检查系统恢复能力。

参考文献：

[^theoretical_consistency]: Gray, J., & Reuter, A. (1993). Transaction Processing: Concepts and Techniques. Morgan Kaufmann.
[^tpc_c_performance]: CockroachDB 团队性能基准测试报告 (2020-2022)
[^cap_theorem]: Taft, R., et al. (2020). CockroachDB: The Resilient Geo-Distributed SQL Database. SIGMOD.
[^distributed_systems]: Google Cloud Architecture Center. (2022). Designing for Consistency in Distributed Databases.
[^fowler_architecture]: Fowler, M. (2003). Patterns of Enterprise Application Architecture. Addison-Wesley.
[^alibaba_architecture]: Alibaba Group. (2019). Nacos: A Dynamic Naming and Configuration Service for Cloud Native Applications.
[^data_integrity_issues]: Kleppmann, M. (2017). Designing Data-Intensive Applications. O’Reilly.
[^data_warehouse_challenges]: Netflix Technology Blog (2018). “When Data Relationships Break: Lessons from Recommendation Systems”
[^engineering_guidelines]: Kleppmann, M. (2020). Transaction Processing in Healthcare Systems. Communications of the ACM, 63(7).
[^aurora_logical_foreign_keys]: AWS Database Blog. (2021). Logical foreign keys in Amazon Aurora.
[^medical_data_criticality]: Jensen, P. B., et al. (2019). Mining Electronic Health Records: Towards Better Research Applications and Clinical Care. Nature Reviews Genetics.
[^fda_regulations]: U.S. Food and Drug Administration. (2023). 21 CFR Part 11: Electronic Records; Electronic Signatures.
[^pfa_data_quality]: Pfizer Clinical Data Science Team. (2022). Annual Data Quality Report. Internal Publication.
[^fhir_standard]: HL7 International. (2022). FHIR R4 Clinical Reasoning Module.
[^nhs_data_quality]: NHS Digital. (2022). Data Quality Framework for Healthcare Systems.
[^iso_medical_standard]: ISO/TR 20514:2021. Health informatics — Framework for integrity of health information.
[^data_governance_tools]: Johns Hopkins Medical Center Technical Report (2022). Data Governance in Chronic Disease Research.
[^mayo_clinic_case_study]: Mayo Clinic Proceedings. (2021). Design Patterns for Resilient Chronic Disease Management Systems. 96(8).
[^aws_healthlake]: AWS. (2023). HealthLake Security and Compliance Controls.

-- cgit v1.2.3