Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database

AUTOR(ES)

Nadkarni, Prakash M.

FONTE

American Medical Informatics Association

RESUMO

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.

Documentos Relacionados

• Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation
• Metadata-driven Ad Hoc Query of Patient Data: Meeting the Needs of Clinical Studies
• Managing Attribute—Value Clinical Trials Data Using the ACT/DB Client—Server Database System
• WebEAV: Automatic Metadata-driven Generation of Web Interfaces to Entity-Attribute-Value Databases
• Ad Hoc Calcium