Efficient schema design for a pharmaceutical data repository

Author

Liu, Yang ; Miled, Zina Ben ; Bukhres, Omran ; Bem, Michael ; Jones, Robert ; Oppelt, Robert

Author_Institution

Comput. & Inf. Sci., Purdue Sch. of Sci., Indianapolis, IN, USA

fYear

2000

fDate

2000

Firstpage

247

Lastpage

254

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

Keywords

information retrieval; medical computing; medical information systems; pharmaceutical industry; very large databases; access patterns; attribute value retrieval; consecutive access patterns; data retrieval; drug discovery experiment; efficient schema design; large scientific databases; pharmaceutical data repository; pharmaceutical drug repository; random access patterns; tuples; Bismuth; Chromium; Pharmaceuticals;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer-Based Medical Systems, 2000. CBMS 2000. Proceedings. 13th IEEE Symposium on

Conference_Location

Houston, TX

ISSN

1063-7125

Print_ISBN

0-7695-0484-1

Type

conf

DOI

10.1109/CBMS.2000.856907

Filename

856907