Proceedings 13th IEEE Symposium on Computer-Based Medical Systems. CBMS 2000 (2000)
June 23, 2000 to June 24, 2000
Yang Liu , Purdue University
Zina Ben Miled , Purdue University
Omran Bukhres , Purdue University
Michael Bem , Eli Lilly & Company
Robert Jones , Eli Lilly & Company
Robert Oppelt , Eli Lilly & Company
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.
schema design, schema transformation, performance, data access, large databases
R. Jones, R. Oppelt, Z. B. Miled, Y. Liu, M. Bem and O. Bukhres, "Efficient Schema Design for a Pharmaceutical Data Repository," Proceedings 13th IEEE Symposium on Computer-Based Medical Systems. CBMS 2000(CBMS), Houston, Texas, 2000, pp. 247.