Construction of Data-Warehouse for Clinical Data and Its Consequence.
|
Accession number;00A0345359
|
| Title;Construction of Data-Warehouse for Clinical Data and Its Consequence. |
| Author;
MATSUMURA YASUSHI
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
OKADA TAKEO
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
KUWATA SHIGEKI
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
OKAMOTO YUJI
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
TAKAHASHI DAIYO
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
NAKANO HIROHIKO
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
KUSUOKA HIDEO
(Osaka National Hospital)
TAKEDA HIROSHI
(Osaka Univ., Univ. Hosp. attach. to Fac. of Med.)
|
Journal Title;Japan Journal of Medical Informatics
|
Journal Code:Y0510A
|
ISSN:0289-8055
|
|
VOL.19;NO.4;PAGE.297-305(2000)
|
| Figure&Table&Reference;TBL.2, REF.26 |
| Pub. Country;Japan |
| Language;Japanese |
| Abstract;We constructed and have been managed the data warehouse (DWH) for evaluation of hospital activity or support of clinical study since 1995. The data in the mainframe are transferred to the DWH in batch processing at night. This database has patient profile information, consultation and admission history, diagnoses, prescriptions, laboratory test results etc. Using this database, we could count the number of outpatients or inpatients with designated disease, and search the patient who took the designated medicine and so on. Although, the DWH was proved to be significant, we found some problems; data category in the database was not sufficient for elaborate analysis, thesaurus of some kind of terminology was insufficient, some part of the database structure was not suitable. Based on the experiences, we plan to reform the DWH, in which the data category is broadened, the thesaurus is made for all of the significant terminology, the format of the time field is unified in database files, the frequently retrieved data set are involved in one database file. After these reform, the DHW will be more functional and be indispensable for the hospital. (author abst.) |
|
|
|
Related Articles;
|
|
