Abstract
This case report describes development and testing of a method to extract clinical information stored in the Veterans Affairs (VA) Decentralized Hospital Computer System (DHCP) for the purpose of analyzing data about groups of patients. The authors used a microcomputer-based, structured query language (SQL)-compatible, relational database system to replicate a subset of the Nashville VA Hospital's DHCP patient database. This replicated database contained the complete current Nashville DHCP prescription, provider, patient, and drug data sets, and a subset of the laboratory data. A pilot project employed this replicated database to answer questions that might arise in drug-use evaluation, such as identification of cases of polypharmacy, suboptimal drug regimens, and inadequate laboratory monitoring of drug therapy. These database queries included as candidates for review all prescriptions for all outpatients. The queries demonstrated that specific drug-use events could be identified for any time interval represented in the replicated database.
Full Text
The Full Text of this article is available as a PDF (880.8 KB).
Selected References
These references are in PubMed. This may not be the complete list of references from this article.
- Beers M. H., Ouslander J. G., Rollingher I., Reuben D. B., Brooks J., Beck J. C. Explicit criteria for determining inappropriate medication use in nursing home residents. UCLA Division of Geriatric Medicine. Arch Intern Med. 1991 Sep;151(9):1825–1832. [PubMed] [Google Scholar]
- Crane J., Pearce N., Flatt A., Burgess C., Jackson R., Kwong T., Ball M., Beasley R. Prescribed fenoterol and death from asthma in New Zealand, 1981-83: case-control study. Lancet. 1989 Apr 29;1(8644):917–922. doi: 10.1016/s0140-6736(89)92505-1. [DOI] [PubMed] [Google Scholar]
- Gerich J. E. Oral hypoglycemic agents. N Engl J Med. 1989 Nov 2;321(18):1231–1245. doi: 10.1056/NEJM198911023211805. [DOI] [PubMed] [Google Scholar]
- Ginsburg R. E. 1994 Edward R. Stitt Lecture Award. Organizational analysis of the Veterans Administration decentralized hospital computer system: the challenge of innovation in a bureaucratic setting. Mil Med. 1995 Apr;160(4):161–167. [PubMed] [Google Scholar]
- Marre M., Chatellier G., Leblanc H., Guyene T. T., Menard J., Passa P. Prevention of diabetic nephropathy with enalapril in normotensive diabetics with microalbuminuria. BMJ. 1988 Oct 29;297(6656):1092–1095. doi: 10.1136/bmj.297.6656.1092. [DOI] [PMC free article] [PubMed] [Google Scholar]
- Ravid M., Savin H., Jutrin I., Bental T., Katz B., Lishner M. Long-term stabilizing effect of angiotensin-converting enzyme inhibition on plasma creatinine and on proteinuria in normotensive type II diabetic patients. Ann Intern Med. 1993 Apr 15;118(8):577–581. doi: 10.7326/0003-4819-118-8-199304150-00001. [DOI] [PubMed] [Google Scholar]
- Seltzer H. S. Drug-induced hypoglycemia. A review of 1418 cases. Endocrinol Metab Clin North Am. 1989 Mar;18(1):163–183. [PubMed] [Google Scholar]
- Spitzer W. O., Suissa S., Ernst P., Horwitz R. I., Habbick B., Cockcroft D., Boivin J. F., McNutt M., Buist A. S., Rebuck A. S. The use of beta-agonists and the risk of death and near death from asthma. N Engl J Med. 1992 Feb 20;326(8):501–506. doi: 10.1056/NEJM199202203260801. [DOI] [PubMed] [Google Scholar]