Efficient Schema Design for a Pharmaceutical Data Repository

Authors:
Yang Liu;Zina Ben Miled;Omran Bukhres;Michael Bem;Robert Jones;Robert Oppelt
Affiliations:
-;-;-;-;-;-
Venue:
CBMS '00 Proceedings of the 13th IEEE Symposium on Computer-Based Medical Systems (CBMS'00)
Year:
2000

Citing 5
Cited 2

Fundamentals of database systems (2nd ed.)

Fundamentals of database systems (2nd ed.)
Data schema design as a schema evolution process

Data & Knowledge Engineering
WOL: A Language for Database Transformations and Constraints

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Achievements of Relational Database Schema Design Theory Revisited

Selected Papers from a Workshop on Semantics in Databases
Evolving databases: an application to electronic commerce

IDEAS '97 Proceedings of the 1997 International Symposium on Database Engineering & Applications

Data access performance in a large and dynamic pharmaceutical drug candidate database

Proceedings of the 2000 ACM/IEEE conference on Supercomputing
Use and Maintenance of Histograms for Large Scientific Database Access Planning: A Case Study of a Pharmaceutical Data Repository

Journal of Intelligent Information Systems

Quantified Score

Hi-index	0.01

Visualization

Abstract

Large scientific databases often consist of heterogeneous components that differ in the number of attributes and the number of tuples. In this paper, we show that increased performance is achieved when a complex schema is used to represent different components of a data repository. The driving application used in this study is a pharmaceutical drug repository. The types of access patterns associated with this repository consist of the retrieval of a selected set of attribute values for a consecutive or a random set of tuples. These consecutive and random access patterns, which are typical of a drug discovery experiment, are used to measure the data retrieval throughput for different schemas.