Designing and implementing special-purpose databases: lessons from the pharmacogenetic network.

The Pharmacogenetics Research Network, which has the long-term goal of genotype-phenotype correlation related to pharmacotherapy, mandates timely electronic publication of results by participating research groups through submission to PharmGKB, the consortium's repository database. Because informatics expertise across groups varies, many groups need help in managing their own data and in generating electronic submissions. To assist these operations, we perform a needs assessment to determine an optimum database implementation strategy, which varies from standalone microcomputer database application to Web-based solutions, depending on the group and problem scope. Solution implementation is coupled with transfer of expertise through hands-on training, so as to reduce the groups' long-term dependence on us. Where multiple groups face common problems, such as managing genotyping data or clinical study support, we have devised generic software that can be reused in its entirety by individual groups, or customized with modest effort.