实体-属性-值数据库的数据提取与即席查询。
Data extraction and ad hoc query of an entity-attribute-value database.
作者信息
Nadkarni P M, Brandt C
机构信息
Yale University, New Haven, Connecticut, USA.
出版信息
J Am Med Inform Assoc. 1998 Nov-Dec;5(6):511-27. doi: 10.1136/jamia.1998.0050511.
Abstract
Entity--attribute--value (EAV) tables form the major component of several mainstream electronic patient record systems (EPRSs). Such systems have been optimized for real-time retrieval of individual patient data. Data warehousing, on the other hand, involves cross-patient data retrieval based on values of patient attributes, with a focus on ad hoc query. Attribute-centric query is inherently more difficult when data are stored in EAV form than when they are stored conventionally. The authors illustrate their approach to the attribute-centric query problem with ACT/DB, a database for managing clinical trials data. This approach is based on metadata supporting a query front end that essentially hides the EAV/non-EAV nature of individual attributes from the user. The authors' work does not close the query problem, and they identify several complex subproblems that are still to be solved.
摘要
实体-属性-值（EAV）表构成了多个主流电子病历系统（EPRS）的主要组成部分。此类系统已针对个体患者数据的实时检索进行了优化。另一方面，数据仓库涉及基于患者属性值的跨患者数据检索，重点是临时查询。当数据以EAV形式存储时，以属性为中心的查询本质上比传统存储时更困难。作者用ACT/DB（一个用于管理临床试验数据的数据库）阐述了他们针对以属性为中心的查询问题的方法。这种方法基于支持查询前端的元数据，该前端基本上向用户隐藏了各个属性的EAV/非EAV性质。作者的工作并未解决查询问题，他们还识别出了几个仍有待解决的复杂子问题。
相似文献
1
Data extraction and ad hoc query of an entity-attribute-value database.实体-属性-值数据库的数据提取与即席查询。
J Am Med Inform Assoc. 1998 Nov-Dec;5(6):511-27. doi: 10.1136/jamia.1998.0050511.
2
Metadata-driven ad hoc query of patient data: meeting the needs of clinical studies.基于元数据的患者数据临时查询：满足临床研究需求
J Am Med Inform Assoc. 2002 Jul-Aug;9(4):369-82. doi: 10.1197/jamia.m1034.
3
Exploring performance issues for a clinical database organized using an entity-attribute-value representation.探索使用实体-属性-值表示法组织的临床数据库的性能问题。
J Am Med Inform Assoc. 2000 Sep-Oct;7(5):475-87. doi: 10.1136/jamia.2000.0070475.
4
QAV: querying entity-attribute-value metadata in a biomedical database.QAV：在生物医学数据库中查询实体-属性-值元数据
Comput Methods Programs Biomed. 1997 Jun;53(2):93-103. doi: 10.1016/s0169-2607(97)01815-4.
5
On-the-fly form generation and on-line metadata configuration--a clinical data management Web infrastructure in Java.即时表单生成与在线元数据配置——一种用Java实现的临床数据管理Web基础设施。
Stud Health Technol Inform. 2006;124:271-6.
6
Temporal query of attribute-value patient data: utilizing the constraints of clinical studies.属性值患者数据的时态查询：利用临床研究的约束条件
Int J Med Inform. 2003 Apr;70(1):59-77. doi: 10.1016/s1386-5056(02)00183-1.
7
Implementation of a query interface for a generic record server.为通用记录服务器实现查询接口。
Int J Med Inform. 2008 Nov;77(11):754-64. doi: 10.1016/j.ijmedinf.2008.05.003. Epub 2008 Jul 9.
8
CohortExplorer: A Generic Application Programming Interface for Entity Attribute Value Database Schemas.CohortExplorer：实体属性值数据库模式的通用应用程序编程接口。
JMIR Med Inform. 2014 Dec 1;2(2):e32. doi: 10.2196/medinform.3339.
9
Medical record management systems: criticisms and new perspectives.病历管理系统：批评与新视角。
Methods Inf Med. 1999 Jun;38(2):89-95.
10
Neuronal database integration: the Senselab EAV data model.神经元数据库整合：Senselab EAV数据模型
Proc AMIA Symp. 1999:102-6.
引用本文的文献
1
Integrating row level security in i2b2: segregation of medical records into data marts without data replication and synchronization.在i2b2中集成行级安全性：将医疗记录隔离到数据集市中，无需数据复制和同步。
JAMIA Open. 2023 Aug 14;6(3):ooad068. doi: 10.1093/jamiaopen/ooad068. eCollection 2023 Oct.
2
Migrating a Well-Established Longitudinal Cohort Database From Oracle SQL to Research Electronic Data Entry (REDCap): Data Management Research and Design Study.将一个成熟的纵向队列数据库从Oracle SQL迁移到研究电子数据录入系统（REDCap）：数据管理研究与设计研究
JMIR Form Res. 2023 May 31;7:e44567. doi: 10.2196/44567.
3
Research articles on volunteering in biomedical journals: a MEDLINE-based bibliometric analysis.生物医学期刊中关于志愿服务的研究文章：基于MEDLINE的文献计量分析。
J Int Med Res. 2020 Feb;48(2):300060520903616. doi: 10.1177/0300060520903616.
4
Big data management challenges in health research-a literature review.大数据管理在健康研究中的挑战——文献综述
Brief Bioinform. 2019 Jan 18;20(1):156-167. doi: 10.1093/bib/bbx086.
5
Combining clinical and genomics queries using i2b2 - Three methods.使用i2b2结合临床和基因组学查询——三种方法。
PLoS One. 2017 Apr 7;12(4):e0172187. doi: 10.1371/journal.pone.0172187. eCollection 2017.
6
Using i2b2 to Bootstrap Rural Health Analytics and Learning Networks.利用i2b2推动农村卫生分析与学习网络发展。
Annu Int Conf IEEE Eng Med Biol Soc. 2016 Aug;2016:2533-2536. doi: 10.1109/EMBC.2016.7591246.
7
Data interchange using i2b2.使用i2b2进行数据交换。
J Am Med Inform Assoc. 2016 Sep;23(5):909-15. doi: 10.1093/jamia/ocv188. Epub 2016 Feb 5.
8
Review and evaluation of electronic health records-driven phenotype algorithm authoring tools for clinical and translational research.用于临床和转化研究的电子健康记录驱动的表型算法创作工具的综述与评估
J Am Med Inform Assoc. 2015 Nov;22(6):1251-60. doi: 10.1093/jamia/ocv070. Epub 2015 Jul 29.
9
Efficient Execution Methods of Pivoting for Bulk Extraction of Entity-Attribute-Value-Modeled Data.用于批量提取实体-属性-值建模数据的枢轴转换高效执行方法
IEEE J Biomed Health Inform. 2016 Mar;20(2):644-54. doi: 10.1109/JBHI.2015.2392553. Epub 2015 Jan 15.
10
CohortExplorer: A Generic Application Programming Interface for Entity Attribute Value Database Schemas.CohortExplorer：实体属性值数据库模式的通用应用程序编程接口。
JMIR Med Inform. 2014 Dec 1;2(2):e32. doi: 10.2196/medinform.3339.
本文引用的文献
1
Managing attribute--value clinical trials data using the ACT/DB client-server database system.使用ACT/DB客户端-服务器数据库系统管理属性-值临床试验数据。
J Am Med Inform Assoc. 1998 Mar-Apr;5(2):139-51. doi: 10.1136/jamia.1998.0050139.
2
Concept locator: a client-server application for retrieval of UMLS metathesaurus concepts through complex boolean query.概念定位器：一种客户端-服务器应用程序，用于通过复杂布尔查询检索统一医学语言系统（UMLS）元词表概念。
Comput Biomed Res. 1997 Aug;30(4):323-36. doi: 10.1006/cbmr.1997.1433.
3
SQLGEN: a framework for rapid client-server database application development.SQLGEN：一个用于快速开发客户端-服务器数据库应用程序的框架。
Comput Biomed Res. 1995 Dec;28(6):479-99.
4
Converting a legacy system database into relational format to enhance query efficiency.将遗留系统数据库转换为关系格式以提高查询效率。
Proc Annu Symp Comput Appl Med Care. 1995:372-6.
5
A comparison of the temporal expressiveness of three database query methods.三种数据库查询方法的时间表达性比较。
Proc Annu Symp Comput Appl Med Care. 1995:331-7.
6
The Unified Medical Language System.统一医学语言系统
Methods Inf Med. 1993 Aug;32(4):281-91. doi: 10.1055/s-0038-1634945.
7
HELP the next generation: a new client-server architecture.助力下一代：一种新的客户端-服务器架构。
Proc Annu Symp Comput Appl Med Care. 1994:271-5.
8
A temporal query system for protocol-directed decision support.用于协议导向决策支持的时态查询系统。
Methods Inf Med. 1994 Oct;33(4):358-70.
9
Knowledge-based approaches to the maintenance of a large controlled medical terminology.基于知识的方法来维护大型受控医学术语集。
J Am Med Inform Assoc. 1994 Jan-Feb;1(1):35-50. doi: 10.1136/jamia.1994.95236135.
10
Writing Arden Syntax Medical Logic Modules.编写 Arden 句法医学逻辑模块。
Comput Biol Med. 1994 Sep;24(5):331-63. doi: 10.1016/0010-4825(94)90002-7.
Zotero 插件