Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation
نویسندگان
چکیده
منابع مشابه
Research Paper: Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation
BACKGROUND The entity-attribute-value representation with classes and relationships (EAV/CR) provides a flexible and simple database schema to store heterogeneous biomedical data. In certain circumstances, however, the EAV/CR model is known to retrieve data less efficiently than conventionally based database schemas. OBJECTIVE To perform a pilot study that systematically quantifies performanc...
متن کاملExploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation
Objective: To perform a pilot study that systematically quantifies performance differences for database queries directed at real-world microbiology data modeled with EAV/CR and conventional representations, and to explore the relative merits of different EAV/CR query implementation strategies. Methods: Clinical microbiology data obtained over a ten-year period were stored using both database mo...
متن کاملData Extraction and Ad Hoc Query of an Entity– Attribute–Value Database
n J Am Med Inform Assoc. 1998;5:511–527. A clinical patient record needs to store several thousand possible facts for patients across all specialties. For any given patient, however, the number of actual findings may not exceed a few dozen. A conventional (‘‘orthodox’’) database table design (one fact per column) is unsuitable for such data, because of database vendor limitations on the number ...
متن کاملApplication of Information Technology: 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 values of patient attributes, with a focus on ad hoc query. Attribute-centric query is inherently mo...
متن کاملDomain-Driven News Representation Using Conditional Attribute-Value Pairs
Financial news carry information about economical figures and indicators. However, these texts are mostly unstructured and consequently hard to be processed in an automatic way. In this paper, we present a representation formalism that supports a linguistic composition for machine learning tasks. We show an innovative approach to structuring financial texts by extracting principal indicators. C...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of the American Medical Informatics Association
سال: 2000
ISSN: 1067-5027,1527-974X
DOI: 10.1136/jamia.2000.0070475