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

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 value...

Descrizione completa

Salvato in:
Dettagli Bibliografici
Autori principali: Nadkarni, Prakash M., Brandt, Cynthia
Natura: Articolo
Lingua:en
Pubblicazione: American Medical Informatics Association 1998
Soggetti:
The Practice of Informatics
Accesso online:https://ncbi.nlm.nih.gov/pmc/articles/PMC61332/
https://ncbi.nlm.nih.gov/pubmed/9824799
Tags: Aggiungi Tag
Nessun Tag, puoi essere il primo ad aggiungerne! !
id pubmed-61332
record_format dspace
spelling pubmed-613322001-12-27 Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database Nadkarni, Prakash M. Brandt, Cynthia J Am Med Inform Assoc The Practice of Informatics 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. American Medical Informatics Association 1998 /pmc/articles/PMC61332/ /pubmed/9824799 Text en Copyright © 1998, American Medical Informatics Association
institution US National Library of Medicine
collection PubMed Central
language en
format Article
topic The Practice of Informatics
spellingShingle The Practice of Informatics
Nadkarni, Prakash M.
Brandt, Cynthia
Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database
description 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.
author Nadkarni, Prakash M.
Brandt, Cynthia
author_facet Nadkarni, Prakash M.
Brandt, Cynthia
author_sort Nadkarni, Prakash M.
title Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database
title_short Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database
title_full Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database
title_fullStr Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database
title_full_unstemmed Data Extraction and Ad Hoc Query of an Entity— Attribute— Value Database
title_sort data extraction and ad hoc query of an entity— attribute— value database
publisher American Medical Informatics Association
publisher_facet American Medical Informatics Association
publishDate 1998
url https://ncbi.nlm.nih.gov/pmc/articles/PMC61332/
https://ncbi.nlm.nih.gov/pubmed/9824799
_version_ 1758997572513431552

Documenti analoghi