Analysis and solution of data quality in data warehouse of Chinese materia medica

The data quality problem often be ignored in the process of data warehouse construction and utilization. In order to avoid the phenomenon of “garbage in, garbage out” which will influence the decision-making, the problem of data quality must be paid great attention. In this paper, we took the Chinese materia medica (Cmm) data warehouse in China Academy of Chinese Medical Sciences (CACMS) as example. We analyzed the data quality problems in the process of its construction, cited the reasons for bad data quality, and gave the key elements and their relations for data quality analysis and assessment. At the end of article, we proposed a series of assessment standards and solution scheme to improve the data quality in Cmm data warehouse, and carried out in practice to prove it.