HELP患者数据库的SQL模型评估。
Evaluation of an SQL model of the HELP patient database.
作者信息
Huff S M, Berthelsen C L, Pryor T A, Dudley A S
机构信息
Department of Medical Informatics, LDS Hospital/University of Utah, Salt Lake City 84143.
出版信息
Proc Annu Symp Comput Appl Med Care. 1991:386-90.
We tested a new model of the HELP patient database that makes use of relational tables to store patient data and provides access to data using SQL (Structured Query Language). The SQL database required more storage space and had many more physical records than the HELP database, but it was faster and more efficient in storing data than the standard HELP utilities. The HELP utilities used disk space more efficiently and were faster than the SQL tools when retrieving data for typical clinical reports. However, the SQL model provides networking capabilities, general report writing tools, detailed user documentation, and an ability for creating secondary indexes that offset its poorer performance.
我们测试了HELP患者数据库的一种新模型，该模型利用关系表来存储患者数据，并使用SQL（结构化查询语言）来访问数据。SQL数据库比HELP数据库需要更多的存储空间，并且有更多的物理记录，但在存储数据方面比标准的HELP实用工具更快、更高效。在为典型临床报告检索数据时，HELP实用工具更有效地利用磁盘空间，并且比SQL工具更快。然而，SQL模型提供了网络功能、通用报告编写工具、详细的用户文档，以及创建辅助索引的能力，这些弥补了其性能较差的问题。
Zotero 插件