diff options
Diffstat (limited to '2025/09')
| -rw-r--r-- | 2025/09/09/database-fk-design-in-clinical-medicine/index.html | 2 |
1 files changed, 1 insertions, 1 deletions
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 @@ <blockquote> <p>核心原则是：<strong>外键的存在与否取决于业务操作的后果严重性，而非单纯的技术指标</strong>。当数据断裂可能直接伤害患者时，必须用外键，当系统响应速度关乎生命时，则需设计更智能的补偿机制。</p> </blockquote> -<p>值得注意的是，现代云医疗数据库（如AWS HealthLake）已内置此类混合策略：在 OLTP 层保留关键外键，同时提供 FHIR 资源引用的逻辑一致性检查[^aws_healthlake]。开发者可以定期通过 Chaos Engineering 测试数据断裂场景，模拟删除患者记录后检查系统恢复能力。</p> +<p>不过现代云医疗数据库（如AWS HealthLake）已内置此类混合策略：在 OLTP 层保留关键外键，同时提供 FHIR 资源引用的逻辑一致性检查[^aws_healthlake]。开发者可以定期通过 Chaos Engineering 测试数据断裂场景，模拟删除患者记录后检查系统恢复能力。</p> <h2 id="参考文献："><a href="#参考文献：" class="headerlink" title="参考文献："></a>参考文献：</h2><p>[^theoretical_consistency]: Gray, J., & Reuter, A. (1993). Transaction Processing: Concepts and Techniques. Morgan Kaufmann.<br>[^tpc_c_performance]: CockroachDB 团队性能基准测试报告 (2020-2022)<br>[^cap_theorem]: Taft, R., et al. (2020). CockroachDB: The Resilient Geo-Distributed SQL Database. SIGMOD.<br>[^distributed_systems]: Google Cloud Architecture Center. (2022). Designing for Consistency in Distributed Databases.<br>[^fowler_architecture]: Fowler, M. (2003). Patterns of Enterprise Application Architecture. Addison-Wesley.<br>[^alibaba_architecture]: Alibaba Group. (2019). Nacos: A Dynamic Naming and Configuration Service for Cloud Native Applications.<br>[^data_integrity_issues]: Kleppmann, M. (2017). Designing Data-Intensive Applications. O’Reilly.<br>[^data_warehouse_challenges]: Netflix Technology Blog (2018). “When Data Relationships Break: Lessons from Recommendation Systems”<br>[^engineering_guidelines]: Kleppmann, M. (2020). Transaction Processing in Healthcare Systems. Communications of the ACM, 63(7).<br>[^aurora_logical_foreign_keys]: AWS Database Blog. (2021). Logical foreign keys in Amazon Aurora.<br>[^medical_data_criticality]: Jensen, P. B., et al. (2019). Mining Electronic Health Records: Towards Better Research Applications and Clinical Care. Nature Reviews Genetics.<br>[^fda_regulations]: U.S. Food and Drug Administration. (2023). 21 CFR Part 11: Electronic Records; Electronic Signatures.<br>[^pfa_data_quality]: Pfizer Clinical Data Science Team. (2022). Annual Data Quality Report. Internal Publication.<br>[^fhir_standard]: HL7 International. (2022). FHIR R4 Clinical Reasoning Module.<br>[^nhs_data_quality]: NHS Digital. (2022). Data Quality Framework for Healthcare Systems.<br>[^iso_medical_standard]: ISO/TR 20514:2021. Health informatics — Framework for integrity of health information.<br>[^data_governance_tools]: Johns Hopkins Medical Center Technical Report (2022). Data Governance in Chronic Disease Research.<br>[^mayo_clinic_case_study]: Mayo Clinic Proceedings. (2021). Design Patterns for Resilient Chronic Disease Management Systems. 96(8).<br>[^aws_healthlake]: AWS. (2023). HealthLake Security and Compliance Controls.</p> </div> |